Overview
Job Title:Senior SQL Database AdministratorExperience:10–12 YearsLocation: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 deepexpertisein 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, andmaintainSQL Server databases to ensure high availability, performance, and security.
- Design and support complex replication topologies tomaintaindata 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) forvery largedatabases (VLDBs).
- Perform wait state analysis andoptimizestorage I/O performance.
High Availability & Disaster Recovery
- Design, implement, and manage SQL Server AlwaysOnAvailability Groups.
- Troubleshoot high-latency transactional replication issues in high-throughput systems.
- Establish andmaintainrobust backup and disaster recovery strategies.
Automation & Scripting
- Develop self-service automation solutions for development teams (e.g., automated database refreshes, schema validation).
- Build andmaintaincross-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+) fromon premisesto AWS (EC2/RDS) with minimal downtime. Utilize tools and techniques such as Log Shipping, Mirroring, and AWS DMS.
- LeverageDelphixfor 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
- Proactivelymonitordatabase performance and resolve incidents.
- Use monitoring tools such asFoglight,DataDog, CloudWatch, and Redgate.
- Perform root cause analysis and implement preventive solutions.
Collaboration
- Collaborate with application development, DevOps, and infrastructure teams.
- Providedatabase 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+).
- SQL Server performance tuning (execution plans, indexing, query optimization)
- Always On Availability Groups
- Backup and recovery strategies
- Hands-on experience with PowerShell scripting for automation.
- Experience withDelphix(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 withCommVaultfor 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 tomaintaincomposure and lead technical resolution during high-pressure production outages and complex multi-wave cloud migrations.
- A strategic mindset focused on 'Automation First' - proactivelyidentifyingmanual bottlenecks and architecting long-term scalable solutions rather than quick fixes.