Mukesh Singh Email & Phone Number

India

Gurugram, Haryana, India

India

Noida Area, India

• Professional and highly motivated having over 10 years of DBA experience in software industry with MySQL, MariaDB, SQL Server, PostGreSQL• 9+ Years of experience in database administration in MySQL(5.x), MariaDB(10.x) and SQL Server 2005,2008,2012,2014, 2017. PostGreSQL 9.X• Strong PL/SQL skills and also proficient in writing shell scripts for database administration tasks.• Experience of Database Administration activities, database design, maintenance and production support of relational databases, new server setup, server installation, upgrade, patching and migration.• Installation, configuration, deployment, troubleshooting SSIS, SSRS, SSAS, PBIRS, MDS (Master Data service).• Supporting more than 20000 database servers. Which includes production\Staging and development servers.• Have successfully managed high availability of production systems through Always on, Galera Clusters, Replications, Log Shipping and Mirroring.• Experienced in database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: SQL Server, MySQL,Postgres,Mariadb• Performance Tuning – Execution plan, Profiler, Performance Monitor, Extended Events, Data Collector• Working as a level-3+ MS SQL DBA,MySQL,PostGresql/MariadDB to work on escalated Incidents and issues. Providing RCA Independently on P1 and other complex Issues.• Experience in managing database backup and recovery strategies, replication and data synchronization.• Having successfully managed load balancing through HA Proxy, Proxy SQL.• Experience in handling database sizes from 5MB to 25TB in both production and non-production 24X7 environments. • Experienced with Requirements gathering, data modeling, System Architecture, Feasibility studies, Scope Documents & requests for proposal (RFP).

Noida Area, India

• SQL Server Setup, Installation, Version Upgrade & Architect Setup• Installation, configuration, deployment, troubleshooting SSIS, SSRS, SSAS, PBIRS, MDS (Master Data services.• I have some sound and practical knowledge in AzurDevops (Pappet,GIT,BIT,Powershell) for deployment and troubleshooting .• Implementing and Maintaining Log Shipping | Clustering | Mirroring | Always On HADR• Install, manage & troubleshoot multi node multisite SQL Server clusters• SQL Server Hardening & Best Practice Implementation• Load Balancing & Scaling out SQL Server• Design and Implement Database Backup Restore & Disaster Recovery Strategy• Database Archiving / Partitioning (Horizontal / Vertical)• Performance Tuning – Execution plan, Profiler, Performance Monitor, Extended Events, Data Collector and Resource Governor• Setting up Base lining and Capacity Planning• SQL Server Hardware sizing and bottleneck tuning• Auditing SQL Server Security• Data Transfer / Transformation• Plan, Design and Scheduled Database Maintenance & Administrative Tasks• Configuring Replication / Data Synchronization• SQL Server Database Monitoring with DDL Triggers | SQL Server Profiler | Event Notifications• Data Quality and Master Data Service Design and Implementation• Schedule SQL Jobs | SQL Server across multiple Servers• Enterprise Policy Management / Centralized Management• Experience on BizTalk application and BizTalk Terminator tool solution.• Involve the planning of deployment of database• Knowledge of IIS and Binding application pool and host the website.

Greater Noida

1.Installation, Administration and Maintenance of SQL Server Instances.2.Setup Test, Dev, Staging and Production Environments.3.Create Users and assign permissions based on the level of database access the user would need.4.Create Linked Servers to SQL Servers and other databases such as Access, MySQL etc.5.Design database Backup and Restoration Strategy.6.From time to time recover the databases to a specific point of time, as per the requests.7.Setup High-Availability as part Disaster Recovery Strategy for the Databases.such as (Failover Clustering, Database Mirroring, Log Shipping and Replication)8.Troubleshoot various problems that arise in a day-to-day work and fix the issues. such as (Monitoring SQL Server Error Logs and checking your email alert).9.Monitoring and Performance Tuning; Physical Server Level, Database level and query tuning.10.Documenting major changes to the SQL Servers. (General)11.Apply Service Packs and hot fix and cumulative patch.

Noida

• Creation of reports as per requirement by the clients.• Creation of procedures, triggers and jobs as per the database requirement and monitoring the Database Servers.• Involved in planning of structure of database.• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.• Queries/Complaints/new requirements and ensure timely closure.• Involved in the process of replication of databases.• Responsible for creating and drooping of indexes and re indexing.• Involved in the performance of tuning of SQL queries and database.• Responsible for taking backup and maintaining the space in the database. Maintaining disk spaces.