Maturi Mahesh Goud
Azure SQL & MSSQL Database Administrator
Hyderabad, IN.About
Highly accomplished Azure & MSSQL Database Administrator with 4 years of hands-on experience managing large-scale databases in production support environments. Expertise spans on-premise MSSQL (2016 & 2019) and Azure SQL DB, encompassing critical functions like performance tuning, high availability, disaster recovery, cloud migration, and cost optimization. Proven ability to proactively resolve complex database issues, manage user access, and provide 24x7 production support, ensuring robust and efficient database operations for diverse client requirements.
Work
Hyderabad, Telangana, India
→
Summary
Administered Azure SQL Databases for Microsoft, focusing on resource deployment, performance optimization, and ensuring high availability within a dynamic cloud environment.
Highlights
Deployed and managed Azure SQL resources, strategically optimizing service tiers and compute tiers to achieve significant cost savings and enhanced performance.
Monitored and optimized the performance of cloud databases, proactively resolving connectivity issues to maintain high availability and disaster recovery capabilities.
Executed comprehensive import and export operations for Azure SQL databases utilizing Portal, PowerShell, and SqlPackage, ensuring data integrity and accessibility.
Managed user access and permissions within Azure SQL environments, strengthening security protocols and ensuring compliance.
Participated in daily scrum calls, collaborating with cross-functional teams to align database operations with project goals and client requirements.
Foray Software Pvt Ltd
|Azure SQL Database Administrator (Contractor for AMERICAN ELECTRIC POWER (AEP), USA)
Columbus, Ohio, US
→
Summary
Provided comprehensive Azure SQL Database administration for AMERICAN ELECTRIC POWER (AEP), USA, focusing on cloud database management, migration, and performance tuning.
Highlights
Migrated critical databases across Azure subscriptions and tenants, ensuring seamless transitions and maintaining data consistency for vital systems.
Implemented robust backup and restore procedures for Azure SQL Managed Instances, significantly reducing potential data loss risks and ensuring business continuity.
Troubleshot and resolved complex database connectivity issues and performance bottlenecks, improving system reliability and user experience.
Ensured high availability and disaster recovery for Azure SQL databases by configuring and managing Geo-Replication and Failover Groups.
Managed user access and permissions across various Azure SQL environments, strengthening database security and ensuring compliance with organizational policies.
Atlanta, Georgia, US
→
Summary
Administered MSSQL and MS Access databases for GENUINE PARTS COMPANY, ATLANTA, managing large-scale production environments and ensuring operational efficiency.
Highlights
Managed over 500 MSSQL servers and 5000+ databases, overseeing installation, configuration, and growth parameters in a high-volume production support environment.
Resolved critical SQL Server blocking and disk space issues, identifying root causes and implementing permanent fixes to minimize downtime and optimize performance.
Configured and maintained high availability and disaster recovery solutions, including Log Shipping and Replication, ensuring continuous data access and protection.
Executed comprehensive database backup, recovery, and restoration processes, safeguarding critical business data and ensuring rapid recovery from incidents.
Migrated MS Access databases to SQL Server, streamlining data management, improving system scalability, and enhancing overall database performance.
Languages
Telugu
English
Hindi
Skills
Operating Systems
Azure, Windows, Linux.
Databases
MSSQL 2016, MSSQL 2019, Azure SQL DB.
Programming & Scripting
T-SQL, Shell Script, SQL.
Performance Monitoring Tools
SQL Profiler, Activity Monitor, Azure Monitor.
Database Tools
SSMS, RDP, DFM, ServiceNow, Portal, PowerShell, SqlPackage.
High Availability & Disaster Recovery
Log Shipping, Replication, AlwaysOn Availability Groups, Geo-Replication, Failover Groups in Azure SQL.
Database Management
Database Backup, Recovery, Restoration, User Management, Job Scheduling, Troubleshooting, Database Migration, Performance Optimization, Cost Optimization.