Soumalya Chatterjee
Willoughby,OH
Summary
My key area of experience has been with Oracle Database Server Administration (Oracle DBA), Oracle Applications 11i/R12/19C Administration (Oracle Apps DBA), Oracle Fusion Middleware Administration and Oracle Cloud Administrator with Solution Architect as designation. Currently working as Senior Solution Architect in EBS 12c to 19C upgrade project, Senior Oracle Apps DBA Support for EBS R12 and OCI Cloud Admin supporting the infrastructure
Overview
18
18
years of professional experience
1
1
Certification
Work History
Lead Oracle Apps DBA , Oracle Cloud Admin
Avery Dennison Inc.
06.2023 - Current
- Worked as SRE for support of Weblogic hosted infrastructures like OBIEE/BI Publisher,SOA12c
- Responsible for Production support for 12c and 19c databases
- Solution Architect as Lead Oracle Apps DBA
- Extensive experience solving complex database query performance issues.
- Passion for solving complex application related database performance issues
- Deep understanding of partitioning, query execution plan optimization, table/data structure.
- Support for OTM and Demantra
- Support for other business critical products like Apro,Ariba,OneSource,Endeca,More4Apps,Primas,DFM.
- Performance tuning for long running queries/concurrent programs and providing solutions and Recommendations
- Vulnerability remediation and auditing for SOX compliance
- Manual deployments
- Database Quarterly Patching and weekend cloning
- Centralized monitoring for database hosted applications
- Weblogic scripting for automation
- Proactive OEM Monitoring
- Day to day support and on time resolutions and Servicenow Ticket Handling
- SR support and weekend critical on call support
- Documentations and agile methodology
Oracle Fusion Middleware Administration / Oracle Apps DBA
Experian
11.2022 - 04.2023
- Worked as SRE for support of Weblogic hosted infrastructures like OBIEE/BI Publisher
- Responsible for upgrade for 12c to 19c database
- Oracle Multitenant Container Database (CDB) and Pluggable Database (PDB) experience.
- Oracle RAC experience
- Advanced understanding of Oracle DataGuard/GoldenGate.
- SSO setup for EBS environments post upgrade
- Vulnerability remediation
- Manual deployments and worked on Jira for weekend deployments and support
- Database Quarterly Patching
- Centralized monitoring for database hosted applications
- Weblogic scripting for automation
- Day to day support and on time resolutions
- SR support and weekend critical on call support
- Documentations and agile methodology
Oracle Fusion Middleware Administration / AWS Admin
Equifax Inc
01.2020 - 11.2022
- Worked as SRE for support of Weblogic hosted infrastructures like OBIEE/BI Publisher/C2O/EDQ/CSRT
- Responsible for DR setups for AWS hosted weblogic applications
- Responsible for High Availability setups for AWS hosted weblogic applications
- PSU apply for AWS hosted applications like OBIEE/BI Publisher/C2O/EDQ/CSRT
- SSO setup for BIP environments
- Vulnerability remediation
- Manual deployments and automated deployments using Jenkins
- Automation of Patching using Ansible
- Grafana setup for centralized monitoring for MW hosted AWS platforms
- Prometheus setup for server monitoring using node exported / URL monitoring using Blackbox exporter/ weblogic means using weblogic exporter
- Weblogic scripting for automation
- Day to day support and on time resolutions
- SR support and weekend critical on call support
- Documentations and agile methodology
- Other than worked as DBA role (support/development) and Weblogic Administrator for multiple client’s like
Senior Oracle Apps DBA
Jacobs
08.2017 - 12.2019
- Database version: 12C
- Client Location : Texas , USA
Oracle Fusion Middleware Administration
Tata McGrawHill Education
11.2016 - 08.2017
- Database version: 12C
- Client Location : Columbus , USA
Oracle EBS 12.2.0.4
TFG
06.2016 - 11.2016
- Database version: 12C
- Client Location : Johannesburg , South Africa
Oracle Fusion Middleware Administration
Sembcorp Marine Ltd.
04.2015 - 06.2016
- Database version: 12C
- Client Location : Tuas , Singapore
Oracle Fusion Applications Admin
Toronto Dominion Bank
05.2014 - 03.2015
- Database version: 12C
- Client Location : Toronto , Canada
Oracle Projects DBA and Performance Tuning
Walgreen CO.
11.2013 - 04.2014
- Database version: 12C
- Client Location : Deerfield , IL , USA
Oracle Projects DBA
EQUIFAX Inc.
01.2013 - 10.2013
- Database version: 9i,11g,12C
- Client Location : Alpharetta , Georgia,USA
Oracle Projects DBA
APP – HOWMET
03.2011 - 12.2012
- Database version: 11g
- Client Location : Muskegon , Michigan , USA
Oracle APPS DBA
AEES Divestiture Group
08.2010 - 02.2011
- Database version: 9i, 10g.
- ERP Version: 11.5.10, 11.5.10.2.
- Client Location : Pittsburgh , Pennsylvania,USA
Oracle Applications DBA
Aluminium Company of America (ALCOA)
07.2008 - 07.2010
- Client Name Aluminium Company of America
- Position Oracle Applications DBA
Education
MBA - Marketing Management
IISWBM
Kolkata05-2020
Bachelor of Science - Computer Engineering
WBUT
Kolkata05-2007
Skills
- Hands-on experience developing and operating services on a public cloud platform (Examples: AWS, Oracle) and Experience with Linux, AIX,Sun-Solaris ,Unix, and/or Microsoft related platforms
- Extensive experience with Oracle Database and Exadata
- Understanding of distributed computing and cloud-based platforms
- Experience and understanding of cloud infrastructure services, regions, and multi-AD designs
- Database Design and Architecture:
- Design, implement, and maintain highly available and scalable database architectures
- Collaborate with software developers and system architects to optimize database design for application performance
- Performance Tuning and Optimization:
- Conduct regular performance monitoring and tuning of databases to ensure optimal efficiency
- Proactively identify and address performance bottlenecks and system issues
- Data Security and Compliance:
- Implement and enforce security measures to safeguard sensitive data
- Ensure compliance with data protection regulations and industry best practices
- Backup and Recovery:
- Develop and maintain robust backup and recovery strategies to protect against data loss and minimize downtimeConduct regular testing of backup and recovery procedures
- Application Support and Installation:
- Troubleshoot day to day application issuesSupport installation of new or legacy applications
- Monitoring and Maintenance:
- Establish and maintain database monitoring systems to proactively identify and address issues
- Perform regular maintenance tasks, such as patching and updates, to keep databases running smoothly
- Capacity Planning:
- Monitor and analyze database growth trends to plan for future capacity needsMake recommendations for hardware and software upgrades as necessary
- Deep understanding in tools like SQLdeveloper,TOAD,Github,Jenkins,Flexdeploy,ServiceNow,Kintana,Mercury,Splunk,HP Openview, OEM,Grafana,Zabbix,Dynatrace,Agile Methodology tools like Jira
- Manages database instances, including monitoring performance, tuning, and optimizing
- Performs database backups, restores, and recovery operations
- Analyzes and optimizes query performance and database resources
- Monitors and manages database access, permissions, and roles
- Implements database indexing, partitioning, and other performance-enhancing techniques
- Develops and maintains automation scripts for database management tasks
- Utilizes tools and frameworks to automate database deployments and configuration management
- Provides advanced troubleshooting ,support for database-related issues and building high available resilient data layer platforms
- Collaborates with IT and development teams to resolve complex technical problems
- Maintains comprehensive documentation of database configurations, processes, and procedures
- Collaboration and Communication:
- Collaborate with cross-functional teams to understand and address database-related requirementsCommunicate effectively with technical and non-technical stakeholders
- Documentation:
- Maintain comprehensive documentation of database configurations, processes, and procedures
- Develop and update disaster recovery plans
- Mentorship and Leadership:
- Provide technical leadership and mentorship to junior members of the database administration team Stay current with industry trends and share knowledge with the team
- Experience supporting the following technologies: OAM, OID, Oracle RAC, ASM, Weblogic on Linux/UNIX
- Experience supporting the following applications: Hyperion Financial Suite, OBIEE/OBIA, Kofax for Accounts Payable
Accomplishments
Certifications -
Oracle Cloud Foundations Architect -OCI (January 2022)
Oracle Cloud Architect Associate - OCI (March 2022)
Oracle Fusion Cloud Applications ERP Process Essentials Certified - Oracle Fusion ERP (Sept 2025)
Oracle Cloud Infra 2025 AI Foundation Associate -OCI Cloud AI (Dec 2025)
Certification
Oracle Cloud Foundations Architect
Oracle Cloud Architect Associate
Oracle Fusion Cloud Applications ERP Process Essentials
Oracle Fusion ERP
Oracle Cloud Infra 2025 AI Foundation Associate
Languages
English
Full Professional
Timeline
Lead Oracle Apps DBA , Oracle Cloud Admin
Avery Dennison Inc.
06.2023 - Current
Oracle Fusion Middleware Administration / Oracle Apps DBA
Experian
11.2022 - 04.2023
Oracle Fusion Middleware Administration / AWS Admin
Equifax Inc
01.2020 - 11.2022
Senior Oracle Apps DBA
Jacobs
08.2017 - 12.2019
Oracle Fusion Middleware Administration
Tata McGrawHill Education
11.2016 - 08.2017
Oracle EBS 12.2.0.4
TFG
06.2016 - 11.2016
Oracle Fusion Middleware Administration
Sembcorp Marine Ltd.
04.2015 - 06.2016
Oracle Fusion Applications Admin
Toronto Dominion Bank
05.2014 - 03.2015
Oracle Projects DBA and Performance Tuning
Walgreen CO.
11.2013 - 04.2014
Oracle Projects DBA
EQUIFAX Inc.
01.2013 - 10.2013
Oracle Projects DBA
APP – HOWMET
03.2011 - 12.2012
Oracle APPS DBA
AEES Divestiture Group
08.2010 - 02.2011
Oracle Applications DBA
Aluminium Company of America (ALCOA)
07.2008 - 07.2010
MBA - Marketing Management
IISWBM
Bachelor of Science - Computer Engineering
WBUT
On the Spot Award , Team Lead Award
1. On the Spot Award - 2022 / 2023
2. Best Team Award - 2020
3. Smileys Award - 2024
4. Multiple Accolades and Appreciations as received on my diverse career
Adding one of the mail reference which I received after a successful implementation in USA from Business Unit Manager from ALCOA
On Wed, Jan 2, 2013 at 12:13 PM, Helal, Philip M. (Cleveland) <Philip.Helal@alcoa.com> wrote:
Soumalya,
I sincerely appreciate all the good work that you did for APP, and wish you all the best in the future. The project could not have been the success that it is without your help.
Best Regards,
Phil
Office: 216-641-4073
Mobile: 216-577-4785