Talent.com
MatchBox Consulting Group
Senior DBA - PostgreSQLMatchBox Consulting Group • Vancouver, British Columbia
Senior DBA - PostgreSQL

Senior DBA - PostgreSQL

MatchBox Consulting Group • Vancouver, British Columbia
30+ days ago
Job type
  • Full-time
  • Permanent
Job description
MatchBox Consulting Group is currently seeking a Senior PostGres SQL Database Administrator (Infrastructure & Platform) for a permanent, full-time opportunity with our client based in Vancouver. This is a hybrid role (2 days in office and 3 days remote) at the clients downtown Vancouver office.

Overview:

We are looking for an experienced and highly skilled Senior PostgreSQL DBA to manage, scale, and optimize our PostgreSQL database infrastructure. You will be responsible for ensuring the performance, availability, and security of critical database systems in production and development environments. This role requires deep expertise in PostgreSQL internals, high availability strategies, query optimization, and automation.

You will collaborate with cross-functional teams to ensure the availability, reliability, and performance of our database infrastructure.

Scope of Duties:
  • Design, implement, and manage PostgreSQL clusters in production and non-production environments (on prem)
  • Build high-scale data pipelines and data infrastructure for migrating from other data sources such as ArangoDB and CockroachDB to PostgreSQL
  • Ensure high availability and disaster recovery using tools available
  • Monitor and tune database performance, including query optimization, index tuning, and vacuum strategies
  • Automate database operations using scripting (Bash, Python) and Infrastructure-as-Code tools (Ansible)
  • Manage database security, user roles, access controls, and encryption
  • Plan and perform database upgrades, migrations, and patching with minimal downtime
  • Maintain backup and recovery strategies and test them regularly for effectiveness
  • Troubleshoot complex database issues related to locks, replication lag, corruption, and system resources
  • Write and maintain clear documentation on database standards, procedures, and architecture
  • Monitor and optimize database performance, ensuring high availability and scalability
  • Perform database backups, restores, and disaster recovery procedures
  • Develop and maintain database security protocols, ensuring data privacy and integrity
  • Provide support and guidance to developers and other team members regarding database-related topics
  • Participate in capacity planning and performance tuning activities
  • Stay updated with emerging database technologies and best practices, recommending improvements to enhance system performance and efficiency

Must Haves:
  • 5+ years of hands-on experience as a PostgreSQL DBA in high-availability, mission-critical environments
  • Proven experience as a Database Administrator, managing PostGresSQL databases
  • Deep knowledge of PostgreSQL internals, including WAL, VACUUM, query planner, and extensions (e.g., PostGIS, pg_partman, pg_stat_statements)
  • Strong understanding of database concepts, principles, and best practices
  • Proficient in writing and optimizing database queries
  • Experience with database performance tuning and optimization techniques
  • Familiarity with backup and recovery procedures, replication, and high availability strategies
  • Solid understanding of database security and access control
  • Excellent problem-solving skills and attention to detail
  • Strong communication and collaboration abilities, working effectively within a team environment

Nice to Haves:
  • Experience with multi-tenant or large-scale database architectures
  • Exposure to MS SQL Server, Kafka, Arango, Cockroach
  • Familiarity with Kubernetes and running PostgreSQL in containers or with operators
  • Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, PostgreSQL Certified Engineer) are a plus

For more current job opportunities, Follow MatchBox at linkedin.com/company/matchbox-recruitment/

_________________________

About MatchBox
Headquartered in downtown Vancouver and serving clients nationally, MatchBox is one of the leading recruitment and solutions firms that specializes in the fields of IT & Technology, Engineering & Technical, Real Estate & Construction, and Accounting & Finance. We offer unrivaled expertise with our team's extensive experience in the recruitment and professional services industry. We are dedicated to building great connections and creating strong opportunities within the workforce and the labor market.

Equal Opportunities
MatchBox is committed to providing equal opportunities for all applicants. We welcome and encourage applications from people of all backgrounds, including members of minority groups such as racialized individuals, people with disabilities, LGBTQ+ individuals, and Indigenous peoples. It is a priority for us that all candidates are treated fairly and without discrimination. Our recruitment teams receive ongoing training on using objective criteria for evaluating candidates and other related topics to create an inclusive and welcoming environment for all.

Work Permits
Please note that we require all interested candidates to obtain the necessary work permits from the Government of Canada prior to submitting an application. This position is open exclusively to individuals residing in Canada and legally authorized to work in Canada. Applications not meeting these criteria will not be considered.

Further Consideration
We receive a high volume of applications and are only able to contact candidates who are selected for further consideration.

Find out more at www.matchboxhr.com
Create a job alert for this search

Senior DBA - PostgreSQL • Vancouver, British Columbia

Similar jobs

SQL DBA & DevOps Engineer - Contract

Two CirclesVancouver, Metro Vancouver Regional District, CA
Temporary

A marketing company in Vancouver is seeking a skilled Database Administrator for a fixed-term contract covering maternity leave.The ideal candidate will be experienced in SQL Server administration,... Show more

 • Promoted

Senior Engineer - Data Dashboards Development

DatabricksVancouver, Metro Vancouver Regional District, CA
Full-time

Shape the future of data analytics at Databricks as a Senior Engineer specialized in Data Dashboards.Build user-friendly interfaces that facilitate insightful data exploration and visualization.In ... Show more

 • Promoted

Senior Database Migration Engineer Role

TELUS DigitalVancouver, Metro Vancouver Regional District, CA
Full-time

Join TELUS Digital as a Senior Database Migration Engineer, focusing on migrating systems from Oracle to PostgreSQL.This long-term project requires advanced PL/SQL and PL/pgSQL skills.In this hands... Show more

 • Promoted

Senior SQL Developer (REMOTE)

NTT DATA, Inc.Vancouver, Metro Vancouver Regional District, CA
Remote
Full-time

This role is fully remote and can be based anywhere in Canada.Conduct analysis, architect, design, develop, test, implement, configure, integrate, and support data solutions that address critical c... Show more

 • Promoted

Senior Oracle Cloud Architect: OCI, 19c & Multi‑Tenant DB

BeaconsoftwareVancouver, Metro Vancouver Regional District, CA
Full-time

A high-growth capital holding company in Canada is looking for a Senior Oracle DBA & Infrastructure Engineer to lead cloud-native transitions.The role requires managing database administration, clo... Show more

 • Promoted

Remote Oracle Cloud ERP & DB Expert (Bilingual)

Next VenturesVancouver, Metro Vancouver Regional District, CA
Remote
Full-time

A technology consulting firm is seeking a highly experienced Oracle Cloud ERP and Database Expert for a long-term remote assignment in Canada.The role focuses on providing expert-level support acro... Show more

 • Promoted

Senior Database Engineer

JobberVancouver, Metro Vancouver Regional District, CA
Full-time

Do you want to develop more than just a product?.Then Jobber might be the place for you! We’re looking for a.At Jobber, we don’t just build a product – we work on real problems that help people in ... Show more

 • Promoted

Senior SQL Developer (REMOTE)

NTT America, Inc.Vancouver, Metro Vancouver Regional District, CA
Remote
Full-time

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us.If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.... Show more

 • Promoted

Experienced Oracle DBA and Infrastructure Engineer for Cloud Solutions

Beacon SoftwareVancouver, Metro Vancouver Regional District, CA
Full-time

Become a vital Oracle DBA and Infrastructure Engineer driving sophisticated cloud solutions.Manage comprehensive database systems while working entirely remote.In this pivotal role, you'll lead the... Show more

 • Promoted

PostgreSQL Lead DBA: 24x7 Reliability & Performance

AgodaVancouver, Metro Vancouver Regional District, CA
Full-time

A global travel company in Vancouver is seeking a PostgreSQL professional to ensure the scalability and security of their database infrastructure.The role involves providing strategic recommendatio... Show more

 • Promoted

SRE: PostgreSQL & High-Performance Database Reliability

AlpacaVancouver, Metro Vancouver Regional District, CA
Full-time

A fintech company is seeking an experienced Site Reliability Engineer to ensure the reliability and performance of their systems.The ideal candidate will have over 5 years of experience in Site Rel... Show more

 • Promoted

Senior Databricks Architect — Lead Cloud Data Platform

Data ElephantVancouver, Metro Vancouver Regional District, CA
Full-time

A leading data consulting firm in Canada is seeking a Senior Databricks Architect to guide clients through their data modernization journeys.In this senior technical leadership role, you will be re... Show more

 • Promoted

Architecte Réseau / Cloud Senior - greater vancouver

Astekgreater vancouver, bc, ca
Full-time

Astek est un leader mondial en conseil technologique.Avec plus de 7 800 experts à travers le monde, nous accompagnons nos clients dans leur transformation numérique en développant des solutions inn... Show more

 • Promoted

Senior Data Architect: Oracle EBS & Cloud Integrations

Stantec Consulting International Ltd.Burnaby
Full-time

A global consulting firm is seeking a Senior Data Architect to enhance workflows and optimize collaboration between project teams.This role involves integrating existing applications with a focus o... Show more

 • Promoted

Senior Azure Cloud Engineer: AKS & SQL Expert

Press GaneyVancouver, Metro Vancouver Regional District, CA
Full-time

A leading analytics provider is seeking an experienced Senior Cloud Engineer with deep Azure expertise to optimize and manage their cloud infrastructure.The ideal candidate should have over 5 years... Show more

 • Promoted

PostgreSQL Open-Source Engineer

HornetlabsVancouver, Metro Vancouver Regional District, CA
Full-time

A software development company is seeking an experienced PostgreSQL developer to contribute to open source projects and improve processes.The ideal candidate will have a background in computer scie... Show more

 • Promoted

Senior Database Consultant, PostgreSQL

PythianVancouver, Metro Vancouver Regional District, CA
Full-time

At Pythian, we are experts in strategic database and analytics services, driving digital transformation and operational excellence.Founded in 1997, we quickly earned a reputation for solving tough ... Show more

 • Promoted

Senior Oracle DBA for Cloud Architecture Solutions

BeaconsoftwareVancouver, Metro Vancouver Regional District, CA
Full-time

Shape the future of cloud computing as a Senior Oracle DBA.Spearhead critical Oracle database management and cloud migrations to enhance operational efficiency in a fully remote role.In this strate... Show more

 • Promoted

Senior Data Architect — Oracle EBS & Cloud Integrations

StantecBurnaby, Metro Vancouver Regional District, CA
Full-time

A global design and consulting firm in Metro Vancouver is seeking a Senior Data Architect to optimize data workflows between Project Managers and Project Accountants.The role involves designing sca... Show more

 • Promoted

Oracle Cloud ERP/Database expert

Next VenturesVancouver, Metro Vancouver Regional District, CA
Full-time

Head of Oracle Technologies at Next Ventures.Our client is seeking a highly experienced.Oracle Cloud ERP and Database Expert.This role requires deep expertise across Oracle technologies, cloud plat... Show more