Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL (IN)
HCLTech
HCLTech
Seeking a skilled L2 PostgreSQL Database Administrator to ensure the smooth operation of PostgreSQL databases in production and non-production settings. This role is pivotal for maintaining database availability, optimizing performance, managing backups and recovery, resolving incidents, and upholding security compliance for business-critical applications.
You will collaborate closely with application, infrastructure, and cloud teams, as well as L3 database Subject Matter Experts, to guarantee stable and secure database operations. A key aspect of this position involves contributing to enterprise database operations and transformation initiatives as part of managed services delivery.
Manage daily PostgreSQL database administration, including monitoring health, availability, and performance across Linux and cloud environments. Execute essential database tasks such as starting/stopping instances, maintenance, and validation, while supporting provisioning and decommissioning activities to ensure optimal uptime and stability.
Effectively handle and resolve P2, P3, and P4 database incidents, participating in major incident bridge calls when necessary. Conduct initial root cause analysis for database-related issues and escalate complex problems to L3 engineers, maintaining thorough documentation.
Monitor query performance and overall database utilization, analyzing slow SQL queries and supporting index optimization. Track CPU, memory, I/O, storage, and connection usage, assisting application teams with performance investigations.
Execute backup verification and restore testing, ensuring successful completion of backup jobs. Perform database restorations according to approved procedures and support disaster recovery testing.
Administer database users, roles, and privileges, ensuring adherence to security policies and audit requirements. Support vulnerability remediation and database hardening efforts, reviewing access requests and implementing approved changes.
Implement approved database changes, supporting application releases and deployments. Execute schema changes, patches, and upgrades, participating in CAB reviews as needed.
Possess 3-6 years of comprehensive Database Administration experience, with a minimum of 2 years specifically supporting PostgreSQL databases. Proven experience supporting production environments and working within 24x7 operations and support models is essential.
Proficiency in database technologies including PostgreSQL versions 12-16, SQL, and PL/pgSQL. Strong knowledge of database backup and recovery, user/role management, tablespaces, index management, partitioning, replication, and high availability concepts is required.
Familiarity with database monitoring, security best practices, and operating systems like Linux (RHEL, CentOS, Oracle Linux) with basic shell scripting is expected. A good understanding of cloud database platforms such as Amazon RDS PostgreSQL and Azure Database for PostgreSQL, along with cloud-based database operations and lifecycle management, is necessary.
Experience with monitoring and observability tools including Grafana and Splunk, as well as ITSM tools like ServiceNow for incident, change, and problem management, aligned with ITIL processes, is highly valued.
HCLTech
IT Consulting