Subrat Mishra

Experience

• 

  KIIT - Kalinga Institute of Industrial Technology

  Aug 2008 - Jul 2011

  Programmer and Database Management

  • Installing and configuring SQL Server• Creating and Managing User.• Physical database design for SQL Server 2000• Creating and managing Stored procedure, trigger• Database backup and recovery• Performance monitoring, index tuning and troubleshooting.• Database restoration• Database Monitoring• Managing Hard disk Space Utilization • Up gradation of Database from SQL Server 2000 to 2005.• Implemented Alert Mechanisms for all Production Systems.

• 

  Anna University Chennai

  Aug 2011 - Jan 2012

  Project Associates and Database Management

  • Create and Manage Databases.• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.• Requested refreshes pre or post restore activities (e.g. data loads).• Performed database/infrastructure physical design, database upgrades & applied soft-ware patches to databases as per application/client requirements.• Up gradation of Database from SQL Server 2005 to 2008.• Estimated disk storage requirements for database software, database files & database administration needs.• Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, and User etc. and ensured the Availability of the Database Server in a 24X7 Environment.• Creating SSIS packages for ETL process.• Creating SSRS packages for Report generation.• Implemented Alert Mechanisms for all Production Systems• Managed security by defining roles and rights Show less

• 

  SUYOG COMPUTECH (P) LTD

  Jan 2012 - Nov 2013

  Database Administrator

  • Create and Manage Databases.• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.• Requested refreshes pre or post restore activities (e.g. data loads).• Conducted root cause and analysis for database incidents and problems.• Designing, testing and implementing an enterprise Disaster Recovery Plan.• Adhered to Change Control Procedures.• Developed & executed scripted changes requests in accordance with change control procedures.• Set up security and access profiles and procedures for database system administrators.• Set up Log Shipping, MSSQL Mail• Implementation of Database Mirroring in SQL Server 2008.• Creating SSIS packages for ETL process.• Implemented Alert Mechanisms for all Production Systems.• Performed database/infrastructure physical design, database upgrades & applied soft-ware patches to databases as per application/client requirements.• Up gradation of Database from SQL Server 2005 to 2008.• Estimated disk storage requirements for database software, database files & database administration needs.• Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, and User etc. and ensured the Availability of the Database Server in a 24X7 Environment.• Managed security by defining roles and rights.• Proven ability to handle Database of more than 500 GB in Size. Show less

• 

  Tech Mahindra

  Dec 2013 - May 2014

  SQL DBA

  Database server health checkup.Database performance monitoring.Solving Database blocking and root cause for it.Database Index Tuning.Analyzing database root blocking issueDatabase backup and archival planing.Database growth monitoring.Server installation and configuration.Database properties setup.Database Migration.Database service broker.Database Server setup on Amazon EC2 and RDS environment.SQL Server authentication and authorization management.Planing for weekly and monthly maintenance for Database Server.Providing Database Server Clustering for data High Availability.Meet the SLA (Service Level Agreement) established.Day-to-day administration of live SQL Servers.Using DBCC commands and DMV queries to troubleshoot issues related for database consistency. Show less

• 

  HCLTech

  May 2014 - Jan 2020

  Associate Consultant

  Database Clustering.Database Replication.Database Mirroring.Database Log Shipping.2012 FCI.Always On.UCP.Symantec NetBackup.M360PPMCService NOWDMVSecure DMZ Server.SQL Server 2000.Issue troubleshooting and RCA for it.SCOM Tool

• 

  IBM

  Feb 2020 - Aug 2021

  Subject Matter Expert

  SME - SQL Server Technology.

• 

  Kyndryl India

  Sept 2021 - May 2023

  Subject Matter Expert

  Lead II SQL Server Database Administrator

• 

  HCLTech

  May 2023 - now

  Consultant

  Manage client database requirements and provide solutions for that.