Implement and manage database replication, CDC, Always On, WFC, and high-availability solutions for continuous operation and disaster recovery.
- Design, implement, and maintain SQL and Azure database solutions aligned with organizational requirements and industry best practices.
- Design, develop, and enhance ETL processes using Azure Data Factory or other tools to seamlessly integrate data from diverse sources into the database.
- Collaborate with teams to optimize and streamline data transformation pipelines.
- Collaborate with the teams to troubleshoot and resolve complex database issues efficiently using Azure Insights, Monitoring, DMVs, Query Store, etc.
- Demonstrate expert knowledge of SQL, Transact-SQL, DMVs, Stored Procedures, user-defined functions, and Custom Types.