Senior Technical Lead (IN)

HCLTech

5–8 yrs India Full Time Hybrid (office + remote)
HCLTech logo
Posted : today
Actively hiring

Job description

Seeking an experienced Snowflake & SQL DBA with 5-8 years in database administration, performance tuning, data warehousing, and cloud database management. This role focuses on administering, monitoring, securing, and optimizing Snowflake and SQL Server environments to ensure high availability, scalability, and peak performance for critical business databases.

Responsibilities

Key responsibilities include comprehensive Snowflake administration, encompassing environment management, database configuration, performance optimization, and security implementation. Tasks involve managing data sharing, replication, and failover strategies, alongside user access controls and cost monitoring. For SQL Server, duties cover installation, configuration, monitoring, performance tuning, and backup/recovery processes. This also includes managing High Availability/Disaster Recovery solutions and database troubleshooting.

Qualifications

Candidates must possess strong Snowflake architecture and administration experience, including security, RBAC, and governance features. Proficiency in Snowflake Time Travel, Fail-safe, Streams, Tasks, and Dynamic Tables is essential, as is experience in workload monitoring and cost management. A solid background in SQL Server administration, query tuning, and performance optimization is required. Experience with backup/recovery, HA/DR, Clustering, and Always On is also vital.

Familiarity with Azure platforms, data warehousing concepts, and ETL/ELT processes is necessary. Experience in migrating on-premises databases to cloud platforms and knowledge of data integration tools like Informatica, Matillion, ADF, or SSIS are expected.

Preferred qualifications include experience supporting 24x7 production environments and exposure to ITIL processes. Working knowledge of Agile and DevOps methodologies is also advantageous.

Essential Skills

SnowflakeSQL ServerDatabase AdministrationPerformance TuningData WarehousingCloud Database ManagementAzureETLELTData MigrationInformaticaMatillionADFSSIS

Good to Have

ITILAgileDevOps

Highlights

  • Actively hiring

More Details

RoleSenior Technical Lead (IN)
Employment TypeFull Time, Hybrid (office + remote)

About the Company

HCLTech logo

HCLTech

IT Consulting

Senior Technical Lead (IN) at HCLTech | SkillMX | SkillMX