Database administration, I have honed my skills in managing MS SQL Server environments across diverse industries. My skills include performance tuning, data security, and high-availability solutions. Let's connect to discuss how I can contribute to enhancing your database operations.
As part of Xerox's Global Infrastructure Support team, my responsibilities include maintaining and monitoring all Windows servers hosting MS SQL Servers, providing 24/7 on-call support, and managing ticketing support for the development team, end-users, and customers.
Roles and Responsibilities
Responsible for maintaining & monitoring SQL Server Systems and Databases in 4 environments including 150+ SQL Servers. Responsible for Installations, Upgrading, Patching of SQL Server in AlwaysOn cluster. Recommend hardware and software refresh roadmap of SQL Server environments. Participated in planning of SQL Server disaster recovery. Maintain Backup and Recovery Plans for all Databases and validating them to meet RTO and RPO. Monitoring Jobs, Error Logs, locks, Server Space, Health of Databases & Servers. Troubleshoot issues to the following technologies: a. SQL Server Clustering. b. AlwaysOn c. SSAS. d. SSRS. e. Managing backup and Restore strategies. Meet the SLA (Service Level Agreement) established. SQL Server migration migrated from SQL Server 2016 to 2019 and to Microsoft Azure. Azure MySQL server to Azure MySQL Flexible server. Preparation of Production Management Reports for Production Servers. Tuning queries which are running slow using DMVs, Execution Plans, Extended Events, Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
Technologies: MSSQL
Industry: Infrastructure management
Xerox Global Cloud
July-2016 to July-2024
Description
24/7 on-call support, and managing ticketing support for the development team, end-users, and customers for Azure as DBA
Roles and Responsibilities
Azure DBA support, Azure MySQL server, Azure MySQL Flexible server, Azure VM
Technologies: Azure
Industry: Cloud Services
Work history
Lead DBA • September-2013 to July-2024
Description: Oversee and manage database environments, ensuring data integrity, security, performance, and availability while guiding the database team and collaborating with other IT professionals on database design and implementation.