Subrata Kumar Roy

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