Principal Cloud Database Administrator
Location
Waterloo, ON | Canada
Job description
OPENTEXT - THE INFORMATION COMPANY
As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital. Be part of a winning team that leads the way in Enterprise Information Management.
The Opportunity:
We are looking for an experienced Cloud Database Administrator with strong PostgreSQL experience who will be responsible for the performance, availability, security, and backup/recovery of PostgreSQL clusters on VMWare, AWS RDS, and GCP CloudSQL managed services. Along with the opportunity to gain experience and support Oracle and/or SQL Server instances.
You Are Good At: - Pro-actively review database metrics, identify bottlenecks, and tune database and query performance.
- Implement backup/recovery strategies with point-in-time restore capability to meet customer's SLA. Periodically perform data restore to ensure recoverability.
- Implement/maintain data replication in disaster recovery environments and execute disaster recovery exercises annually.
- Respond to page-outs as part of the on-call rotation, perform incident recovery, and root cause analysis, and identify and implement corrective actions.
- Develop and maintain documented procedures to ensure consistent and effective database operation in the team.
- Function as PostgreSQL SME supporting your peers to provide expertise, input, and insights as needed.
- Support database environments used by customer-facing OpenText applications aligned to our SaaS stack of products.
- Automate database deployments on-prem and in the cloud using Terraform and Ansible.
- Migrate legacy database solutions to AWS or GCP-managed database services.
- Engage with enterprise architects and strategic internal and external partners to ensure our database deployments are in line with defined best practices.
- Prototype new database solutions or versions and then deploy and build them to scale.
- Self-motivation to learn and grow technical skills
- Support the team by performing Scrum Master duties within the team, including:
- Implement Agile methodologies within the database administration processes, adapting Scrum practices to accommodate database-related tasks.
What It Takes: - Bachelor’s Degree in Computer Engineering or related
- Should have at least 8 years of Information technology experience
- 3+ years of PostgreSQL operations experience
- Expert skills in setting up and managing PostgreSQL HA environments
- Expert skills in PostgreSQL troubleshooting and performance management
- Expert skills in PostgreSQL backup/recovery
- Strong Unix skills, especially in writing automation scripts for remote execution
- Proficiency in writing and optimizing SQL statements and query plans
- Ability to thrive in a fast-paced environment working on projects against strict deadlines
- Experience supporting enterprise-level database environments
- Proficient in Agile methodologies and experienced in applying Scrum principles
- Strong and effective facilitation, communication, and leadership skills to support the team
Additional Value-Added Qualifications:
- Skills in Oracle or SQL Server database administration
- Experience with Terraform, Ansible, or other automation technologies
- Experience managing CI/CD pipelines with GitLab.
- Strong understanding of ITIL principles, certification is a plus
- Experience with database monitoring tools such as Zabbix, Prometheus, and Grafana
- Experience with HELM, containerized database solutions, and Kubernetes
OpenText's efforts to build an inclusive work environment go beyond simply complying with applicable laws. Our Employment Equity and Diversity Policy provides direction on maintaining a working environment that is inclusive of everyone, regardless of culture, national origin, race, color, gender, gender identification, sexual orientation, family status, age, veteran status, disability, religion, or other basis protected by applicable laws. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please contact us at [email protected] .
Job tags
Salary
