Tower Lead - Oracle Administration,PostgreSQL,MYSQL, MS SQL (IN)

HCLTech

Fresher India Full Time Work from office
HCLTech logo
Posted : today
Actively hiring

Job description

Seeking a skilled Oracle Administration and SQL resource to join our team. This role focuses on managing and optimizing diverse database environments.

Key responsibilities include ensuring high availability, designing robust disaster recovery strategies, and managing cloud and hybrid database integrations. The ideal candidate will possess a deep understanding of performance tuning, query analysis, and proactive monitoring techniques.

This position also involves leading database migrations, upgrades, and patching initiatives. Experience with ETL pipeline support and maintaining strict security and compliance standards is essential.

Responsibilities

Design, implement, and maintain high-availability database environments including Oracle RAC and SQL Server AlwaysOn. Establish and test comprehensive backup, recovery, and disaster recovery strategies. Manage database workloads across on-premises, engineered systems, and cloud platforms (AWS, Azure, OCI). Identify and resolve database performance bottlenecks, locking issues, and resource contention. Optimize complex PL/SQL and T-SQL code, stored procedures, indexes, and execution plans. Implement proactive monitoring with automated alerts and dashboards. Lead or assist in complex data migration projects and database engine upgrades. Apply regular security patches and support ETL processes through structural design and data replication. Manage user authentication, roles, privileges, and database audits. Implement data protection measures such as Transparent Data Encryption (TDE) and data masking.

Qualifications

Requires deep administrative knowledge of Oracle Database (19c and above), including Multitenant architecture, ASM, RAC, and Data Guard. Advanced administration skills in MS SQL Server (2016 through 2022+), encompassing AlwaysOn, Transactional Replication, and SSIS. Strong proficiency in writing complex PL/SQL and T-SQL code is essential. Proficiency in OS-level scripting (Bash, Shell, or PowerShell) for automation. Solid understanding of Linux/Unix (RedHat/Oracle Linux) and Windows Server administration related to database hosting. Experience with tools like Oracle Enterprise Manager (OEM) and SQL Server Management Studio (SSMS). Familiarity with cloud ecosystems (AWS, Azure, OCI) is a plus.

Essential Skills

Oracle AdministrationPostgreSQLMySQLMS SQL ServerOracle RACOracle Data GuardSQL Server AlwaysOnRMANPL/SQLT-SQLLinuxUnixWindows ServerBashShell ScriptingPowerShellOracle Enterprise ManagerSQL Server Management Studio

Highlights

  • Actively hiring

More Details

RoleTower Lead - Oracle Administration,PostgreSQL,MYSQL, MS SQL (IN)
Employment TypeFull Time, Work from office

About the Company

HCLTech logo

HCLTech

IT Consulting