SUMMARY:

• Confidential has over 8+ years of Consulting Experience in IT Services industry with a proven track record as Oracle Core/Apps Fusion DBA Quick problem solver in fast - paced environments and works well under pressure, with a focus on root cause analysis and incident resolution. Motivated team player with the ability to function independently. Well organized and consistently meets deadlines. Excellent interpersonal and communication skills with the ability to effectively interact with both technical and non-technical staff along with global clientele. Strong focus on customer service, along with strong oral, written and presentation skills.
• Oracle Certified Professional (OCP-10g) DBA with 8+yrs of experience in administration of Oracle database, Oracle E-Business Suite (EBS), Oracle Cloud Application and Oracle Fusion Middleware
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g and 11g, with experience in very large scale database environment and mission critical large OLTP and OLAP systems.
• Oracle Technologies have been base technical skill comprises Oracle Development Suite and Databases, Oracle Data Integration.
• Create logical and physical database design
• RBAC level 3 support for both pre and post implementations for outstanding access issues.
• Design and development of ETL procedures
• Developed scripts for the various simple to complex DBA tasks (day to day DBA tasks, cloning
• Installed and configured Oracle E-Business Suite 12.2.0 for monitoring and alerting
• Installed and configure Weblogic server and SOA in Linux 6 environment
• Installed and configured Oracle Fusion Application 11.1.7 in premises for monitoring and alerting
• Experience in upgrades for Oracle EBS 12.0.6 to 12.1.3 to 12.2.0and Oracle databases from 10g to 11g and 11g to 12c
• Expertise in Maintenance, Patching, Cloning, troubleshooting of Oracle Applications (11i and R12) e-Business Suite
• Expertise in AD Utilities like adpatch, adadmin, adctrl, adrelink, adsplice, admerge, adclone, adconfig.
• Expertise in Maintenance, Patching, Clustering, troubleshooting of WebLogic Server
• Migrating Oracle ERP 12.1.3 from Linux 4.5(32 bit) to Linux 5.3(64 bit) OS.
• Implemented, maintenance of WebLogic, SOA, IDM in Fusion Application
• Hands on experience on 10g, 11g and 12c Database Refresh using RMAN and custom scripts
• Extensively used Oracle Datapump, export, import
• Documenting, Applying patches that included mini-patch sets, standalone patches, Family packs
• Develop and Tune SQL and PL/SQL code
• Experience in creating user and assigning roles in Oracle Cloud Application(13.18.02, 13.18.10)
• Allocating Roles and Privileges in Oracle Cloud Fusion Application
• Experience in Providing Data Access to the User
• Experience in Custom Role Creation in Cloud Application
• Assigning Security Content for particular user in Cloud Functional
• Enabling Geographic for US Country code in Cloud Financial Application 13.18.10
• Importing Nokia Data in Geography Hierarchy.
• Checking the periods in all the modules in Cloud Application
• Experienced in Working as a team working individually on various projects according to the requirement
• Working knowledge UNIX/LINUX OS and shell scripts.

TECHNICAL SKILLS:

Databases: Oracle Database 12c, 11g, 10g, 9i, 8, Microsoft SQL Server 2005 and 2008

Applications: Oracle Cloud Application(13.18.02, 13.18.10)Oracle E-Business Suite Release- R12 (12.1.3, 12.2.4) 11.5.9Oracle Fusion Application(11.1.7)Enterprise Management Oracle Enterprise Manager Cloud Control 10g

Middleware: Weblogic Admin SOA Admin

Operating Systems: Redhat Linux, Solaris 10, Solaris 9, Solaris 8, IBM AIX 5L, Windows 2003 AS, 2000 Professional, NT, Windows Server 2008, Windows 7, Windows XP

DBA Tools & Utilities: Datapump, Logminer, SQL Loader, SQL Tuning advisor, Tracing & TKPROF, AWR/ASH/ADDM/STATSPACK, AD utilities, streams

WORK EXPERIENCE:

Confidential, Long Beach

Oracle Apps DBA

Responsibilities:

• 24x7 Production database and applications support.
• ETCC on DB Tier Upgrade
• Upgrade Oracle 11i to R12.2.6 (Test,Uat and Production)
• Database Upgrade 10g to 12c using Rapidwiz
• Installation Steps MT and DB Upgrade.
• Installing 12c database using Rapidwiz.
• Developed the ODI interfaces and Oracle Interfaces along with technical designs using Custom Development methods.
• Experience in creating user and assigning roles in Oracle Cloud Application
• Allocating Roles and Privileges in Oracle Cloud Fusion Application
• Experience in Providing Data Access to the User
• Experience in Custom Role Creation in Cloud Application
• Assigning Security Content for particular user in Cloud Functional
• Enabling Geographic for US Country code in Cloud Financial Application
• Prepared the development and test environment for ODI with topology definition, database and repository build.
• Importing Nokia Data in Geography Hierarchy.
• Checking the periods in all the modules in Cloud Application
• Provide Notification to the END user through Dashboard.
• Experience in Troubleshooting Cloud Application(18A)
• Running Diagnostic Tests to know the Issues in Application.
• Create, configure and tune weblogic domains/applications for performance
• Work with vendors and developers for application related issues.
• Deployment and troubleshooting of JAR, WAR, and EAR files in domain and clustered environments
• Code deployments/promotions, performance monitoring and performance tuning
• WebLogic Administration, Monitoring and Troubleshooting using Admin Console and JMX.
• Cluster Configuration
• Creating security roles, group policy, user authentication, aduting and authorization
• Node Manager Configuration
• Installed, configured, and maintained Oracle 10g and 11gR2.
• Developed the ODI interfaces and Oracle Interfaces along with technical designs using Custom Development methods.
• Applied CPU patches.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Performed block recovery using RMAN.
• Moving data between databases using Data Pump.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing
• Co-ordinate with Oracle Support

Confidential, Tennessee

Oracle DBA

Responsibilities:

• Applying the Online Patch using Adop session.
• Applied the patches in Fusion Middleware home
• Good knowledge in applying the patch in 12.2.4 in Production using Adop
• Performed cloning from PROD to UAT/Test server.
• Issue resolved in invalid objects tables.
• Developed ODI interfaces to get Payroll Translator payment files for various business modules like Projects, General Ledger and Payments.
• Oracle Technologies have been base technical skill comprises Oracle Development Suite and Databases, Oracle Data Integration.
• Monitoring of concurrent managers and concurrent requests from fronted and backend.
• Resolved the view log/out files issues of concurrent requests
• Applying patches to resolve different functional, technical and other application related issues.
• Monitoring Concurrent Manager activities
• Monitoring and Troubleshooting of Apache, Forms, Conc. Manager and Database related issues
• Compiling invalid objects (manually and also using adadmin)
• Performance Tuning and Maintenance for all database
• Doing all R12 SYSADMIN activities like user ID and responsibility creation,
• Assignments

Confidential, TX

Oracle Apps DBA

Responsibilities:

• End to End Implementations for TEST,UAT and PRODCUTION
• Multinode installation in Production.
• Cloning 12.2.7 single node
• Installing 12.2.0 on Linux 6.5(64-bit) Fresh Instance.
• Installing 12.2.0 with Arabic Languages.
• Performance Tuning in Concurrent programs
• Enabling Online patching on 12.2.0.
• Upgrading the 12.2.0 to 12.2.7 using online patching.
• Applying the Patch using ADOP Online Patching.
• Upgrading NLS languages for 12.2.5
• Applying the TSP patches on Arabic Languages,
• Upgrading WebLogic 11.1.1.9
• Upgrading Forms and Reports using opatch

Confidential

DB Engineer

Responsibilities:

• Performed an Upgrade of Oracle Application from R12 (12.0.6 to 12.1.3) in production
• Performed an Upgrade of DATABASE (10.2.0.4.0 to 11.2.0.3) in production
• Monitoring Concurrent Manager & its operations like starting/stopping
• Maintaining the Users issue in production
• Oracle EBS Cloning- Used Rapid clone utility to clone production EBS to non-production, was also involved in post cloning activities
• Performing the Rman Backup in production weekly once
• Worked as application DBA to resolve performance issues, user issues and network related issues.
• Maintaining the ORACLE database Health checkup
• Maintaining the Tablespace, alert log files, concurrent log files
• Performing solved the Users issue in production.
• Monitoring and fixing issues related to backups
• Provided Maintenance and troubleshooting support for EBS- Resolved Concurrent Manager and concurrent requests related issues. Worked on Concurrent manager startup issues and various performances and long running issues reported by users. Also worked on issues related to application performance issue, login issues etc.
• Resizing the data files, adding new data files to the tablespace as per the necessity.
• Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, J-initiator and database) Interacting with users/developers and resolving their regular Service requests
• Troubleshooting Problem in performance tuning and concurrent manager requests,
• Worked on Backup and Recovery-Configured backups using RMAN and custom scripts. Recovered using hot/cold/full and incremental backups
• Daily Maintenance of the Applications and Database

Confidential

DB Engineer

Responsibilities:

• Installed and configured multiple applications as part of the engagement that includes Fusion Applications Provisioning Framework, Transactional Database for Fusion Applications, Fusion Applications RCU, Identity Management RCU
• Installed and configured Oracle HTTP Server as the entry point, Oracle Identity and Access Management Components.
• Created identity and policy stores for Fusion Applications.
• Creating the WebLogic Server Domain for Identity Management
• Installation, Configuration, Troubleshooting FMW Server.
• Manage and perform patching/security fixes/upgrades to Weblogic environment.
• Creating Nodemanager in weblogic server
• Install Oracle SOA Suite 11g
• Deploy SOA Composite Applications
• Backup the Manage Server Domain in weblogic.

Confidential

Oracle Apps DBA

Responsibilities:

• Production Support DBA -Provided 24*7 Support for 45+ instances of Oracle databases and Oracle EBS Applications
• Backup and Restore of database using RMAN UTILITES.
• Interacting with users/developers and resolving Service requests
• Cloning / backups (cold & hot)for PROD server.
• Monitoring Concurrent Manager & its operations like starting/stopping.
• Administered and Troubleshooting of Oracle applications Server issues.
• Resolution of Concurrent Manager and DBA issues.
• Troubleshooting production issues for slowness of the application.
• Sys Admin functions like Creating Users, Creating responsibilities and Menus.
• Performed upgrading Oracle Application from 12.1.1 to 12.1.3
• Creating Custom Top as per business requirements
• Generating and analyzing AWR reports.
• Configured Parallel Concurrent Processing, Debugging Concurrent Managers and requests

Confidential

Oracle Apps DBA

Responsibilities:

• Performed an Upgrade of Oracle Application from 11.5.9 To 11.5.10.2 Multimode (PRODUCTION) Environment.
• Resizing the data files, adding new data files to the tablespace as per the necessity.
• Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, J-initiator and database)
• Applying various applications patches to the instance
• Supporting users across all the DEV instances.
• Monitoring Concurrent Manager & its operations like starting/stopping
• Users Administration (Roles and Profiles)
• Installed and used RMAN for taking the backup of Oracle9i Databases
• Applied language NLS patches on Multi-node environment
• Configured Parallel Concurrent Processing, Debugging Concurrent Managers and requests
• Experience with AD utilities of Oracle Applications environments.
• Oracle Application 11i, R12 single node Installation, Multi-node Installation
• Migrate Concurrent Program using FNDLOAD and Deployment of Customized forms in Production Environment

Confidential

Oracle Apps DBA

Responsibilities:

• Installation of Red Hat Linux AS 5.x in HP DL 360, 380 and 580 server
• Using Production APPS backups to create development & UAT environment
• Installation of Oracle Apps 11i/R12 on Red Hat Linux AS 5.x to create vision instance
• Applied patches into database using Opatch and application of mini-patch using adpatch
• Sysadmin responsibility to configure SMTP in workflow email and creating new users
• Implemented Oracle Physical Standby database using Data guard.
• Re-org of tablespacesincase of fragmentation or when purging.
• Implementation of RMAN as a backup.
• Cloning of Apps environment to development and UAT as required
• Implemented Data Guard using physical standby database.
• Sys Admin functions like Creating Users, Creating responsibilities and Menus.
• Defined new concurrent managers, tuned concurrent managers, defined work shifts and set incompatibility rules for efficient concurrent processing.
• Database Level Patching using Opatch
• Proactive Monitoring of the Database, Application with monitoring tools
• Coordinating with Oracle Support for logging tar and knowledge based search to find solution to the problems that are occurring in the live server and while Applying Patches (Tar, Bug Search, User Forum Participation)

Confidential

Oracle DBA

Responsibilities:

• Involved in DBA support for 24/7 Production Environments
• Taking full Database and archive log backup through RMAN by weekly incremental backup and monthly full backup.
• Monitoring space of Table spaces, data files, undo and temp Table spaces.
• Creating users and granting roles to them.
• Granting specific privileges and roles to the users.
• Managing the Storage Clause for objects depends on the application.
• Monitoring the objects growth and space management.
• Responsible for taking logical backup using Export/import and maintaining the integrity of data of individual user.