Senior PostgreSQL Database Administrator
Hybrid in Markham, ON, CA • Posted 2 days ago • Updated 2 days agoContract Corp To Corp
Contract Independent
Contract W2
75% Travel Required
Hybrid
$60 - $65/hr


Zeal Solutions Inc
Fitment
Dice Job Match Score™
👾 Reticulating splines...
Job Details
Skills
- PostgreSQL
- Database Administration
- DBA
- High Availability
- Disaster Recovery
- Performance Tuning
- Query Optimization
- Linux/Unix
- Bash/Python Scripting
- Replication
- Cloud DBA
- pgBackRest
- Barman
- Docker
- Kubernetes
- MongoDB
- CI/CD
- Ansible
- Terraform
- Mentoring
- Troubleshooting
Summary
Position: PostgreSQL System Admin
Location: Canada
Work Mode: Hybrid
Job Summary:
We are looking for a seasoned Senior PostgreSQL Database Administrator with 5–7 years of hands-on experience in managing large-scale PostgreSQL environments. The ideal candidate will ensure high performance, scalability, and security of mission-critical databases, mentor junior DBAs, and contribute to architectural decisions for high availability and business continuity.
Key Responsibilities:
- Lead installation, configuration, and administration of PostgreSQL servers across production and non-production environments.
- Design and implement High Availability (HA), Disaster Recovery (DR), and replication strategies.
- Monitor and analyze database performance; identify bottlenecks and optimize queries/configurations.
- Perform database upgrades, patching, and migrations with minimal downtime.
- Implement and maintain robust backup and recovery solutions (e.g., pgBackRest, Barman).
- Ensure database security through access control, auditing, and encryption.
- Automate routine DBA tasks using Bash, Python, or Ansible.
- Collaborate with development, DevOps, and infrastructure teams for scalable architecture.
- Document processes, standards, and best practices.
- Mentor junior DBAs and act as a PostgreSQL SME across teams.
- Participate in on-call rotations and handle critical production incidents.
Required Skills & Qualifications:
- Bachelor’s degree in Computer Science, Engineering, or related field.
- 5–7 years of PostgreSQL DBA experience in production; exposure to MongoDB preferred.
- Strong knowledge of PostgreSQL internals, architecture, and advanced features (v14).
- Hands-on experience with streaming/logical replication, clustering, and performance tuning.
- Proficient in backup/recovery strategies and tools.
- Advanced Linux/Unix skills and scripting (Bash or Python preferred).
- Familiarity with monitoring tools like Prometheus, Grafana, Zabbix.
- Experience managing PostgreSQL on cloud platforms (AWS RDS, Google Cloud Platform Cloud SQL, Azure).
Preferred Skills / Good to Have:
- Containerization/orchestration experience (Docker, Kubernetes).
- Knowledge of other databases (MySQL, Oracle, NoSQL).
- Exposure to CI/CD pipelines and DevOps practices.
- Infrastructure-as-Code (Ansible, Terraform) experience.
Soft Skills:
- Strong analytical, problem-solving, and troubleshooting abilities.
- Excellent communication and documentation skills.
- Leadership, mentoring, and team collaboration mindset.
- Proactive approach with focus on process improvements and automation.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 91172983
- Position Id: 48932
- Posted 2 days ago
Create job alert
Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs