Satish Sharma

Satish Sharma

Database Administrator - SQL Server

Followers of Satish Sharma184 followers
location of Satish SharmaCanada

Connect with Satish Sharma to Send Message

Connect

Connect with Satish Sharma to Send Message

Connect
  • Timeline

  • About me

    Director Business Transformation

  • Education

    • CSJM University

      -
      Bachelor of Arts (BA) English
    • National Institute of Information Technology

      2003 - 2006
      GNIIT Information Technology

      GNIIT (Software Development)

  • Experience

    • Wipro Infotech

      Oct 2005 - Apr 2007
      Database Administrator - SQL Server

      Client – Max Newyork Life Insurance, India• Taking care of 25+ production database servers, which are containing around 30 databases of all core business applications.• Replication (heterogeneous) between MS SQL and Oracle servers.• Representing the regular checklist and MIS for proactive planning for upcoming projects and work pressure.• Change requests on business databases and database servers with respect to upcoming projects, application upgrades and business requirements.Client – Hindustan Unilever Ltd., India• Implementation and Support of Client’s Core ERP application RSUnify.• Installation/configuration/support of application front end and SQL Server database on all sites.• Setting up remote site and sales men PDAs to follows the merge replication procedure.• Training the local staff on new ERP system.• Supporting the remote sites on-call for any issues or errors faced by them.• Troubleshooting and user feedback collection for regular update and enhancement of the application• Project involved extensive travelling and deadlines. Show less

    • HCL Comnet Systems and Services Limited

      Apr 2007 - Mar 2009
      Specialist Systems (SQL Server)

      Client - JPMorgan Chase, USA, former Bear Stearns• Managed 250+ MS SQL Servers 2005/2000 in a 24/7 high-transaction environment• Documentation and report generation• Acted as a Backup Track Lead, Interviewer and Technical Trainer• Imparted SQL Server trainings to trainees and other teamsClient – Misys, UK, Onsite• Responsible for all the MSSQL Servers during the Data Centre Migration and merger• Only DBA in the Data Centre Migration team• Documented Database Server Architecture• Planned and deployed Database servers’ migration and movement, their backups and failovers• Coordinated with application teams to study the impact of Database Servers’ movement on the various applications and customers Show less

    • Clifford Chance

      Apr 2009 - Jan 2014
      Senior Database Administrator - SQL Server

      • Responsible for knowledge transfer from on-site team to India Office (GSSC)• Set up a new team to support, function and manage 150+ SQL Servers for sophisticated and confidential legal environment spanning around the globe• Prepared management-level support and functional policies and documentation• Set-up, Manage and support SharePoint (Doc & Data Centric) database environment (approx. 14 Terabyte collectively) • Build, managed and supported Global DR sites for complete database environment• Regular consultation/meetings with development teams (for internally developed application and tools) and third party vendors for application support/performance related issues. Show less

    • College of Physicians and Surgeons of Ontario

      Mar 2014 - Oct 2021

      • Infrastructure Transformation Projects o Move from On-Prem to Azure Cloud-based infrastructure o Enterprise-level implementation of MS Dynamics 365 CRM o SharePoint Online for document management• Annual Renewal Projects (leading from 5 years) o The main source of revenue, generating approximately $62+ million yearly o Impacts 40000+ members (all Ontario Physicians and Surgeons)• Single Sign-On Project o Implementation of Azure Active Directory B2C for identity management o Consolidated all external facing systems in one platform o Custom built user impersonation tool between ADB2C and Dynamics CRM• CPSO – Ontario Health OneID/OneMail Project o secure link/gateway between CPSO Member Portal and Ontario Health’s OneID Portal o Completely revamped face-to-face, paper based manual process to fully automated online (zero paper) process• Website Projects (Content Management System: Kentico 9, 12, 13) o Multiple rounds of refreshes and rebranding o New corporate website in 2019 (https://www.cpso.on.ca) o New member portal (https://my.cpso.on.ca) o New tribunal website (http://opsdt.ca) (to be launched by Sep 2021) o AODA Compliance o Automated Stress/Load Testing (StresStimulus) o Focus group management o Usability Reviews• Learning Management System o New web-based solution (https://greatecare.cpso.on.ca) o Revamped QI program o Other educational offerings Show less

      • Project Manager

        Aug 2021 - Oct 2021
      • Manager - Core Systems

        Aug 2019 - Aug 2021
      • Project Manager

        May 2017 - Jul 2019
      • Database Administrator/Analyst

        Mar 2014 - Apr 2017
    • Centrilogic

      Oct 2021 - now
      • Director Business Transformation

        Aug 2024 - now
      • Senior Information Technology Project Manager

        Oct 2021 - Sept 2024
  • Licenses & Certifications

    • Prince 2: Foundation

      APMG-International
      Jan 2011
    • Microsoft Certified: Azure Fundamentals

      Microsoft
      May 2022
      View certificate certificate
    • Project Management Professional (PMP)®

      Project Management Institute
      Apr 2022
      View certificate certificate
    • MCSA: SQL Server 2012/2014 - Certified 2016

      Microsoft
      Jan 2014
      View certificate certificate