Candidate should have 4 years of experience on implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance for corporate applications. This is a position requiring solid technical skills, as well as excellent interpersonal and communication skills.
Responsibilities
- Writing T-SQL queries/ Stored procedures/ Dynamic queries
- Configure and maintain database servers and processes, to ensure high levels of performance, availability, and security.
- Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations
- Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
- Able to do complex query tuning and schema refinement.
- Provide support for critical production systems.
- Perform scheduled maintenance and support release deployment activities after hours.
Skills
- 4 years of experience on MS SQL Server development required
- Created various SSIS and SSRS Packages to serve company needs.
- Adept at T-SQL, stored procedures, tables, indexes, views, functions, and triggers.
- Experienced in Upgrade/Migration of MS SQL Server 2008 to MS SQL Server 2008R2, from SQL Server 2012 and SQL Server 2014.
- Experience with backups, restores and recovery models.