Apply now »

Thank you for your interest in OpenText! Our career page is currently undergoing maintenance and will be back up by May 29, 2022, 2:00 am UTC (May 28, 2022, 10:00 pm EST)

Please return soon to complete your dream job application!

 

 

Principal Cloud Database Administrator

Req id:  33459

Mississauga, 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 Information Management. 

 

 

The Opportunity:

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 MySQL/MariaDB instances.

 

You Are Great AT

  • Set up and manage highly available Crunchy Data HA-based PostgreSQL clusters. Patch, upgrade, and maintain PostgreSQL software.
  • Implement minimal downtime database upgrades using various technologies. 
  • Design and implement application-specific data migration solutions for database upgrades to minimize customer impact.
  • Establish PostgreSQL best practices across various deployments
  • Pro-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, and security auditing. 
  • Develop and maintain documented procedures to ensure consistent and effective database operations in the team.
  • Respond to page-outs as part of an on-call rotation, perform incident recovery, and root cause analysis, and identify and implement corrective actions. 
  • Act 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 multi-tenant SaaS stack of products
  •  

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 environment
  • 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
  • Ability to thrive in a fast-paced environment working on projects against strict deadlines
  • Experience supporting enterprise-level database environments

 

 

While OpenText is an Equal Opportunity Employer, our 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. Should you require accommodations during the selection process, please contact accommodationrequests@opentext.com.


OPENTEXT - THE INFORMATION COMPANY

Our growing team is mapping the future of Information Management, and we continue to make new discoveries that expand its boundaries. Join us and be part of a winning team, where the opportunities for your career are limitless. 

From its innovative start as a research project by University of Waterloo professors in 1991, OpenText has grown into a global company with offices in more than 35 countries. Our high- performance culture has forged our growth and is an excellent fit for people looking to push themselves to learn and do more.

It’s our time to lead, and as part of our team, it will be your time too. Our continued growth will provide you the opportunity to explore, learn and chart an exciting career path while enjoying a good work-life balance. 

Perks 
If you thrive in a dynamic work environment, there is always a new horizon to explore. We are proud to offer excellent benefits, challenging work and competitive financial rewards. 

Benefits 
Our employee programs prioritize employees’ well-being and that of their families. We offer a comprehensive benefit plan, education assistance, a wellness/fitness reimbursement and time off to volunteer. 

Social events 
With offices around the world and flexible work arrangements, OpenText strives to make sure all our employees feel connected. Teamwork extends to our social lives too from local social events to company-wide activities, we want our employees to take time to relax and have fun.  

Corporate Citizenship  
Corporate Citizenship is more than a program for us, it is engrained in our purpose, impact, and approach to doing business. Through numerous volunteer initiatives, we support education and innovation for global change.

Explore your career and potential. Become an OpenText Navigator.

Apply now »