Senior PostGresSQL Database Administrator (Infrastructure & Platform) at Global Relay
Vancouver, BC, Canada -
Full Time


Start Date

Immediate

Expiry Date

09 Nov, 25

Salary

90000.0

Posted On

09 Aug, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

Good communication skills

Industry

Information Technology/IT

Description

WHO WE ARE:

For over 20 years, Global Relay has set the standard in enterprise information archiving with industry-leading cloud archiving, surveillance, eDiscovery, and analytics solutions. We securely capture and preserve the communications data of the world’s most highly regulated firms, giving them greater visibility and control over their information and ensuring compliance with stringent regulations.
Though we offer competitive compensation and benefits and all the other perks one would expect from an established company, we are not your typical technology company. Global Relay is a career-building company. A place for big ideas. New challenges. Groundbreaking innovation. It’s a place where you can genuinely make an impact – and be recognized for it.
We believe great businesses thrive on diversity, inclusion, and the contributions of all employees. To that end, we recruit candidates from different backgrounds and foster a work environment that encourages employees to collaborate and learn from each other, completely free of barriers.

Responsibilities

YOUR ROLE:

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.

YOUR RESPONSIBILITIES:

  • 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
Loading...