MS SQL Database Administrator

About the Role

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.