Database Administrator

Data Pipeline Design and Development

Design and develop end-to-end ETL pipelines using Azure Data Factory and Azure Databricks. Implement copy activities, data flows, error handling, dynamic pipelines, and parameterize executions. Work with Delta logic, control tables, and orchestrate data movement across multiple systems.

Cloud Integration and Data Engineering

 Integrate diverse data sources including Oracle, SQL Server, flat files, and APIs into Azure Data Lake using secure, scalable solutions. Work extensively with Azure services like Data Lake Storage, Key Vault, Azure Synapse, and Logic Apps

Testing, Monitoring and Production Support

 Perform unit testing, end-to-end validation, and implement restartability in ETL frameworks. Provide L1, L2, and L3 production support and work closely with cross-functional teams to resolve failures and bottlenecks. Monitor ADF pipeline executions, configure alerts, and ensure uptime compliance during hypercare.

Reporting and Visualization

 Develop analytical reports and dashboards in Power BI using DAX and custom visuals. Connect to Azure SQL, model datasets, create slicers, bookmarks, and share dashboards with users. Optimize performance with indexing and summarize data loads for reporting.

Documentation and Collaboration

 Collaborate with product owners and analysts to gather requirements, estimate efforts, and define user stories. Document ETL processes, data dictionaries, and transition support guides. Participate in Agile ceremonies and maintain project updates in Azure DevOps.