Opens LinkedIn
- Employment type
- Contract
- Minimum education
- Bachelor’s degree
- Posting language
- English
- Office presence
- 3 days per week
- Application method
- Apply on LinkedIn (LinkedIn sign-in required)
Job summary
Design, model, administer, and optimize PostgreSQL databases, including schemas, migrations, security, backups, recovery, and performance. Use approved specifications and AI-assisted tools to generate database artifacts, while reviewing outputs, maintaining traceability, and enforcing quality and compliance controls.
Job details
Job Title: PostgreSQL Database Engineer – DBA, Data Modeling & AI-Driven Development Location: Toronto, ON - Hybrid (3 Days WFO) Duration: Contract 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 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 ex
What you’ll do
Design, model, administer, and optimize PostgreSQL databases, including schemas, migrations, security, backups, recovery, and performance. Use approved specifications and AI-assisted tools to generate database artifacts, while reviewing outputs, maintaining traceability, and enforcing quality and compliance controls.
Requirements
Requires a bachelor's degree in Computer Science, Information Technology, Engineering, or equivalent practical experience, plus at least five years of database administration or data platform experience with substantial hands-on PostgreSQL administration. Candidates must have strong PostgreSQL, SQL, and PL/pgSQL skills, experience in data modeling and database design, familiarity with specification-driven development, and knowledge of backup and recovery.
Listed skills
- SQL · Preferred
- AI-assisted development · Preferred
- CI/CD · Preferred
- Root Cause Analysis · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- PostgreSQL Administration
- PostgreSQL Performance Tuning
- Data Modeling
- Database Design
- SQL
- PL/pgSQL
- Backup and Recovery
- Database Security
- Database Operations
- Schema Migrations
- AI-Assisted Development
- Specification-Driven Development
- CI/CD
- Incident Response
- Root-Cause Analysis
Job areas
- Technology
- Data & Analytics
- Software
- Engineering
More jobs from Apptoza Inc.
Treasury Business/Data Analyst
- Hybrid
- Toronto, ON
- Posted Nov 21, 2026
Microsoft 365 Application Operations Engineer
- On-site
- Vancouver, BC
- Posted Nov 21, 2026
M365 Technical lead
- On-site
- Vancouver, BC
- Posted Nov 21, 2026
ServiceNow Lead
- On-site
- Vancouver, BC
- Posted Nov 21, 2026
