Senior Database Administrator

Overview

Job Title: Senior SQL Database Administrator Experience: 10–12 Years Location: Hyderabad (Office / Rotational) Employment Type: Full-Time 

Job Summary 

We are looking for a Senior SQL Database Administrator with 10–12 years of experience to lead the design, optimization, and automation of enterprise-scale database systems. This role requires deep expertise in performance tuning, large database management (10TB+), and building automation frameworks that integrate on-premises and AWS environments. The ideal candidate will adopt an “infrastructure as code” mindset and drive scalable, high-performance data solutions. 

Key Responsibilities 

Database Administration & Maintenance 

• Manage, monitor, and maintain SQL Server databases to ensure high availability, performance, and security.  

• Design and support complex replication topologies to maintain data consistency across distributed environments.  

• Perform regular health checks, system audits, and capacity planning.  

Performance Tuning & Optimization 

• Conduct advanced performance tuning and bottleneck analysis across CPU, memory, and storage layers (NVMe/EBS) for very large databases (VLDBs).  

• Perform wait state analysis and optimize storage I/O performance.  

High Availability & Disaster Recovery 

• Design, implement, and manage SQL Server Always On Availability Groups.  

• Troubleshoot high-latency transactional replication issues in high-throughput systems.  

• Establish and maintain robust backup and disaster recovery strategies.  

Automation & Scripting 

• Develop self-service automation solutions for development teams (e.g., automated database refreshes, schema validation).  

• Build and maintain cross-platform automation frameworks using PowerShell, Python, or Ansible.  

• Implement automated compliance checks and health monitoring for large-scale environments.  

Database Migration & Upgrades 

• Architect and execute migration strategies for large databases (10TB+) from on premises to AWS (EC2/RDS) with minimal downtime. Utilize tools and techniques such as Log Shipping, Mirroring, and AWS DMS.  

• Leverage Delphix for data virtualization and masking to streamline non-production data provisioning.  

Cloud & Infrastructure 

• Deploy and manage SQL Server databases in AWS environments, including RDS and EC2.  

• Ensure adherence to cloud best practices for scalability, security, and cost optimization.  

Monitoring & Troubleshooting 

• Proactively monitor database performance and resolve incidents.  

• Use monitoring tools such as Foglight, DataDog, CloudWatch, and Redgate.  

• Perform root cause analysis and implement preventive solutions.  

Collaboration 

• Collaborate with application development, DevOps, and infrastructure teams.  

• Provide database design guidance and support development initiatives.  

Required Skills & Qualifications 

• 10–12 years of experience as a SQL Server DBA.  

• Proven experience managing large-scale databases (10TB+).  

• Strong expertise in:  

• SQL Server performance tuning (execution plans, indexing, query optimization)  

• Always On Availability Groups  

• SQL Server Replication  

• Backup and recovery strategies  

• Hands-on experience with PowerShell scripting for automation.  

• Experience with Delphix (data virtualization and masking).  

• Strong knowledge of AWS database services.  

• Experience in database migrations and upgrades.  

• Solid understanding of database security and compliance practices.  

• Excellent analytical and problem-solving skills.  

Good to Have Skills 

• Experience with CommVault for backup and recovery.  

• Working knowledge of MongoDB or other NoSQL databases.  

• Exposure to Microsoft Azure (Azure SQL, Managed Instances).  

• Familiarity with DevOps tools and CI/CD pipelines.  

Soft Skills 

• Ability to translate complex technical database challenges into actionable business insights for stakeholders and provide technical mentorship to junior team members. 

• Proven ability to maintain composure and lead technical resolution during high-pressure production outages and complex multi-wave cloud migrations. 

• A strategic mindset focused on 'Automation First' - proactively identifying manual bottlenecks and architecting long-term scalable solutions rather than quick fixes.