What are the responsibilities and job description for the PostgreSQL Database Administrator (DBA) with AWS position at Nityo Infotech Corporation?
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