Summary
Overview
Work History
Education
Skills
Certification
Languages
Disclaimer
Personal Information
Timeline
Generic
Deepak Mishra

Deepak Mishra

Lucknow

Summary

  • An Innovative thinker with extensive experience implementing the next generation database solution.
  • Possesses 13+ yrs. experience as Database Administrator.
  • Proficient in Homogeneous & Heterogeneous Migration on Google Cloud Managed Instance.
  • Azure (IaaS & PaaS) On-premises to cloud migration, Infrastructure provisioning, Cloud-based services and cost optimizations.
  • Well aware about windows server features starting from 2003 to 2022 and top of that hosting SQL server databases. Implementing best practices as well which are good for high performance of SQL Server.
  • Proficient in technologies like MS SQL (Primary), Postgresql (Secondary), Oracle (Secondary), MongoDB (Secondary).
  • Expert in technical problem solving skills.
  • Expert at optimizing process to improve data retrieval and data restore.
  • Skilled at researching and resolving discrepancies.
  • Service Strategy, Service Transition, Service Operation, and Continual Service Improvement to more specific for database environment.
  • Good coordination within team and inter team to get the proper support during priority cases or transition of new project.
  • Defining and Preparing SOW and also documenting escalation metrix of vendor to get the proper support during priority case.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Consultant

HCL Technology
Lucknow
10.2021 - Current
  • Homogeneous and heterogeneous migration from on-prem to Google Cloud Managed Instance.
  • Azure (IaaS and PaaS): on-premises to cloud migration, infrastructure provisioning, cloud-based services, and cost optimizations.
  • PostgreSQL to PostgreSQL.
  • Oracle to PostgreSQL.
  • DB2 Mainframe to PostgreSQL.

DXC Technologies LTD.
10.2019 - 10.2021
  • Company Overview: Client: QBE Insurance
  • Installation, Configuration, Managing, Monitoring and Troubleshooting of SQL Server 2000/2005/2008R2/2012/2014/2016 and 2017
  • Planning and implementation of SQL Server Backup and Restoration
  • Expert in Migration, upgrading of SQL servers
  • Planning and implementation of Log Shipping, Mirroring, Replication and always on
  • SQL Server Failover clustering installation, administration and patching
  • Working experience on Azure Cloud
  • Experience in monitoring, tuning, and analysis database performance and allocates resources to achieve optimum data base performance
  • Having knowledge in managing the SSIS, and SSRS
  • Managing team meeting like backlog, change and RCA call
  • Providing 24
  • 7 production support including on call support
  • Excellent communication, presentation and interpersonal skills
  • Client: QBE Insurance

HCL Technologies LTD.
03.2018 - 10.2019
  • Company Overview: Client: Sensata Technology Inc
  • Installation, Configuration, Managing, Monitoring and Troubleshooting of SQL Server 2000/2005/2008R2/2012/2014/2016 and 2017
  • Planning and implementation of SQL Server Backup and Restoration
  • Expert in Migration, upgrading of SQL servers
  • Planning and implementation of Log Shipping, Mirroring, Replication and always on
  • SQL Server Failover clustering installation, administration and patching
  • Working experience on Azure Cloud
  • Experience in monitoring, tuning, and analysis database performance and allocates resources to achieve optimum data base performance
  • Having knowledge in managing the SSIS, and SSRS
  • Managing team meeting like backlog, change and RCA call
  • Providing 24
  • 7 production support including on call support
  • Excellent communication, presentation and interpersonal skills
  • Client: Sensata Technology Inc

DXC Technology Pvt. LTD.
01.2016 - 03.2018
  • Company Overview: Client: Airtel Africa & Reliance India Pvt LTD
  • Experienced in Installation, applying patches, managing, and database integrity/consistency and troubleshooting of SQL Server 2016/2014/2012/2008R2/2008 in Windows 2012/08/03
  • Experience in setting up Log shipping, DB mirroring, Transactional Replication, and Always On
  • Got hands-on experience in configuring and scheduling Database maintenance plans
  • Migrating SQL Server 2005/2008/R2 and 2012 databases into SQL Server 2012/14/16
  • Experience with performance monitoring, security, backup, restore and DR solutions
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, log issues, connectivity issues, security issues
  • Ability to identify and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
  • Expertise in Database refresh from Prod to Staging/Dev/Testing environments
  • Experienced in implementing SQL Server security models
  • Experienced in Shrinking log files to free up the space and Indexing, update statistics at regular intervals for better performance
  • Experienced in monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors
  • Handling the daily backlog call, weekly change call, client standup call and RCA call
  • Client: Airtel Africa & Reliance India Pvt LTD

Innodata India Pvt LTD.
07.2015 - 12.2015
  • Involved in Installation and configuration of MS SQL Server 2005/2008/R2/2012 in Windows Server 2003/2008/2012 environment
  • Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups
  • Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transactional log backups, fixing backup failures
  • Monitor SQL Error Logs, Schedule tasks, database activity
  • Worked on DBCC commands to maintain Database Consistency
  • Up gradation of SQL Server 2000,2005,2008/R2 to SQL server 2012
  • Working experience in Migration of databases in side by side and in-placed servers
  • Working Experience of Log shipping and monitoring log shipping jobs and troubleshooting
  • Overcome failure of Log shipping through the manual Fail-Over of log shipping

NIC -E-Centric Solution Pvt LTD.
08.2012 - 06.2015
  • Company Overview: Client-: COMMERCIAL TAX DEPAARTMENT
  • Installing and configuring SQL Server 2005/2008/2008R2
  • Backing up database, backing up data files, log files, verifying the integrity of backup
  • Ensuring data consistency in the database through DBCC Commands
  • Creating maintenance plans and jobs for automation of the repetitive task
  • Managing security by creating logins, users and assigning privileges
  • Checking the general health of the servers and also identifying CPU/IO bottlenecks
  • Closely monitoring the growth of the databases, as a part of capacity planning
  • Ensuring high availability of the database exploiting the concepts of Mirroring and Log shipping
  • Implementing SQL server hardening for best practices
  • As per capacity plan Release the free space from database files to OS, when disk space above 70% utilizing by database files
  • Resolving the issues like blocking, deadlocks, slow running queries High etc
  • Actively participated in DR and HA drills
  • Handling a big database CRM which size is approx
  • 3.3 TB
  • Client-: COMMERCIAL TAX DEPAARTMENT

Education

B. TECH - Bachelor of Technology

UTTAR PRADESH TECHNICAL UNIVERSITY
Uttar Pradesh, India
07-2011

Skills

  • SQL DB Management
  • Homogeneous and heterogeneous migration on Google Cloud Managed Instance
  • MS SQL to MS SQL migration
  • PostgreSQL to PostgreSQL migration
  • Oracle to PostgreSQL migration
  • DB2 Mainframe to PostgreSQL migration
  • Oracle to BigQuery migration

Certification

  • Implementing Microsoft Azure Fundamentals (AZ-900)
  • Administering Microsoft SQL Server 2012/2014 Databases (70-462)
  • Associate Cloud Engineer GCP.
  • ITIL Foundation Certified

Languages

  • Hindi
  • English

Disclaimer

I hereby declare that details furnished above are true to the best of my knowledge.

Personal Information

  • Passport Number: S8622127
  • Father's Name: Mr. Shiv Sahay Mishra
  • Date of Birth: 06/03/1988
  • Nationality: Indian
  • Marital Status: Married

Timeline

Consultant

HCL Technology
10.2021 - Current

DXC Technologies LTD.
10.2019 - 10.2021

HCL Technologies LTD.
03.2018 - 10.2019

DXC Technology Pvt. LTD.
01.2016 - 03.2018

Innodata India Pvt LTD.
07.2015 - 12.2015

NIC -E-Centric Solution Pvt LTD.
08.2012 - 06.2015

B. TECH - Bachelor of Technology

UTTAR PRADESH TECHNICAL UNIVERSITY

Similar Profiles

CREATE PROFILE
Deepak Mishra