Senior PostGresSQL Database Administrator (Infrastructure & Platform)
Senior PostGresSQL Database Administrator (Infrastructure & Platform)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job 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 worlds 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. Its 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 skilledSenior PostgreSQL DBAto 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 ofPostgreSQL internals including WAL VACUUM query planner and extensions (e.g. PostGIS pgpartman pgstatstatements)
- 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 Columbias 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!
What you can expect:
At Global Relay theres no ceiling to what you can achieve. Its the land of opportunity for the energetic the intelligent the driven. Youll receive the mentoring coaching and support you need to reach your career goals. Youll be part of a culture that breeds creativity and rewards perseverance and hard work. And youll 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 its 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 .
Required Experience:
Senior IC
Employment Type
Full Time
