PostgreSQL DBA

We are seeking an experienced PostgreSQL DBA to manage, maintain, and optimize PostgreSQL database environments across cloud and on premise platforms. The ideal candidate will bring strong hands on expertise in AWS RDS and Aurora PostgreSQL environments, along with deep experience in database performance tuning, high availability, and disaster recovery strategies.

Job Title: PostgreSQL DBA

Location: Remote

Duration: Long Term Contract

Required Experience and Skills:

8+ years of overall Database Administration experience

Minimum 6+ years of hands on PostgreSQL DBA experience

Strong experience with AWS RDS and Aurora PostgreSQL

Experience with Linux Red Hat environments

Strong SQL expertise and database design experience

Experience with Cloud Infrastructure

MS SQL Database Administration experience

Experience writing and optimizing Stored Procedures

Experience with replication, clustering, and high availability solutions

Strong backup and recovery planning experience

Key Responsibilities:

Manage, configure, monitor, and tune PostgreSQL databases in AWS and on premise environments

Design and implement backup, recovery, and disaster recovery strategies

Configure and manage replication, clustering, and high availability solutions

Optimize database performance and troubleshoot production issues

Automate database maintenance and operational tasks

Collaborate with development teams on schema design and SQL performance optimization

Manage database security and access controls

Perform capacity planning and maintain detailed documentation

Deliver DBA scripts and documentation as required