PostgreSQL DBA
About the role
PostgreSQL DBA – PostgreSQL Administration, Performance Tuning & High Availability
Toronto, ONWork Model: Hybrid (4 days a week in office)
Required Skills
- PostgreSQL Database Administration
- PostgreSQL Architecture
- Performance Tuning & Query Optimization
- High Availability & Clustering
- Backup & Recovery
Role Description
Database Administration
- Install, configure, and maintain PostgreSQL databases in production and non-production environments.
- Perform database refresh activities between environments.
- Execute database patching and upgrade activities.
Architecture & Performance
- Manage PostgreSQL architecture, including memory management, indexing, and query optimization.
- Analyze query execution plans and perform performance tuning.
High Availability & Clustering
- Implement and manage repmgr clustering for high availability and failover.
- Troubleshoot and resolve cluster node failures.
Migration & Cloud Integration
- Design and execute database migration strategies from on-premises to cloud environments.
- Experience with Google Cloud Platform (GCP) or Microsoft Azure is an asset.
Backup & Recovery
- Implement database backup, recovery, and disaster recovery procedures.
- Configure logical and physical backup strategies using native PostgreSQL tools and third-party solutions.
Replication
- Configure and manage logical and streaming replication across environments.
Required Qualifications
- Proven experience as a PostgreSQL Database Administrator in enterprise environments.
- Strong knowledge of PostgreSQL architecture, including WAL, MVCC, and Vacuum processes.
- Hands-on experience with repmgr clustering, failover handling, and node recovery.
- Expertise in performance tuning, query optimization, and troubleshooting.
- Experience with migration strategies from on-premises to cloud platforms.
- Familiarity with Oracle DBA, RMAN, GoldenGate, and Exadata.
- Proficiency in backup, recovery, and disaster recovery planning.
- Working knowledge of logical and streaming replication.
- Excellent problem-solving and communication skills.
Preferred Qualifications
- Experience with Ansible and Terraform.
- Knowledge of pgAdmin, Prometheus, or Grafana.
- Scripting experience with Shell, Python, or similar languages.
Not the right fit? Search for PostgreSQL DBA jobs in Toronto, Ontario, Canada
About Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Astra - North Infoteck Inc.
Agile - Systems - Technologies - Resources - Applications
Apply for Jobs@ https://careers.astra-north.com/jobs/
We are a global information technology services, management consulting and outsourcing company headquartered in Canada. Astra North helps clients navigate the ever-changing complex information technology landscape with its portfolio of IT consulting services, managed services and staffing and talent management solutions.
The core challenge facing many businesses in their IT functions is the increasing shortage of talent across the globe and its resultant impact on productivity. To overcome this challenge Astra-North provides its clients with a single source Integrated Recruitment Process Outsourcing - iRPO Service. Astra-North works as a specialist strategic partner for its clients by providing the best talent pool of IT Professionals on contract hire, permanent hire or managed services basis through its comprehensive and integrated recruitment, staff augmentation, workforce solutions, recruitment process outsourcing and managed services programs which are customized for individual client needs. Astra North Staffing Services include managing programs that are in compliance with matters focussing on careers, communications, legal and regulatory issues, technology and outsourcing, budgeting and metrics, IT staffing management best practices and global staffing management issues.
Our technical service extends the entire software development lifecycle from Consulting, Business Process Analysis, Requirement Mapping, Analysis, Design, Development, Testing to Implementation and Support. Astra-North Infoteck has expertise in building, maintaining and reengineering IT solutions to meet its client’s evolving needs.We help clients become agile to meet and exceed their goals.
Astra-North ~ Conquering Today's Challenges, Achieving Tomorrow's Vision!
Similar Jobs
PostgreSQL DBA
About the role
PostgreSQL DBA – PostgreSQL Administration, Performance Tuning & High Availability
Toronto, ONWork Model: Hybrid (4 days a week in office)
Required Skills
- PostgreSQL Database Administration
- PostgreSQL Architecture
- Performance Tuning & Query Optimization
- High Availability & Clustering
- Backup & Recovery
Role Description
Database Administration
- Install, configure, and maintain PostgreSQL databases in production and non-production environments.
- Perform database refresh activities between environments.
- Execute database patching and upgrade activities.
Architecture & Performance
- Manage PostgreSQL architecture, including memory management, indexing, and query optimization.
- Analyze query execution plans and perform performance tuning.
High Availability & Clustering
- Implement and manage repmgr clustering for high availability and failover.
- Troubleshoot and resolve cluster node failures.
Migration & Cloud Integration
- Design and execute database migration strategies from on-premises to cloud environments.
- Experience with Google Cloud Platform (GCP) or Microsoft Azure is an asset.
Backup & Recovery
- Implement database backup, recovery, and disaster recovery procedures.
- Configure logical and physical backup strategies using native PostgreSQL tools and third-party solutions.
Replication
- Configure and manage logical and streaming replication across environments.
Required Qualifications
- Proven experience as a PostgreSQL Database Administrator in enterprise environments.
- Strong knowledge of PostgreSQL architecture, including WAL, MVCC, and Vacuum processes.
- Hands-on experience with repmgr clustering, failover handling, and node recovery.
- Expertise in performance tuning, query optimization, and troubleshooting.
- Experience with migration strategies from on-premises to cloud platforms.
- Familiarity with Oracle DBA, RMAN, GoldenGate, and Exadata.
- Proficiency in backup, recovery, and disaster recovery planning.
- Working knowledge of logical and streaming replication.
- Excellent problem-solving and communication skills.
Preferred Qualifications
- Experience with Ansible and Terraform.
- Knowledge of pgAdmin, Prometheus, or Grafana.
- Scripting experience with Shell, Python, or similar languages.
Not the right fit? Search for PostgreSQL DBA jobs in Toronto, Ontario, Canada
About Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Astra - North Infoteck Inc.
Agile - Systems - Technologies - Resources - Applications
Apply for Jobs@ https://careers.astra-north.com/jobs/
We are a global information technology services, management consulting and outsourcing company headquartered in Canada. Astra North helps clients navigate the ever-changing complex information technology landscape with its portfolio of IT consulting services, managed services and staffing and talent management solutions.
The core challenge facing many businesses in their IT functions is the increasing shortage of talent across the globe and its resultant impact on productivity. To overcome this challenge Astra-North provides its clients with a single source Integrated Recruitment Process Outsourcing - iRPO Service. Astra-North works as a specialist strategic partner for its clients by providing the best talent pool of IT Professionals on contract hire, permanent hire or managed services basis through its comprehensive and integrated recruitment, staff augmentation, workforce solutions, recruitment process outsourcing and managed services programs which are customized for individual client needs. Astra North Staffing Services include managing programs that are in compliance with matters focussing on careers, communications, legal and regulatory issues, technology and outsourcing, budgeting and metrics, IT staffing management best practices and global staffing management issues.
Our technical service extends the entire software development lifecycle from Consulting, Business Process Analysis, Requirement Mapping, Analysis, Design, Development, Testing to Implementation and Support. Astra-North Infoteck has expertise in building, maintaining and reengineering IT solutions to meet its client’s evolving needs.We help clients become agile to meet and exceed their goals.
Astra-North ~ Conquering Today's Challenges, Achieving Tomorrow's Vision!