Subrata Kumar Roy

Subrata Kumar Roy

Programmer

Followers of Subrata Kumar Roy118 followers
location of Subrata Kumar RoyHyderabad, Telangana, India

Connect with Subrata Kumar Roy to Send Message

Connect

Connect with Subrata Kumar Roy to Send Message

Connect
  • Timeline

  • About me

    IT Service Delivery Manager SDM

  • Education

    • Jadavpur University

      1995 - 1998
      MCA Computer Science
    • Visva-Bharati

      1992 - 1995
      B. Sc Mathematics
  • Experience

    • Rites Limited - Government Of India Enterprise

      Nov 1999 - Dec 2002
      Programmer

      Project Study, Analysis, prepare SRS, Database Design, Database creation, storage plan, security plan, Backup recovery plan and Implementation. Finally handed over to Client Database Administrator• Worked for Indian Railways• Eastern Coalfields Lts, India• Tripura Govt• RE College Durgapur, India

    • IBM Global Business Services

      Dec 2002 - Feb 2003
      System Consulatant

      Working for Nestle GlobeTo Build a data warehouse using Informatica

    • State Bank of India

      Mar 2003 - Sept 2006
      Asst. Manager (Systems)

       Closely work with Computer Policy and Planning Department which plays a major role to bank computerisation of whole State Bank group Installation of Oracle on Windows and UNIX platforms for Branch Migration in core banking Work with various technology service provider like Networking, Application, Security, Hardware, Operating system Maintain OLAP System for Analytical report for strategical decision of Banking Business and RBI regulatory. Establish Backup Policy (RMAN, Hot backup, Export/Import), Stand by Database Maintenance Show less

    • Ford Motor Company

      Oct 2006 - Sept 2007
      Dy. Manager (DBA)

      DBA Team Lead to support of ORACLE and MS-SQL databases for Ford-Britain, Ford-Germany, Jaguar and Land-Rover.

    • HP

      Oct 2007 - Jun 2009
      Sr. System Engineer

      Infrastructure Management Service/L3 Database support, Problem management, resolve escalated incident, Root cause Analysis. 24x7 database support. Single instance/RAC, on UNIX, Windows

    • IBM Global Services

      Jun 2009 - Jun 2011
      Advisory Technical service Professional

      Performing Oracle Database Administration SME Role for Astrazeneca account which is having RAC, Dataguard, Fail-over cluster, Streams• First point of contact for Advisory Technical service• Handling escalated issues• Technical help team on various critical issue• Take ownership of critical restore, recovery, rebuild• Provide action plan on Disaster recovery• Perform Disaster Test• Problem Management, Root Cause Analysis• Advisory service with action plan on critical task• RAC, Standby Database configuration, Trouble shooting• Recommendation/Solution providing on various customer requirements• Disaster recovery/High availability Architecture Solution Show less

    • IBM Canada Ltd.

      Jul 2011 - Nov 2012
      Database Administrator

      Worked for our client Canadian Pacific Railway.Involved with some new building project works with Oracle database.

    • IBM Global Process Services

      Dec 2012 - Jul 2015
      Oracle DBA (SME)

      Oracle Database Administrator consultant Working for DuPontSupport Transition; Data Centre migration; DR setup and Exercise; Production support war room

    • Novartis

      Jul 2015 - now
      Service Delivery Manager
  • Licenses & Certifications

    • Oracle 11g Administration

      Oracle
      Aug 2010
    • ITIL Foundation

      EXIN
      May 2008
    • HP-UX 11.3 administration

      HP
      Apr 2008
    • JAIIB

      IIBF
      Aug 2006
    • Computer Networking

      NIBM Pune
      May 2006