Overview
Join to apply for the Principal Database Administrator - PostgreSQL (Cork Hybrid) role at OpenText.
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 are hiring talent that AI can\'t replace to help us shape the future of information management. Join us.
What The Role Offers
* Design, automate, build, maintain, support, and continuously improve multiple database services including PostgreSQL, Oracle, and MS SQL Server.
* Perform routine database maintenance tasks such as backups, restores, and upgrades, including support to perform these tasks on scheduled weekends as needed.
* Implement and maintain monitoring configurations to track database health, performance, and utilization.
* Work closely with development and application support teams to design, build, deploy, support, and monitor new and existing deployments, including gathering requirements and documenting the solution.
* Maintain high availability and disaster recovery configurations to ensure database system recoverability.
* Support and responding to service requests that satisfy our OLAs.
* Support incident resolution processes for backing services that we are responsible for.
* Develop and maintain scripts, playbooks, and modules for automating routine tasks using tools like Terraform or Ansible.
* Migrate VM-based deployments to containerized solutions or managed services in AWS, GCP, or Azure.
* Identify tactical and strategic opportunities to improve service health, performance, reliability, and telemetry.
* Contribute to capacity planning and management processes.
* Support the migration of legacy deployments to modernized design patterns.
* Interact with third-party provider(s) who provide additional expertise and a layer of escalation support for our services.
* Build and maintain repeatable technology design patterns.
* Create and update documentation such as operational procedures, change execution plans, and incident write-ups.
What You Need To Succeed
* Strong expertise in PostgreSQL, including installation, configuration, upgrades, and performance tuning. Experience with MS SQL Server and/or Oracle is a plus.
* Hands-on experience managing large-scale PostgreSQL environments in enterprise settings, with exposure to SQL Server and/or Oracle being beneficial.
* Deep understanding of database performance optimization, query tuning, and indexing strategies for PostgreSQL. Similar expertise in SQL Server and/or Oracle is a plus.
* Bachelor’s degree in Computer Science, Information Technology, or a related field.
* Proven experience working with large-scale enterprise systems, particularly within Linux environments.
* Experience in a Database Reliability Engineering (DBRE) or Site Reliability Engineering (SRE) role is highly desirable.
* Strong knowledge of high availability, disaster recovery, and replication techniques (e.g., streaming replication, logical replication, clustering).
* Strong understanding of private and public cloud infrastructure platforms, including VMware, AWS, and GCP.
* Excellent collaboration skills, with experience working alongside developers, system administrators, professional services, and customer support teams.
Nice To Have Skills
* Familiarity with cloud platforms (AWS, Azure, GCP) and their managed database offerings (e.g., Amazon RDS, Azure Database for PostgreSQL).
* Strong awareness of industry trends, including emerging technologies, best practices, and automation tooling.
* Experience with automation and CI/CD tools, such as Terraform, Ansible, and/or GitLab.
* Experience with database monitoring and alerting tools (e.g., pgAdmin, Prometheus, Grafana, Spotlight, SQL Server Profiler, Zabbix, PagerDuty, Everbridge).
* Hands-on experience with orchestration and runbook automation tools, such as RunDeck or Ansible Tower.
One Last Thing
OpenText is more than just a corporation; it's a global community where trust is foundational, the bar is raised, and outcomes are owned. OpenText\'s 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.
Seniority level
* Mid-Senior level
Employment type
* Full-time
Job function
* Information Technology
* Industries
* Software Development
Referrals increase your chances of interviewing at OpenText by 2x
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr