PostgreSQL DBA with AWS

Job Description

Job Title: PostgreSQL DBA with AWS

\n

Location: 131 Morristown Rd, Basking Ridge NJ (5 Days a week)

\n

Duration: Fulltime and contract both

\n

Note: Only on W2

\n

Any Visa

\n

\n

Job Description:

\n

\n

Key Responsibilities

\n

\n
• Manage, monitor, and support PostgreSQL databases in production environments.

\n

• Perform performance tuning, query optimization, indexing, backup/recovery, and capacity planning.

\n

• Manage HA/DR, replication, failover, upgrades, and database migrations.

\n

• Troubleshoot performance issues, locks, deadlocks, replication lag, and production incidents.

\n

• Administer PostgreSQL on AWS RDS/Aurora and support cloud migrations.

\n

\n

\n

Required Skills

\n

\n
• 5–8 years of hands-on PostgreSQL DBA experience.

\n

• Strong knowledge of PostgreSQL architecture, SQL tuning, VACUUM, WAL, MVCC, replication, and performance optimization.

\n

• Hands-on experience with AWS RDS, Aurora PostgreSQL, EC2, S3, IAM, CloudWatch, KMS, Secrets Manager, and AWS DMS.

\n

• Strong knowledge of backup/recovery, PITR, HA/DR, security, and database monitoring.

\n

• Experience with Linux and Shell/Python scripting.

\n

• Good communication, troubleshooting, and stakeholder-management skills.

\n

\n

\n

Good to Have:

\n

\n
• Terraform/Ansible, CI/CD, PostgreSQL migration and AWS certification.

\n

\n