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 & Administrator

Experience : 6+ Years

Notice Period : immediate to 15 Days

Work Mode : Work From Office( 5 Days in a week)

Interview Mode : 1st Level is online & 2nd Level is F2F.

Work Location : Ameerpet, Hyderabad

Job 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 :

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.