2+ Microsoft SQL Server DBA Jobs in Chennai | Microsoft SQL Server DBA Job openings in Chennai

years MS SQL Server Administration experience required 

∙Provide 24x7 support for critical production systems. 

∙ Provide technical leadership for the service component or the product. 

∙IT Operations with strong understanding of database structures, theories, principles, and best practices. 

∙Experience with Performance Tuning and Optimization (PTO), using native monitoring and third-party tools 

∙Experience with backups, restores and recovery processes 

∙Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server  

∙Assist developers with complex query tuning and schema refinement. 

∙Experience in handling database corruption 

∙Manage Encrypted database, TDE and SSL certificate 

∙Manage PaaS and IaaS environment 

∙Experience with SSIS packages, SSRS and SSAS 

∙Experience working with Windows server, including Active Directory 

Skill Set:

• Strong knowledge in SQL Server
• Program and develop SQL scripts, tables, views, stored procedures, functions, triggers & constraints.
• Scripting (PowerShell, shell scripting)
• Azure Database (Nice to have)
• Experience with backups, restores and recovery models.
• Familiarity with database design, documentation and coding.

 Responsibilities: 

• Configures and validates database backup routines on a regular basis.
• Establish a regular data retention plan.
• Optimizes database performance through the use of database performance tuning techniques and tools.
• Require extensive familiarity with data management principles and best practices in order to properly store, migrate, and structure data for multiple applications.