SQL Server DBA • July-2022
Description: • Providing support to both production and development databases, with a focus on ensuring optimal performance and reliability. Particularly, managed and maintained databases powering a high-traffic online e-commerce website, guaranteeing seamless user experiences and uninterrupted business operations. • Addressing and resolving performance challenges, including high CPU, memory, and disk I/O issues, leveraging SolarWinds Database Performance Assistant in tandem with native SQL Dynamic Management Views (DMVs). This proactive approach ensured the continued optimal operation of critical systems. • Collaborating closely with the development team to fine-tune and optimize sluggish queries, enhancing application performance and user satisfaction while streamlining database operations. • Conducting routine data transfers from production to development/user acceptance testing (Dev/UAT) databases as part of the ongoing maintenance process, ensuring the availability of up-to-date data for testing and development activities. • Setting up auditing for any login and user-related changes. • Participating in peer reviews of stored procedures and queries authored by developers, ensuring code quality, adherence to best practices, and the overall optimization of database operations. • Engaged in Database Change Control meetings, playing a key role in assessing and validating that all proposed database changes met stringent performance criteria and complied with established standards using Azure DevOps for CI/CD. • Maintaining a rigorous patch management regimen, regularly updating all servers within the infrastructure to bolster security, optimize performance, and safeguard against vulnerabilities. • Working on the migration of the database from On-Premises to Azure Managed Instance.
database consultant • June-2005 to November-2016
CSC India Pvt. Ltd.
Description: • Ensured smooth migration of servers from one data center to another. • Performed in-place upgrades for all cloud v-center databases from 2008 r2 to 2012. • Developed VB scripts for unattended install of SQL server 2008 R2 and SQL 2012, leading to a reduction in deployment time from 2 hours to 30 minutes. • Developed VB scripts for automating the post-install QA process, reducing time to 10 minutes from 1 hour. • Developed integrated re-index and updated statistics script, thereby reducing the number of tickets due to blocking by 10%. • Updated backup scripts to use compression and backup to multiple files thereby reducing overall backup times by 30%. • Collaborated on the slipstreaming process for SQL Server 2008 and SQL Server 2012 installations, optimizing deployment efficiency. • Strategically planned and executed a successful migration initiative, transitioning client databases to the latest version of SQL Server for improved performance and enhanced features • Revamped internal monitoring stored procedures, transitioning them to utilize Dynamic Management Views (DMVs) in lieu of system tables, enhancing the system monitoring capabilities of the team. • Engineered an efficient stored procedure, capable of accepting backup filenames and database names as input parameters, with the added functionality of terminating user connections to the database and executing seamless database restoration. This solution sped up the process of migration of databases between servers. • Expanded the Offshore DBA team to a robust unit of 8 members through comprehensive recruitment, onboarding, training, and mentorship of all new additions, fostering a dynamic and skilled workforce.