Mayank Soni

To give my best efforts towards the success of organization with my skills and knowledge in every prospect and thus, contribute towards organizational goals.

12+ years of experience as a Sr. SQL DBA (L3 + Support) + Azure SQL DBA for very large databases in SQL Server 2022, 2019, 2017, 2016, 2014, 2012 as well as in Azure SQL. Hands on experience in Azure SQL database, Elastic Version, Azure Storage, Virtual Machines, Azure AD, Azure Monitoring, Azure Databricks, Azure Cosmos DB. Experience in Microsoft Azure Cloud Services (PaaS & Iaas), Document DB, Internet of Things (IoT), Azure SQL & Monitoring. Migrate data SQL Database to Azure SQL database and vice versa. Knowledge technical background along with the ability to perform business analysis and write effective documentation and specifications. Expert in data Transformation services like BCP and Bulk insert. Experience on installation and configuration of SQL SERVER versions, and also applying the patches, hot fix, services packs and RTM’s accordingly, involved in upgrading on in place and side by side as per client requirement, and also Migrating the database on SQL SERVER 2012 to 2014 and 2016 and so on. Experience on configuring and maintenance of High availability SQL Server solutions, including Log shipping, Database Mirroring, Always on, Replication (Transactional and Merge) and SQL Server Clustering, having experience on performance tuning on server level, database level and query level. Strong experience in monitoring team members and writing documentation. Ability to multi-task and context-switch effectively between different activities and teams. ITIL Skill set requirement (Problem Management/Incident Management/Chain Management). Basic Experience on SSRS, SSAS, SSIS (BI tools). Production or critical Database On Call Support at any time.

• MS SQL server 2012/2014 Associate(70-462), Microsoft Certification, Dec2017-Feb2018, 2018
• Java and asp.net, NIIT (Training), Sep2010-Dec2010, 2010
• PLC (Programmable Logic Controller), Creative Automation, July2008-Aug2008, 2008

• Appreciate Award for CMC Limited in 7 Oct 2013.
• Appreciate Award for CNH Industrial in Sep 2023.
• Won prize in painting competition at district level in school.
• Participated and won second prize in a remote controlled robotic race event at a robotic workshop organized by Technophilia solutions.

India, K7303613, 10/21/2031

Microsoft Windows 2012 , 2010, 2007, T-SQL, SQL , Azure SQL, Azure Storage, SQL Server 2008,2008R2, 2012, 2014, 2016, 2017, SQL2019 databases, Service now, Remedy, SSIS, SSAS, SSRS, Database Engine, SSDT , Net backup, Java, Asp.Net, SAS, Monitoring team members and writing documentation, Work in a team, Use Interpersonal Skills, Observations , Analyze the data , Prior Client facing experience, Problem Management/Incident Management/Chain Management, MS Office

• Manage and maintain SQL databases in AWS and Azure cloud environments.
• Perform database installations, configurations, upgrades, and migrations.
• Monitor database performance and optimize query execution.
• Troubleshoot database issues and provide timely resolutions.
• Implement and maintain database security, including user access and data encryption.
• Develop and maintain database backup and recovery strategies.
• Collaborate with development teams to design and optimize database schemas.
• Develop and maintain database documentation, including standard operating procedures and best practices.
• Automate database administration tasks using scripting languages, such as PowerShell.
• Stay up to date with the latest trends and advancements in cloud database technologies.
• Proven experience as a SQL DBA L3, specifically in managing SQL databases and Azure cloud environments.
• Strong knowledge and experience with Azure SQL Database, or similar cloud database services.
• Proficient in SQL Server administration, including installation, configuration, and maintenance.
• Solid understanding of database performance tuning and query optimization techniques.
• Experience with database backup and recovery strategies.
• Strong scripting knowledge, preferably in PowerShell, for automating database administration tasks.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills
• Maintained more than 1000 Production, UAT and Development Clustered Servers, around 1500 instances with 5000 databases including 5 TB of VLDB’s.
• Responsibilities as a SQL Server Database Administrator include installation, creation, maintenance and optimization of databases for various clientele projects.
• Daily monitor the internal ticketing tool (Virtual Ticket), and working the priority and severity of the issue or user request.
• If is there any production changes we required RFC from users as per change management policies, accordingly we will schedule on production server at weekends to remediate.
• Daily monitoring the Jobs and alerts, for monitoring purpose we are using Remedy, Service Now, if at all is there any job failures we need to remediate immediately.
• Daily interact with developers is there any performance related issue, and work with them, troubleshoot accordingly
• As per user request working on database refreshment.
• Is there any escalation from client side we will discussed in weekly meetings and remediate accordingly.
• Having good experience on documentation to prepare is there any configuration done on particular server, also share with team members.
• Daily monitoring all the database backup maintenance job’s and maintaining the disk space accordingly
• As part of a team, analyzed the different high availability solutions and implemented database mirroring and replication.
• Monitoring the clustering environment.
• Trouble shooting (Memory Bottlenecks (log), D-drive space issue, Blocking etc)
• Using log shipping for synchronization of database
• Database instances configuration, change, for example DB recovery model, DB or server collation, memory allocation, CPU allocation, degree of parallelism, and any other potential configuration option
• Security management, database instances configuration as well as logins creation, change, removal
• SQL Jobs management, creation, change, removal and monitoring
• Knowledge of SQL – data extraction, Operation and maintenance
• Performance monitoring and tuning of SQL server instances and databases. Regular review of database health checkup and Backup monitoring for SQL database
• Monitoring the server for High availability of the servers.(Mirroring , Log shipping , Replication, Always On-HADR , Clustering)
• Solving the request raised by user support.
• Participate in implementation of new releases into production.
• Configuration and management of database cluster environments for high availability services
• Designed and implemented Security policy for SQL Servers.
• Used Stored Procedures, DTS packages, BCP for updating Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Database upgrade with latest patch levels
• Backup and recovery, creation and management of ADMIN database management
• Maintenance of database management scripts (backup, fragmentation analysis)

I hereby declare that all the statements made above are correct to the best of my knowledge and belief.