SUMMARY:

• I am an Oracle Apps DBA with 8+ years of IT experience . I have worked on some of the most complex and highly available deployments including deployment of Oracle EBS Applications, Oracle fusion middleware components and oracle Database on various platforms such as OEL, Solaris, AIX for the well - known customers.
• 8+ Years of experience on Oracle Database Administration (10g/11g/12c)
• 6+ Years of experience on Oracle EBS Applications DBA (11i & R12)
• 5+ Years of experience on Oracle Fusion Middleware Administration(10g/11g)
• 2+ Years of experience on Oracle access manager (OAM), EBS R12 integration

SKILLS SUMMARY:

Oracle Applications (11i & R12): Server Sizing, Capacity Planning, Design, Installation, Patching, Cloning, and Upgrade 11i/R12 to R12.2, DMZ setup. SSL setup, Load balancer setup, Configuration update with autoconfig, adding managed servers, Printer setup, configure concurrent managers, Application Maintenance with AD utilities (adadmin, adsplice, adpatch, admrgpch, adident, adctrl, adchkdig, adrelink, adlicmgr), Application health check using OAM, Online patching using ADOP.

Oracle Database (10g/11g/12c): Installation and Configuration of Databases, monitor diagnostic logs, tablespace management, user management, Backup/recovery (RMAN). Refresh non-prod instances, apply patches, Tune Database instances, application code objects. Generate AWR, stats pack reports, collect hit ratios, trouble shoot user issues and system issues. Perform Upgrades (10g/11g to 12c).

Oracle Fusion Middleware WebLogic, OAM, OAS and OHS.: Design, Installation, Configuration and Deployment of WebLogic Server, OHS, OAS and OAM. Upgrade of Fusion Middleware applications from 10g to 11g, SSL configuration and Load balancer for high availability. Upgrade of application server 10g to FMW 11g(Forms/Reports). add managed servers, Data sources, JMS services. implement clustering. Setup DR for high availability.

PROFESSIONAL EXPERIENCE:

Confidential, Georgia, Atlanta

Environment: Oracle Database, Loftware, Load Xpert, OHS, Linux, Solaris, Windows servers, SAP, Web Methods, FileNet, .net Applications

Oracle DBA

Responsibilities:

• Size and build new infrastructure at Confidential data center to accommodate database and applications
• Evaluate current or emerging technologies to consider factors such as cost, portability, compatibility, or usability to re-architect the existing solution.
• Installation, configuration of Oracle databases 12c on Sun Solaris and Linux.
• Migrate oracle databases from IP’s Data center to Confidential Data center.
• Install and configure OHS 12c (12.2.1) On Solaris server in DMZ zone.
• Integrate OHS with SAP portal in DMZ for external users.
• Perform Database Backup’s including cold, hot and RMAN backup
• Collect AWR reports and analyze the report for database bottle necks.
• Monitor the Database objects and code objects to find out the performance issues.
• User management and tablespace management.
• Monitoring growth of the database and performing health check on daily basis
• Monitor RMAN backup logs on regular basis.
• Migrate Loftware environments (Dev/Test/Prod) to Confidential data center.
• Configure Label printers for All three paper mills.
• Migrate Load Xpert to Confidential data center.
• SAP database maintenance support.
• Configure Hand held devices in all three paper mills.
• Provide support, guidance and implement to build Test environment, High availability and Disaster recovery environments
• Backup and monitoring implementation

Confidential

Environment: Oracle EBS, Oracle Fusion Middleware and oracle Database

Responsibilities:

• Installation and configuration of EBS R12.0, R12.1 and R12.2 Applications
• Apply EBS patches online using ADOP on R12.2.x Environment.
• Apply EBS patches using ADPATCH on R12.0 /R12.1 and 11i
• Upgrade Oracle EBS Applications from 12.1.3 to 12.2.3
• Clone EBS 11i, R12.0, R12.1 and R12.2 prod environments to Dev and Test environments.
• Apply Technology patches using opatch and BSU utilities on EBS R12.2 environment.
• Technology patches patch management using ETCC
• Add managed servers oacore, forms to improve performance using adProvisionEBS.pl
• Add additional Application nodes using adaddnode.pl
• Create, Configure and manage custom tops & custom objects in R12 using adsplice
• Perform configuration changes to Application services using autoconfig
• Manage and monitor middleware components using weblogic, EM console.
• Manage and monitor EBS application components using OAM.
• Configure hardware load balancer in front of EBS R12 to distribute the user load
• Create and manage users and relevant responsibilities in EBS applications
• Implemented SSO integration with OAM and EBS R12.2
• Setup DMZ environment with EBS applications
• Configure the SSL for web tier and EBS Apps tier
• Tune the managed server jvm for better performance
• Take oracle database backup using RMAN utility
• Install and configure FMW components weblogic, SOA, WebCenter, OBIEE, OHS.
• Deploy enterprise applications on weblogic managed servers
• Add managed servers for better performance using weblogic admin console.
• Perform weblogic server administration
• Troubleshoot Oracle Applications and Oracle database issues
• Perform Daily health check for tablespace, mount points, Application objects etc
• Perform sysadmin tasks (define users, responsibilities and manage concurrent requests)
• Configure mobile hand held devices for maintaining warehouse
• Configure Label printer for EBS applications

Confidential, Houston, Texas

Environment: Oracle EBS, Oracle Fusion Middleware and oracle Database

Responsibilities:

• Install and configure OAS 10.1.2.0.2 in new data center as part of data center move.
• Upgrade Oracle application Server (OAS) from 10.1.2.0.2 to 10.1.2.3
• Apply interim patches on oracle metadata repository database 10.1.0.5
• Upgrade OAS 10gR2 Forms/ Reports "Standalone" to Fusion Middleware 12c
• Monitor and restart the OAS services for abnormal terminations.
• Configure the oracle forms application instances for new Business units
• Monitor and manage the OPMN components and OC4J instances.
• Application Code Deployment from Development to QA and QA to Production
• Housekeeping of Web Cache, Apache log Files and Report Outputs
• Perform general management of Oracle HTTP Server (OHS)
• Patch Impact Analysis and patch management for EBS R12.2 applications
• Technology patches patch management using ETCC
• Clone 12.2.3/12.2.4 , Multinode to single node and single node to multi node
• Tune the application server to increase the performance.
• Take oracle database backup using RMAN utility
• Manage and monitor RAC database instances
• Implement load balancer between the servers
• Create, Configure and manage custom tops & custom objects in R12 using adsplice
• Perform configuration changes to Application services using autoconfig
• Manage and monitor middleware components using weblogic, EM console.
• Create and manage users and relevant responsibilities in EBS applications
• Configuration of Secure Socket Layer (SSL) in Web Tier, Application Tier.
• Manage oracle Database with OEM console.
• Monitor all the Domain resources, servers, clusters, JMS, Connection Pools
• Analyze and Troubleshoot the Concurrent Mangers, Programs issues
• Perform EBS application administration tasks with Oracle application adutilites (adadmin, adident, adctrl, adpatch, autoconfig…etc)
• Perform general database administration tasks.
• Apply patches on database to fix bugs.
• Upgrade oracle Database from 11.2.0.4 to 12.1.0.2

Confidential

Environment: EBS, FMW, Oracle Database.

Responsibilities:

• Install and Upgrade R12.2.0 EBS applications to R12.2.3
• Applying patches to EBS 12.2 applications using ADOP
• Add managed servers oacore, forms to improve performance using adProvisionEBS.pl
• Add additional Application nodes using adaddnode.pl
• Create, Configure and manage custom tops & custom objects in R12 using adsplice
• Perform configuration changes to Application services using autoconfig
• Manage and monitor middleware components using weblogic, EM console and WLST
• Install and configure FMW components like weblogic, SOA, OHS, OAM.
• Technology patches patch management using ETCC
• Performing Health checks for Oracle Application services
• Clone Oracle E-business suite Applications 12.2 environments.
• Monitor and manage RAC instances
• Create Data Sources and JMS and User creation in Web logic
• Monitor the status of important services like, form server, web server, oacore.
• Concurrent Manager monitoring and administration.
• Patch Impact Analysis and patch management.
• Regular health checkup of database including space management
• Troubleshoot Apache issues after cloning
• Troubleshoot Concurrent Mangers, Programs, and Requests issues
• Changed the Profile options in Site/Responsibility/Application/User Level
• Monitor Table space growth
• Enable trace at user level whenever is required
• Setup Database monitoring including SGA, Datafile, Archive Log, Database Connectivity, Listener
• Manage and monitor RAC database instances
• Perform EBS application administration tasks with Oracle application adutilites (adadmin, adident, adctrl, adpatch, autoconfig…etc)
• Perform sysadmin activities like creating users, menus, concurrent managers etc
• Creation of New SRs, monitor open tickets and Interact with Oracle Support for technical assistance
• Recreation of the DB structures as per new development
• Perform Database Backup’s including cold, hot and RMAN backup
• Collect AWR reports and analyze the report for database bottle necks.
• Monitor the Database objects and code objects to find out the performance issues.

Confidential

Environment: oracle Database, single view Application

Responsibilities:

• Install and configure oracle 10g/11g Database for Dev and Migration teams.
• Refresh QA Schemas from prod for Testing purpose using data pump utilities
• Clone database in STAGING env for reconciliation purpose
• Create database users, grant/revoke privileges on need basis for Dev team.
• Monitor Tablespaces and add or resize Data files as required
• Take incremental backups using RMAN
• Schedule and monitor weekly logical backups for Dev, QA and taking cold backup of production before migration activities.
• Apply various patches on Dev and Test databases using opatch utility
• Upgrade CRM DEV and QA databases from 10.2.0.1 to 10.2.0.4
• Generate and Analyze AWR reports for query performance issues.
• Check the database health using alert log file and troubleshoot the issues.
• Perform DB ANALYZE/Stats gather for billing tables to gather table and index stats
• Collect database Hit Rations on Daily basis to monitor the Database load.
• Monitor and clear the inactive user sessions
• Perform ticket release management for billing code in Dev, QA and prod applications.
• Generate explain plan reports for database code objects on need basis.
• Create users and roles in singleview application
• Manage and monitor Intec singleview applications