Senior PostGresSQL Database Admin (Infrastructure

Base Salary Range: $90000 - $130000

Job Title: Senior PostGresSQL Database Admin (Infrastructure and Platform) 
Job ID: 76717
Location: Vancouver, British Columbia


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.

What you will do:

• 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

• 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

• 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

Salary/Rate Range: $90,000—$130,000 CAD


For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com