PostgreSQL Database Administrator

<p><p><b>About the Opportunity : <br/></b><br/>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.<br/><br/>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.<br/><br/>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.<br/><br/><b>Key Responsibilities : </b><br/><br/>- Install, configure, and maintain PostgreSQL databases across hybrid infrastructures (on-premises and AWS).<br/><br/>- Implement high availability and disaster recovery solutions using replication, clustering, and backup strategies.<br/><br/>- Perform database tuning, query optimization, and resource utilization analysis for enhanced system performance.<br/><br/>- Oversee backup and restore procedures, ensuring data consistency, security, and recoverability.<br/><br/>- Manage schema design, indexing, and storage optimization to support application scalability.<br/><br/>- Monitor system health, query performance, and resource metrics using pgAdmin, AWS CloudWatch, or equivalent tools.<br/><br/>- Administer user roles, access permissions, and implement database security policies in compliance with best practices.<br/><br/>- Collaborate with development and DevOps teams to automate deployment and integrate database operations within CI/CD pipelines.<br/><br/>- Conduct database upgrades and migrations with minimal downtime using AWS DMS or similar tools.<br/><br/>- Troubleshoot and resolve production issues proactively, ensuring maximum uptime and stability.<br/><br/><b>Required Skills and Qualifications : </b><br/><br/>- Minimum 4 years of experience as a PostgreSQL Database Administrator in production environments.<br/><br/>- Strong expertise in AWS Cloud Services, including RDS, EC2, S3, CloudWatch, and IAM.<br/><br/>- Proven hands-on experience in replication, clustering, and failover configuration.<br/><br/>- Deep understanding of Linux/Unix environments, including shell scripting for automation.<br/><br/>- Strong proficiency in performance tuning, query optimization, and indexing strategies.<br/><br/>- Experience with PostgreSQL administration tools such as pgAdmin, pgBouncer, and AWS Database Migration Service (DMS).<br/><br/>- Knowledge of backup and recovery mechanisms and database security configurations.<br/><br/>- Excellent analytical, troubleshooting, and communication skills.<br/><br/>- Bachelors degree in Computer Science, Information Technology, or related technical field.<br/><br/><b>Preferred Skills : </b><br/><br/>- Exposure to infrastructure-as-code (IaC) tools like Terraform or CloudFormation.<br/><br/>- Familiarity with containerized deployments using Docker and Kubernetes.<br/><br/>- Experience with monitoring and alerting tools such as Prometheus, Grafana, or ELK stack.<br/><br/>- Knowledge of database version control and migration scripting.<br/><br/>- Experience supporting DevOps workflows and automated database provisioning</p><br/></p> (ref:hirist.tech)