Senior Database Administrator

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.