Senior Technical Lead (IN)
HCLTech
HCLTech
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.
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.
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.
HCLTech
IT Consulting