SQL Production DBA
上海意贝斯特信息技术有限公司
- 公司规模:150-500人
- 公司性质:合资(欧美)
- 公司行业:计算机软件
职位信息
- 发布日期:2012-08-08
- 工作地点:上海-徐汇区
- 招聘人数:1
- 职位类别:其他
职位描述
POSITION DESCRIPTION:
The ideal candidate has a well-rounded understanding of OLTP features of SQL Server 2005/2008. In addition, this person should have great interpersonal and communication skills, as well as professional maturity - e.g. Understanding of financial aspects of the architectural decisions and cost-benefit analysis. This person must be willing to demonstrate a "hands on" approach, as well as, mentor the team. This person is responsible for database planning and design, set-up, maintenance, back-ups, performance tuning, partitioning, and disaster recovery. Also, the SQL Production DBA will manage the scheduling of an enterprise, high transactional volume database.
POSITION RESPONSIBILITIES:
? Install and configure databases (including tables, views, keys, etc), administer policies, standards, procedures and guidelines necessary to effectively maintain the database environment.
? Gather and analyze business requirements to develop and lead the enterprise data architecture strategy to conform and manage data across an organization.
? Provide design recommendations based on long-term IT organization strategy
? Build and Maintain standards for SQL Server Clusters and DR technologies including but not limited to Log Shipping, Database Mirroring, Database Replication and SAN Replication (as it pertains to SQL Server)
? Create, monitor and execute all SQL related Jobs in production environment
? Document and maintain database system specifications, diagrams and connectivity charts
? Leverage Change Control processes for all SQL Server changes made in our Production environment
? Performance-tune and optimize all databases
? Install and configure any new data servers (hardware, software, physical databases)
? Develop, test and administer server security procedures, database backup and recovery procedures
POSITION REQUIREMENTS:
? 5+ years of experience with SQL Server 2000 family (2005 preferred and 2008 a plus)
? Extensive experience with SQL Server Database objects with the ability to leverage T-SQL to manipulate them
? Strong understanding of Microsoft Best Practices for SQL Server Configuration
? Experience with SSRS, SSIS and SSAS is a plus
? Experience with Database Planning and Design, Set-up, Maintenance, Performance Tuning, and Partitioning
? Experience in Database Backup, Recovery, Replication and Disaster Recovery
? Extensive experience Creating and Optimizing Database Queries, Indexes, Stored Procedures, Triggers, and Reports
? Must be able to demonstrate experience managing the set up and upgrades of complex databases, including interfacing with source control and change control in order to generate creation, upgrade, and maintenance scripts
? Experience using ERD and data modeling with data dictionaries is a plus
? Demonstrated excellent verbal and written communication skills
? Ability to exercise effective judgment, sensitivity, creativity to changing needs and situations
? Must be adaptable, professional, courteous, motivated and work well on their own or as a member of a team
? Ability to handle a fast-paced environment and challenging workload
公司介绍
eBest Mobile 作为最先涉足国内外移动商务的解决方案提供商,在吸收引进国外先进技术的同时,利用自主开发的技术和产品,与众多的合作伙伴实施了多个适合中国企业需求的成功案例,在快消、医药、售后服务等移动信息化领域达到国内一流,国外领先的水平。
Mobile Business--移动商务
我们的移动商务解决方案可应用于各行各业的移动工作领域。它允许在外工作人员随时随地访问企业内部系统,实时进行订单录入,库存查询以及现场对账等。从而加强对在外人员的管理,辅助他们更好的完成工作,并减少浩繁的手工作业和重复劳动,提高工作效率和信息传递的积极性。
针对各行业,结合几年来的行业经验,推出各种行业移动解决方案和平台:
*移动销售管理系统(适用于:快速消费、医药、零售等行业)
*移动售后服务管理系统(适用于:物业、电梯、空调、家电等行业)
*移动巡检管理系统(适用于:政府药品、食品检查等行业)
*移动专柜会员管理系统(适用于:月饼、化妆品、服装等行业)
*移动生产无线追踪系统(适用于:汽车生产、空调生产等制造行业)
*移动无线仓库系统(适用于:化妆品、奢侈品等行业)
*移动RFID无线应用(适用于:化妆品、奢侈品等行业)
*移动手机B2B应用平台(适用于:钢铁、化工等垂直B2B行业)
企业移动商务,让信息化管理无处不在!
eBest Mobile 倡导员工共享公司发展成果,每一位员工均可享有期权;为员工提供良好的工作环境和完善的福利制度,如咖啡、饮料、下午茶点、水果、生日礼物、节假日礼品、结婚礼金等;同时为员工提供各种培训,让员工有更多的提升机会和空间。
欢迎有志之士加入我们!
联系方式
- 公司地址:地址:span上海市虹漕路461号漕河泾软件大厦19楼