Principal Cloud Database Administrator

8 - 13 years

25 - 30 Lacs

Posted:1 hour ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

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.

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 strategy
  • 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 customers 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 needed
  • Support 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 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
Additional Value-Added Qualifications
  • Skills in Oracle database administration
  • Skills in MS SQL administration
  • Experience with Terraform, Ansible, or other automation technologies
  • Experience with GCP CloudSQL or AWS RDS services
  • Strong understanding of ITIL principles, certification is a plus
  • Experience with database monitoring through tools such as Nagios, Zabbix, or New Relic

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Opentext
Opentext

Software Development

Waterloo ON

RecommendedJobs for You