Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

PostgreSQL Database Administrator with AWS RDS/Azure DB

Full-time

Astra North Infoteck Inc.

Job Title: PostgreSQL Database Administrator with AWS RDS/Azure DB

Role Description

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 Qualifications

  • Bachelor's 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
Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the PostgreSQL Database Administrator with AWS RDS/Azure DB in Toronto, ON vacancy
  •  ...Database Administrator – Oracle, SQL Server, AWS RDS Location: Toronto, ON, Canada Work Model: Hybrid (2 days per week in-person at Toronto Canada office preferred) Experience Required: 6–8 Years Skills: AWS DevOps and Automation, Database Administration (DBMS... 
    Amazon Web Service
    Permanent employment
    Work at office
    2 days per week

    Astra North Infoteck Inc.

    Toronto, ON
    10 days ago
  • $100k - $130k per year

     ...structure under it?  We're hiring a Database Administrator to join an established recovery-audit firm...  ...a large on-premises SQL Server estate, with databases of 30 to 40 terabytes on Pure...  ...teams  Nice to have:  Experience with Azure SQL Database or Azure SQL Managed... 
    Amazon Web Service
    PostgreSQL
    Full time
    Remote work

    STACK IT Recruitment

    Toronto, ON
    22 days ago
  •  ...Job Summary We are looking for an experienced Senior PostgreSQL System Administrator with 5–7 years of hands-on experience managing large-scale, mission...  ...in performance tuning, high availability design, and database security, and who enjoys mentoring junior DBAs while... 
    Amazon Web Service
    PostgreSQL
    Contract work

    Galent

    Toronto, ON
    more than 2 months ago
  •  ...Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist Location: Toronto, ON Work Arrangement: Hybrid...  ...Role Descriptions Collaborate with application development teams on data...  ...transactional environments. Lead database release automation, code reviews, and... 
    Amazon Web Service
    PostgreSQL
    Permanent employment
    Internship
    Manual labor
    Work at office
    Weekend work
    Weekday work

    Astra North Infoteck Inc.

    Toronto, ON
    17 days ago
  •  ...We are seeking an experienced Intermediate Database Administrator with strong senior-level DBA expertise to oversee both on-premises and cloud-based (Azure) database environments. In this role, you will be responsible for managing Microsoft SQL Server, supporting Microsoft... 
    Suggested
    Contract work

    Randstad Canada

    Toronto, ON
    11 days ago
  •  ...distribution and outreach firm that works with public companies and asset managers. We...  ...We’re looking for a talented Junior Database Administrator to join our team and work alongside our...  ...Exposure to cloud platforms, ideally Azure Experience with replication, high availability... 

    forum-ventures

    Toronto, ON
    9 days ago
  • $92.1k - $142.1k per year

     ...a time of exponential change with speed. With deep expertise in...  ...hands-on Db2 for z/OS and IMS DB/DC experience Experience supporting...  ...with IMS DBRC/RECON administration, DBD/PSB/ACB management, IMS recovery...  ...environments DB2 & IMS Database Administration Provide day-... 
    Permanent employment
    Full time
    Contract work
    Remote work
    Flexible hours

    DXC Technology

    Toronto, ON
    14 days ago
  •  ...you will be doing   As a Lead SQL Database Engineer (Azure) you will be responsible for deployment, migration, implementation, and administration of databases and support of all...  ...checks, and replication and works directly with other teams to triage and troubleshoot... 
    Flexible hours
    3 days per week
    1 day per week

    CIBC

    Toronto, ON
    11 days ago
  •  ...Cloud Database Administrator About FNZ FNZ is committed to opening up wealth so that everyone, everywhere can invest in their future on their terms...  ...wealth management platform that integrates modern technology with business and investment operations. All in a regulated... 
    Full time

    FNZ

    Toronto, ON
    14 days ago
  • $75.6 - $90.72 per hour

     ...RQ11210 - Sr. Database Administrator 9-month contract (170 business days) - possible extension...  ...on experience as a DBA ~ Experience with database optimization, capacity planning...  ...environments including database administration, maintenance, optimization, migration,... 
    Contract work
    Remote work

    Source Code

    Toronto, ON
    more than 2 months ago
  •  ...and Deployment solutions in our Azure environment. As a Senior...  ...Engineer, you will work closely with the CTO, VP, and Engineering team...  ...with Azure architecture & administration, Serverless, Azure App Service...  ...Familiar with SQL, Azure SQL, Cosmos DB, Azure Cache Passionate... 
    Full time
    Contract work
    Internship
    Remote work

    Plooto

    Toronto, ON
    4 days ago
  • Job Responsibility: Job Title: AWS Architect Location: Toronto, ON Duration: Long Term Contract...  ...' AWS Cloud services Drive cloud security with leading the design and implementation of...  ...: IAM, EC2, EKS, Lambda, API Gateway, S3, RDS, KMS, VPC, Cognito, Config, SCP, Security... 
    Amazon Web Service
    Long term contract
    Full time
    Fixed term contract
    Relocation

    APPTOZA INC.

    Toronto, ON
    4 days ago
  •  ...world. Job Description The AWS Solution Architect is...  ...provisioning The architect collaborates with enterprise architects platform...  ...of applications ETL processes databases and data lake workloads from onpremises...  ...o EMR o Redshift o RDS o CloudWatch o SNSSQS... 
    Amazon Web Service
    Permanent employment
    Full time
    Local area

    Capgemini

    Toronto, ON
    16 days ago
  •  ...Find Your Limitless with Reliance By joining Reliance as an Analyst, Databases, you’ll become an important Team Member and will be provided with the tools you need...  ...on Enterprise Service Bus (ESB) Tools and Azure Pipelines • Experienced with Azure Data tools such... 

    Reliance Home Comfort

    Toronto, ON
    11 days ago
  • $120k per year

     ...AWS Architect Key Responsibilities 1. AWS Architecture Design...  ...amend cloud infrastructure with a focus on high availability,...  ...subnetting and CIDR block/mask administration. 2. Disaster Recovery (DR) &...  ...Access Points (MRAP), and RDS/Redshift cross-region replication... 
    Amazon Web Service
    Permanent employment

    Astra North Infoteck Inc.

    Toronto, ON
    29 days ago
  •  ...believe in empowering people. That’s why we equip our teams with cutting-edge technology, AI tools, and a collaborative...  ..., and layered application design Familiarity with databases, networking, system administration, and Voice over IP (VoIP) technologies Demonstrated ability... 
    Amazon Web Service
    Full time
    Work at office
    3 days per week

    Bell

    Toronto, ON
    11 days ago
  • $115k - $165k per year

     ...global business and technology service provider with $11.5B in revenues. CGI is on a mission to...  ...of scalable, secure, and resilient AWS cloud solutions to support modernization and...  ...with AWS core services including EC2, S3, RDS, Lambda, API Gateway, ECS/EKS, IAM, and Infrastructure... 
    Amazon Web Service
    Full time
    Work at office
    Worldwide
    2 days per week

    CGI

    Toronto, ON
    14 days ago
  •  ...TEHORA est présentement à la recherche d’un(e) administrateur(trice) système infonuagique Microsoft 365 / AWS . Sans être exhaustifs, voici les services et livrables...  ...que devra fournir la personne retenue : Administrer les services infonuagiques Microsoft 365 et AWS;... 
    Amazon Web Service
    Hourly pay
    Full time
    Contract work
    Apprenticeship
    Remote work
    Flexible hours

    TEHORA

    Toronto, ON
    more than 2 months ago
  • $140.6k - $190.6k per year

     ...You’ll own the Azure platform that Thomson Reuters product engineering...  ...contributor position with broad technical authority. You...  ...Service plans, autoscale rules, database tiers and read replicas, caching...  ...Hands-on Entra ID / Azure AD administration — RBAC, conditional access, PIM... 
    Amazon Web Service
    Full time
    Work at office
    Local area
    Flexible hours

    Thomson Reuters

    Toronto, ON
    1 day ago
  • $180k - $220k per year

     ...senior gold mining company with operations and projects in the...  ...Director, Geological Data & Database Management is a senior...  ...managing a team of database administrators and analysts.   Key Responsibilities...  ...geological database design, administration, or data management. ~5+... 
    Long term contract
    Temporary work
    Casual work
    Immediate start
    Remote work

    Kinross Gold Corporation

    Toronto, ON
    11 days ago
  • $60k - $110k per year

     ...seeking an experienced Intermediate Azure Cloud Specialist to join our...  ...across a multiple clients. With a focus on scalability, availability...  ...your expertise in GCP, AWS, Azure, Terraform, scripting, coding...  ...including VMs, networking, storage, databases, and security. Familiarity with... 
    Amazon Web Service
    Full time

    CGI

    Toronto, ON
    14 days ago
  • $68k - $80k per year

     ...We are looking for an Investment Database Analyst for an existing vacancy   on our Proposal and Database Team. If you enjoy learning...  ...want to succeed! Our offices currently operate on a hybrid model with a combination of in-office and remote working days throughout the... 
    Internship
    Work at office
    Remote work
    Flexible hours

    Connor, Clark & Lunn Financial Group Ltd.

    Toronto, ON
    5 days ago
  •  ...development environment. The objective is to rationalize and integrate AWB with another internally developed application. Additionally, the...  ...experience working with cloud-based technologies, specifically AWS. Solid expertise in Big Data solutions... 
    Amazon Web Service

    Luxoft

    Toronto, ON
    5 days ago
  • $84k - $175k per year

     ...communities to enjoy the quality of life that comes with a sustainable future. And as the largest...  ...(agents, copilots, orchestration) o Azure OpenAI and Azure AI services • Design...  ...platforms o RAG architectures, vector databases o Azure AI Foundry / ML lifecycle tooling... 
    Permanent employment
    Flexible hours

    Deloitte

    Toronto, ON
    11 days ago
  • $40.8k - $61.2k per year

     ...At EY, we’re all in to shape your future with confidence. We’ll help you succeed in a globally connected powerhouse...  ...working world.  The opportunity You’ll join our Administration Workplace Services (AWS) team helping to support the important business... 
    Amazon Web Service
    Temporary work
    Work at office
    Weekend work

    Ernst & Young

    Toronto, ON
    18 days ago
  • $84.7k - $134.7k per year

     ...of    As a Senior Associate, Azure Data Engineer, you will play a...  ...on Azure. You will work closely with project teams to deliver high-quality...  ..., Amazon Web Services (AWS), Analytical Thinking, Apache Airflow...  ...Data Architecture Development, Database Administration, Database... 
    Amazon Web Service
    Visa sponsorship
    Work visa

    PwC

    Toronto, ON
    17 days ago
  •  ...CRO specializing in gastrointestinal disease therapies, seeks a Database Programmer to design, develop, and maintain clinical study databases...  ...Develop custom functions in C# and create annotated eCRFs with automated edit checks Generate clinical data listings, project... 

    Alimentiv

    Toronto, ON
    24 days ago
  •  ...benefits. It has rebuilt its data foundation on AWS, already runs generative AI in production...  ...: document pipelines, embeddings, vector databases, hybrid retrieval, access-aware search and...  ..., guardrails, audit, and alignment with insurance regulation and model risk management... 
    Amazon Web Service
    Contract work

    Maarut

    Toronto, ON
    3 days ago
  • $69k - $114k per year

     ...the quality of life that comes with a sustainable future. And as...  ...We are seeking an experienced Azure Cloud Engineer to design, build...  ...AKS), Azure Functions, storage, databases and networking. Develop...  ...certifications, such as: Azure Administrator Associate (AZ-104) Azure... 
    Permanent employment
    Remote work
    Flexible hours

    Deloitte

    Toronto, ON
    10 days ago
  • Wed, 11/04/2026 - 00:40 At EY, we’re all in to shape your future with confidence.  We’ll help you succeed in a globally connected...  ...across organization. Architect & Design solutions for cloud (e.g. AWS, Azure) which are optimal, secure, efficient, scalable, resilient and... 
    Amazon Web Service
    Shift work
    Weekend work

    EY

    Toronto, ON
    20 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to PostgreSQL Database Administrator with AWS RDS/Azure DB. Be the first to apply!