PostgreSQL Database Administrator

Apptoza Inc.

Toronto

Hybrid

CAD 90,000 - 130,000

Full time

17 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Apptoza Inc. in Toronto, ON is seeking a Contract Role focused on designing and optimizing PostgreSQL database platforms.

The role involves creating data models and database specifications aligned with business requirements, and managing backup, recovery, and performance tuning. You will participate in incident response, root-cause analysis, and maintain documentation to ensure compliance with database standards.

Qualifications

  • Experience designing PostgreSQL schemas and data models.
  • Hands-on PostgreSQL administration and operations including backup and recovery.
  • Ability to translate business requirements into database specifications.

Responsibilities

  • Design and optimize PostgreSQL database platforms.
  • Create data models and database specifications based on business requirements.
  • Manage backup, recovery, and performance tuning.
  • Participate in incident response and root-cause analysis.
  • Maintain documentation and ensure database standards compliance.

Skills

PostgreSQL
Data Modeling
Database Design
SQL
Performance Tuning

Job description

Location: Toronto, ON – Hybrid

Contract Role

Job Description

Role Descriptions: Key responsibilities include designing and optimizing PostgreSQL database platforms. The role involves creating data models and database specifications based on business requirements. The DBA will also manage database operations| including backup| recovery| and performance tuning. Additionally| the position requires participation in incident response and root-cause analysis. Maintaining documentation and ensuring compliance with database standards is also crucial. Key Responsibilities Data Modeling & Database Design Create conceptual| logical| and physical data models aligned with business processes| application architecture| data ownership| and reporting needs. Design PostgreSQL schemas| tables| relationships| constraints| indexes| views| materialized views| sequences| functions| and partitioning strategies. Define naming conventions| data types| normalization and selective denormalization standards| reference data patterns| and database design guidelines. Review entity-relationship diagrams and database changes for integrity| scalability| maintainability| and performance before implementation. Plan schema evolution and data migrations with backward compatibility| rollback| validation| and minimal-downtime considerations. Spec-Driven PostgreSQL Development Translate approved functional| data| security| performance| and retention requirements into precise| version-controlled PostgreSQL specifications that define schemas| tables| relationships| constraints| indexes| views| functions| migrations| rollback behavior| and acceptance criteria. Use AI-assisted or specification-driven engineering tools to generate PostgreSQL DDL| DML| PL/pgSQL| migration scripts| seed data| documentation| and automated database tests from the approved specifications| minimizing manual coding. Review| validate| and approve AI-generated database artifacts for correctness| data integrity| security| performance| maintainability| and compliance before merge or deployment. AI-generated output must never be promoted without human review. Maintain traceability from business requirement to specification| generated database object| test case| deployment evidence| and production change record in Git-based repositories and CI/CD pipelines. Implement automated quality gates including SQL linting| schema validation| migration testing| backward-compatibility checks| security scanning| performance baselines| and rollback verification. Manage specification changes through peer review and controlled regeneration so the specification remains the source of truth and direct production database changes are prevented or reconciled. PostgreSQL Administration & Operations Install| configure| patch| upgrade| and administer PostgreSQL across development| test| staging| and production environments. Manage roles| privileges| authentication| encryption| secrets| auditing| and least-privilege access in partnership with security teams. Design and test backup| point-in-time

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Admin - Oracle, Postgressql
Database Admin - Oracle, Postgressql

Astra-North Infoteck Inc. • Toronto

On-site
CAD 90,000 - 120,000
PostgreSQL DBA
PostgreSQL DBA

Delpath • Toronto

Hybrid
CAD 100,000 - 130,000
Senior PostgreSQL & MongoDB DBA - Hybrid (Toronto)
Senior PostgreSQL & MongoDB DBA - Hybrid (Toronto)

Delpath • Toronto

Hybrid
CAD 100,000 - 130,000
Senior System Administrator
Senior System Administrator

Galent • Markham

On-site
CAD 90,000 - 120,000
Senior PostgreSQL Lead DBA - Remote & AWS-Ready
Senior PostgreSQL Lead DBA - Remote & AWS-Ready

Canadian Inclusion • Quebec

Hybrid
CAD 80,000 - 110,000
PostgreSQL Database Administrator (Production DBA)
PostgreSQL Database Administrator (Production DBA)

Centric Software • Canada

Remote
CAD 173,000 - 211,000
Database Administrator
Database Administrator

Lancesoft • Toronto

Hybrid
CAD 80,000 - 100,000
PostgreSQL Database Administrator (Production DBA)
PostgreSQL Database Administrator (Production DBA)

Centric Software • Toronto

Remote
CAD 160,000 - 217,000
Software Engineer - Postgres Tooling
Software Engineer - Postgres Tooling

Jobgether • Canada

Remote
CAD 120,000 - 180,000
Fully remote India
WeWork allowance
ESOP
+7
Database Administrator (Oracle & SQL Server)
Database Administrator (Oracle & SQL Server)

Astra-North Infoteck Inc. • Calgary

On-site
CAD 85,000 - 110,000