Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL (IN)

HCLTech

3–6 yrs India Full Time Remote
HCLTech logo
Posted : today
Actively hiring

Job description

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.

Responsibilities

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.

Qualifications

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.

Essential Skills

PostgreSQL 12/13/14/15/16PostgreSQL AdministrationSQLPL/pgSQLDatabase Backup & RecoveryUser & Role ManagementTablespacesIndex ManagementPartitioningReplicationHigh Availability ConceptsDatabase MonitoringDatabase SecurityLinux (RHELCentOSOracle Linux)Basic Shell ScriptingAmazon RDS PostgreSQLAzure Database for PostgreSQLCloud-based database operationsGrafanaSplunkServiceNow

Good to Have

PostgreSQL Associate CertificationPostgreSQL Professional CertificationAWS Certified Database SpecialtyMicrosoft Azure Database CertificationsITIL Foundation

Highlights

  • Actively hiring

More Details

RoleSenior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL (IN)
DepartmentDatabase Administration
Employment TypeFull Time, Remote

About the Company

HCLTech logo

HCLTech

IT Consulting

Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL (IN) at HCLTech | SkillMX | SkillMX