Senior Database Administrator

Job Description

The Senior Database Administrator (DBA) will lead and optimize database infrastructure, with deep hands-on expertise in PostgreSQL and solid experience in MySQL. This role involves complete ownership of database reliability, performance, and scalability across multiple AWS RDS instances. The ideal candidate should have strong command of PostgreSQL internals, tuning, and architecture, and drive database best practices across the organization.

Key Responsibilities

• Manage and optimize multiple RDS environments (PostgreSQL, MySQL, Aurora)
• Ensure reliability, scalability, and security of all database systems
• Analyze and tune SQL queries, indexing strategies, and schema design efficiency
• Implement monitoring, alerting, and maintenance routines; perform version upgrades
• Design efficient database schemas, manage data migrations, and ensure data integrity
• Enforce access controls, backup policies, and compliance standards for data security
• Collaborate with engineering teams to define and implement database best practices

Required Skills & Qualifications

• Mandatory: Deep, hands-on expertise in PostgreSQL administration and performance tuning
• Proven experience managing MySQL in production environments
• Strong knowledge of AWS RDS management and optimization
• Proficiency in query optimization, indexing, and execution plan analysis
• Experience with replication, backups, and disaster recovery strategies
• Solid understanding of schema design, normalization, and partitioning
• Familiarity with monitoring tools (CloudWatch, Performance Insights, etc.)
• Strong scripting skills (Python, Bash, or equivalent) for automation
• Experience managing large-scale, mission-critical database systems
• Exposure to NoSQL databases (MongoDB, DynamoDB) is a plus
• Familiarity with Aurora and database cost optimization practices
• AWS Database or Data Analytics certification
• Bachelor’s degree in Computer Science, or a related field

Note:

• Shift Time: PKT 2:00 PM - 11:00 PM