Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL

India
Job Description

Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL

Lucknow, Uttar Pradesh

Job Summary

The L2 Oracle Database Administrator is responsible for the administration, monitoring, maintenance, and support of Oracle database environments. The role involves handling routine database operations, troubleshooting database issues, ensuring database performance, backup and recovery management, and supporting business-critical applications running on Oracle databases.

Key Responsibilities

Monitor and maintain Oracle database environments to ensure high availability and performance. Perform Level 2 support activities including incident, problem, and change management. Troubleshoot database-related issues and work toward timely resolution within SLA. Execute database backup, recovery, and restore operations using RMAN. Monitor database health, storage utilization, tablespaces, and performance metrics. Perform database patching, upgrades, and security updates. Manage Oracle users, roles, profiles, and privileges. Support database refresh, cloning, migration, and replication activities. Analyze and optimize SQL queries and database performance bottlenecks. Perform routine maintenance tasks such as gathering statistics, index maintenance, and log management. Support High Availability (HA) and Disaster Recovery (DR) solutions. Coordinate with application teams, infrastructure teams, and vendors for issue resolution. Prepare and maintain technical documentation, SOPs, and knowledge articles. Participate in on-call support and rotational shifts.

Skill Requirements

Oracle Database Administration Oracle Database 12c, 19c, 21c Oracle Enterprise Manager (OEM) Oracle RAC (Real Application Clusters) Oracle ASM (Automatic Storage Management) Oracle Data Guard Oracle Multitenant Architecture Backup & Recovery RMAN (Recovery Manager) Export/Import (Data Pump) Flashback Technologies Performance Tuning AWR Reports ADDM ASH Reports SQL Tuning Query Optimization Wait Event Analysis Database Security User and Role Management Privilege Administration Database Auditing Security Patching Operating Systems Linux (RHEL, Oracle Linux, CentOS) Unix (Preferred) Windows Server Scripting SQL PL/SQL Shell Scripting Python (Preferred) Monitoring Tools Oracle Enterprise Manager (OEM) ServiceNow Nagios SolarWinds (Preferred)

Other Requirements

NA

Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 230,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending September 2026 totaled $14.8 billion.