Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL (IN)
HCLTech
HCLTech
As an L2 PostgreSQL Database Administrator, you will be instrumental in ensuring the robust administration, vigilant monitoring, and seamless maintenance of PostgreSQL databases across production and non-production environments. This critical role prioritizes database availability, performance optimization, secure backup and recovery strategies, effective incident resolution, and unwavering security compliance to support vital business applications. You will collaborate closely with application, infrastructure, and cloud teams, alongside L3 database SMEs, to guarantee stable and secure database operations. Enterprise database operations and transformation initiatives are key components of our managed services delivery.
Key responsibilities include:
Database Administration & Operations: Oversee daily PostgreSQL database administration, monitor health and performance, and manage instances across Linux and cloud platforms. Execute essential maintenance activities and support database provisioning and decommissioning.
Incident & Problem Management: Handle and resolve P2, P3, and P4 database incidents, participating in major incident calls as needed. Conduct initial root cause analysis and escalate complex issues to L3 engineers, maintaining comprehensive documentation.
Database Performance Management: Monitor query performance and utilization, analyze slow SQL queries, and support index optimization. Track resource utilization and assist application teams with performance investigations.
Backup & Recovery: Execute and verify backup procedures, monitor job status, and perform restorations. Support disaster recovery testing and validation.
Security & Compliance: Manage user access, roles, and privileges, ensuring adherence to security policies and audit requirements. Support vulnerability remediation and database hardening.
Change & Release Support: Implement approved database changes, support application releases, and execute schema changes, patches, and upgrades.
Required skills encompass a strong foundation in PostgreSQL administration, including versions 12 through 16, with expertise in SQL and PL/pgSQL. Proficiency in database backup and recovery, user and role management, tablespaces, index management, partitioning, replication, and high availability concepts is essential. You should possess solid knowledge of database monitoring and security best practices. Experience with Linux operating systems (RHEL, CentOS, Oracle Linux) and basic shell scripting is required. A good understanding of cloud database platforms such as Amazon RDS PostgreSQL and Azure Database for PostgreSQL, along with cloud-based database operations, is also necessary. Familiarity with monitoring and observability tools like Grafana and Splunk, as well as ITSM tools like ServiceNow, is expected.
We are seeking candidates with 3–6 years of overall Database Administration experience, including a minimum of 2 years specifically supporting PostgreSQL databases. Prior experience in production environments and working within 24x7 operations and support models is required. Preferred certifications include PostgreSQL Associate/Professional Certification, AWS Certified Database Specialty, Microsoft Azure Database Certifications, and ITIL Foundation.
HCLTech
IT Consulting