PostgreSQL Database Administrator

About the Opportunity :

We are looking for a skilled and experienced PostgreSQL Database Administrator (DBA) to take ownership of the design, optimization, and management of PostgreSQL databases across on-premise and AWS cloud environments.

This role is ideal for a hands-on DBA with strong technical expertise in database performance tuning, replication, and cloud integration, who thrives in high-availability and mission-critical systems.

You will play a pivotal role in ensuring data reliability, scalability, and performance while collaborating with cross-functional development and DevOps teams to support continuous integration and deployment workflows.

Key Responsibilities :

• Install, configure, and maintain PostgreSQL databases across hybrid infrastructures (on-premises and AWS).
• Implement high availability and disaster recovery solutions using replication, clustering, and backup strategies.
• Perform database tuning, query optimization, and resource utilization analysis for enhanced system performance.
• Oversee backup and restore procedures, ensuring data consistency, security, and recoverability.
• Manage schema design, indexing, and storage optimization to support application scalability.
• Monitor system health, query performance, and resource metrics using pgAdmin, AWS CloudWatch, or equivalent tools.
• Administer user roles, access permissions, and implement database security policies in compliance with best practices.
• Collaborate with development and DevOps teams to automate deployment and integrate database operations within CI / CD pipelines.
• Conduct database upgrades and migrations with minimal downtime using AWS DMS or similar tools.
• Troubleshoot and resolve production issues proactively, ensuring maximum uptime and stability.

Required Skills and Qualifications :

Preferred Skills :

(ref : hirist.tech)