Your Name

Database Administrator with around 5 years of experience in IT Industry. Experience in SQL DBA 5 years and MongoDB 2+ years. Expertise in SQL Server database administration in production, test and development environments, with MS SQL Server 2016, 2014, 2012, 2008R2, 2008 systems. Good knowledge of SQL Server cluster and standalone Server environments in terms of installation and configuration. Competence in Migrating SQL Server 2008/2008R2 to 2012/2014/2016. Experience in Microsoft SQL server administration from 2008-to-2017 versions, experience on Microsoft Azure Administration. Experience in MongoDB up-gradation from 4.2 to 6.0. Experience in configuring registering servers and linked servers. Proficient in involving in clustering at both Windows and SQL Server levels and maintenance. Experience in automation of administrative tasks like creating maintenance plans, creating Jobs, alerts using SQL Server agent and monitoring and troubleshooting the jobs. Good experience in planning and controlling the user privileges, monitoring the security and audit issues as per standards. Very good knowledge used tools like SQL Profiler, Index Tuning Wizard and windows performance monitor for monitoring and tuning MS SQL server performance. Experience in understanding of RDBMS concepts as well as Azure SQL concepts. Good knowledge in identifying the I/O and memory, bottlenecks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing better, Query Execution plans. Experience in high availability & disaster recovery techniques likes log shipping, mirroring (high safety, high performance), replication (snapshot, transactional) and clustering (active - passive and active- active). Experience in analyzing performance, Query optimization and tuning. Experience in index maintenance like index tuning, rebuild, reorganizing according to index fragmentation, running DBCC checks and update statistics to check the data base integrity. Proficient in Database Recovery models. Experience in daily database maintenance and administrative tasks like Space issues, transaction log file size growth, connectivity issues and regular monitoring of SQL Server error logs and Windows event viewer. Experience in using DMVs, DMFs, and SYSTEM VIEWS for instant analysis. Expertise in performing database regular Backups full/ differential/ transaction log backups into disk and restoring on requirement. Experience in Log shipping database Cutover DR drill to data recovery servers and routing the application from data recovery servers and testing the application connectivity. Experience and knowledge in Azure SAAS and PAAS services.

• BILLTRUST, Billtrust is an A/R automation suite for B2B companies. This software provides automated order-to-cash solutions that meet diverse buyer requirements, secure multi-channel payment enablement, and intelligent matching and payment posting., SQL Server 2017, MongoDB 4.2 to 6.0
• AHOLD, The client is an online grocery company, the grocery chain expanded through the first half of the 20th century the company also influenced culinary Development in the country., SQL Server, SQL 2000, SQL 2005, SQL 2014

• Involve in Installing SQL Server and applying patches.
• Create logins, assigning permissions, and mapping them to database.
• Involved in migration & up-gradations of both SQL and MongoDB.
• Knowledge and configure the Azure SQL Database Managed Instance.
• Involve in tuning performance issues using DB profiler and tuning advisor.
• Perform regular backups, creating, scheduling jobs, restoration of DBs’ & checking the status of backups, troubleshooting failed backups.
• Reviewing ddl and dml.
• Handle login issues and providing solutions to Connectivity issues.
• Configure the clustering and troubleshooting the issues.
• Fix the orphaned users that occur during migration or refresh activities.
• Involve in Indexes on tables and maintaining indexes through Rebuild/Reorganize.
• Handle the blockings and deadlocks & resolving by interacting with App team.
• Resolve the Memory issues like Disk space, Log file, and TEMPDB issues.
• Configure and troubleshoot the Database maintenance plans and configure and troubleshoot the jobs, alerts and DB mail.
• Configure & troubleshoot the replication, Log Shipping & mirroring.
• Create /configure Azure SQL Databases.
• Responsible in migrating On-Prem DBs to Azure SQL DBs (Singleton) using DMA.
• Involve in DMS (Data Migration Services) for performing migrations.
• Migrate On-Premises DBs to Azure Managed Instance using Backup/Restore (Lift-Shift method).
• Export the BACPAC from Azure SQL Databases.
• Create Azure Virtual Machines on Windows using Azure portal and Good knowledge.
• Create Azure Virtual Machine Images (including SQL Server).
• Understand on Premium/Standard Storage accounts.