DBA/DataBase Administrator
瑞易信息技术（上海）有限公司
- 公司规模：150-500人
- 公司性质：外资(欧美)
- 公司行业：计算机服务(系统、数据服务、维修) 计算机软件
职位信息
- 发布日期：2015-07-13
- 工作地点：上海-徐汇区
- 招聘人数：1
- 职位类别：数据库工程师/管理员
职位描述
About Retail Solutions, Inc (RSi)
Retail Solutions develops and delivers a comprehensive suite of award-winning software-as-a-service (SaaS) solutions that turn Retailer "downstream data", such as point-of-sale (POS), supply chain, merchandiser feedback and category data, into actionable visibility into the store and onto the shelf for their suppliers.
Retail Solutions, the largest and fastest-growing company in the Retail Execution Management field, has more experience with processing customer-specific retailer data than any other company. Retailers and consumer product goods (CPG) companies trust Retail Solutions to grow sales, reduce out-of-stocks, improve promotion execution and effectiveness, maximize retail operation productivity and foster collaborative relationships in the retail industry to improve product availability for the end-consumer.
Retail Solutions serves more than 500 CPG Companies, including nine of the top ten global consumer goods companies, and processes data from more than 30 leading retailers in the Americas and Europe.
Retail Solutions is headquartered in Mountain View, CA and has offices in Providence, RI; Bentonville, AR; Paris, France; Richmond, UK; and Shanghai, China.
Retail Solutions, Shanghai office, is looking for a Senior SQL Server DBA
The Senior SQL Server DBA will install, monitor, maintain, and manage the distributed SQL Server environment that is the foundation of RSI's SaaS solution ensuring maximum reliability, performance, and availability. This position will work closely with software developers ensuring efficient use of database resources, development of and adherence to standards, and proper SQL Server system maintenance. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
RSi is growing rapidly, and the work atmosphere is team-oriented and knowledge-intensive: motivated professionals are highly appreciated.
Responsibilities
- Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers
- Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts
- Database administration tasks including setup of new databases and database objects
- Managing database objects in the production environment
- Performance monitoring, tuning, and capacity planning
- Maintaining database logs and transaction logs
- Database failover/recovery, including backup and restoration
- Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets
- Work with application development staff and Technical Operations to design and implement production DB security practices and solutions
- Create and maintain user, roles and privileges within the database instances
- Work with application development staff to troubleshoot application level performance issues
- Collect and publish ongoing status reports on production bottlenecks and issues
- Automation of labor-intensive maintenance activities
- Plan and coordinate data migrations between systems
- Manage SQL Server upgrades and patches adhering to a cadence of regular upgrade schedules
- Partner with and continue to foster productive, collaborative relationships within various RSi teams to meet common and corporate goals
- Manage and/or provide guidance to junior members of the team
Position Requirements
Formal Education, Certification
- Bachelor's Degree in ComputerScience/Mathematics/Engineering with 5+ years in industry
Knowledge & Experience
- Strong understanding of database structures, theories, principles, and practices.
- 5+ years Database administration experience in a 24x7 environment
- Hands-on experience with Microsoft SQL Server; certification (MCDBA) preferred but not required
- In-depth database tuning and troubleshooting experience
- Solid experience in database clustering and SAN technologies
- Project management experience is a plus
- Knowledge of high availability configurations for MS SQL server deployments
- Knowledge of applicable data privacy practices and laws.
- Hands-on knowledge of large scale database environments for multi-Terabyte datasets
- Experience working in a Data warehouse environment , with Microsoft BI stack such as SSIS and SSAS
- Oracle experience a plus
- Experience utilizing data modeling tools
- Software development experience with VB, COM, Java, and ASP a plus
Personal Attributes
- Good written and oral communication skills.
- Strong technical documentation skills.
- Good interpersonal skills.
- Ability to present ideas in user-friendly language.
- Highly self-motivated and directed.
- Excellent business and system analysis skills
- Keen attention to detail.
- Proven analytical and problem-solving abilities.
- Ability to effectively prioritize and execute tasks in a high-pressure environment.
- Strong customer service orientation.
- Ability and desire to work in a team-oriented, collaborative environment.
Retail Solutions develops and delivers a comprehensive suite of award-winning software-as-a-service (SaaS) solutions that turn Retailer "downstream data", such as point-of-sale (POS), supply chain, merchandiser feedback and category data, into actionable visibility into the store and onto the shelf for their suppliers.
Retail Solutions, the largest and fastest-growing company in the Retail Execution Management field, has more experience with processing customer-specific retailer data than any other company. Retailers and consumer product goods (CPG) companies trust Retail Solutions to grow sales, reduce out-of-stocks, improve promotion execution and effectiveness, maximize retail operation productivity and foster collaborative relationships in the retail industry to improve product availability for the end-consumer.
Retail Solutions serves more than 500 CPG Companies, including nine of the top ten global consumer goods companies, and processes data from more than 30 leading retailers in the Americas and Europe.
Retail Solutions is headquartered in Mountain View, CA and has offices in Providence, RI; Bentonville, AR; Paris, France; Richmond, UK; and Shanghai, China.
Retail Solutions, Shanghai office, is looking for a Senior SQL Server DBA
The Senior SQL Server DBA will install, monitor, maintain, and manage the distributed SQL Server environment that is the foundation of RSI's SaaS solution ensuring maximum reliability, performance, and availability. This position will work closely with software developers ensuring efficient use of database resources, development of and adherence to standards, and proper SQL Server system maintenance. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
RSi is growing rapidly, and the work atmosphere is team-oriented and knowledge-intensive: motivated professionals are highly appreciated.
Responsibilities
- Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers
- Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts
- Database administration tasks including setup of new databases and database objects
- Managing database objects in the production environment
- Performance monitoring, tuning, and capacity planning
- Maintaining database logs and transaction logs
- Database failover/recovery, including backup and restoration
- Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets
- Work with application development staff and Technical Operations to design and implement production DB security practices and solutions
- Create and maintain user, roles and privileges within the database instances
- Work with application development staff to troubleshoot application level performance issues
- Collect and publish ongoing status reports on production bottlenecks and issues
- Automation of labor-intensive maintenance activities
- Plan and coordinate data migrations between systems
- Manage SQL Server upgrades and patches adhering to a cadence of regular upgrade schedules
- Partner with and continue to foster productive, collaborative relationships within various RSi teams to meet common and corporate goals
- Manage and/or provide guidance to junior members of the team
Position Requirements
Formal Education, Certification
- Bachelor's Degree in ComputerScience/Mathematics/Engineering with 5+ years in industry
Knowledge & Experience
- Strong understanding of database structures, theories, principles, and practices.
- 5+ years Database administration experience in a 24x7 environment
- Hands-on experience with Microsoft SQL Server; certification (MCDBA) preferred but not required
- In-depth database tuning and troubleshooting experience
- Solid experience in database clustering and SAN technologies
- Project management experience is a plus
- Knowledge of high availability configurations for MS SQL server deployments
- Knowledge of applicable data privacy practices and laws.
- Hands-on knowledge of large scale database environments for multi-Terabyte datasets
- Experience working in a Data warehouse environment , with Microsoft BI stack such as SSIS and SSAS
- Oracle experience a plus
- Experience utilizing data modeling tools
- Software development experience with VB, COM, Java, and ASP a plus
Personal Attributes
- Good written and oral communication skills.
- Strong technical documentation skills.
- Good interpersonal skills.
- Ability to present ideas in user-friendly language.
- Highly self-motivated and directed.
- Excellent business and system analysis skills
- Keen attention to detail.
- Proven analytical and problem-solving abilities.
- Ability to effectively prioritize and execute tasks in a high-pressure environment.
- Strong customer service orientation.
- Ability and desire to work in a team-oriented, collaborative environment.
公司介绍
总部位于硅谷最中心的Retail Solutions, Incorporated(中文名：瑞易信息技术有限公司，简称RSI),从2004年创立以来，短短几年内，已经成为所在行业最大也是发展最迅猛的公司。
RSI的主要业务范围是将应用于大型零售商及其供应商所拥有的各种数据，作不同角度的整合，将研究的艺术融于科学，以尖端科技结合实际，从而帮助供应商和零售商解决投资回报需要的各种最迫切现实问题。RSI同时也是射频标签(RFID)技术应用软件的先驱者和领头羊，在实际的应用以及行业标准的制定，RSI都一直是领导力量，拥有世界上最大的标签读量和客户群。
现在RSi拥有超过300个大型的消费者产品公司(Consumer packaged goods -CPG)作为客户，几乎所有行业领先的CPG公司都是RSi客户比如宝洁，联合利华，百事，可口可乐，拜尔，惠普等等，客户的年收入总和超过10000亿美金；并且涵盖前十大零售商的7个大型的知名零售商比如沃尔马，家乐福，CVS, Walgreen等。 RSi用软件即服务的方式帮助这些客户，提供的数据分享平台和基于数据的分析与应用， 可以以非常低风险和资金投入的方式获得最大的投资回报，在这个领域RSi遥遥领先，规模是所有竞争对手的总和。
RSi在德勤（Deloitte）北美发展最快的技术类 前500家公司排名中2010年排名48位；2009年排第33名，在软件行业排名第三。RSi也是IBD最有创造性公司（IBD Innovation Award 2005）, 被称为零售与消费者产品行业的Google，并且也是ＭＡ前十个最值得注意的尚未上市公司的名单之中。目前，RSi开始积极在欧洲和中国开展业务。
RSI拥有规范化的经营流程，人性化的管理和工作氛围，并且致力于在中国的研发和服务部门的扩展，提供有竞争性的待遇给中国员工，甚至股票待遇都是标准化，与美国欧洲员工在同一个职位用同一个标准，加入的５０％以上员工都会获得去美国总部培训工作机会。 任何RSI队伍中的成员，你的每一个意见都会被仔细考虑，你的每一处贡献都会被珍视，我们相信，你的成长是RSI快速成长里最重要的一部分。
For more information, please access http://www.retailsolutions.com
RSI的主要业务范围是将应用于大型零售商及其供应商所拥有的各种数据，作不同角度的整合，将研究的艺术融于科学，以尖端科技结合实际，从而帮助供应商和零售商解决投资回报需要的各种最迫切现实问题。RSI同时也是射频标签(RFID)技术应用软件的先驱者和领头羊，在实际的应用以及行业标准的制定，RSI都一直是领导力量，拥有世界上最大的标签读量和客户群。
现在RSi拥有超过300个大型的消费者产品公司(Consumer packaged goods -CPG)作为客户，几乎所有行业领先的CPG公司都是RSi客户比如宝洁，联合利华，百事，可口可乐，拜尔，惠普等等，客户的年收入总和超过10000亿美金；并且涵盖前十大零售商的7个大型的知名零售商比如沃尔马，家乐福，CVS, Walgreen等。 RSi用软件即服务的方式帮助这些客户，提供的数据分享平台和基于数据的分析与应用， 可以以非常低风险和资金投入的方式获得最大的投资回报，在这个领域RSi遥遥领先，规模是所有竞争对手的总和。
RSi在德勤（Deloitte）北美发展最快的技术类 前500家公司排名中2010年排名48位；2009年排第33名，在软件行业排名第三。RSi也是IBD最有创造性公司（IBD Innovation Award 2005）, 被称为零售与消费者产品行业的Google，并且也是ＭＡ前十个最值得注意的尚未上市公司的名单之中。目前，RSi开始积极在欧洲和中国开展业务。
RSI拥有规范化的经营流程，人性化的管理和工作氛围，并且致力于在中国的研发和服务部门的扩展，提供有竞争性的待遇给中国员工，甚至股票待遇都是标准化，与美国欧洲员工在同一个职位用同一个标准，加入的５０％以上员工都会获得去美国总部培训工作机会。 任何RSI队伍中的成员，你的每一个意见都会被仔细考虑，你的每一处贡献都会被珍视，我们相信，你的成长是RSI快速成长里最重要的一部分。
For more information, please access http://www.retailsolutions.com
联系方式
- 公司地址：上班地址：徐家汇