PostgreSQL Database Administrator – PostgreSQL, Clustering & Cloud Migration
- Toronto, ON, Canada
Applications open in a new tab.
Job details
- Posting language
- English
- Posted
Original job description
PostgreSQL Database Administrator – PostgreSQL, Clustering & Cloud Migration
Required Skills & Qualifications
PostgreSQL Administration
- Proven experience as a PostgreSQL Database Administrator in enterprise environments.
- Strong knowledge of PostgreSQL architecture, including:
- WAL
- MVCC
- Vacuum processes
- Hands-on experience with RepMgr clustering, failover handling, and node recovery.
- Working knowledge of:
- Logical replication
- Streaming replication
Performance & Troubleshooting
- Expertise in:
- Performance tuning
- Query optimization
- Database troubleshooting
- Strong problem-solving skills for complex database issues.
Migration, Backup & Recovery
- Experience with migration strategies from on-premises environments to cloud platforms.
- Proficiency in:
- Backup and recovery
- Disaster recovery planning
- Familiarity with Oracle DBA technologies, including:
- RMAN
- GoldenGate
- Exadata
Technical Skills
- Experience with database automation tools:
- Ansible
- Terraform
- Knowledge of database monitoring tools:
- pgAdmin
- Prometheus
- Grafana
- Scripting experience using:
- Shell
- Python
- Similar automation scripting languages
Preferred Qualifications
- Experience automating database deployments and operational processes.
- Strong communication skills with the ability to collaborate across technical teams.
More about this job
Responsibilities
The PostgreSQL Database Administrator at Astra North Infoteck Inc. will run and tune PostgreSQL databases, handle clustering, failover and recovery, and plan migrations from on-premises systems to the cloud. The role also automates database deployments and monitors database health.
Requirements
Astra North Infoteck Inc. needs candidates with proven enterprise PostgreSQL administration experience, RepMgr clustering and replication skills, and strong troubleshooting and performance tuning abilities. Familiarity with Oracle DBA tools, automation and monitoring tools, and scripting in Shell or Python is also expected.
Skills
- PostgreSQL
- RepMgr
- WAL
- MVCC
- Vacuum
- Streaming replication
- Logical replication
- Failover and node recovery
- Performance tuning
- Query optimization
- Database troubleshooting
- Cloud migration
- Backup and recovery
- Disaster recovery planning
- Oracle RMAN
- Oracle GoldenGate
- Oracle Exadata
- Ansible
- Terraform
- pgAdmin
- Prometheus
- Grafana
- Shell scripting
- Python
- Database automation
Categories
- Software
- Technology
- Data & Analytics
Keywords
- PostgreSQL
- PostgreSQL DBA
- Database Administrator
- DBA
- RepMgr
- Clustering
- Failover
- Streaming replication
- Logical replication
- WAL
- MVCC
- Vacuum
- Performance tuning
- Query optimization
- Cloud migration
- Disaster recovery
- Backup and recovery
- Oracle DBA
- RMAN
- GoldenGate
Tools
- PostgreSQL
- RepMgr
- Ansible
- Terraform
- pgAdmin
- Prometheus
- Grafana
- Oracle RMAN
- Oracle GoldenGate
- Oracle Exadata