Senior Software Engineer (DW+SQL) – (Shanghai, China)

JOB DESCRIPTION

Position: Senior Software Engineer (DW+SQL) – (Shanghai, China)

Industry Type: Education and training

Company: Established in 1965, the group is the largest private English Education Institution in the world, and it focuses on English training, study abroad travel, exchange of English culture and so on. There are more than 400 schools and branches in 51 countries around the world, and more than 130 schools in China.

Key Responsibilities:

Be responsible for data warehouse design and development, MSSQL Server development.
Monitor database and systems utilization, Maintain database performance by troubleshooting and developing tuning methodologies; determine problems and solutions
Provides information by collecting, analyzing, and summarizing database performance and trends.
Database administration, database backup/restore and disaster recovery.
Utilize SQL server in a production environment, and work on large production databases
Perform the ad-hoc data fix tasks in production servers.
Provide reliable technical support and guidance to developers on routine database issues.

Requirements:

BS or MS in Computer Science or equivalent is required.
5+years of industry experience with solid software design skills.
3+ years of project experience in n-tier and distributed applications.
Experienced in Reporting Systems development: T-SQL, MDX, SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services. Must have worked in reporting systems at least for the past 1 year
Must be experienced in developing SSIS packages
Must be experienced in Report authoring for SSRS; and configuration of SSRS subscriptions
Must be experienced in designing SSAS Cubes and querying them
Solid knowledge on database concepts. Have a good understanding of SQL Server Performance Tuning, Manage Indexes, Query optimization
Knowledge of Sharepoint based report delivery is a plus. .NET knowledge is a plus too.
Must have worked with production (live) reporting and database systems
Have strong problem solving ability, is able to find creative solutions to challenging technical problems.
Experience in large-scale database development and customer relationship management system or related is required.
Possess good communication skills in English and good technical documentation skills.
Demonstrate the following abilities or characteristics:
- A track record of high performance.
- Passion for quality
- Technical excellence