Challa. Naga Chandra Sekhar

[email protected] • +91 9996111666 • India

PROFESSIONAL SUMMARY

Dynamic Microsoft SQL Server Database Administrator with over 5 years of experience in managing and optimizing database environments. Proficient in Transact SQL (T-SQL), backup and recovery strategies, and performance tuning, with a proven track record of improving database efficiency and troubleshooting production issues. Successfully guided server migration and implemented high-availability solutions. Eager to leverage expertise in SQL Server administration to drive excellence and support operational success at your esteemed organisation.

WORK EXPERIENCE

Database Administrator
08/2024 - 07/2025
LTIMindtree Pvt Ltd , Hyderabad
• Optimised project workflows using Microsoft Project, encompassing planning, scheduling, resource allocation, and progress tracking
• Employed Gantt charts and various visualization tools to facilitate milestone tracking and effective risk management
• Contributed significantly to ensuring project deliverables adhered to established timelines and quality standards
• Assisted in the formulation of comprehensive project plans, timelines, and task breakdowns to promote efficient project execution through Microsoft Project
• Delivered 24/7 support and technical expertise across multiple applications to clients
• Provided support across APAC and EMEA regions, handling inquiries from customers across different time zones including EST and PST
• Facilitated server migration activities, including transferring databases from on-premises servers to Azure
• Conducted weekly resource allocation meetings with team leaders, enhancing resource alignment with strategic project priorities
• Diagnosed problematic queries leading to deadlocks and blocking issues, providing actionable recommendations to clients
• Advised customers on scaling resources up or down based on their usage to mitigate unnecessary expenses
• Recommended best practices for database design, schema optimisation, and high availability concepts
• Cooperated with the PTA Team to resolve issues, providing recommendations and resolutions to clients
• Utilised tools such as Case Buddy, ASC, and Kusto for backend validation of customer issues
• Engaged with the Product Team (PG) to troubleshoot issues such as restoring deleted servers and handling Jarvis-related problems
Database Administrator
08/2022 - 05/2024
TATA CONSULTANCY SERVICES Pvt Ltd , Hyderabad
• Managed the pharmaceutical supply chain databases for McKesson on Microsoft SQL Server
• Collaborated with various teams, utilising Transact SQL (T-SQL) to design and implement procedures and functions. And configured and maintained Microsoft SQL Server databases across all environments
• Regularly maintained and backed up databases while executing Extract, Transform, Load (ETL) operations
• Evaluated existing SQL queries for performance enhancements
• Demonstrated expertise in troubleshooting common database issues effectively
• Provided 24/7 DBA support and technical consultation for multiple applications across development, testing, QA, and production SQL Servers
• Participated in server data migration initiatives, involving the transfer of databases, users, logins, jobs, and stored procedures, while resolving orphaned user issues
• Engaged in performance tuning by proposing the creation of indexes and stored procedures
• Identified and resolved problematic queries causing deadlocks, blocking, and prolonged execution times
• Addressed production performance issues and participated in disaster recovery activities
• Attended Change Advisory Board (CAB) meetings to acquire approvals from stakeholders for database change requests (CR)
• Executed backup and recovery strategies, user management, and query optimisation
• Possessed extensive experience in managing, troubleshooting, and optimising SQL Server environments
• Ensured database security adhered to best practices while coordinating with Windows servers and Active Directory
• Demonstrated comprehensive knowledge of high availability concepts, such as Always On, log shipping, replication, and mirroring
• Conducted database maintenance tasks, including data modelling, index rebuilding, reorganising indexes, and updating statistics
• Performed manual full and log database backups and executed restorations within Always ON Availability Groups
• Contributed to SQL Server upgrades, specifically to CU26
• Maintained extensive experience in script deployments and utilised SSIS, SSRS, and SSAS services
• Managed clustered environments, executing failover and failback activities during OS patching
• Utilised SNOW and IDERA SQL Diagnostic Manager for operational support and monitoring
• Provided technical support and troubleshooting assistance to end users
• Conducted database creation, dropping processes, and user management, including granting and revoking privileges on PostgreSQL servers
• Executed script deployments in Azure PostgreSQL Server
Database Administrator
08/2021 - 10/2021
Apex Logistics pvt ltd , Visakhapatnam
• Created user logins and granted necessary privileges
• Monitored Temp DB growth and addressed database security issues
• Implemented backup and recovery strategies effectively
• Conducted weekly and monthly database maintenance tasks
• Monitored and resolved support tickets based on their priority levels
• Managed disk space and addressed blocking and transaction log database issues
Database Administrator
07/2018 - 07/2021
SSIGRUN Consultancy pvt ltd , Hyderabad
• Monitored dashboards and assigned incidents to team members
• Maintained all SQL Server instances and databases using automated jobs while managing clustered environments
• Executed all database management responsibilities within MS SQL Server for both production and non-production workloads
• Oversaw physical database architecture and design, capacity planning, development, performance tuning, implementation, and application support from a database perspective
• Processed ad hoc data requests from business departments and configured backup schedules and job tasks
• Conducted I/O utilisation monitoring on servers and submitted detailed performance reports to management

EDUCATION

Bachelor of Technology
Jawaharlal Nehru Technological University Kakinada

SKILLS