DOMMALAPATI Sobhanadri

Dynamic SQL Database Administrator with extensive experience at TCS and IBM, excelling in database design and client relations. Proven track record in optimizing RDBMS performance and enhancing process efficiency. Adept at technical support and project planning, driving successful outcomes through effective problem-solving and risk assessment strategies.

PROJECT#1
Client : SONY CORPORATION
Duration : Apr 2015 to Aug 2018
Environment : MS SQL 2005, 2008, 2008 R2, 2012,2014,2016 & 2017
Skill/Tools : Windows 2008 R2, 2012&2016

PROJECT#2
Client : NBC Universal
Duration : August 2018 to June 2018.
Environment : MS SQL 2005, 2008, 2008 R2, 2012,2014,2016,2017&2019.
Skill/Tools : Windows 2008 R2,2012&2016

PROJECT#3
Client : SONY CORPORATION
Duration : July 2019 to Oct 2020
Environment : MS SQL 2005, 2008, 2008 R2, 2012,2014,2016,2017,2019,2022
Skill/Tools : Windows 2008 R2, 2012&2016

PROJECT#4
Client : MCMS(Multi Cloud Managed Services)
Duration : Nov 2020 to Feb 2022
Environment : MS SQL 2005, 2008, 2008 R2, 2012,2014,2016,2017,2019,2022
Skill/Tools : Windows 2008 R2, 2012, 2016 & 2019

PROJECT#5
Client : Microsoft Premier Support
Duration : March 2022 to May 2024
Environment : MS SQL 2012,2014,2016,2017,2022

PROJECT#6
Client : AkzoNobel
Duration : May 2025 to till date
Environment : MS SQL 2008, 2008R2, 2012,2014,2016,2017,2022

• SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019, and 2022 database administration
• Commvault, TSM, and Redgate tools for backup
• Creation of databases, logins, and maintenance
• Prepared monthly reports for server performance, audit reports for all servers
• Monitoring alerts, disk space of all the servers, and freeing up space as per SQL Server, i.e., older backups, unused files, etc
• Resolving tickets, which include creating and maintaining databases, monitoring disk space, database integrity, and performance issues
• Commissioning and decommissioning of SQL servers as per change requests and for upcoming projects
• Applying the service packs and cumulative updates as per vulnerability tickets
• Configuring and troubleshooting high availability scenarios, like mirroring, AG, and cluster builds
• Creation of SSL encryption and TDE encryption for databases on the server
• Responsible for performing database maintenance activities, like rebuilding/reorganizing indexes, updating statistics, checking database integrity, and cleaning up history at regular intervals
• Daily and weekly database backups, and refreshing the database from production to dev/test environment
• Maintained and monitored alert/schedule to make a smooth replication process
• Enrolling users, controlling, and monitoring user access to the database, and maintaining system security
• Daily monitoring of the database space management parameters, allocating the required space to databases, and suitably managing database growth
• Identifying and resolving fragmentation and performance issues
• Creation of jobs through maintenance plans and troubleshooting job failures
• Changing the server-level configuration settings through change requests from client approvals
• Regular health checks and worked on high-importance issues in the ticketing queue
• Involved in disaster recovery strategy, i.e. Planning an appropriate backup and recovery strategy
• Experienced in upgrading from MS SQL 2000 to 2008 R2, 2005 to 2008 R2, 2008 to 2012, 2012 to 2017, 2019, 2008 to 2016, 2012 to 2019, 2014 to 2022
• Experienced in performance tuning of SQL Server, which includes creating indexes, and updating statistics to improve the performance of queries
• Experienced in using SQL Server Profiler and SQL Query Analyzer for performance-related problems
• Experienced in implementing high availability features like log shipping, mirroring, replication, clustering, and always-on
• Completely handled the migration project, ongoing projects, and regular operations
• Attending daily status calls with customers and working on long-pending issues in the ticketing queue
• Creating and updating the project technical documents and uploading them to the project SharePoint
• Daily monitoring and resolving the tickets depends on the priority levels
• We have maintained the highest number of servers, like 1,300 SQL servers, in the environment

• Appreciated with a cash award of 1,000 USD for contributions toward the transition of the Sony account
• Appreciated with a cash award of 8,000 INR for contributions toward customer service delivery for the 2022-2023 year
• Appreciated with a cash award of 100 USD for efforts and dedication in stabilizing the SQL environment in the MCMS project
• Appreciated with a cash award of $50 for dedication and focus in supporting our clients
• Appreciated with a cash award of 50 USD for hard work, dedication, and team coordination to fulfill our client deliverable, the Sabadell DRP activity is a successful event that went off flawlessly
• Appreciated with a cash award of 300 INR three times in the year 2024-2025 for outstanding contributions to the organization in TCS

• Certified PGSQL DB technology

• Nationality : Indian
• Gender : Male
• Marital status : Married
• Pan card : CCGPS3241F
• Passport : U5654188