Toronto, ON - Hybrid (2-3 Days WFO)
6-12 months
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 ResponsibilitiesData Modeling & Database DesignCreate 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 DevelopmentTranslate 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 & OperationsInstall| 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
Essential Skills: Experience with cloud database services like AWS RDS or Azure Database for PostgreSQL is beneficial. Familiarity with high-availability tools and migration/versioning tools is a plus. Knowledge of containerized platforms and infrastructure-as-code practices is advantageous. Relevant certifications in PostgreSQL or cloud databases are desirable. Experience with AI-assisted development tools is a nice-to-have.Must have strong PostgreSQL skills| including administration and performance tuning. Experience with data modeling and database design is essential. Familiarity with spec-driven development practices is required. Knowledge of backup and recovery processes is critical. Proficiency in SQL and PL/pgSQL is necessary for this role.Required QualificationsBachelors degree in Computer Science| Information Technology| Engineering| or equivalent practical experience.5+ years of database administration or data platform experience| including substantial hands-on PostgreSQL administration.Demonstrated