Sudhakar Ketha

Environment: Oracle Applications R12.2 on Red Hat and Oracle Linux.

Role: Lead Oracle Apps DBA.

Client: Infosys, LKQ.

Project Description: LKQ Corporation was initially formed in 1998 through the combination of a number of wholesale recycled products businesses located in Florida, Michigan, Ohio, and Wisconsin. We subsequently expanded through internal development and approximately 270 acquisitions of aftermarket, recycled, refurbished, and remanufactured product suppliers and manufacturers; self-service retail businesses; and specialty vehicle aftermarket equipment and accessories suppliers.

Responsibilities:

• Installation, upgrading, and administration of Oracle EBS R12.1/R12.2 environments.
• Patching and cloning of EBS/database environments.
• ADOP and online patching, analyzing and resolving patching issues.
• Managing and Supporting Oracle EBS 12.1.x/12.2.x multitier environments.
• Performed Oracle Database upgrade from 12c to 19c on the Linux platform, including migration from non-CDB to multitenant (CDB/PDB) architecture, with pre/post-upgrade checks, patching, and performance tuning.
• Debugging EBS/Database performance issues and tuning skills.
• Enabled additional languages in Oracle Apps R12 by performing end-to-end configuration (character set validation, License Manager activation, admin tasks, NLS patching) to support multilingual operations.
• Load balancing of the application tier and setting up parallel, concurrent processing.
• Oracle 12c, 19c database administration.
• Upgrading Oracle Database to the 12c/19c versions.
• Multitenant architecture. Container and pluggable database administration and cloning.
• Configuration, Managing, and Supporting Oracle RAC Databases.
• Installation, Setup, and Managing Oracle ASM.
• Oracle Data Guard, RMAN.
• Setting up a DR environment and supporting periodic DR drills.
• Working with Oracle Support.
• Performing quarterly PSU, and CPU patching.
• Work as part of a team, and provide 24/7 support.

Environment: Oracle Applications R12.2 and R12.1.3 on Red Hat and Solaris.

Role: Module Lead.

Client: Babcock & Wilcox, U.S.

Responsibilities:

• Managing Oracle EBS R12 environments, patching, and cloning.
• Performing database performance tuning and SQL query optimization.
• Handling PSU and CPU patching on a quarterly basis.
• Implementing and maintaining Oracle RAC and Data Guard setups.
• Addressing long-running requests and improving system performance.
• Troubleshooting concurrent manager and ADOP patching issues.
• Monitoring tablespace growth and ensuring adequate storage allocation.
• Performing database refreshes and backup management using RMAN.

Environment: Oracle Applications R12.1.3 on Red Hat Linux 5.

Client: Agrigold.

Responsibilities:

• Monitoring production instances and troubleshooting issues.
• Cloning production instances to development and test environments.
• Resetting user passwords and managing security roles.
• Resolving Service Requests (SRs), and migrating files between environments.
• Running gather stats and rebuilding indexes for performance optimization.
• Performing database backups and recovery using RMAN.
• Handling schema-level refreshes and expdp/impdp data migrations.

Role: Oracle Database Administrator.

Client: Honeywell.

Responsibilities:

• As a team member, I started working primarily in databases and performing daily database-related activities.
• Regularly working on production databases and taking care of the health check-up of all databases regularly.
• Supported the development and test teams with data refresh using exp/imp, Data Pump, and script execution.
• Assisting with all development work on Oracle. This includes helping to work with the application team, designing and creating database objects, migrating from test to production, and implementing batch schedules.
• Implemented the Data Guard, i.e., setting the logical and physical standby databases, and setting the migration from primary to standby databases.
• Participate with the application development team to design the Oracle Database.
• Planning and scheduling backup and recovery procedures.
• Performed schema, tables, and databases export using Data Pump, export, and import utilities.