Azure SQL DBA

Job Description Experience in designing and hands-on development in cloud-based analytics solutions.

 Having 1-2 years of experience in Azure cloud services  Having experience in Azure resources like Azure Data Factory, Azure Synapse Analytics, Azure Blob, ADLS, Azure Data Lake  Storage Gen1 and Gen2, Logic Apps, Key Vault, Azure SQL DB and Synapse  Hands-on experience in Azure Data factory and its Core Concept's like Linked Services, Datasets.
 Data Flows, Pipelines, Activities and Triggers, Integration Runtime, Self-Hosted Integration Runtime.  Designed and developed data ingestion pipelines from on-premises to different layers into Azure Built Dataflow transformations.

 Worked on Copy Data activity, Get Metadata Activity, look up, Filter, Store Procedure, For-each, IF and execute Pipeline activities  Implemented dynamic pipeline to extract the multiple files into multiple targets with the help of single pipeline  Strong Knowledge on Parameterization of Linked Services, Datasets Pipelines, Activities.
 Pipeline execution methods (Debug vs Triggers).  Experience in scheduling the pipelines and monitoring the pipelines through the monitor tab.  Experience in creating alerts on the pipelines level and activity level.

 Stack (Including Compute, Function App, Blobs, Resource Groups, Azure SQL, Cloud Services, and ARM),  Focusing on high - availability, fault tolerance, and auto-scaling.
 Performed custom activity using python, for unsupported task in Azure Data Factory V2.

Customer support:
 Strong customer engagement skills to understand customer needs for Analytics solutions fully.  Experience in leading small and large teams in delivering analytics solutions for customers Have demonstrated ability to define, develop and implement data models and supporting policies, standards, and guidelines.  Strong problem solving and troubleshooting skills Read more