PostgreSQL DBA PostgreSQL Administration Performance Tuning & High Availability
Toronto ON
Work 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.
Required Skills:
Top 3 Required Skills: 1. IBM Financial transaction 2. Payment flow 3. Support Modernization Detailed Job Description: Design develop and maintain applications built on IBM Financial Transaction Manager (FTM) to support core payments processing. Contribute to the development of payment flows supporting transaction processing. Build and support integrations between FTM and upstream/downstream systems using enterprise integration patterns. Participate in the design development testing deployment and production support. Troubleshoot and resolve application and integration issues in a complex regulated environment. Collaborate with architecture QA and operations teams to ensure platform stability scalability and performance. Support modernization initiatives and enhancements to existing payment hub capabilities. Produce clear technical documentation and participate in code reviews and knowledge sharing.
Employment Type : Full Time
Experience: years
Vacancy: 1
Monthly Salary Salary: 10 - 10
PostgreSQL DBA • Toronto, Ontario, Canada
A Canadian tech firm is seeking an experienced Database Administrator for a 6-month contract.The role involves managing PostgreSQL and MongoDB installations, ensuring database security, and support... Voir plus
A leading cloud solutions provider located in Toronto, Canada is seeking a GCP Technical Lead to oversee migration projects to Google Cloud Platform.This role requires a strong technical leader exp... Voir plus
Head of Oracle Technologies at Next Ventures.Our client is seeking a highly experienced.Oracle Cloud ERP and Database Expert.This role requires deep expertise across Oracle technologies, cloud plat... Voir plus
A technology solutions provider in Toronto is seeking a Senior Database Administrator with expertise in SQL and Oracle.The role involves performance tuning, storage optimization, and managing repli... Voir plus
A premier tech firm in Toronto is seeking a Senior PostgreSQL System Administrator with 5–7 years of experience in managing large-scale PostgreSQL environments.This position involves leading databa... Voir plus
A leading IT consulting firm in Toronto is seeking a Senior Database Administrator with extensive experience in Oracle DB for a long-term contract.This role demands expertise in complex database ma... Voir plus
A leading technology staffing firm in Toronto seeks an experienced Database Administrator.The successful candidate will manage PostgreSQL and MongoDB databases, ensuring security and efficiency acr... Voir plus
Centric Software® is a global leader, providing an innovative and AI-enabled product-concept-to-commercialization platform for retailers, brands and manufacturers of all sizes.We equip retail, fash... Voir plus
The Database Reliability Engineer will ensure the smooth functioning of datastores, designing solutions for large-scale engineering challenges and contributing to database reliability, availability... Voir plus
Elevate your career as a Lead PostgreSQL DBA at Kraken, focusing on high-throughput environments.This remote role centers on operational excellence and automation.Join a team dedicated to scaling d... Voir plus
A leading technology firm is hiring LLM Serving Engineers in Markham to develop scalable AI inference platforms.Candidates will work on machine learning packages and directly collaborate with vario... Voir plus
A technology consulting firm is seeking a highly experienced Oracle Cloud ERP and Database Expert for a long-term remote assignment in Canada.The role focuses on providing expert-level support acro... Voir plus
A leading technology services firm is seeking a Database Administrator Specialist.This hybrid role, based in downtown Toronto, demands strong expertise in Oracle GoldenGate and SQL Azure.The succes... Voir plus
Become a PostgreSQL Database Expert with Centric Software, focusing on performance and reliability in a remote setting.Bring your expertise to enhance our customer support strategies.As a Productio... Voir plus
Huawei Canada has an immediate permanent opening for a Senior Engineer.Established in 2014, the Distributed Scheduling and Data Engine Lab is Huawei Cloud's technical innovation center in Canada.Th... Voir plus
Join Engage as a Senior DevOps Administrator II and drive impactful solutions for web technology systems.Manage cloud infrastructure and collaborate to optimize internal processes.In this role, you... Voir plus
Location 44 King Street W 10th Floor, Toronto, Ontario.Hybrid: 2 days in-office (will increase to 4 days in future).Possibility of extension: Yes, based on performance and business needs.Conversion... Voir plus
A leading recruitment firm in Toronto is seeking a mid-senior level Regional Recruiting Manager to oversee database engineering with NoSQL technologies.The ideal candidate will have 5-7 years in da... Voir plus
A leading consulting firm is seeking a Senior Data Architect to enhance and integrate applications, focusing on Oracle E-Business Suite and cloud technologies.The role requires deep technical exper... Voir plus
About Centric Software: Centric Software® is a global leader, providing an innovative and AI-enabled product-concept-to-commercialization platform for retailers, brands and manufacturers of all siz... Voir plus
