Log in Sign up free
Apply now

Posted 4 months ago

PostgreSQL Database Administrator – PostgreSQL, Clustering & Cloud Migration

@ Astra North Infoteck Inc.

View all jobs

Toronto, Ontario

Apply now
SIGNALS

Overview

Astra North Infoteck Inc. is hiring a PostgreSQL Database Administrator to manage enterprise PostgreSQL environments, including clustering, failover, performance tuning and cloud migration. The role requires hands-on RepMgr clustering experience, deep knowledge of PostgreSQL internals, and backup and disaster recovery planning. Schedule.

Responsibilities:

  • Administer enterprise PostgreSQL databases
  • Manage RepMgr clustering, failover and node recovery
  • Tune performance and optimize queries
  • Plan on-premises to cloud migrations
  • Automate database deployments with Ansible and Terraform

Requirements summary:

  • Proven enterprise PostgreSQL DBA experience
  • Deep knowledge of PostgreSQL architecture (WAL, MVCC, vacuum)
  • Hands-on RepMgr and replication experience
  • Backup, recovery and disaster recovery skills
  • Oracle DBA experience (RMAN, GoldenGate, Exadata) an asset
  • Scripting in Shell or Python

Tools & skills

PostgreSQLRepMgrAnsibleTerraformpgAdminPrometheusGrafanaOracle RMANOracle GoldenGateOracle Exadata
Source and dates

Source type not verified · zoho

Employer posting date
2026-07-08
First seen by our source
2026-10-11
Source record updated
2026-10-11

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

DepartmentSoftware development
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high

Summary and details written by AI from the posting; the employer’s posting is the authority.

Apply now

Astra North Infoteck Inc.

View all jobs
FieldValue
Open jobs on Jobsy426
Job description

PostgreSQL Database Administrator – PostgreSQL, Clustering & Cloud Migration​

Required Skills & Qualifications

PostgreSQL Administration

• Proven experience as a PostgreSQL Database Administrator in enterprise environments.

• Strong knowledge of PostgreSQL architecture, including:

• WAL

• MVCC

• Vacuum processes

• Hands-on experience with RepMgr clustering, failover handling, and node recovery.

• Working knowledge of:

• Logical replication

• Streaming replication

Performance & Troubleshooting

• Expertise in:

• Performance tuning

• Query optimization

• Database troubleshooting

• Strong problem-solving skills for complex database issues.

Migration, Backup & Recovery

• Experience with migration strategies from on-premises environments to cloud platforms.

• Proficiency in:

• Backup and recovery

• Disaster recovery planning

• Familiarity with Oracle DBA technologies, including:

• RMAN

• GoldenGate

• Exadata

Technical Skills

• Experience with database automation tools:

• Ansible

• Terraform

• Knowledge of database monitoring tools:

• pgAdmin

• Prometheus

• Grafana

• Scripting experience using:

• Shell

• Python

• Similar automation scripting languages

Preferred Qualifications

• Experience automating database deployments and operational processes.

• Strong communication skills with the ability to collaborate across technical teams.


Similar jobs

  • PostgreSQL Database Administrator (Production DBA)

    Toronto, ON
    Full Time

    Centric Software, Inc.: From its headquarters in Silicon Valley, Centric Software provides an innovative and AI-enabled product concept-to-commercialization platform for…

    5+ YOECandidates need at least five years of hands-on PostgreSQL administration in production, with deep knowledge of Postgres internals, strong SQL and execution-plan skills, and experience with replication, high availability and backup tools. Located in North America with core hours overlapping the team.

    PostgreSQL, PgBouncer, Patroni, pgBackRest, WAL-G, pg_basebackup

  • Billing Manager

    Toronto, ON +1

    The Fertility Partners Inc: TFP provides partner clinics with back-office support and a collaborative synergistic medical-scientific, professional and business environment.

    We strive to provide support, knowledge, choices and treatment for our fertility patients, ultimately helping them achieve their goal of becoming parents; Prepares funded-cycle reporting and supports compliance with…

  • Bilingual Client Services Representative

    Toronto, ON
    Full Time

    CI Investments Inc.

    You will work independently and collaboratively in a fast-paced, regulated environment, bringing sound judgment, attention to detail, and a strong commitment to the client experience; Support account-opening and…

  • Power Systems Engineer Intern - Co-Op

    Toronto, ON

    Electric Power Engineers: Electric Power Engineers (EPE) is a global advisory and engineering firm advancing grid reliability, resilience, flexibility, and affordability.

    Internships at Electric Power Engineers, Inc. are more than just a job, they’re an experience!; This position will report to an experienced Transmission Manager and be exposed to exciting projects building valuable…

    IBM Power Systems, Process improvement, Python, Electrical engineering, Computer engineering

  • Financial Planning Analyst

    Toronto, ON
    HybridFull Time

    ecobee Technologies ULC

    This role follows a hybrid schedule, with in-office work required on Wednesdays and Thursdays to support collaboration, and flexibility to work remotely for the remainder of the week; 3+ years of experience in…

    Senior Financial Planning Analyst

    Toronto, ON
    HybridFull Time

    ecobee Technologies ULC

    This role follows a hybrid schedule, with in-office work required on Wednesdays and Thursdays to support collaboration, and flexibility to work remotely for the remainder of the week; 5+ years of experience in…

  • Supply Chain Business Partner

    Toronto, ON

    Wesdome Gold Mines Ltd: The Company is 100% Canadian focused with a pipeline of projects in various stages of development.

    As the primary supply chain interface for site operations, the SCBP ensures sourcing decisions, contracts, and supplier engagements are aligned with business needs, category strategies,…; You are a highly analytical…

  • Senior Financial Analyst, Financial Reporting

    Toronto, ON
    $105k–$155k/yr

    Torex Resources Inc.

    Reporting to the Corporate Controller, the Senior Financial Analyst, Financial Reporting is responsible for the end-to-end preparation of Torex’s quarterly and annual consolidated…; Bachelor's degree in Accounting,…

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.