Principal Cloud Database Administrator

2 weeks ago

Waterloo, Canada opentext Full time

**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.
- 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
- 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

  • Principal Cloud Database Administrator

    2 days ago

    Waterloo, Canada Open Text Corporation Full time

    **Principal Cloud Database Administrator**: - Req id: 34906- Waterloo, ON, CA Mississauga, ON, CA Richmond Hill, ON, CA**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...

  • Lead Cloud Database Administrator

    20 minutes ago

    Waterloo, Ontario, Canada Open Text Corporation Full time

    Hiring Manager: Deteng LiuTalent Acquisition Advisor: Draun RavalJob Code Level: IDP4Refer Your FriendsAI-First. Future-Driven. Human-Centered.At OpenText, AI is at the heart of everything we do—powering innovation, transforming work, and empowering digital knowledge workers. We're hiring talent that AI can't replace to help us shape the future of...

  • Principal Cloud Database Administrator

    2 days ago

    Waterloo, Canada opentext Full time

    **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**: This position is responsible for managing highly available database...

  • Principal Cloud Applications Administrator

    2 days ago

    Waterloo, Ontario, Canada Open Text Corporation Full time

    Hiring Manager: Ross SpeiranTalent Acquisition Advisor: Draun RavalJob Code Level: IRP5 Refer Your FriendsYOUR IMPACTAs a Principal Cloud Application Administrator role would be a great fit for someone with creative and innovative problem-solving skills. Collaborates with Agile squads/developers, sustain and business partners and provides significant...

  • Principal Cloud Applications Administrator

    49 minutes ago

    Waterloo, Ontario, Canada Open Text Corporation Full time

    Hiring Manager: Ross SpeiranTalent Acquisition Advisor: Draun RavalJob Code Level: IRP5 Refer Your FriendsYOUR IMPACTAs a Principal Cloud Application Administrator role would be a great fit for someone with creative and innovative problem-solving skills. Collaborates with Agile squads/developers, sustain and business partners and provides significant...

  • Administrative Assistant

    1 week ago

    Waterloo, Canada Cloud Realty - Hi.Tech Real Estate Full time

    **Company description** Cloud Realty is a tech focused real estate firm located in Waterloo. The company is headquartered in Mississauga and has been in business since 2015. Cloud Realty prides itself on having an amazing cutting-edge work environment with room for personal and professional growth. Hi.Tech Real Estate is a fast-growing group of passionate...

  • Manager, Relational Databases

    2 days ago

    Waterloo, Canada Sun Life Full time

    You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll...

  • Principal Systems Administrator

    2 weeks ago

    Waterloo, Canada Open Text Corporation Full time

    **Principal Systems Administrator**: - Req id: 34748- Waterloo, ON, CA Mississauga, ON, CA Richmond Hill, ON, CA**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...

  • Top Customer Solutions Developer I, Databases and Storage, Cloud

    2 days ago

    Waterloo, Ontario, Canada Google Full time

    Minimum qualifications:Bachelor's degree in Science, Technology, Engineering, or equivalent practical experience.3 years of experience troubleshooting and advocating for customers' needs, triaging technical issues, or in software development.Experience creating content for technical audiences (e.g., developer documentation, industry white papers, computer...

  • Top Customer Solutions Developer I, Databases and Storage, Cloud

    3 minutes ago

    Waterloo, Ontario, Canada Google Full time $128,000 - $132,000

    Minimum qualifications:Bachelor's degree in Science, Technology, Engineering, or equivalent practical experience.3 years of experience troubleshooting and advocating for customers' needs, triaging technical issues, or in software development.Experience creating content for technical audiences (e.g., developer documentation, industry white papers, computer...