Open To Work
Verified
This profile is verified using an email address.
Lothugedda Kurma Dasu Naidu
Work Preference
Summary
Results-driven DBA specializing in SQL Server installations and Azure migrations. Enhanced system reliability and scalability while communicating complex concepts clearly. Supported over 100 clients, demonstrating leadership and technical expertise in cloud environments. Mentored teams to foster innovation and success.
Overview
14
14
years of professional experience
Work History
L4 DBA
Rackspace Technology
Gurgaon/Hyderabad
10.2017 - Current
- Provided 24x7 production support for SQL Server databases on standalone and Clustered Servers with sizes ranging from 100s of GB to 20+ TB to achieve maximum performance and uptime in production environment.
- Provided 24x7 production support for ~100 plus customers.
- Strong verbal/written communication skills.
- Expertise in handling the various Azure Data related services like SQL PAAS, SQL MI Including AZURE cloud services.
- Having good knowledge in moving On-premises Database migrating SQL Databases to Azure Managed instances, Azure SQL PAAS (single and elastic pool) and Azure IAAS.
- Working Microsoft Azure Cloud SQL (IAAS, PAAS) Environments.
- Good knowledge the Azure Active Directory (AD)& Cloud-based identity and access management (IAM) service.
- Worked Cloud On premises Virtual Servers.
- Good experience in SQL Azure Cloud Migration.
- Good experience in Cloud AD security management systems.
- Rackspace is a managed cloud computing company that aims to make it easy to manage private and public cloud deployments. The company is the largest managed cloud provider, offering expertise across cloud platforms such as, Amazon Web Services, Microsoft cloud/ Azure and OpenStack. Rackspace offers services such as Fanatical Support for Microsoft Azure and for AWS. These services are designed to help businesses to get the most out of their public cloud deployments. Rackspace also has many data centres operating in USA, UK, Australia and Hong Kong. The company’s headquarters is based in Texas, USA.
Principal Consultant
Tricore Solutions Pvt Ltd
Gurgaon
10.2014 - 10.2017
- Coordinate and manage multiple problems and projects with different teams at the same time.
- Led projects and implementation teams, collaborating with clients on database configuration, requirements gathering, storage implementations, data migration, and application testing.
- Analyzed existing infrastructure to recommend modifications enhancing system reliability, availability, serviceability, and scalability.
- Work with teammates, clients and other teams to identify and address systems problems.
- Translates highly complex concepts in ways that can be understood by a variety of audiences.
- Enough expertise to identify and recommend changes/improvements to the process and infrastructure design.
- Provided L4 and L3 level technical support to clients and team members.
- Strong technical aptitude and ability to research and solve complex issues independently.
- Installation & Configuration of MS SQL Server 2008R2/2012/2014/2016/2017/2019.
- Configuration knowledge in Advanced features of SQL Server 2012/2014/2016/2017/2019.
- Develop, implement, administer and maintain security and integrity of the Application databases.
- Advance Database Performance Tuning Instance, Database, OS Parameters.
- TriCore Solutions, the applications management experts, provides a full suite of scalable and reliable managed application, cloud, infrastructure hosting, and consulting services to enterprise organizations. The company delivers its services and the TriCore Trusted Promise to more than 250 companies worldwide to reduce costs, raise service levels, improve customer experience, increase business agility, and accelerate innovation, unlocking the business value from their IT investments. TriCore Solutions is headquartered in Boston, MA, with offices in India and throughout North America.
Senior Database Administrator
McKinsey & Company
Gurgaon
08.2013 - 10.2014
- SQL Server 2008 R2 and 2012 deployments using Building Blocks i.e. PowerShell Scripted code.
- Optimized installation times through Slipstream installations.
- Hardening SQL Server instance configurations and database settings.
- Developed alert notifications via email system for all fatal/critical system errors, enhancing incident response.
- Performed migrations (also in-place) from SQL Server 2005 to 2008 R2.
- Mirror failures through Mirror Monitor and resolving sync/corruption issues.
- Worked on replication models and verifying replication agents' status.
- Resolved deadlocks and blockings by identifying key sessions, improving database stability.
- Optimized query performance through methodologies such as index fragmentation analysis, table statistics evaluation, and TempDB optimization recommendations.
- Fixing 14420 and 14421 errors of log shipping and also job failures related to LS.
- Handling escalations in team related to Clustering and Performance Tuning.
- McKinsey has created and invests significantly in its knowledge management system to support field consultants. The system includes generalist researchers, industry- and function-specific experts and librarians, and access to journals and databases. McKinsey maintains an organisation called the McKinsey Knowledge Centre (McKC) that provides rapid access to specialized expertise and business information.
Database Administrator
Wipro Ltd
Gurgaon
01.2012 - 08.2013
- SQL Server 2000, 2005, 2008 installations, configuration and security settings.
- SQL Server upgrade with service packs and hot fixes.
- Creating Database users, controlling access to instance and databases.
- Established alerts and notifications for system errors, resource shortages, fatal database errors, hardware issues, and security breaches to enhance system reliability.
- Configuring / maintaining high availability SQL Server solutions that include Log shipping, Mirroring, Replication.
- Implement database administration/ maintenance plans and monitor using alerts.
- Monitor database usage and growth trends to forecast future storage needs as Capacity planning measure.
- Migration of SQL Server 2000 to 2005 and in-place upgrade.
- Resolved blocking and locking issues in databases to ensure smooth operations.
- Contacted Microsoft support for assistance with critical database issues.
- Creating and maintaining scheduled jobs and implementing automation for other tasks.
- Managed situations where databases were marked as suspect to restore functionality.
- Conducted regular database consistency checks using DBCC commands to ensure data integrity and operational stability.
- Created database snapshots based on requests from the application team.
- Configuring and installing clustering 4-node (N+1).
- Coordinating with the onsite DBA Support Team on production support issues.
- Developed root cause analyses for P1 critical issues and problem tickets to improve incident response and prevention strategies.
- Documented newly resolved tasks and environmental details in SharePoint for team reference.
- Dish TV India Limited (dishtv) is an Essel Group venture. Essel Group has a vast range of national and global business interests that include media programming, broadcasting & distribution, specialty packaging and entertainment. dishtv is India's first direct to home entertainment service that has digitalized Indian entertainment to bring to home the best in television viewing through the latest in digital technology.
Education
Master of Computer Application -
JNTU University
Skills
- SQL Server Installation
- Backup and Restore
- Log Shipping
- Mirroring
- Clustering
- Replication
- High Availability
- Database Corruption Handling
- Migrations
- In-place Upgrades
- Monitoring Alerts
- User Management
- Security Implementation
- PowerShell Integration
- Production Support
- Azure database migration
- Azure Data Services
- Microsoft Azure Cloud
- Azure Portal
- Azure Site Recovery
- Blob Storage
- Azure Active Directory
- Cloud IAM
- Cluster deployments
Projects
- Rackspace, Handling ~100 plus customers, 21, L4 DBA, Rackspace is a managed cloud computing company that aims to make it easy to manage private and public cloud deployments. The company is the largest managed cloud provider, offering expertise across cloud platforms such as, Amazon Web Services, Microsoft cloud/ Azure and OpenStack.
- Tricore Solutions, Handling ~100 plus customers, 16, Principal Consultant, TriCore Solutions provides a full suite of scalable and reliable managed application, cloud, infrastructure hosting, and consulting services to enterprise organizations.
- McKinsey & Company, Mckinsey & Company, 16, Senior SQL DBA, McKinsey has created and invests significantly in its knowledge management system to support field consultants.
- Wipro, Dishtv (Z news), 6, DBA (Production Support), Dish TV India Limited is an Essel Group venture that provides direct to home entertainment service.
Disclaimer
I hereby declare that the information furnished above is true to the best of my knowledge and belief.
Aka
LKD Naidu
Certification Summary
- MCSA: SQL 2016 Database Administration - Microsoft
- ITIL Expert Certificate in IT Service Management ITIL V3
- Administering a SQL Database Infrastructure 70-764 - Microsoft
- 70-463 Implementing A Datawarehouse using SQL Server 2012/2014 - Microsoft
- Provisioning SQL Databases 70-765 - Microsoft
- AWS Certified Solutions Architect - Associate - AWS
- Microsoft AZ-301 - Microsoft
Timeline
L4 DBA
Rackspace Technology
10.2017 - Current
Principal Consultant
Tricore Solutions Pvt Ltd
10.2014 - 10.2017
Senior Database Administrator
McKinsey & Company
08.2013 - 10.2014
Database Administrator
Wipro Ltd
01.2012 - 08.2013
Master of Computer Application -
JNTU University