上海招聘

  

Responsibilities:

  

 1. Daily management and maintenance of SQL Server database

  

 2. Create solid SQL code to achieve all necessary functions

  

 3. Data Warehouse, BI (SSAS, SSRS), ETL Implementation and Support

  

 4. Solve the technical problems of database and complete the task of SQL development on time according to high quality

  

 5. Analyse the causes of errors and develop solutions to improve quality and productivity

  

 6. DB unit testing through projects to ensure code quality and coverage

  

 7. Repair problems found by testers in project or production environments

  

 Requirements:

  

 1. Bachelor degree or above in computer science, 2-3 years DB related programming experience, at least 1 year experience in SQL Server DBA

  

 2. Solid skills in SQL Server database design and performance optimization, including stored procedures, indexing, partitioning and SQL Server configuration tuning

  

 3. SQL Integration, Analysis and Reporting Services (SSIS, SSAS or SSRS)

  

 4. Experience with ETL, data warehouse creation and BI applications

  

 5. Familiar with Oracle, Power BI

  

 6. Good team spirit and communication skills

  

 7. Good self-learning ability to learn new technologies and new business applications

  

  

工作职责：

  

1. SQL Server数据库日常管理和维护

  

2、创建坚实的SQL代码以实现具有必要所有功能

  

3、数据仓库，BI（SSAS，SSRS），ETL的实施和支持

  

4、解决数据库技术问题，按照高质量准时完成SQL开发任务

  

5、分析错误原因并制定解决方案来提高质量和生产力

  

6、通过项目进行DB单元测试，确保代码质量和覆盖范围

  

7、修复测试人员在项目或生产环境中发现的问题

  

 

职位要求：

  

1、计算机科学本科及以上学历，2-3年DB相关编程经验，至少1年以上SQL Server DBA工作经验

  

2、SQL Server数据库设计和性能优化方面的扎实技能，包括存储过程，索引，分区和SQL Server配置调优

  

3、SQL集成，分析和报告服务（SSIS，SSAS或SSRS）

  

4、具有ETL，数据仓库创建和BI应用程序的经验

  

5、熟悉Oracle，Power BI

  

6、良好的团队合作精神和沟通技巧

  

7、良好的学习新技术和新业务应用的自学能力

  

About GTB

Headquartered in Dearborn, Michigan and founded in 2007, GTB is an industry-leading advertising and communications agency. Formerly known as Team Detroit, Blue Hive, and Retail First, the agency unified under the single name GTB in May of 2016. A WPP company, GTB has 49 global offices across 6 continents. Clients include Ford Motor Company, Johnson Controls, Ohio Art, and Purina among others.

Visit www.gtb.com for more information.