Sudhakar Guntur

G Sudhakar (MS SQL Database Administrator with 14+ Years of industrial experience) Experienced IT professional with 14+ years in the industry and over 10 years in SQL Server database administration across versions- and Azure. Skilled in installations, upgrades, and migrations—including on-prem to AWS cloud and legacy to SAP IS-U using EMIGALL/LSMW. Proficient in managing clustered/non-clustered environments (2–4 nodes) and ensuring SLA compliance through effective monitoring and support. Professional Summary: • Overall 14+ years of IT experience,10+years of relevant experience in MSSQL database administration, system analysis, backup/recovery, testing, disaster recovery and development & support in production using SQL Server 2016/2014/2012/2008R2/2005, Azure • Experience with migrations of SQL servers from SQL 2005, SQL 2008R2 to SQL Server 2012 ,2014 and 2016. • Extensive experience in Installation, Configuration and Upgrading of MS SQL Server, Client Software and related products for Production, Development, Sandbox and Test Environment. • Expert in installation, upgrade and configuration of MS SQL Server and databases in clustered and non-clustered environments ranging from 2 nodes to 4 node clusters • Experience with migrations of SQL servers from on premise SQL Server 2014 to AWS SQL 2016 cloud migration. • Migrated SQL Legacy customers data to SAP System for ISU billing by using EMIGALL, LSMW. • Closing the tickets within the SLA time and monitoring the SLA. • Extensive experience in planning/design and implementing solution for data center migrations/configuration. • Scheduled and monitored all maintenance activities including database consistency check and index defragmentation. • Expertise in configuring High Availability and Disaster recovery strategies like Log shipping, Mirroring, Clustering, Replication and Always on. • Performed bcp and bulk insert to import and export data from other data sources like Excel and flat file Extensive experience in Capacity planning, Performance Tuning and Troubleshooting. • Worked on Bugzilla open-source tool to configure monitoring tickets • Expert in using native tools like database tuning advisor, profiler, Performance Monitor, index tuning wizard, Event viewer for performance analysis. • Experience in using TSM Backup, Redgate tools, SQL server profiler • Planning and Implementing the Replication of MS SQL Server Database successfully Configured Transactional replication using MS SQL Server 2008 R2/2012/2014/2016 • Experience on Maintaining the Very Large Database on Production Environment, Cleansing, and Monitoring. • Good Knowledge in implementing SQL database in SQL Azure cloud computing platform. • Expertise in Optimization of T-SQL procedures, removing the deadlocks, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities. • Resolving the Disk space issues and finding the root cause to fix it permanently. • Experience in Creating and scheduling the jobs and troubleshooting the failed jobs. • Experience with SQL server Integration Services (SSIS), SQL Server reporting services (SSRS). • Experience working with Windows 2008/R2/2012 Advanced Server. • 6 years of hands-on experience in MS Dynamics CRM Application support. • Good Exposure in SOAP UI Tool for web services testing. • Knowledge of Azure. • 24 X 7 Production Database on Call Support. • Good Communication and Time Management skills and excellent team player. • Ability to adapt quickly to changing environments. • Work experience in abroad – 1 – Year Ethiopia & 3 – Months USA Technical Skills: Relational Databases : SQL Server 2016, 2014, 2012, 2008,2008 R2 and 2005 SQL Server tools : SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SSRS, SSIS Other Tools : Bugzilla, Remedy, Service Now, Testlink and Buzilla Architecture : Relational DBMS, Clustering, Replication, AlwaysOn Languages : T-SQL Operating Systems : Window Server 2016/2012 Microsoft Suite : Word, Excel, Power Point, Outlook, Access Education: • B. Tech from NIT Warangal in 2004 Professional Experience: Project # 1. Insight catastrophe managers - USA Project Description: Insight Catastrophe Managers (ICM) provides detailed real-time analytics of catastrophe-exposed properties for insurance companies, leveraging commercial catastrophe models (e.g., RMS, Verisk) and business financials to drive underwriting decisions. Their platform is designed to enhance efficiency and profitability in high-risk insurance markets. Contribution: • Installation and configuration of MS SQL 2017, SQL 2019 for new server builds standalone and cluster. • SQL servers’ migrations from SQL 2012, 2014 to SQL 2019 • Migrating MS SQL Databases from on premise environment to AWS – Ec2 Instances • AWS – Ec2 Instances cost optimization, optimized approximately ~17000 USD per month bill saving • AWS – Instance creation, required disks allocation, sync data from EBS to S3 bucket • SQL server upgrades from SQL 2012 to SQL 2016 or SQL 2019 • Migration from on-prem to AWS Ec2 instances, AWS RDS • Works on user requests like access requests, script execution etc., Regular deployments as part of production development • Configuration of Backups Jobs, EBS to S3 data sync, Datadog monitoring tool • Worked on weekly deployments, data sync, schema comparison and sync the missing columns in staging environment, later production environment • Configure Log – shipping and mirroring between principal and mirror servers. • Manually checks server health, works on incidents, alerts raised by monitoring tool, disk space alerts, temp drive full, log full alerts • Prepare the script for data purge jobs and schedule • Supporting OS patching • Based on new patch releases – SQL patching on non-production and production server • Datadog and disk space alerts monitoring, purgin the big tables data across the environment – SQL script Project # 2. Scotia– Canada Project Description: Scotiabank - P2V migration and V2V migration using platespin and Choesity. Lift and shift migration of 220 SQL Database server. Contribution: • Assessment of the infrastructure • Have implemented physical to virtual migration to the customer Scotiabank using Micro focus platspin. • I have performed virtual to virtual migration of the servers to the customer Scotiabank using Choesity. • I was responsible for pre health checks before the migration and decided to go or no go for the migration of the servers. • I was responsible for post migration health checks after the completion of migration to ensure the servers have migrated successfully. • We were coordinating with the customer and the partner for meeting the prerequisites of the migration • I was also responsible for preparing documents such as presentations, excel along with the team. Project # 3. Verizon wireless (USA) – Data center migration Project Description: Installation and configuration of MS SQL Server 2016 Always on clusters and migrated the SQL on premises Databases from SQL 2014 to SQL Server 2016 for Verizon wireless all lab applications related databases. Responsibilities: 1. Installation and configuration of MS SQL Server 2016 Always on clusters, Migrated the SQL on premises Databases from SQL 2014 to SQL Server 2016 always on environment 2. Prepare the HLD, LLD, SQL UAT & Hardening documents as per the project requirement. 3. As a Database administrator I have adhered to Business-as-usual activities 4. Working as part of a team and providing 24 x7 supports. Environment: MSSQL Server 2014/2016, Windows 2016/SSIS, ServiceNow, SQLProfiler, Query Analyze. Project # 4. Ethiopian Electric Utility – Ethiopia Project Description: Design the system as per Client requirement, Installation and configuration of MS SQL Server 2012 on Primary Data Center, Disaster Recovery Data Center & Contact Center for EEU. SQL Databases will be clustered in DC and SQL Log shipping is used to synchronize the database with the DR site, to ensure the data is highly available. Migrating the SQL legacy customer (Entire Ethiopia country’s Electricity customers data) billing data to SAP ISU system by using SAP EMIGALL, LSMW Program. Contribution: 1. Design the system as per client requirement and Prepare the HLD, LLD Documents as per the project design. 2. Installation and configuration of MS SQL Server 2012 Clustered based Instances. 3. Configured SQL Mirroring, Log shipping and Reverse Log shipping from Primary Data center to Disaster recovery data center 4. Handling the drive full, log file growing, TempDB and other SQL related Issues. 5. Total 296 Instances are installed (Stand-alone + SQL clusters) 6. Customers data Cleansed and Migrated from SQL legacy data to SAP System by using SAP EMIGALL and LWMW Program. Project # 5: Global Sales Experience - L3 support - Microsoft Project Description: GSX is an MSCRM product. It is used by salespeople of Microsoft to track the records of all the sales of Microsoft products and services. Previously this task was carried out with the help of Siebel version 7.2. Now entire Microsoft Sales IT operations have been moved to MSCRM. It has various applications Like GSX, PSX, GSX Online, GSX-Data Services, CSMAS, Dynamic CRM for Partner Sales, Direct Sales, Corporate Sales outlook and online/web applications. Contribution: 1. Installation and configuration of MS SQL Server 2012 and set up the UAT environment for Microsoft client in Redmond datacenter. 2. Handling and troubleshooting the MS SQL clustering, Replication, Backup/Recovery, Always-On Availability Groups and HA/DR features of SQL Server. 3. Handling the Data Center servers and 1.4 TB databases 4. Working as a DBA & analyst in Sales IT Operation project with majority work is maintaining SQL databases and fixing the user data related Issues. 5. Troubleshooting data flow related issues, SQL blockings issues. 6. SQL 2000, 2005 & 2008 standalone installations. 7. Troubleshooting the SQL Server processes and jobs. 8. Solving Disk space related issues. 9. Resolving database suspect issues. 10. Troubleshooting Log and database file full issues 11. Resolving Tempdb issues 12. Troubleshooting Server down issues 13. Troubleshooting Log shipping, Replication, Clustering issues Project # 6: Global Sales Experience (GSX); L3 Support - Microsoft Project Description: GSX is a large scale, multi-year program.  The effort was broken into 2 major phases, each with its own investment profile and business case.  The first phase is focused on re-platforming the MSFT CRM ecosystem off Siebel and onto Microsoft technology, with an emphasis on efficiencies … saving sellers time and reducing costs.   The goal is to have all MSFT sellers onto GSX this year, and retiring Siebel shortly thereafter.  The second phase will focus on leveraging that new platform to improve and extend our sales productivity, with an emphasis on sales effectiveness and agility.  Contribution: 1. Defined Standards, architecture and implemented Automation of GSX 2. Built Extracts and Process Scripts to find OutofSync records between 5 servers 3. Worked with multiple source systems to have comprehensive understanding of the data flow. 4. Performed data validation by writing queries in Source, Staging and Destination databases 5. Responsible for running reports and checking the optimization and data validation process. 6. Solely responsible for customizing the code as per the releases by Microsoft 7. Administering SQL Server 2000, 2005 and 2008 Production Database Servers. 8. Configuring and managing SQL Server services, Jobs, Alerts, and Maintenance Plans. 9. Managing and Troubleshooting High-Availability methods like Replication, Mirroring, Log shipping and SQL Failover Clustering. 10. Performing day-to-day tasks of taking Backup’s and maintaining Jobs. 11. System Performance Monitoring and managing the Disk Space of the SQL Servers. Project # 7: Begin Application Transfer on Notification (BATON) & Enterprise Data Warehouse (EDW); L3 Support and Development - Microsoft Project Description: Executive sponsors have requested that we retire Siebel in favor of Microsoft technologies. Currently, our business users rely upon services provided through the Data Enrichment Tool (DET). To enable retirement of Siebel, we must ensure the data management services necessary to support our business user case scenarios are enabled within our core platform systems – principally Global Sales Experience (GSX). Data Quality Management (DQM) for GSX focuses on the retirement of the DET. The project is a work stream within the Siebel to GSX Migration Program. The GSX Data Management Tool (DMT) is targeted to replace the DET legacy solution. BATON team uses the DMT tool to support the requirement of executive sponsors. CRM Publish is a bulk data publishing application that has a controlled API to enable backend, read-only access to sales data via periodic, automated pulls of Siebel data. CRM Publish superimposes over 900 logical views (of which approx. 250 are public) on this data to simplify its consumption. DSL provides access to a wide variety of data, which includes, but is not limited to, sales data from the Enterprise Data Management (EDM) data store (via the operational GSX ODS data store). You can use the EDW Explorer to explore and manage the different objects in EDW. Contribution: 1. Analyzing the requirements and design documents and understanding the functionality of source and destination systems. 2. Analyze the requirement and provide appropriate estimates with possible solutions and impediments if any. 3. Creation of SSIS solutions based on the business requirements to load, transform & validate the data. 4. Design SSRS reports as per the requirement and deploy them in report server. 5. Creation of SSRS reports as per the requirements to provide output data to the client in XLS format to be loaded into MDM system 6. Creating drill down reports as per business requirement. 7. Developing SSIS packages according to the design specifications. 8. Used different transformations like Conditional Split, Derived Column, Merge and Merge Join to load the data into DMT File 9. Implemented Unit testing.  10. Generate reports, trace software requirements, prioritize and assign tasks, the tool has web-based interface with PHP and background database MS-SQL. Contribution: 1. Configured the test link tool, it has interface with PHP web application 2. Convert the Excel based test cases to xml file then upload to test link 3. Created SQL Job Scheduler for Data Base Backup on a daily basis 4. Issues fixed, Understand the functionality and created logins based on role 5. Prepared the technical documentation for the application