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.