Senior DBA - PostgreSQL

Match Box Consulting Group is currently seeking a Senior Post Gres 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 Postgre

SQL DBA to manage, scale, and optimize our Postgre

SQL 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 Postgre

SQL 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 Postgre
  
  SQL 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 Arango
  
  DB and Cockroach
  
  DB 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 Postgre
  
  SQL DBA in high-availability, mission-critical environments
• Proven experience as a Database Administrator, managing PostGresSQL databases
• Deep knowledge of Postgre
  
  SQL internals, including WAL, VACUUM, query planner, and extensions (e.g., PostGIS, , _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 Postgre
  
  SQL in containers or with operators
• Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, Postgre
  
  SQL Certified Engineer) are a plus

For more current job opportunities, Follow Match Box at

_________________________

About Match Box
Headquartered in downtown Vancouver and serving clients nationally, Match Box 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
Match Box 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.…