Subrat Mishra

Subrat Mishra

Programmer and Database Management

Followers of Subrat Mishra915 followers
location of Subrat MishraDelhi, India

Connect with Subrat Mishra to Send Message

Connect

Connect with Subrat Mishra to Send Message

Connect
  • Timeline

  • About me

    Working as a Consultant in DBMS

  • Education

    • KIIT University

      2009 - 2011
      Master of Technology (M.Tech.) Computer Science and Engineering First Class

      M.Tech in Computer Science and Engineering

    • Bhadrak College, Bhadrak, Odisha

      2001 - 2004
      Bachelor's degree(Science) Chemistry First class with Distinction

      Bachelor of Science

    • Indira Gandhi National Open University

      2007 - 2009
      Master of Computer Applications (MCA) Computer Science and Application First class

      Master in Computer Application

  • 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.

  • Licenses & Certifications

    • Microsoft Certified: Azure Data Fundamentals

      Microsoft
      Aug 2022
      View certificate certificate
    • Microsoft Certified: Azure Database Administrator Associate

      Microsoft
      Oct 2022
      View certificate certificate
  • Honors & Awards

    • Awarded to Subrat Mishra
      Extramile In Client Delivery IBM Jun 2021
    • Awarded to Subrat Mishra
      Outstanding Appreciation IBM Jun 2021