Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Hobbies
Timeline
Generic
Soumya Guha Roy

Soumya Guha Roy

Senior Oracle Applications DBA
Kolkata

Summary

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

17
17
years of professional experience
4
4
years of post-secondary education
2
2
Certifications

Work History

Senior Oracle APPS DBA

Rackspace technology
10.2012 - Current
  • Managed time efficiently in order to complete all tasks within deadlines.
  • Used critical thinking to break down problems, evaluate solutions and make decisions
  • Self-motivated, with strong sense of personal responsibility.
  • Efficiently manage Production environment for 26 clients
  • Upgraded databases from 11.2.0.3 to 19.16.
  • Upgrade eBS from 12.1.3 to 12.2.10
  • Cloning activities are done by single to single node and multi-node to single node using rapid clone process.
  • Interacting with users and functional team for resolving issues.
  • Applying patches for fixes and issues.
  • User account management, creating users, disabling users, responsibility management (adding & retiring responsibilities).
  • Used adadmin to generate jar files, and forms & compiling the invalid objects, validating Apps Schema and relinking executables, and also, used f60gen to generate and compile forms.
  • Applied patches using maintenance mode & hot patch option.
  • DBlinks creation from one instance to other instances.
  • Create and maintain Standby Database using DG Broker
  • Perform yearly DR test.

Azure Team Lead

Rackspace Technology
01.2021 - Current
  • Creating POC for pre-sales team.
  • Create Recovery Site on Aure using ASR.
  • Maintain incremental recovery from On-prem to Azure recovery Site.
  • Create and maintain snapshot of recovery Site for fallback option.
  • Create Oracle Standby Dataguard on Azure for 19c on-prem database.
  • Perform actual cutover of database during go-live

Principal Consultant

IBM India Pvt. Ltd
01.2010 - 09.2012
  • Upgraded the databases from 11.2.0.3 to 19.16
  • Upgrade eBS from 12.1.3 to 12.2.10
  • Interacting with the users and functional team for resolving the issues.
  • Creating the Application users and assigning the responsibility with the approval of reporting managers.
  • Applying patches for fixes and issues.
  • Worked on OEM and Monitoring alerts.
  • Used Adadmin to generate jar files, and forms & compiling the invalid objects, validating Apps.
  • Create and maintain Standby Database using DG Broker




Oracle Apps DBA

TCS
10.2006 - 07.2010
  • Cloning activities are done by single to a single node and multi-node to the single node using a rapid clone process.
  • Applying patches for fixes and issues.
  • Patch analysis and troubleshooting & Setup of RMAN for backups.
  • 24X7 Production support.
  • Configuring various jobs for regular activities through crontab.
  • Monitoring Users and Concurrent managers by using ‘sys admin’ from the front end. User account management, creating users, disabling users, responsibility management (adding & retiring responsibilities).
  • Performing Code move for development team

Education

B. Tech - Civil Engineering

Jalpaiguri Govt. Engineering College
Jalpaiguri
04.2002 - 05.2006

Skills

E-Business Suite : Oracle EBS 11i & R12/R12210undefined

Accomplishments

  • Certifications:
  • Oracle Could Foundation 1Z0-1085-20
  • Microsoft Azure Foundation – AZ900

Certification

Az-900 - Microsoft Azure Fundamentals

Hobbies

I am passionate musician. I do compose music, sing, record, mix, and master them and release on spotify.

Apart  from that, I also have interests in photography, and video editing.

Timeline

Az-900 - Microsoft Azure Fundamentals

05-2021

Azure Team Lead

Rackspace Technology
01.2021 - Current

1Z0-1085-20 - Oracle Cloud Infrastructure Foundation Associate

01-2020

Senior Oracle APPS DBA

Rackspace technology
10.2012 - Current

Principal Consultant

IBM India Pvt. Ltd
01.2010 - 09.2012

Oracle Apps DBA

TCS
10.2006 - 07.2010

B. Tech - Civil Engineering

Jalpaiguri Govt. Engineering College
04.2002 - 05.2006

Similar Profiles

CREATE PROFILE
Soumya Guha RoySenior Oracle Applications DBA