PostgreSQL DBA with AWS

Client Name

Zeta (Please do not post client name anywhere)

Indent ID

PSL309538-2

PTalent Job#

189839

Position Title

PostgreSQL DBA with AWS

Location

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

Hybrid working

Work from office

Employment Type

Fulltime and contract both

Visa Type

Any

Rate

Fulltime Salary $120,000 + $3000 APB and on contract $70

Job Description

Key Responsibilities

• Manage, monitor, and support PostgreSQL databases in production environments.
• Perform performance tuning, query optimization, indexing, backup/recovery, and capacity planning.
• Manage HA/DR, replication, failover, upgrades, and database migrations.
• Troubleshoot performance issues, locks, deadlocks, replication lag, and production incidents.
• Administer PostgreSQL on AWS RDS/Aurora and support cloud migrations.

Required Skills

• 5–8 years of hands-on PostgreSQL DBA experience.
• Strong knowledge of PostgreSQL architecture, SQL tuning, VACUUM, WAL, MVCC, replication, and performance optimization.
• Hands-on experience with AWS RDS, Aurora PostgreSQL, EC2, S3, IAM, CloudWatch, KMS, Secrets Manager, and AWS DMS.
• Strong knowledge of backup/recovery, PITR, HA/DR, security, and database monitoring.
• Experience with Linux and Shell/Python scripting.
• Good communication, troubleshooting, and stakeholder-management skills.

Good to Have: Terraform/Ansible, CI/CD, PostgreSQL migration and AWS certification.

Name of the candidate

Contact#

Email ID

Location

Availability

Visa

Rate

Supplier Name

Particular

Details

LinkedIn profile Link

Ptalent Applicant id

Job#

Profile uploaded against which Indent:

Relocation

ETA for relocation post pandemic

Educational qualification (along with Year of passing and university details)

Video / In-person interview availability (Yes/No)

Currently on Project

Any Certification

Interviewed with Persistent in past 3 months