PostgreSQL Database Administrator with AWS RDS/Azure DB
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
- ...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 ServicePermanent employmentWork at office2 days per week
$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 ServicePostgreSQLFull timeRemote work- ...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 ServicePostgreSQLContract work
- ...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 ServicePostgreSQLPermanent employmentInternshipManual laborWork at officeWeekend workWeekday work
- ...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...SuggestedContract work
- ...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...
$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 employmentFull timeContract workRemote workFlexible hours- ...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 hours3 days per week1 day per week
- ...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
$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 workRemote work- ...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 timeContract workInternshipRemote work
- 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 ServiceLong term contractFull timeFixed term contractRelocation
- ...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 ServicePermanent employmentFull timeLocal area
- ...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...
$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 ServicePermanent employment- ...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 ServiceFull timeWork at office3 days per week
$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 ServiceFull timeWork at officeWorldwide2 days per week- ...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 ServiceHourly payFull timeContract workApprenticeshipRemote workFlexible hours
$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 ServiceFull timeWork at officeLocal areaFlexible hours$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 contractTemporary workCasual workImmediate startRemote work$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 ServiceFull time$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...InternshipWork at officeRemote workFlexible hours- ...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
$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 employmentFlexible hours$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 ServiceTemporary workWork at officeWeekend work$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 ServiceVisa sponsorshipWork visa- ...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...
- ...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 ServiceContract work
$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 employmentRemote workFlexible hours- 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 ServiceShift workWeekend work
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!
