Lead Database Administrator

Job Description

32072BR Bangalore - Campus Job Description Senior Database Administrator / SQL Developer Job Summary: We are seeking a highly skilled and experienced Senior MS SQL Server Database Administrator to manage and support mission-critical, customer-facing environments. The role involves implementing and maintaining high-availability and disaster recovery solutions, including Always On Availability Group Cluster and replicated (OLTP/ODS) environments deployed in both private cloud datacenters (VMWare) and AWS EC2 instances. The candidate will ensure optimal performance, security, and scalability for our customers environments. Role And Responsibilities: Design, implement, and maintain MS SQL Server databases in a hybrid cloud environment. Support multiple hosted customer SQL Server environments from SQL Server 2014 -2019. Manage and support Always On Availability Groups for high availability and disaster recovery. Configure and manage OLTP (Online Transaction Processing) and ODS (Operational Data Store) replicated environments. Monitor database performance, identify bottlenecks, and apply optimizations to ensure high availability and scalability. Perform regular backups, restores, and database maintenance tasks to ensure data integrity and availability. Implement database security best practices to ensure data protection and compliance with industry standards (e.g., HIPAA, HITRUST). Collaborate with development, infrastructure, and DevOps teams to support database architecture, tuning, and deployment strategies. Troubleshoot and resolve complex database issues, providing 24x7 support for production environments as needed. Participate in on call support and after-hours rotations for customer upgrades, script executions, and maintenance. Create and maintain database documentation, including configuration, processes, and runbooks. Assist with ad hoc and custom reporting using T-SQL for customers including management and collaboration with offshore reporting team. Develop and implement automated processes for monitoring, backups, and failover to improve efficiency. Develop custom Stored Procedures and SQL Agent Jobs Automate repeated DBA tasks using SQL Agent Jobs and PowerShell. Respond to customer requests via Jira tickets and work directly with customers on solutions to issues and custom processes. Qualifications Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience). 7+ years Database Administration Experience. Extensive experience with MS SQL Server 2016/2019, including installation, configuration, and troubleshooting. Strong expertise with Always On Availability Groups and high-availability architectures. Proficient in managing large databases in a hybrid cloud environment. In-depth knowledge of database replication, performance tuning, and query optimization techniques. Experience with backup/recovery strategies and disaster recovery planning. Strong scripting skills (T-SQL, PowerShell) for automation and database maintenance. Familiarity with monitoring tools (e.g., SQL Sentry, DataDog, Prometheus, Grafana) and cloud management platforms (AWS RDS, EC2). Excellent problem-solving skills, with the ability to troubleshoot complex issues under pressure. Experience with security and compliance standards (HIPAA, HITRUST) is a plus. Strong communication and collaboration skills required as this is a customer facing position. Knowledge of Windows Server, command line, and PowerShell. Knowledge of SSIS and installing and executing SSIS packages. Preferred AWS Certified Solutions Architect or AWS Certified Database – Specialty. Familiarity with DevOps practices and CI/CD pipelines. Experience in database administration/management for large-scale, high-traffic environments. Working Hours: US EST hrs (8 am - 5 pm EST) Qualifications BE Range of Year Experience-Min Year 8 Range of Year Experience-Max Year 10 Show more Show less