Sql dba Jobs in Richmond, BC

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