Sagnik Sarkar
Oracle Apps DBA Architect And Solutioning With Fusion Admin
Kolkata,West Bengal
Summary
- A Qualified Bachelor of Technology (Computer Science & Engineering) professional offering more than 14 years of experience (which includes 1.6 years of Onsite,USA experience) in Oracle DBA/Oracle Applications DBA, Fusion Middle Ware Admin with extensive knowledge in DBA Architecture, Implementation and Upgrade Projects.
- Extensive experience with analysis, design, development, customizations and implementation of software applications including ERP applications.
- Good interpersonal, communication and organizational skills with proven abilities in team management, vendor/customer relationship management and planning.
- Well equipped with the knowledge & expertise across various industries and have supported projects for industries like Chemical & Petroleum, Medical/Hospital, Manufacturing, Paints and Telecommunication industry etc.
- Have been nominated and received special retention bonus from my current employer(given only to selected list of employees) for the skills and services delivered for the clients. My everyday work is dedicated to client success and understanding and solving client solutions.
- I have a Valid stamped H1B.
Overview
15
15
years of professional experience
4
4
years of post-secondary education
8
8
Certifications
Work History
Oracle Application & Fusion Middle Ware DBA
IBM India Pvt Ltd, World Fuel Services Client
Kolkata
04.2019 - Current
- Production Support & Maintenance of Oracle Applications 11i&12.2 and Oracle Fusion Middleware with Oracle database 19c on Linux and Solaris.
- Involved in migration and architecting of 11g to 19c database
- Assisting,fixing and automating DBA stuffs using shell script for the benefit of client.
- Also working in AWS cloud migration for all the On-premise servers, design and setting up data flows through AWS DMS and Attunity, guiding and leading the offshore DBA team to the successful closure of different projects for client.
- Automating the 19c refresh process with no manual intervention. Understanding and Communicating with Onsite/client about the requirement and guiding my offshore team for timely delivery is an important aspect of my client success.
Oracle Apps DBA
IBM India Pvt Ltd, L'oreal Client USA
Kolkata
11.2018 - 03.2019
- Responsible to maintain all the Production and Non-Production databases that are integrating with SAP as the Application
- Database performance related issues, tablespace shrinking, Database reorg activities and other DB performance tuning. Helping AMS team with suitable database queries to fetch reports, maintaining Database performance and install/upgrade of Databases.
Oracle APPS DBA
IBM India Pvt Ltd, Stryker Medical Corporation Client
Kolkata
04.2016 - 02.2019
- Oracle EBS support (both 11i/R12) with Oracle database support of 9i/10g/11g, Weblogic 11g, OBIEE managing WebLogic Managed and Admin nodes along with Node manager, OEM 12c administration, patching, production support, cloning.
- Taking part and leading the Monthly/Quarterly/Yearly Change and maintenance of all the production servers during weekend.
- Automation using shell scripting through cronjobs. Interacting with developers from other team for technical assistance and Interacting with Oracle on SRs and solving Priority 1 issues.
Oracle Apps and SOA DBA
IBM India Pvt Ltd, Acco Brands Client
Chicago
11.2014 - 03.2016
- Worked as the Onsite DBA lead planning and executing various DBA tasks and fixing issues for the client.
- Along with Apps DBA worked as an WebLogic Administrator in SOA servers, providing support to the Managed and Admin nodes issues and supporting the Developers to deploy SOA composites.
- Database replication using RMAN full backup (Cloning), Created tablespaces, users,roles and schema objects . Coordination with Oracle Support for fixing the Application and Database related problems.
- Supporting OTM 5.6 systems. Leading the team from offshore for the monthly outage activities related to SOX password change or outage related to EBS PROD or SOA PROD maintenance.
- Resolve issues raised by end users and arranging meetings with Internal team members and client members during severe P1 issues and helping the client to solve those P1 issues with proper RCA documented and maintained. Have received kudos many time from client for my dedication to user/client needs and for my availability to any project specific issues/needs.
Oracle Advanced Pricing/APPS DBA
IBM India Pvt Ltd, FOTL/Safaricom/Coopervision Clients
Kolkata
12.2013 - 10.2014
- Worked as an Oracle Apps DBA in R12 implementation Managing,maintenance and troubleshooting of Oracle Application using Oracle E-Business suite R12.
- Had been involved in the CVI project for the OAP implementation division over EBS. As an Oracle Apps DBA involved in implementing Oracle Advanced Pricing(OAP) module in fresh EBS 12.2.0 installation and upgrading it to R12.2.3. Worked in full development to Production life cycle for the R12.2.3 project implementation.
- Guiding and solutioning for the R12.2 implementation requirement through out.
Oracle IDM Administrator
IBM India Pvt Ltd, NetApp Client
Kolkata
11.2011 - 11.2013
- Maintaining and supporting OIM web Console as an IDM Administrator. Fixing user’s request like Provisioning, Password problems(changing or resetting it etc), troubleshooting for any issues in Provisioning any resource(like AD,SAP,VPN,etc). Supporting the LDAP Directory, both Enterprise LDAP and SSO LDAP. Various LDAP queries to know and find the user’s attributes.
- Contributing in ASCP & AID documents related to OIM,OAM and made document repository of all the daily works/issues in IDM track which is been used later for knowledge transfer and KT for the new members joining in the IDM track.
- Doing release activities in OIM Prod on a monthly basis, Ownership of the OIM Prod servers(Bouncing or troubleshooting for any errors in the logs).
Systems Engineer
TCS
Kolkata
12.2008 - 11.2011
- Management of oracle Instance, physical structure of the database like data files, redo log files, control files (mirroring of the control file), Storage management, Distribution of disk I/O, Sizing of tables and indexes.
- Maintaining RAC database. RAC to RAC, RAC to Non-RAC cloning.
- Using of various tools like export/import, Kintana, and ticketing system like remedy, jira etc for my everyday activities.
- Database replication using snapshots (Cloning), Created tablespaces, users, roles and schema objects. Coordination with Oracle Support for fixing the Application and Database related problems.
- Backup utilities using RMAN
Education
Bachelor’s in Computer Science & Engineering - Computer Engineering
West Bengal University of Technology (WBUT)
West Bengal, India 04.2004 - 03.2008
Skills
Oracle Application DBA Architect
undefinedCertification
Certificate Training for Oracle Enterprise Manager Cloud Control 12c
References
Available upon request
Accomplishments
Certifications :
- Completed AWS Cloud Practitioner CLF-C01 exam 2021
- Completed AWS Certified Solutions Architect – Associate SAA-C02 exam 2021
- Completed Oracle Cloud Infrastructure Architect 2018 Associate certificate (1Z0-932)
- Oracle Cloud Data Management 2023 Foundations Associate
- Oracle Cloud Infrastructure 2023 Foundations Associate (1Z0-1085)
- Completed Oracle Autonomous Database Cloud Specialist (1Z0-931)
Have received special retention bonus in 2021 from my current employer for my dedication to my clients.
Timeline
Oracle Application & Fusion Middle Ware DBA
IBM India Pvt Ltd, World Fuel Services Client
04.2019 - Current
Oracle Apps DBA
IBM India Pvt Ltd, L'oreal Client USA
11.2018 - 03.2019
Oracle APPS DBA
IBM India Pvt Ltd, Stryker Medical Corporation Client
04.2016 - 02.2019
Oracle Apps and SOA DBA
IBM India Pvt Ltd, Acco Brands Client
11.2014 - 03.2016
Oracle Advanced Pricing/APPS DBA
IBM India Pvt Ltd, FOTL/Safaricom/Coopervision Clients
12.2013 - 10.2014
Oracle IDM Administrator
IBM India Pvt Ltd, NetApp Client
11.2011 - 11.2013
Systems Engineer
TCS
12.2008 - 11.2011
Bachelor’s in Computer Science & Engineering - Computer Engineering
West Bengal University of Technology (WBUT)
04.2004 - 03.2008
Certificate Training for Oracle Enterprise Manager Cloud Control 12c
Training for Oracle Identity Management 11g
Completed AWS Cloud Practitioner CLF-C01 exam 2021
Completed AWS Certified Solutions Architect – Associate SAA-C02 exam 2021
Completed Oracle Cloud Infrastructure Architect 2018 Associate certificate (1Z0-932)
Oracle Cloud Data Management 2023 Foundations Associate
Oracle Cloud Infrastructure 2023 Foundations Associate (1Z0-1085)
Completed Oracle Autonomous Database Cloud Specialist (1Z0-931)
Similar Profiles
MUKESH KUMARMUKESH KUMAR
Automation Lead at Kyndryl Solutions Pvt. Ltd, IBM India Pvt. Ltd, Client: Airtel IndiaAutomation Lead at Kyndryl Solutions Pvt. Ltd, IBM India Pvt. Ltd, Client: Airtel India
Ranjitkumar SalianRanjitkumar Salian
Senior Portfolio Manager at IBM India Pvt. Ltd. (Client: USAA)Senior Portfolio Manager at IBM India Pvt. Ltd. (Client: USAA)
Seena MenonSeena Menon
Controller at Acentra Health Software India Pvt Ltd ( Formerly Client Network Services India Pvt Ltd)Controller at Acentra Health Software India Pvt Ltd ( Formerly Client Network Services India Pvt Ltd)