Nikhil Bansal Email and Phone Number

As a dedicated Team Lead in DBA support, I spearheaded 24/7 operations spanning multiple time zones, ensuring optimal database performance and reliability within the healthcare domain for our esteemed client, Zimmer.Key Contributions:Leadership:- Led a 24/7 DBA support team across multiple time zones for Zimmer, a key client in the healthcare domain.Policy Development:- Created and implemented a robust backup and restore policy for data integrity and disaster recovery.Automation:- Streamlined SQL installation, patching, and database refreshes through automation, boosting efficiency.Training and DR:- Trained junior team members, conducted Knowledge Transfer (KT), and actively participated in Disaster Recovery (DR) activities.Upgrades:- Successfully performed SQL upgrades to stay current with evolving technologies.Client Support:- Provided on-call support, ensuring prompt issue resolution and high client satisfaction.High Availability:- Implemented high-availability solutions for over 600 servers across various environments.Migration Planning:- Orchestrated seamless migrations from lower to higher SQL Server versions.Performance Optimization:- Proactively resolved performance issues related to slowness, locking, and application concerns.DPA Tool Implementation:- Introduced the Database Performance Analysis (DPA) tool for effective server monitoring and optimization.Database Optimization Expertise:- Assisted developers in query tuning and refined database schemas for optimal performance.Real-Time Issue Resolution Specialist:- Analyzed, solved, and corrected issues on the fly to ensure seamless system functionality.Workflow Optimization Leadership:- Created and maintained jobs to streamline processes, contributing to enhanced overall workflow efficiency.

As Data Lead for Marks and Spencer India in e-commerce, I optimized data processes, supporting the brand's online success.Key Contributions:Backup Strategy:- Implemented a robust backup policy using SQL Backup FTP and Ola Hellengreen scripts, ensuring data integrity and quick disaster recovery.Server Installations:- Orchestrated seamless end-to-end installations, meeting evolving organizational needs.Data Integration:- Introduced a streamlined process for transferring daily transactional data from MSSQL to MySQL using the Talend ETL tool, enhancing data interoperability and efficiency.Advanced Data Organization:- Developed merge procedures and CDC processes for efficient data syncing and ingestion into Talend.Strategic Architecture:- Played a key role in launching Marks and Spencer's online application, architecting servers for specific data requirements.Collaboration:- Actively collaborated with the marketing team, automating daily data processes and generating insightful sales reports.Performance Optimization:- Resolved performance issues for India store operations, ensuring efficient data-driven business.My tenure showcased strategic data leadership, innovation, and collaborative success in e-commerce.

L2 DBA | 24/7 Support | Legal ClientsPerformance Optimization:- Delivered 24/7 L2 DBA support, addressing and resolving performance issues for legal clients.Backup and Restore:- Managed backup and restore activities, ensuring data integrity and seamless recovery processes.Collaborative Issue Resolution:- Worked closely with the application support team to troubleshoot and resolve user-facing application issues, ensuring a seamless user experience.Contributed to the smooth operation of database systems and collaborative problem-solving for enhanced client satisfaction.

L2 DBA | 24/7 Support | Client: Stryker | Healthcare DomainComprehensive Support:- Provided 24/7 L2 DBA support, specializing in healthcare solutions for client Stryker.Core DBA Activities:- Executed fundamental DBA activities, contributing to the seamless operation of critical healthcare databases.Dedicated to ensuring robust database support and performance within the healthcare domain.

Initial Role: L1 DBA | 24/7 Support | Client: XeroxFoundational Learning:- Started as an L1 DBA, providing 24/7 support for client Xerox, and gained valuable insights into core DBA activities.Skill Development:- Absorbed fundamental aspects of database administration, forming the foundation for subsequent roles.Professional Growth:- Demonstrated proficiency and dedication, leading to a promotion to L2 DBA after 2.5 years.Embarked on a journey of continuous learning and advancement, laying the groundwork for a successful career in database administration.