SUMMARY:

• Experienced Oracle E - Business Suite DBA providing support for Oracle EBS R12 on Exadata/ZFS engineered systems with Sun T4 webservers.
• Performed several Oracle implementations taking care of install, upgrade, migrate, replication, patching, database cloning/duplication backup and recovery planning, testing, 24x7 production support, Oracle RAC, ASM and Data Guard.
• Provided DBA support for Oracle 11g RAC Instances on Exadata x2-2 and Oracle EBS R12 instances in OEL, Solaris, RedHat Linux platforms. Performed database tuning, SQL tuning, database upgrades, CPU & PSU patching and SR support.
• Implemented replication between Oracle EBS to EDW Teradata database using Oracle GoldenGate 11g. Provided support for OBIEE, Informatica, Teradata and Discoverer.
• Installation and administration of MySQL databases, WebLogic and Oracle Fusion Middle Ware. Supporting company’s blog server (WordPress) configuration and wiki (Atlassian Confluence).

TECHNICAL SKILLS:

• Oracle E-Business Suite Administration R12 (12.2.5, 12.0.6) and 11.5.x.
• Oracle 12c/11g/10g/9i RAC with ASM, Oracle MySQL and Teradata.
• OEM 12c,11g, Oracle GoldenGate 12c/11g/10g, Oracle Fusion Middleware, Oracle 10gAS, OIM, OID with Replication, Oracle BRM, WebLogic, Oracle OSB and BI Publisher, Discoverer, Portal, Workflow, ASM, RMAN, Export/Import and Toad.
• SQL*Plus, PL/SQL, Pro*C, SQL*Loader, Deployment Manager, PPM, Informatica and Tivoli, Replication Manager (EMC), SanCopy and Snapview.
• Oracle Enterprise Linux (OEL), Sun Solaris10/8/7, Redhat Linux, Tru64 UNIX 5.1, IBM AIX 4.3.1, Reliant UNIX 5.44, Windows 10/8/7.
• Oracle Exadata X2/ZFS Engineered system, Sun T4, SUNW,SPARC-Enterprise,SUNW Sun-Fire- T-2000.

PROFESSIONAL EXPERIENCE:

Confidential, Wayne, PA

Senior Database Administrator

Responsibilities:

• Upgraded EBS from 12.0.6 to 12.2.5 coordinated with development & testing teams and documented upgradation process for Go-Live.
• Provided support for 4 node RAC Oracle Exadata X2/ZFS Engineered systems with Sun T4 for EBS R12.0.6 (PROD/DEV/UAT), coordinated and applied quarterly patching and provided on call support.
• Implemented Oracle GoldenGate Replication from Oracle EBS database to Teradata Database. Provided support for Informatica, OBIEE, Tivoli and DAC.
• Configured OEM 12c to monitor all the databases and hosts. Implemented SSO and integrated with EBS R12. Supported Active Dataguard on Exadata at DR site. Participated in annual DR Test.
• Installed and Configured Oracle BRM with WebLogic, Oracle OSB and BI Publisher.
• Created UNIX shell scripts and configured cron jobs for backups and monitoring tasks.
• Installed and supported Oracle Fusion Middleware and Oracle 10gAS for WWSS applications.
• Configured 11G RAC databases on RedHat Linux, Solaris and OEL (Exadata) platform. Installed 11G GRID infrastructure for Production and Development instances.
• Install & administration of Oracle 11g/10g RAC with ASM and configuring 11i and R12 EBS instances.
• Performed Oracle Apps instance rapid clones from ASM to non ASM, Non ASM to ASM, RAC to Non-RAC and Non-RAC to RAC with single-node to multi-node/multi-node-single-node web servers.
• Installation, upgrades, patches, Oracle SR support, performance tuning, concurrent manager administration, cloning, shell scripting, tuning apache, JVM and Concurrent requests, backup/recovery using RMAN, documentation and DBA training.
• Support Oracle MySQL clustered database and Enterprise backup. Support Company’s internal WIKI application (Atlassian Confluence).
• Upgraded Production EBS instance (11.5.9) database from 9.2.0.7 to 10.2.0.3,10.2.04
• Applied FND H, ATG RUP5 Patches to comply Oracle’s minimum base level, Performed OATM Migration.
• Configured dedicated Apache for Configurator and tuning JSERV/JVM, Configure and support Workflow Mailer and Discoverer with EBS.
• Customized AutoConfig templates to meet Confidential ’s specific requirements.
• Configure OID/LDAP naming to replace TNSNAMES and Oracle Names.
• Worked closely with functional and development teams and implemented Oracle Apps modules (CZ, AP, AR, INV, PO, GL, HRMS, OE/OM, PAYROLL).
• Administering database security components, working with SOX Administrator and Product Managers to develop and execute relevant security policies.
• Using EMC technologies like Replication Manager, SanCopy, Snapview with storage platforms NAS / SAN with different raid levels.

Confidential

Senior Support Engineer

Responsibilities:

• Performed 50+ Oracle Applications EBS Instances upgrades from 11.5.x to 11.5.8, 9, and 10 along with migrations to another server as a team.
• Installation, upgrade, patching, SR support, performance tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions. Performed database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, developer/integrator relations, script development, documentation and DBA training.
• Administering 9i/10g RAC with 11i APPS, patching and troubleshooting of Oracle Applications, Configuring SSO and DMZ for customers.
• Configuring and scheduling RMAN backups, Workflow Mailer, Discoverer and Concurrent Manager
• Upgradation of individual components like Developer 6i and Jinitiator.
• Technical and Delivery lead for the Entire Migration.
• Initial studies, H/W planning and performing migration, upgrade, Go-Live and support for new customers.
• Applying fixes for issues rose during User Acceptance Test.
• Provided 24 * 7 on-call Production support.

Confidential

Database Administrator

Responsibilities:

• Installation, upgrade, migration and administration of Oracle 8i/8/7.3/7.2 databases in UNIX environments. Creation and administration of file-systems/raw-partitions for Oracle Database usage utilizing RAID techniques. Implementing Backup and Recovery Strategies for ORACLE databases.
• Estimation and management of disk space, administration of users, objects, roles and privileges.
• Tuning databases for OLTP processing which includes identifying and dealing with row chaining, migration, segment fragmentation, high-water mark and query tuning using utilities such as utlbstat/utlestat, tkprof, explain plan.
• Developing shell scripts for routine administration tasks, database security and controls like user and objects creation, roles and grants using utilities such as SED, AWK and PERL.
• Configuring client software such as Developer 2000, and Business Objects to access ORACLE databases using JDBC, ODBC, SQL*Net V2/Net 8 interfaces.
• Promoting database changes from development to test and test to production environments.
• Consolidated Branch SCS databases (Delhi, Chennai and Calcutta) from three Sun Sparc E250 Solaris 2.5 on Oracle 7.3.4 to Compaq 732 Alpha on Tru64 UNIX V5.1 Oracle 8.1.7 to a single database with minimal application change (using SET CURRENT SCHEMA on-logon trigger).
• Upgraded and migrated PTS database from Siemens RM600E (Oracle 7.3.4) to IBM SP RS/6000 AIX 4.3.3 (Oracle 8.1.7).
• Migrated ISAACC and SCS database from Siemens RM600E (Oracle 7.3.4) to Compaq 732 Alpha Tru64 UNIX V5.1 (Oracle 8.1.7)
• Upgraded ISA database from Oracle 8.0.5 to 8.1.7 in IBM SP RS/6000 AIX 4.33.
• Configuration & Maintenance of Oracle Managed Standby Database in Oracle 8.1.7.
• Implemented Oracle Standby Database in Oracle 7.3.4 using shell scripts.