Ramesh Patel

*** ******** ***** *****: (C)919-***-****

Cary, NC 27512 .

Email:adjs08@r.postjobfree.com

Professional Summary

Over 25 years experience in Oracle Environments as Database Administrator/Developer including last 7 years in Oracle E-Business Suite as Technical/Application Database Administrator. The projects includes various creation of small and very large databases, migration and upgrading from various platform on variety of Database versions 7,8i,9i,10g 11g and 12c on unix ( HP-UX, WINDOW,OPEN VMS and linux ), Windows 2003. A core technical lead./architect of migrating

Oracle E-Business suite from 10.7 to 11.5.8, 11.5.9, 11.5.10.2 cup2, 12.1.3 including HRMS, (HR,

Payroll), Financials(AP,AR,GL,FA,PO, HR, BEN,PAYROLL), Compensation, modules using

Apps (11.5.8, 11.5.9, 11.5.10), Oracle Application Server 10g iAS,Discoverer application server.

Support oracle to postgres conversaion.

AWS Amazon – postrgress.

Snowflake – support.

Oracle R12 dba support.

WORK EXPERIENCE

FEB-2014 till >

Railinc Corp. Oracle DBA/Erp application DBA.

EBs 12.1.3 oracle database 12.1.0.2.

Configuration Dbtier and apps tier on server linux red hat 7 enterprise version.

Webtier on linux red hat7 enterprise version.

Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning EBS 12.1.3 and Oracle Apps SYSADMIN functions. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, fire fighting, developer/integrator relations, script development, documentation and DBA training. Specific Oracle Applications modules installed include AP, GL, AR, FA, PO, PA, QA, INV, CM, HR/Payroll, I Procurement and OPM.

Role also includes participating in IT Infrastructure related projects, such as upgrades and system maintenance, working with Project DBA on cut over time and transitions different activity, and coordinating all aspects of projects. This includes scheduling tasks, identifying potential issues, and working with staff to quickly provide solutions to problems as they arise, utilizing current system support staff to aid in the completion of project on time.

1994 till 2014: Dexone Corp, Cary, NC

Currently serving as an Oracle DBA.

Responsibility:

Responsible for installation EBS 12.1.3, upgrades, patches, TAR support, database tuning, concurrent manager administration, adclone utility to cloning various test and development environment and Oracle Apps SYSADMIN functions. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery using rman, general troubleshooting, fire fighting, developer/integrator relations, script development, documentation and DBA training. Specific Oracle Applications modules installed include AP, GL, AR, FA, PO, PA, QA, INV, CM, HR/Payroll, I Procurement and OPM.

Role also includes participating in IT Infrastructure related projects, such as upgrades and system maintenance, working with Project DBA on cut over time and transitions different activity, and coordinating all aspects of projects. This includes scheduling tasks, identifying potential issues, and working with staff to quickly provide solutions to problems as they arise, utilizing current system support staff to aid in the completion of project on time.

EXPERIENCE:

•Support oracle financial 12.1.3 – upgrade, patch installation and cloning to lower environment.

•Upgrade oracle database from 11i to 12.2,x

•Daily support of oracle database, performance tuning and help developer wth code review.

•Support Posgress database. Replicate oracle data to postgres (aws amazon cloud)

•Support Ambari application,

•Support Greenplum database

•Support Haddoop application for daily routine.

•Support Prophix database on sqlserver for bugetting and forcasting.

•Update daily scripts on lunix for backup of oracle and rman.

•Installed 12.1.3, including Financials, HRMS Upgraded 11.5.9 to 11.5.10.2- CUP 2. Iinstall and upgrade to 12.1.3 with the Forms, and Web Server running on Windows 2000/NT, Windows 2003 servers and the Database, Reports and Concurrent Mangers on a second Windows 2003 node.

•Configured Load Balance environment for E-Business Suite with 3 application server using cisco load balance Hardware.

•Applied Procurement Family Pack which includes the PO and OPM modules.

•Migrated Windows/Unix environment to 11.5.9 from 10.7 NCA

•Installed and patched oracle 10g IAS for discoverer on 11.5.10.2 environment and install Neotix Views and EUL layer.

•Maintain 10 development and 1 test environment (load Balanced) 11i environments for various projects and clone/refresh application tier/database tier as per project requirements.

•Install patches, upgrades and code migration in different applications and databases; Install, configure and Support different Application adaptors and Oracle BI Applications. Convert single application server to Multiple application servers Configure PCP on two Concurrent servers. Test failover of concurrent servers and DB servers

•Maintain existing and establish newer security, integrity, controls in the application and database

•Formulate and monitor policies, procedures, and standards relating to database and application management to ensue the security, quality, performance, and accessibility of the Oracle e-Business processing platform.

•Holistic tuning experience of Oracle databases, Oracle Applications as well as SQL & PL/SQL tuning (wait events, tkprof).

•Troubleshooting, recovery, tuning of the database, software installation, resolving Oracle errors and failures, auditing activities, and resource utilization are some of the other important responsibilities.

•Ensuring the high availability, performance and security of the production databases. Supporting the test and development database environments.

Tuning at the instance and SQL statement level.

Maintain database on UNIX environments. Install patches, upgrade, and cloning from production to other environment. Code promotions.

Monitor application performance ensuring scheduled programs and interfaces run appropriately. Analyze current issue resolution processes;

•Planned, re-designed, reconfiguration Oracle E-Business suite 11.5.9. Required re-installation of ap,gl and fa module and converted single org to multiorg environment (HR,PAY,BEN,AP.GL,FA,CA,PAY,PER AND BEN).

•Upgraded Release 10.7 NCA to 11.5.9 in split configuration environment and install Release 11i using rapid install.

•Installed and patched oracle 10g IAS for discoverer on 11.5.10.2 environment and install Noetix Views and EUL layer

•Clone up to 12 different development environments from production as per project requirements.

•Planned and applied numerous patches/family packs to keep system up to date.

•Tuned database, sol applications/packages and assisted in migration database into production.

•Designed cloning system (autoconfig enable) to improve performance and refresh requirement of various development environment from production.

•Designed and developed interfaces for third party vendor (BSBC,Metlife, VSP, Bank of America and JPMorgan for daily upload and download of the data from E-Business Suite. Using Developer 2000 6i (Forms 6i and Reports 6i, Net8, Sql*Plus, PL/SQL, Stored Procedures, DB Triggers.

•Experience in Oracle Applications 11i Installations, configuration, Cloning, Security, Patching, Upgrades, Maintenance using AD and other utilities.

•Extensive use of 10G Oracle Enterprise Manager (OEM) and Oracle Applications Manager (OAM) for Performance, Administration and Maintenance of Databases and e-Business Components.

•Experience in setting up SOX controls on the ERP system from technical perspective.

•Managed Data Warehouse and OLTP (On Line Transaction Processing system) full life cycle projects with about 10 databases at one time, biggest database around 800 GBytes (800GB) supporting both production developments on Unix and Windows 2003 servers

•Oracle Server Installations/Upgrades, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Security

Administration, Data Architecting, normalization/de-normalization, Data Warehousing, Multithread Servers, Distributed Databases for Oracle 8i/9i/10g/11g Databases, table partitioning and Oracle Standby Server.

•Expert in packages Oracle Enterprise Manager, TOAD, SQL Navigator, RMAN, Apache, HTML, RMAN, Schema Manager. Working in environments constituting iAS, Oracle Self Service Web Applications, XML, Discoverer (3.x, 4i).

•Specialization in Administration of Oracle Database, Data Warehouse, Reporting tools, Data Modeling and Data Architecture.

•Representing the DBA group on Projects from planning Stage to the Go-Live stage, meeting expectations and deadlines.

•Highly efficient and experienced working in huge environments across multiple team (Development, Functional and Business) and at the same time, maintaining a satisfactory relationship.

•Working pro-actively with Unix/Linux Support, Web Group and Migrations Team to make sure all operating system and migrations issue are addressed in a timely manner.

•Proactively engaged in research and investigation of new features for database and the application level.

TECHNICAL SKILLS

•RDBMS: Oracle 12c, 11g, 10g, 9i, 8i, MS Access

•RDBMS Tools: Oracle Enterprise Manager (OEM), SQL*Loader, Oracle Schema Manager, RMAN, Space Manager, Net 8, SQL Trace, TKPROF, Stats Pack, TOAD, SQL Navigator Applications:

Oracle 11g, 10.7, 11.0.3, 11.5.8, 11.5.9, 11.5.10, 11.5.10.2 9iAS, Forms6i, Oracle Application

Upgrade oracle financial from 11.5 to 12.1.3.

Manage, Oracle Webserver Operating System:

HP-UX, Windows NT4.0/2000, Windows 2003 enterprise, Veritas Clusters Languages:

SQL*Plus, PL/SQL, C, Pro*C, Cron Processes, Unix Shell Scripting, csh, ksh, HTML,XML Software Tools:

o Apache, IAS, 9iAS, Oracle Portal, Oracle Internet Directory, Developer 2000 (Forms6i, Forms 9i,Report6i, Report9i), TOAD, SQL Navigator.

1993-1994 : Glaxo Welcome. USA – Oracle DBA/Developer.

1987-1993 : Abbey National Plc – UK. – Oracle Developer.

1982-1986 : HMSO- Her Majesty Stationery Office – London UK. – Oracle DBA/Developer. 1979-1982 : Square One – Chesham – UK. – Oracle Developer.

Contact this candidate