Senior MS SQL DataBase Administrator

Key Responsibilities

1. Database Administration:

• Install, configure, and upgrade SQL Server instances.
• Create, modify, and manage databases, tables, statistics & indexes.
• Troubleshooting jobs
• Understand and develop SQL queries & stored procedures.
• Knowledge of PowerShell commands and scripting.

2. Backup and Recovery:

• Develop and maintain backup and recovery strategies.
• Perform regular backups and test restoration procedures.
• Ensure data consistency and minimize downtime during recovery.

3. Performance Tuning:

• Optimize database performance by analyzing query execution plans.
• Identify and resolve performance issues related to indexing, query design, and resource utilization.
• Index maintenance and updating stats
• Monitor server resources (CPU, memory, disk space) and adjust configurations as needed.

4. High Availability and Disaster Recovery:

• Configure and manage database clustering, and Always On Availability Groups.
• Always On - Plan and execute failover and failback procedures, troubleshoot latency and data
• consistency across replicas.
• SQL Cluster - Troubleshooting cluster issues, flipping cluster roles etc.
• Thorough knowledge of Transaction replication - setup, failures, latency and troubleshooting.

5. Good to have :

• Developing SQL queries & stored procedures
• Linux Basics
• PowerShell scripting skills
• PosgreSQL Database administration

Benefits Offered

• Flexible Work Hours.
• Work on impactful, industry-changing projects.
• Continuous learning and career growth opportunities..
• Collaborative, innovative, and inclusive environment.
• Insurance – Group Medical Coverage, Employee Personal Accident,
• Maternity and Paternity Leaves.
• Performance Feedback Sessions.
• Competitive Compensation.
• Rewards and Recognition Program, Employee Referral Program, Fun Events.