Senior Database Administrator
CurrentIn this role, I design and implement advanced database solutions. I oversee Solarwinds SQL Sentry, stored procedures, and triggers execution. I create size and tune databases while managing data space. I employ Azure PowerBI embedded services and automate accounts for efficient data manipulation. Some of my key achievements include: • Developed and implemented efficient processes for importing MSA data, improving reporting efficiency for senior management.• Ensured consistent high levels of database availability and performance, contributing to overall system reliability and positive user experiences.• Created and configured Azure Automation Accounts to optimize server performance, reduce costs, suspend analysis services, and streamline Azure Data Factory pipelines.• Designed and optimized Azure Data Factory resources, becoming proficient in pipeline development and integrating Logic Apps for automated email notifications.• Implemented a strategic data warehouse to centralize product volume history, enabling detailed time trend analysis.• Engineered a scalable Azure Synapse environment, establishing multiple data warehouses and configuring workgroups to accommodate various workloads.• Employed DBCC commands to proactively detect and address database corruption and page allocation problems, maintaining system integrity and performance.
