SUMMARY

• Over 9 plus years of IT experience in administration and maintenance of Oracle applications and databases.
• Technical support, Business Analysis Skills and good knowledge on maintaining mission critical enterprise applications and databases.
• Experienced as Oracle Apps, Core and Fusion Middleware DBA with extensive skills on EBS 11i/R12, Fusion Middleware 11g and Database 11g/12c Installations, Backup, Recovery, Upgradations, Patching, Cloning and 24/7 Support.
• Experienced in implementation of Oracle High availability and Disaster Recovery architecture using Oracle RAC and Dataguard.
• Expertise in performing Database switchover and failover using Dataguard broker.
• Experience in implementing Oracle database 12c multitenant architecture.
• Experienced in implementing Backup and recovery solutions for Oracle databases using Scripting and tools like RMAN.
• Experience in integrating Oracle EBS with OAM and OID 11g. Good working knowledge of OAM and OID 11g.
• Good knowledge in database migrations using Oracle data pump and transportable tablespace techniques.
• Expertise in Oracle EBS upgrade from 11i to 12.2 and database upgrade from 10g and 11g to 12c.
• Proficient in implementing and administration of Oracle Fusion Middleware 11g components such as OBIEE, OHS, WebLogic etc.
• Good Knowledge of managing Oracle databases on Oracle EXADATA machines.
• Proficiency in Oracle EBS online patching using adop and adpatch.
• Extensive Knowledge of AD utilities like adpatch, adadmin, adclone, adident, adctrl, admrgpch.
• Proficient in SQL and Oracle databases instance tuning to improve database performance.
• Good knowledge in implementing monitoring mechanism for Oracle applications and databases using Oracle Enterprise Manager OEM.
• Experience in single, multi - node installation and shared application tier configuration of Oracle EBS applications.
• Experienced in Oracle database flashback and RAT technologies.
• Experienced in implementing SSL and DMZ configuration setup for Oracle EBS applications.
• Extensive knowledge in cloning Oracle EBS and databases using Rapid clone and manual cloning techniques.
• Possess good skills in technical documentation, client interaction and coordinating tasks with multiple teams.
• Have good Analytical and Problem Solving skills and Excellent Communication and Interpersonal Skills, ability to understand and adapt to new technologies and environments faster.
• Proven ability to work independently as well as in a team. Ability to interact with developers, coordinate and manage the tasks assigned, backed by strong technical knowledge.

TECHNICAL SKILLS

Operating Systems: UNIX (Linux 5.x, Sun Solaris 2.x/8, AIX 5.x), Windows

Applications: Oracle EBS 11i, R12 (12.1.3,12.2.5), Oracle Fusion Middleware 11g

RDBMS: Oracle 9i,10g,11g and 12c, Oracle RAC 10g and 11g, Dataguard, ASM Oracle Oracl;

Languages: SQL, PL/SQL, C, UNIX Shell, Perl

Tools: EXPDP, IMPDP, AD Utilities, Oracle Applications Manager (OAM), Oracle Enterprise manager (OEM) 11g and 12c, Recovery Manager (RMAN), DGMGRL, ADRCI, SRVCTL

Other: OBIEE 10g and 11g, WebLogic 11g & 12c, OID, OAM, Oracle 10g AS, UPK, Ringmaster, HP Data protector

PROFESSIONAL EXPERIENCE

Confidential, Richardson TX

Oracle Apps DBA

Responsibilities:

• Upgrade Oracle EBS applications from version 12.1 to 12.2.5
• Upgrade Oracle databases from version 11.2.0.3 to 11.2.0.4 and 12.1.0.2
• Integrate Oracle EBS with OAM and OID 11g.
• Migrate Oracle EBS applications and databases from HP-UX to RHEL.
• Setup Oracle database vault for Oracle financial systems.
• Applying Oracle EBS patches using online patching (ADOP).
• Cloning Oracle databases using RMAN and duplicate database techniques.
• Data migration across multiple Oracle databases using expdp/impdp utilities.
• Support distributed transactions across multiple Oracle databases.
• SSL and DMZ configuration for Oracle EBS R12 applications.
• Designing Tables, Constraints, Views and Indexes in coordination with the application development team.
• Tuning SQL queries for improved performance.

Environment: Oracle Applications EBS 11i, R12 Database 10g, 11g and 12c, OEM 12c, Data guard, RAC, Fusion middleware 11g, WebLogic 11g, OAM 11g, OID 11g

Confidential

Oracle Apps and Core DBA

Responsibilities:

• Implemented complex architecture involving 26 nodes application tier and 18 nodes database tier.
• Planned and performed the upgrade of Oracle EBS applications from version 12.1.3 to version 12.2.4.
• Upgraded Oracle databases from version 11.2.0.3 to 12.1.0.2.
• Applying Oracle EBS patches using online patching(ADOP).
• Implemented multi node Oracle RAC databases supporting high availability architecture.
• Implemented disaster recovery solution for Oracle EBS applications and databases using Oracle Dataguard. Proficient in database switchover and failover using Oracle Dataguard broker.
• Creation of metrics and monitoring mechanism for Oracle applications and databases using OEM 12c.
• Administration and maintenance of Oracle WebLogic 11g instances.
• Integrated Oracle EBS applications with OID and SSO, guaranteeing centralized user administration.
• Performed cloning and patching of Oracle EBS applications and databases.
• Managed databases over the size of 60TB.

Environment: Oracle Applications EBS 11i, R12 Database 10g, 11g and 12c, OEM 12c, Data guard, RAC, Oracle 10gAS, Fusion middleware 11g, OID, WebLogic 11g, SSO

Confidential

Oracle Apps and Core DBA

Responsibilities:

• Involved in Installations, Upgradations, Patching and cloning of Oracle EBS applications and databases.
• Implemented backup and recovery solutions using RMAN for Oracle databases.
• Implemented SSL and DMZ configuration for Oracle EBS 11i and R12 applications.
• Performed Parallel Concurrent processing setup for EBS R12 applications.
• Installation and maintenance of Oracle WebLogic, OBIEE 11g and other fusion middleware components
• Performed database upgrade from versions 10g to 11g.
• Worked on conversion of single node database to RAC database with ASM.

Environment: Oracle Applications EBS 11i and R12, Database 10g and 11g, Data guard, RAC, Oracle 10gAS, Fusion middleware 11g, OID, SSO, OBIEE, BPEL

Confidential

Oracle Apps and Core DBA

Responsibilities:

• Worked on upgrading Oracle EBS applications from Version 11.5.10.2 to 12.1.3.
• Patching Oracle applications and databases using adpatch and Opatch.
• Implemented data archiving for Oracle EBS database using Informatica ILM.
• Worked on Oracle SQL and database instance tuning to enhance the performance of Oracle databases.
• Worked extensively on database reorganization using alter table and expdp/impdp utilities.

Environment: Oracle Applications EBS 11.5.10.2, 12.1.3, Oracle Database 11g, Discoverer 10g & 11g, Data guard, RAC, Oracle 10gAS, Fusion middleware 11g, OID, SSO

Confidential

Technical Support Engineer

Responsibilities:

• Management for Oracle EBS applications and databases users and roles.
• Installation of Oracle databases versions 9i and 10g.
• Managing responsibilities for Oracle EBS applications.
• Monitoring Oracle applications and databases CPU and memory usage and taking corrective actions in case of high usage.
• Providing first level support for Oracle applications and database issues.