The MS SQL Data Engineer will be responsible for the implementation, configuration, and performance of critical Azure Databases (IaaS / PaaS / SaaS) ensuring the availability, consistent performance of cloud native applications.
The MS SQL Data Engineer will also play a key role in the Agile delivery of the SQL Data Ingestion process for an Enterprise Data Lake feeding various enterprise Data Hubs.
This position requires sound knowledge of SQL Server & architecture, SSIS, SSRS, SSAS, designing, implementing, query-tuning, and monitoring performance of new & existing cloud databases.
Working experience in migration of on-premises server / database to Azure (PaaS / IaaS).
Minimum 4 Years’ experience in maintaining critical production environments on-premises and / or cloud-hosted hosted SQL Servers / databases.
Be able to efficiently import / export data from other DBMS like MySQL, PostgreSQL, and Maria DB.
Experience in DB backup & restore, point-in-time restores and Automation tasks.
Possesses excellent knowledge of MS SQL Server architecture and Database concepts.
Strong command on T-SQL and understanding of SSIS, SSAS, SSRS.
Excellent troubleshooting skills and good understanding of issues such as blocking, deadlocks, waits, resource utilization.
Good knowledge of Views, Stored procedures, Synonyms, Indexes and SQL Agent.
Knowledge of database security & patching and performance monitoring standards.
Knowledge of data reliability, high performance, high availability, disaster recovery and scalability concepts.
Excellent communication skills, ability to work independently and within a team.
Proven ability to meet deadlines and strong attention to detail.
Nice to Have :
Working knowledge of Azure Data Warehouse / Azure Data factory pipelines / Azure Data Lake storage.
Experience in database and server upgrade activities.
Experience in design and developing data systems.
Experience in Data warehousing ETL Bigdata projects.
Experience on Synapse Azure Synapse Dedicated Pools.
Developing, testing, and maintaining datasets and data structures.
Qualifications / Requirements :
Bachelor’s Tech in Computer Science or IT / BCA / MCA
3rd Shift (US Hours) required