OPENTEXT - THE INFORMATION COMPANY

OpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture. As a member of our team, you will have the opportunity to partner with the most highly regarded companies in the world, tackle complex issues, and contribute to projects that shape the future of digital transformation.

 

AI-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 information management. Join us.

 

Your Impact:

We are looking for an experienced PostgreSQL database administrator who will be responsible for the performance, availability, security, and backup/recovery of clusters of PostgreSQL instances, along with the opportunity to learn to support Oracle and/or MS SQL instances.

What the role offers:

Setup and manage highly available Crunchy Data HA-based PostgreSQL clusters. Patch, upgrade, and maintain PostgreSQL software. Implement minimal downtime database upgrade using various technologies.  Design and implement application specific data migration solution for database upgrade to minimize customer impact.Establish PostgreSQL best practices across various deployments Act as a Tech Lead within the team to drive our PostgreSQL delivery roadmap and strategyPro-actively review database metrics, identify bottleneck, and tune the database/query.Configure and customize monitoring configurations for PostgreSQL databases. 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 to disaster recovery environment and execute disaster recovery exercise annually.  Automate routine tasks such as software installation, standby database validation, log rotation, security auditing.  Develop and maintain documented procedures to ensure consistent and effective database operations in the team.Respond to page-outs as part of on-call rotation, perform incident recovery, root cause analysis, and identify and implement corrective actions.  Act as PostgreSQL SME supporting your peers to provide expertise, input, and insights as neededSupport database environments used by customer-facing OpenText applications aligned to our multi-tenant SaaS stack of products

What you need to succeed:

Bachelor’s Degree in Computer Engineering or related Should have at least 8 years of Information technology experience3+ years of PostgreSQL operations experienceExpert skills in setting up and managing PostgreSQL HA environmentExpert skills in PostgreSQL troubleshooting and performance managementExpert skills in PostgreSQL backup/recoveryStrong Unix skills, especially in writing automation scripts for remote executionProficiency in writing and optimizing SQL statementsAbility to thrive in a fast-paced environment working on projects against strict deadlinesExperience supporting enterprise level database environments

 

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 hr@opentext.com. Our proactive approach fosters collaboration, innovation, and personal growth, enriching OpenText's vibrant workplace.