Resume

Manager Oracle

Location:

Charlotte, NC

Posted:

October 26, 2020

Contact this candidate

Resume:

TARIT KUMAR MONDAL

Oracle DBA, Oracle Apps DBA, Middleware Administrator

Email: adhbfb@r.postjobfree.com

Cell: +1-414-***-****

PROFESSIONAL SUMMARY

IT Experience Summary

Having 10+ Years of experience as an Oracle DBA, Oracle Apps DBA and Middleware Administrator, experienced in handling Production and Non-Production Databases. Have worked for multiple clients managing their Oracle databases and EBS Application and Databases. I have been involved with multiple upgrade projects and platform migration projects. I have excellent analytical, interpersonal, communicational and organizational skills aimed at achieving project milestones. I have good knowledge on Oracle Cloud Infrastructure and certified with few Cloud certification like OCI Cloud Architect Associate from Oracle.

My role as an Application & Database Administrator is to install and upgrade oracle applications and database along with third party applications. I have worked and gained expertise in below software’s and Technologies.

Oracle Cloud Infrastructure Autonomous database

Oracle Cloud Infrastructure networking like VCN, gateways, route tables.

Oracle Cloud Infrastructure Storage Services like object storage, Block/Boot Volume.

Oracle Cloud Infrastructure Identity and Access Management

Oracle Database 10g, 11g, 12c.

Oracle RAC Custer.

Oracle EXADATA

Oracle SQL Tunning

Oracle Database Tunning

Memory Tunning

CPU Tunning

Filesystem, storage I/O Tunning

Networking details

Linux Red Hat Operating System

RMAN (Database Recovery Manager Utility).

Oracle Datagaurd

Oracle Golden Gate

Oracle EBS 11i & R12.

AD Utilities (ADADMIN, ADPATCH, ADMRGPCH, ADCTRL, ADIDENT)

Oracle WebLogic.

SOA 11g

Repository Creation Utility (RCU).

Oracle Enterprise Manager 12C

OBIEE Administration

Apache Tomcat.

Oracle Discoverer.

BMC Remedy Tool.

HP-Quality Center.

HP-Kintana (Code deployment tool).

HUDSON (Code deployment tool).

SVN (Code repository tool).

CONTROL M JOB SCHEDULER

Relevant Oracle DBA Experience Summary:

10 Years of Experiencing in Oracle Database Administrating, Database tunning, SQL Tunning, CPU, memory, I/O tunning, Networking details like protocols, DNS, routing table, Linux OS operating system.

10 Years experienced and proficient in technologies like EBS R12, EBS 11i, RDBMS 10g/11g, RAC, ASM, RMAN, Database and Application Installation, Upgrades and Enterprise Manager (EM) Grid Control 11g, Cloud Control 12C/13C EM.

4 Years experienced with Oracle 12c Database.

5 Years experienced working with EXADATA environment and worked with EXADATA wait event performance issue in Oracle Database.

Experienced with analysis and resolving of issues in EXADATA machines from Linux server side like high load, High CPU utilization, High Memory Utilization.

Experienced with Oracle Quarterly CPU patching in EXADATA environment.

Experienced with WebLogic Installation and Administration, Middleware installation and support like OBIEE, SOA, OTM.

Have exposure in a variety of environments like Windows XP, HP-UX Itanium, HP-UX PARISC, Red-hat Enterprise Linux

Successfully implemented migration of Databases and Applications across data centres.

Performed instance migration across platforms and DB upgrade from 10.2 to 11gR2

Experienced in RAC Administration (11gR2) with ASM storage and backup and recovery using RMAN.

Proficient in applying Oracle Application patches, Database patches, Upgrades, Apps cloning and Oracle Apps SYSADMIN functionalities.

Proactive Monitoring to identify areas that needs to be modified to improve performance in the application and database using OEM 11g/12C Monitoring.

Performed database and application cloning from production to development environment and resolved various issue encountered during cloning.

Experienced in Oracle E-Business Suite implementations and Upgrades from CRP, Development and UAT to production as an Oracle Applications DBA.

Involved in installation of R12 E-Business suite and upgrading to R12.1.3.

Involved in upgrading of 11.5.10.2 to R12.0.3 oracle instance.

Performed instance build for Oracle Database in RAC.

Experience in setting up HTTP Load balancing and implementing Shared APPL_TOP and PCP.

Expertise in troubleshooting Workflow and Notification Issues.

Successfully implemented Oracle 10g, 11g Data Guard on HP-UX and Linux environment.

Experienced with data pump, export and import utilities in backup and recovery of database.

Expertise in implementing OATM.

Involved in Daily monitoring of mission critical Production and Development System, which includes application, as well as database monitoring.

Managed multiple production databases on 10g and 11g.

Writing shell script for automation of DB RMAN backup and cloning of Oracle Databases and Applications.

Tuning the databases for optimal performance and monitoring CPU performance.

Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures.

24x7 DBA support for multiple production, test, and development environments.

Ability to build professional relationships and capable of multi-tasking for various projects and prioritizing the work.

Mentoring the junior team members and making them well equipped about the processes followed and technologies involved.

SKILL SET

Databases: Oracle 11g/10g/12c

Languages: SQL and PL/SQL

Application Servers: Oracle Application Server (10g & 11g), Apache, WebLogic

Applications: EBS 11i/R12, OEM 11g, 12c, 13c

High Availability: (RAC) Cluster ware 11g and 10g

Operating Systems: HP-UX Itanium, HP-UX PARISC, Red-hat Enterprise Linux, Windows XP

Tools: SQL*Plus, SQL*Loader, Export & Import utility (regular and data pump), OEM, ASMCMD, FNDLOAD, DBUA, DBCA, SQL trace, tkprof, RMAN, TSM TDPO, BMC Remedy, SVN, Hudson, Import/Export, TOAD,SQL Developer, SQL*Loader, OEM, Putty, WinSCP, Kintana, Control M, Splash BI

Programming Languages: SQL, PL/SQL, UNIX Shell Scripts

EDUCATIONAL QUALIFICATION

Bachelor of Engineering in Electronics and Communication Engineering from West Bengal University of Technology, West Bengal, India

PROFESSIONAL EXPERIENCE

Client: American Tire Distributers. Charlotte, NC Dec 2016 – Present

Role: Oracle Applications Database Administrator, Oracle DBA, Middleware Admin

Employer: Cognizant Technology Solutions

Project Summary:

As the nation's largest tire distributor, ATD offers the products, programs and services to ensure that ATD customers, manufacturers and partners have every advantage in building the success of their business.

Tire dealers and retailers depend on ATD for 24/7 access to the industry's broadest and deepest inventory at competitive prices. ATD's coast-to-coast distribution network supports approximately 70,000 customers across the U.S. and Canada to provide rapid and frequent delivery of tires, custom wheels and shop supplies.

By choosing ATD as a distribution partner and benefitting from a wide range of innovative programs and services, customers are equipped with everything they need to move ahead of the competition.

Responsibilities:

Patching coordinator for all Critical patch update and application patch

Regular Support for all production and non-production environment

Point out the key risk and enhancement for betterment of infrastructure.

Working on internal project and support them as database administrator.

Planning and administering backup and recovery strategies.

Maintained and provided PROD support for EBS Application and Database.

Maintained and provided PROD support for Oracle Fusion Middleware SOA services.

Performing SYSADMIN activities like user maintenance and setting up profiles.

Monitoring of Concurrent Managers and troubleshooting long-running concurrent programs.

Providing DBA support during month end activities.

Automation of DBA monitoring activities like purging older archive logs, concurrent manager log/out files, Gather schema statistics.

Maintaining Databases including backups, restores, recoveries, imports, exports.

Set up and administer tablespaces, data files, tables, indexes, views, sequences, synonyms and DB links.

Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.

Perform weekly cloning activities of non-prod instances, both application and database.

Responding to different types of alerts automation using oracle alerts.

Configured Workflow Notification Mailer for inbound and outbound processing.

OBIEE Administration and support.

Environment: EBS R12, RDBMS 11g/10g, Oracle Fusion Middleware, Red Hat Linux, RHEL 5.2, OEM, RAC, ASM, HP Kintana, EXADATA, Oracle Linux, SQL*Plus, WebLogic, SOA Admin, SABRIX, CONTROL-M, Splash BI

Client: Ingersoll Rand., Charlotte, NC Aug 2016 – Dec 2016

Role: Oracle Applications Database Administrator, Oracle DBA

Employer: Cognizant Technology Solutions

Project Summary:

Ingersoll Rand (NYSE:IR) advances the quality of life by creating comfortable, sustainable and efficient environments. IR people and family of brands—including Club Car®, Ingersoll Rand®, Thermo King® and Trane®—work together to enhance the quality and comfort of air in homes and buildings; transport and protect food and perishables; and increase industrial productivity and efficiency. We are a global business committed to a world of sustainable progress and enduring results.

Responsibilities:

Oracle Application and database Day to day Support of EBS 12.1.3 and 11.2.0.5 and Oracle database 11.2.0.4.

Perform end to end support task for Oracle SOA applications/Fusion Middleware production and development systems by checking critical SOA loaders job, checking the coherence data, WEB domain JAVA active thread count, checking all SOA data sources, Bridges, Channels with tools like SOA Coherence Editor, SOAPUI, JAVA Visual VM

Alert and Production EBS application and database Monitoring and take required action to prevent high risk production issue.

Worked with various Oracle Applications Utilities like Rapid Install, FNDCPASS, f60gen, CONCSUB etc.

Planning and administering backup and recovery strategies.

Involved in the Database design and deciding the requirements for migrating Database to new servers.

Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during upgrade.

Involved in Oracle Applications Tablespace Management (OATM) as part of the upgrade.

Migrating databases from PA-RISC environment to HP-UX Itanium.

Performed the installation of oracle 10g RAC database and have good knowledge in basic concepts of RAC.

Installed and configured GRID and ASM as part of the migration.

Performed the conversion of Non-ASM instance to ASM instance.

Converting Database to 2-Node RAC.

Maintained and provided PROD support for EBS 11i Application and Database.

Performing SYSADMIN activities like user maintenance and setting up profiles.

Monitoring of Concurrent Managers and troubleshooting long-running concurrent programs.

Providing DBA support during month end activities.

Automation of DBA monitoring activities like purging older archive logs, concurrent manager log/out files, Gather schema statistics.

Maintaining Databases including backups, restores, recoveries, imports, exports.

Set up and administer tablespaces, data files, tables, indexes, views, sequences, synonyms and DB links.

Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.

Applying patches in EBS 11i and R12 application.

Perform weekly cloning activities of non-prod instances, both application and database.

Responding to different types of alerts automation using oracle alerts.

Configured Workflow Notification Mailer for inbound and outbound processing

Provided application support to users and created a log of all the problems with solutions for future reference.

Environment: EBS R12, RDBMS 11g/10g, Oracle Fusion Middleware, Red Hat Linux, RHEL 5.2, OEM, RAC, ASM, HP Kintana, EXADATA, Oracle Linux, SQL*Plus, WebLogic, SOA Admin, crontab.

Client: Alcoa Inc., New Kensington, PA Mar 2016 – July 2016

Role: Oracle Applications Database Administrator, Oracle DBA, WebLogic Administrator, System Administrator

Employer: Tata Consultancy Services

Project Summary:

Alcoa is the world’s leading producer of primary aluminum and fabricated aluminum, as well as the world’s largest miner of bauxite and refiner of alumina. In addition to inventing the modern-day aluminum industry, Alcoa innovation has been behind major milestones in the aerospace, automotive, packaging, building and construction, commercial transportation, consumer electronics and industrial markets for more than 120 years.

Among the solutions Alcoa markets are flat-rolled products, hard alloy extrusions, and forgings, as well as Alcoa® wheels, fastening systems, precision and investment castings, and building systems in addition to its expertise in other light metals such as titanium and nickel-based super alloys.

Sustainability is an integral part of Alcoa’s operating practices and the product design and engineering it provides to customers. Alcoa has been a member of the Dow Jones Sustainability Index for nine consecutive years and approximately 75 percent of all of the aluminum ever produced since 1888 is still in active use today.

Responsibilities:

Performed SYSADMIN activities like enabling and disabling traces, user creation, assigning menus, responsibilities to users as per requests, workflow navigator and maintained concurrent managers.

Maintenance included relinking applications objects and regenerating forms and reports using all AD utilities Autoconfig, adctrl, adadmin, adpatch etc. Also worked with various Oracle Applications Utilities like Rapid Install, FNDCPASS, f60gen, CONCSUB etc.

Apart from the above-mentioned tasks, daily monitoring is carried out before start of business to ensure database availability and smooth functioning of databases. Daily monitoring includes checking whether all databases are running, listener is running, concurrent managers are running, Unix error messages, disk space availability, checking for alert logs and trace files, checking for invalid objects etc.

Worked with various Oracle Applications Utilities like Rapid Install, FNDCPASS, f60gen, CONCSUB etc.

Planning and administering backup and recovery strategies.

Have expertise in activities like maintaining instances, maintenance of file system and taking appropriate backups for security and consistency.

Validating & Creating grants & synonyms on Apps schema, Performed jar file/forms generation as a post patch step, relinking the Oracle apps programs.

Setting up scripts in CRON to purge concurrent manager log and out files, database trace files periodically.

Provided application support to users and created a log of all the problems with solutions for future reference.

Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during upgrade.

Maintained and provided PROD support for EBS 11i Application and Database.

Performing SYSADMIN activities like user maintenance and setting up profiles.

Monitoring of Concurrent Managers and troubleshooting long-running concurrent programs.

Providing DBA support during month end activities.

Automation of DBA monitoring activities like purging older archive logs, concurrent manager log/out files, Gather schema statistics.

Maintaining Databases including backups, restores, recoveries, imports, exports.

Set up and administer tablespaces, data files, tables, indexes, views, sequences, synonyms and DB links.

Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.

Applying patches in EBS 11i application.

Perform weekly cloning activities of non-prod instances, both application and database.

Responding to different types of alerts automation using oracle alerts.

Configured Workflow Notification Mailer for inbound and outbound processing.

Environment: EBS R12, RDBMS 11g/10g, Red Hat Linux, RHEL 5.2, OEM, RAC, ASM, HP Kintana, EXADATA

Oracle Linux, SQL*Plus, WebLogic, SOA Admin, crontab.

Client: Johnson Controls Inc., Milwaukee, WI Jan 2015 – Feb 2016.

Role: Oracle Applications Database Administrator, Oracle DBA, WebLogic Administrator, System Administrator

Employer: Tata Consultancy Services

Project Summary:

Johnson Controls Inc. (JCI) Building Efficiency (BE) business unit is in the business of providing solutions for operating building effectively and efficiently to increase a building’s energy efficiency and operational performance. This includes selling HVAC&R equipment’s and control systems, industrial and commercial refrigeration, fire and security systems and service for commercial, industrial and residential buildings.JCI BE is using an integration application consisting of a homegrown application system called Integrated Business System (IBS) and Oracle Applications (Oracle e-Business Suite), along with various other applications to run the daily business operations.

The main scope of ADTi Implementation Project is to migrate Database and Application from Richardson Data Centre to Milwaukee Data Centre, which included applications like EBS, OTM, OBIEE, SOA etc. Implemented the migration of 18 PROD servers and 30 DEV servers in less than 3 months with a team strength of three members. Project is in Support Phase now.

Responsibilities:

Supported 100+ databases ranging in size between 30GB to 7TB.

Installed and configured RAC and Performed up-gradation of grid infrastructure and Oracle databases from 11.2.0.1 to 11.2.0.3.

Performed health checks in RAC instances using CRSCTL and SRVCTL utility.

Performed Database refresh from Production RAC environment to TEST RAC environment.

Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.

Starting and stopping the agents to clear metric alerts and collecting ADDM reports in OEM.

Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM.

Involved in Tuning the RAC interconnect Finding RAC wait events. In addition, tuning the RAC using the Enterprise Manager Grid Control.

Performed various tasks on ASM, creating a disk group, adding a disk, making disk online and offline and troubleshooting issues in ASM environment.

Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.

Create thorough documentation of installation procedures and administrative tasks in the clustered environment.

Generated and automated Stats pack/AWR reports from Oracle 11g/10g database and analyzed the reports for Oracle wait events, time-consuming SQL queries, table space growth, and database growth.

Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.

Used Explain Plan, Oracle hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.

Addressed developers/testers requests to clone production databases for the purposes of testing using RMAN.

Planned and Implemented Disaster Recovery (DR), Standby databases with High Availability using RAC, and Data Guard.

Environment: Oracle 11gR1, 11gR2, 11.2.0.3, 12c RHEL 5.8, HP-Unix 11.23, Solaris 10, OEM, DBUA, RMAN, Oracle Enterprise Manager Grid Control, RAC, ASM, Data guard, SQL*LOADER, AWR, Data pumps, Exports/Imports.

Client: Alcoa Inc., Pittsburgh, PA Mar 2014 - Dec 2014

Role: Oracle Apps Admin/DBA, WebLogic Administrator