About this role
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 initiative