PostgreSQL DBA

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.