Principal Database Administrator - PostgreSQL (Cork Hybrid)

OpenText

  • Cork
  • Permanent
  • Full-time
  • 2 months ago
OPENTEXTOpenText 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 ImpactThe Cloud Services team is at the core of delivering and operating our commercial products to our customers at OpenText. You will join a team of global database reliability engineers to design, automate, build, operate, and continuously improve the database services that back our customer-facing SaaS products. You will be responsible for operating a highly available design that includes security, scalability, monitoring, upgradeability, and data backup and recovery, across non-production and production environments. You will work in a fast-paced organization while quickly learning new skills and consistently creating ways to meet service-level agreements for our global cloud services.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 maintaining 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 process 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 ThingOpenText is more than just a corporation; it's a global community where trust is foundational, the bar is raised, and outcomes are owned.#LI-HybridOpenText'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 . Our proactive approach fosters collaboration, innovation, and personal growth, enriching OpenText's vibrant workplace.

OpenText