Job Description
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.
Requirements
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.
PostgreSQL DBA • Toronto, ON, ca
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... Show more
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... Show more
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... Show more
Join a leading team as a Database & Integration Engineer in Downtown Toronto, focusing on cloud-based data integration and enterprise modernization.Leverage your skills in ETL and data integrity.In... Show more
Oracle 19c db version Candidate should have 3-5 years of experience working on OCAC ( Oracle Cloud At Customer) and Oracle Exadata including a full understanding of its architecture Candidate shoul... Show more
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... Show more
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... Show more
An innovative IT services firm is seeking a talented data integration specialist to join their dynamic team.In this mid-senior level role, you will leverage your extensive experience in ETL process... Show more
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... Show more
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... Show more
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... Show more
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... Show more
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... Show more
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... Show more
A leading global software engineering firm is seeking a skilled SQL Database Developer in Toronto, Ontario.This role demands 8-10 years of experience in SQL database development, focusing on optimi... Show more
A financial services provider in Toronto is seeking a skilled Senior Database Architect / Developer (MSSQL) to manage and optimize SQL databases.Responsibilities include data purging, index optimiz... Show more
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... Show more
Drive database efficiency and reliability as a Senior Oracle Database Administrator at Tangerine in Toronto, Ontario.Oversee database architecture while enhancing system performance and data availa... Show more
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... Show more
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... Show more
