Development Database Administrator
CurrentInitially appointed as a Database Administrator, I quickly transitioned into a dual role as a SQL Developer and Advisor within a development team, while maintaining my DBA responsibilities. I actively contribute to SCRUM meetings and daily operational tasks, focusing on SQL development, performance optimization, and pipeline development and authoring. My recent projects include: - Improving Azure Defender Score: Deployed fixes using Terraform to enhance security posture. - Private Endpoint Implementation: Designed and implemented the removal of public access from PaaS databases. - SQL Always-On Clusters: Designed and implemented Always-On Clusters, migrating databases from on-premises environments to the cloud, and between AWS and Azure. - Introducing Parallelization: Enhanced an existing Service Broker-based asynchronous post-calculation system with parallel processing. - Performance Optimization: Achieved high throughput optimization while maintaining ACID properties at a high isolation level and avoiding deadlocks. - Advanced Lookup Techniques: Utilized full-text indexes and the mdq.Similarity function with the Jaro-Winkler algorithm to find the best results.I possess extensive experience working in cloud environments (Azure, AWS) and utilize technologies such as Azure Database, Azure DevOps, ARM, GitHub, GitHub Actions, and Terraform.