AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF13992
profile image
Agarwal A AXF13992 Active
SQL Server DBA in Jabalpur
With over 19 years of experience in SQL server database administration, I am a seasoned professional who can handle any database challenge, from performance tuning to migration, from backup and recovery to high availability and disaster recovery. I hold the Microsoft Azure Database Administrator Associate certification and have worked with all versions of SQL server from 6.5 to 2019, and Azure SQL. I am passionate about learning new technologies and have completed courses on ADF and Snowflake. Currently updating myself with Python. My goal is to leverage my expertise and knowledge to help organizations achieve their business objectives and deliver value to their customers.
Industries : Automobile, Infrastructure management
Share
Hire Agarwal A
Download PDF
Availability
Part-time
Total experience
19 years
Technical skills
SQL Server
19 Years & 3 Months
Backup and Recovery
19 Years
Installation and Configuration
19 Years
query tuning
17 Years
Index maintenance
16 Years
SSIS
Projects
SSIS Migration
September-2022 to October-2022
Description
Migrate over 200 SSIS packages from SQL2012 to 2019
Roles and Responsibilities
changing all connection strings to new server. Creating jobs on new servers
Technologies: SSIS
Industry: Automobile
SQL DBA
August-2021 to December-2021
Description
SQL Server Database Administration Support to development.
Roles and Responsibilities
• Proactively managed server performance on a daily basis, consistently monitoring and addressing any performance issues to ensure the seamless operation and optimal performance of all servers in the environment • Diligently monitoring and promptly resolving all server alerts generated by Redgate SQL Monitor, ensuring the continued health and stability of the SQL server infrastructure. • Maintaining a vigilant approach to server maintenance, ensuring all servers are consistently patched and kept up to date to mitigate security risks and enhance system reliability. • Collaborating closely with the development team to optimize long-running queries, providing valuable insights and recommendations for index creation to enhance overall database performance. • Responsible for implementing and meticulously monitoring essential database maintenance tasks, including reindexing and DBCC checks, to uphold database health and performance standards. • Adhered to the established Change Request process for the seamless implementation of new database changes, ensuring a systematic and controlled approach to modifications while minimizing risks. • Planning and executing database deployments, orchestrating seamless transitions to new configurations or updates, and ensuring minimal disruption to operations. • Executing database migrations from production to development environments, facilitating the availability of current data for testing and development purposes.
Technologies: SQL Server
Industry: Infrastructure management
Work history
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.
Soft skills
Articulate
Critical thinking
Problem-solving
Education
Bachelors degree in Engineeting
Pune
1989 to 1993
Language
English - Advanced