Tower Lead - Veeam (IN)
HCLTech
HCLTech
Seeking an experienced Oracle and SQL resource to lead complex database engineering initiatives. This role focuses on designing, implementing, and maintaining high-availability database solutions across Oracle and SQL Server environments.
Key responsibilities include ensuring robust disaster recovery, seamless cloud integration, and optimizing database performance. The position requires a deep understanding of database architectures and efficient query execution.
This is a critical role for managing database lifecycles, including upgrades, patching, and migrations. You will also be instrumental in supporting ETL processes and ensuring data integrity and security across all platforms.
Architect and implement high-availability database solutions, including Oracle RAC, Data Guard, and SQL Server AlwaysOn. Develop and maintain comprehensive disaster recovery plans, utilizing RMAN and SQL Server native backup mechanisms. Manage database workloads on-premises, engineered systems (Exadata), and cloud platforms (AWS, Azure, OCI). Analyze and resolve database performance bottlenecks, locking issues, and resource contention. Optimize PL/SQL and T-SQL code, stored procedures, and execution plans for enhanced efficiency. Implement proactive monitoring using tools like OEM and SSMS, setting up alerts and dashboards. Lead complex data migration projects between Oracle and SQL Server, including schema and data transfers. Plan and execute database engine upgrades and apply critical security patches. Provide support for ETL pipeline design, data replication, and data movement via Linked Servers or DB Links. Manage user authentication, roles, and privileges, ensuring compliance with corporate data governance and security frameworks. Implement data protection measures such as TDE, data masking, and secure network connections.
Extensive administrative knowledge of Oracle Database (19c+), including Multitenant architecture, ASM, RAC, and Data Guard. Advanced administration expertise in MS SQL Server (2016-2022+), covering AlwaysOn, Transactional Replication, and SSIS. Strong proficiency in writing complex PL/SQL and T-SQL code. Experience with OS-level scripting (Bash, Shell, or PowerShell) for automation tasks. Solid understanding of Linux/Unix administration (RedHat/Oracle Linux) and Windows Server environments for database hosting.
HCLTech
IT Consulting