Role details

Contract type

Contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

6 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Amazon Web Services Amazon Elastic Compute Cloud Cloud Computing Databases Python (Programming Language) PostgreSQL Backup and Restore Scripting Google Cloud Software Troubleshooting Kubernetes Database Replication

Requirements

1. Strong understanding of PostgreSQL architecture and internal components.
2. Hands-on experience with logical and physical backup and restore strategies, including Point-in-Time Recovery (PITR).
3. Proven experience in performing minor and major PostgreSQL version upgrades.
4. Extensive experience with database replication and high-availability solutions.
5. Responsible for day-to-day database operations, monitoring, and performance troubleshooting (CPU/load, locks, blocking, long-running queries, etc..).
6. Deep knowledge of PostgreSQL configuration parameters, system catalogs, and performance views.
7. Experience with routine database maintenance activities (vacuum, analyze, reindex, patching).
8. Hands-on exposure to cloud-based PostgreSQL deployments on AWS (RDS/EC2) and/or Google Cloud Platform (Google Cloud Platform).
9. Strong experience with HA/DR tools such as Repmgr, Pgpool, and pgBackRest.
10. Solid hands-on experience with containerization and orchestration technologies, including Kubernetes.
11. Strong scripting skills in Shell and/or Python for automation and monitoring.
12. Proven experience administering multi-terabyte, high-performance production databases.
13. Ability to independently learn, adapt, and implement new technologies.
14. Excellent communication skills with the ability to collaborate effectively across business and technical teams.
15. Experience in designing and supporting large-scale, mission-critical database infrastructure with high transaction volumes. Good to Have:

• Exposure to Kubernetes platforms such as GKE or EKS. 16. Desirable Skills: Keyword: Skills: PostgreSQL Experience Required: 6-8

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

• Draft this with your agent
• Open in Claude
• Open in ChatGPT
• Copy prompt