Senior PostGresSQL Database Administrator (Infrastructure & Platform)

Global Relay

  • Vancouver, BC
  • 90.000-130.000 $ par an
  • Permanent
  • Temps-plein
  • Il y a 27 jours
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.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
About You:
  • 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
Compensation:Global Relay advertises the pay range for this role in compliance with British Columbia's pay transparency laws. Individual pay rates are determined by evaluating factors such as expertise, skills, education, and professional background.The range below reflects the expected annual base salary, which is only one element of our comprehensive total rewards package designed to reflect our company pay philosophy, culture and values. We aim to foster an inspiring work environment and support employees' work-life rhythms. We provide a comprehensive extended health benefits program, including virtual healthcare and a wellness allowance. Employees also receive annual allotted vacation days, which increase based on tenure. Other benefits include: Paid sick days, maternity/parental enhancement program, corporate bonuses, and an RRSP contribution matching program.For Vancouver-based employees, we provide a subsidized meal program, courtesy of our talented in-house culinary team!British Columbia - Base salary range$90,000—$130,000 CADWhat you can expect:At Global Relay, there's no ceiling to what you can achieve. It's the land of opportunity for the energetic, the intelligent, the driven. You'll receive the mentoring, coaching, and support you need to reach your career goals. You'll be part of a culture that breeds creativity and rewards perseverance and hard work. And you'll be working alongside smart, talented individuals from diverse backgrounds, with complementary knowledge and skills.Global Relay is an equal-opportunity employer committed to diversity, equity, and inclusion.We seek to ensure reasonable adjustments, accommodations, and personal time are tailored to meet the unique needs of every individual.We understand flexible work arrangements are important, and we encourage that in our work culture. Whether it's flexibility around work hours, workstyle, or lifestyle, we want to ensure our employees have a healthy work/life balance. We support and value a hybrid work model that blends collaboration with the team in the office and focus time from the comfort of your home.To learn more about our business, culture, and community involvement, visit .

Global Relay