MS SQL DBA

JD 

1. 6 - 8 years of experience in MS SQL Server Database Administration (all available versions)

2. As this is for a L2 requirement, candidate should have strong skills in architecture, design, installation, configuration, administration and troubleshooting of all areas of MS SQL Server DB including high availability, replication, disaster recovery, patching, backup & recovery, performance tuning, optimizing, and securing Postgres DB in a large environment.

3. Experience in Upgrading and Migration of MS SQL DB databases.

4. Backup and recovery: Implement appropriate database backup and recovery strategy based on database and application availability requirements.

5. Excellent troubleshooting skills. Should be able to resolve any issue related to MS SQL Server DB independently. Should be able to quickly isolate the problem and provide resolution in order to meet the SLAs.

6. Excellent documentation skills. Should have prior experience in creating design documents, SOPs etc.

7. Monitoring management and tuning. Hands-on experience on Monitoring tools to proactively monitor the database environment and to make changes to database structures, SQL, application logic or to optimize performance.

8. Storage management techniques. Responsible to comply the storage hardware and software effectively in production and pre-production environments.

9. Implement Transactional Replication, Always On Availability Groups and Log Shipping across various implementations.

10. Must be an expert on High Availability features of MS SQL Server 2016 and later.

11. Flexible to work in 24x7 operations (working in shifts, on-call support etc.)

12. Should have excellent communication and presentation skills as the candidate needs to work with Architects, Service Owners, Business Leaders and other technical teams

13. Should be a team player and have ability to train L2 and L1 resources

14. Good understanding of ITIL processes Incident, Problem, Configuration and Change Management (ITIL)