Lead Database Administrator

Dear Candidate,Greetings for the Day W are Hiring for a Lead Database Administrator role for Hyderabad Location, Please find below attached job Description for you reference,Job Description :Designation: AWS Aurora Database Lead Developer & AdministratorExperience: 6+ YearsNotice Period: immediate to 15 DaysWork Mode: Work From Office( 5 Days in a week)Interview Mode: 1st Level is online & 2nd Level is F2F.Work Location: Ameerpet, HyderabadJob Description :- 7–10 years of experience as a PostgreSQL DBA, including 2+ years on Amazon Aurora PostgreSQL - · Lead and mentor a team of 7–8 Database developers. - · Proven experience leading teams in an Agile/Scrum environment. - · Excellent communication and stakeholder management skills. - · Demonstrated expertise in administering, configuring, and maintaining PostgreSQL databases across multiple environments, with at least 2+ years of hands-on experience managing Aurora PostgreSQL clusters on AWS. Proven track record of ensuring high availability, scalability, and security in production-grade database systems. Expertise in schema design, normalization, and indexing strategies. - · Strong understanding of PostgreSQL internals, replication, WAL management, and query execution plans. Deep knowledge of how PostgreSQL handles processes, memory, and storage structures (shared buffers, WAL, vacuum, checkpoints, etc.). Skilled in setting up and managing physical and logical replication, monitoring replication lag, and troubleshooting failover issues. Ability to analyze query execution plans for performance optimization and root-cause analysis.Skills to be Proficient in :- · Proficiency in performance tuning, indexing strategies, and analyzing slow queries. - Hands-on experience with diagnosing and resolving database performance issues using tools like pg_stat_activity, pg_stat_statements, and AWS Performance Insights. - Adept at designing and implementing indexing strategies, optimizing SQL queries, and tuning PostgreSQL configuration parameters (work_mem, shared_buffers, maintenance_work_mem, etc.) for optimal throughput and latency. - · Experience managing large-scale, mission-critical databases in AWS environments. Proven ability to manage and monitor large, complex database ecosystems supporting high transaction volumes and low-latency workloads. Experience with capacity planning, scaling Aurora clusters, handling read replicas, and ensuring database availability across multiple Availability Zones. Strong focus on reliability, disaster recovery, and data protection. - · Expertise in Linux administration and shell scripting for automation. Solid command over Linux-based systems for database hosting, performance monitoring, and troubleshooting. Skilled in writing shell scripts for routine database tasks, log analysis, backups, and automating maintenance activities like reindexing, vacuuming, or integrity checks. - · Hands-on experience with AWS RDS/Aurora features (parameter groups, snapshots, performance insights, failover). Proficient in configuring and managing Aurora-specific components such as parameter groups, option groups, and cluster configurations. Experienced with automated backups, snapshots, and point-in-time recovery (PITR). Well-versed in using AWS Performance Insights, CloudWatch metrics, and alarms for proactive performance monitoring and incident response. - · Familiarity with data migration tools (DMS, pg_dump/pg_restore) - Experience planning and executing data migrations, upgrades, and environment refreshes using AWS Database Migration Service (DMS), pg_dump, and pg_restore. Skilled in validating data integrity, minimizing downtime during migration, and troubleshooting compatibility issues between different PostgreSQL versions or environments. - · Monitor and optimize database performance using Datadog, CloudWatch, and other tools. - · Familiarity with Heimdall Proxy, data migration tools, and embedding models. - · Proficient with pgvector setup, development, and optimization. - · Exposure to ISO/IEC 27001 or other compliance frameworks. - · Having an AWS Certified Database – Specialty or AWS Certified Solutions Architect certification will be an added advantage.