Hi,
We are hiring for PostgreSQL Database Administrator (DBA) with AWS at Basking ridge, NJ (onsite/5 days)
Role : PostgreSQL Database Administrator (DBA) with a strong background in AWS
Location : Basking ridge, NJ (onsite/5 days)
About Position
We are seeking an experienced PostgreSQL Database Administrator (DBA) with a strong background in AWS to manage and optimize our PostgreSQL databases in production environments. The ideal candidate will have a proven track record of performance tuning, query optimization, and database management in cloud settings. This role requires a detail-oriented professional who can troubleshoot complex issues and ensure high availability and disaster recovery for our database systems.
What You'll Do
- Manage, monitor, and support PostgreSQL databases in production environments.
- Perform performance tuning, query optimization, indexing, backup/recovery, and capacity planning.
- Manage high availability (HA) and disaster recovery (DR) solutions, including 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.
Mandatory Skills
- 7-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, point-in-time recovery (PITR), HA/DR, security, and database monitoring.
- Experience with Linux and Shell/Python scripting.
- Good communication, troubleshooting, and stakeholder-management skills.
Preferred Skills
- Experience with Terraform/Ansible.
- Familiarity with CI/CD processes.
- Experience with PostgreSQL migration.
- AWS certification.
Expertise You'll Bring
The successful candidate will demonstrate a strong ability to manage complex database environments and provide strategic insights into database performance and optimization. You will be expected to work collaboratively with cross-functional teams and communicate effectively with stakeholders to ensure database reliability and efficiency.
If you are a proactive and skilled PostgreSQL DBA with a passion for cloud technologies and database management, we encourage you to apply for this exciting opportunity
