WeAreDevelopers Logo WeAreDevelopers
Sign in
For You LIVE
Back

PostgreSQL DBA

Nityo Infotech Corporation
Jersey City, NJ, United States
1 day ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source
www.dice.com

Tech stack

Amazon Web Services Amazon Elastic Compute Cloud Amazon S3 Backup Devices Continuous Integration Linux Failover Identity and Access Management PostgreSQL Performance Tuning Query Optimization Ansible
+9 more
Scripting Indexer Database Migration Amazon Relational Database Service Cloud Migration Database Monitoring Cloudwatch Terraform Sql Tuning

Job description

  • 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.

Requirements

  • 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…