Tower Lead - Oracle Administration,PostgreSQL,MYSQL, MS SQL
India
Apply now
Job Description
Tower Lead - Oracle Administration,PostgreSQL,MYSQL, MS SQL
Noida, Uttar Pradesh

Job Summary

Oracle + SQL resource

Key Responsibilities

Database Engineering & High AvailabilityArchitecture Design: Implement, configure, and maintain high-availability database environments, including Oracle Real Application Clusters (RAC), Data Guard, and SQL Server AlwaysOn Availability Groups.Disaster Recovery: Establish, test, and maintain robust backup and recovery strategies using Oracle RMAN and SQL Server native backup/restore mechanisms.Cloud & Hybrid Integration: Manage database workloads running on-premises and engineered systems (like Oracle Exadata) or hosted in cloud ecosystems (AWS, Azure, or OCI).2. Performance Tuning & OptimizationQuery Analysis: Identify and resolve database performance bottlenecks, locking issues, and resource contention.Execution Plans: Optimize complex PL/SQL (Oracle) and T-SQL (SQL Server) code, stored procedures, indexes, and execution plans.Proactive Monitoring: Set up automated alerts and dashboards using tools like Oracle Enterprise Manager (OEM) and SQL Server Management Studio (SSMS) or third-party monitoring platforms.3. Migrations, Upgrades & PatchingCross-Platform Migration: Lead or assist in complex data migration projects, including migrating schemas and data from legacy Oracle databases to SQL Server (or vice versa).Lifecycle Management: Plan and execute database engine upgrades (e.g., upgrading Oracle 19c to newer release tracks or SQL Server modern cycles) and apply regular security patches (CPUs/SPU).ETL Pipeline Support: Assist data teams with structural design, data replication, and data movement across disparate systems via Linked Servers or Oracle DB Links.4. Security & ComplianceAccess Control: Manage user authentication, roles, privileges, and database audits in compliance with strict corporate data governance and security frameworks.Data Protection: Implement Transparent Data Encryption (TDE), data masking, and secure network connections for both environments

Skill Requirements

Oracle Ecosystem: Deep administrative knowledge of Oracle Database (19c and above), Multitenant architecture (CDB/PDB), ASM, RAC, and Data Guard.SQL Server Ecosystem: Advanced administration of MS SQL Server (2016 through 2022+), including AlwaysOn, Transactional Replication, and Integration Services (SSIS).Scripting Languages: Strong proficiency in writing complex PL/SQL and T-SQL code, alongside OS-level scripting (Bash, Shell, or PowerShell) for automation.Operating Systems: Solid understanding of Linux/Unix administration (RedHat/Oracle Linux) and Windows Server environments as they relate to database hosting.

Other Requirements

NA
Apply now
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 223,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 June 2026 totaled $14.8 billion.