SUMMARY:

• Over 6 years of IT experience in Oracle Database Administration on various versions (10g/11g/12c) encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Patches, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning and operating systems Linux.
• Experience as Oracle DBA with primary proficiency in installing, upgrading, administering of multiple Oracle Enterprise Edition 10g, and 11g& 12C databases in Red Hat Enterprise Linux/Oracle Linux.
• Worked on migrating servers from VMware environment to OVM environment (6.9) from test instances through Production environment.
• Experience in Database Administration activities such as patch installs, cloning, backup and recovery of mission critical databases, performance tuning, script development.
• Experience on Oracle 10g and up gradation of standalone databases to 11g environment.
• Oracle application R12.1.3 and R12.2.5 cloning/refresh of both database and application.
• Strong Knowledge in various states of System Development Life Cycle (SDLC) like System Analysis, Applications Design, Development, Integration & System Testing Support of Oracle 10g and Oracle 11g in Production, Staging and Development environments.
• Proficient in Installation and Configuration of 11g R2 cluster ready services and database in NFS and ASM file systems.
• Implemented DMZ configuration on oracle application R12.1.3.
• Migrated database from non - asm to asm (automatic storage management).
• RAC with proficiency in setting up and administering 10g RAC and 11g/12c RAC with Automatic Storage Management (ASM).
• Experience in maintaining OEM and Oracle Cluster ware using CRSCTL/SRVCTL.
• Experience in implementation of Oracle Backup and Recovery strategies.
• Proficient in implementing and maintaining Database Security (Users, Roles, Privileges), space management (logical structures such as table spaces and rollback segments) and auditing of users.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.
• Experience in Oracle Grid Control 11g/12c Installation and Configuration
• Extensive experience Real Application Clusters (RAC), ASM, RMAN, Data Guard and maintain Standby database.
• Implemented development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
• Experience in using 10g & 11g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM, Grid Control Monitoring and Recycle Bin.
• Experience in database migration including migration from single instance databases to multi instance databases.
• Proficiency in standby database (Data guard) installation, configuration, maintenance, and administration for disaster recovery.
• Experience in Backup and Recovery plans, testing and implementation.
• Experience in performing disaster recovery and taking backups, both cold and hot.
• Experience in using Oracle Recovery Manager (RMAN) extensively for backup and recovery.
• Expert in effective troubleshooting of problems encountered on a daily basis in production & development database environments along with the problems encountered in performance monitoring.
• Experience in Project Documentation, creation and adhering to standards of Implementation and Project management.
• Applied patches and involved in patch setup up gradation.
• Experience in configuring Data Guard and ASM.
• Experience in working 24x7 production environment and providing on-call and day-to-day support.

TECHNICAL SKILLS:

Operating Systems: Red Hat Linux RHEL 5.x,6.x and Oracle Enterprise Linux 5,6

RDBMS: Oracle 12c/11g/10g/10gRAC.

Oracle Application: 11i, R12

Languages: SQL, PL/SQL, UNIX Shell Scripting.

DB Management: TOAD 9.5, Enterprise Manager grid, OEM, Grid control (RAC), Nagios Monitoring tool. Stat tool.

Tools: /Utilities: RMAN, OEM,, SQL*Loader, ASM, Export/Import, TOAD, Patch Management, JDBC, Data pump, Data guard.

Ticketing Tools: BMC, Track it.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.

PROFESSIONAL EXPERIENCE:

Confidential, Appleton, WI

Oracle Application DBA

Responsibilities:

• Installation and configuration of Oracle database 11g and 12c on various OS platforms like Red Hat Linux/Oracle Linux.
• Controlled and monitored user access to the database. Optimized the performance of the database. Tuned SGA data dictionary and set database parameters
• Allocated separate rollback segments for the Batch processing jobs in other to speed up processing.
• Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF used to analyze timing and execution plans for SQL query to tune SQL statements.
• Oracle application cloning / Refresh of 11i, R12.
• Oracle Application patching experience with various ad patch options.
• Oracle database patching opatch utility.
• Oracle web logic server administration of SOA.
• Implemented DMZ configuration on oracle application R12.1.3.
• Vertex and tax uploads to database.
• Upgraded RAC database from 4 manual and DBUA.
• Worked with Oracle support to fix the issues faced daily.
• Worked on printer issues and bounce of cups services.
• Database upgrades on standalone databases.
• Migration of databases between operating systems end to end.
• Performed Active database duplication.
• ASM installation and administration.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.

Environment: Oracle 12c, 11g R1, R2, RHEL 5.5, SQL*Plus, Track it ticketing tool, Nagios, RMAN, ASM Packages, OEM 11g, OEM 12c, 11g Grid Control, Oracle RAC Grid Control, and Data guard.

Confidential

Oracle Application DBA

Responsibilities:

• Worked under 24 x 7 production database and on call-support.
• Installed, configured, and maintained Oracle 11g & 12c.
• Migration of instances (databases) from one server to other server.
• Upgraded database from Oracle 11g to 12c in one of the iteration on test instance.
• Maintained data guard of oracle11g environment.
• Involved in NLS implementation of Italian and French in oracle application R12.1.3.
• Created database links, Indexes, and Views on database objects.
• Knowledge on RMAN backup and recovery.
• Experience on RMAN and manual refresh.
• Fusion Middleware web logic and SOA cloning.
• Performed system administration activities like creating users, assigning responsibilities, and changing profile options.
• Knowledge on Active database duplication.
• Cloning from RAC to Non-RAC instances.
• Cloned Oracle application environment (R12) from production to development and test instances.
• Changed passwords using FNDCPASS utility.
• Applied HRMS patches to Oracle application and data install on oracle application database.
• Implemented DMZ configuration on oracle application R12.1.3.
• Vertex upload (tax) to database.
• Migrated database from non-asm to asm (automatic storage management).
• Oracle application R12.1.3 and R12.2.5 cloning/refresh of both database and application.
• Worked on SOA, Sabrix and OTM (Oracle Transportation Management) features which are integrated with EBS environment.
• Migrated the code to Production and other test instances through manual and stat tool.
• Merged patches in Oracle application.
• Applied database patches using opatch and application patches using ad patch.
• Interacted with Oracle Support to resolve issues.
• Managing Tablespaces (creating tablespaces/adding data files to tablespace).
• Performed and managed logical backups like Export/Import, Data pump.
• Check database alert log and trace file manually to detect problems.
• Worked on printer issues.

Environment: Oracle 11gR1/11gR2, HP UX 11.31/ RHEL 5.4, Windows 2008, Data guard Grid control RMAN, Export/Import, ASM Packages. Tivoli backup, SQL*Loader, ASM, Data guard, Data pump, Oracle RAC Grid Control.

Confidential

Oracle Application DBA

Responsibilities:

• Worked under 24 x 7 production database maintenance and on call-support.
• Worked on printer issues.
• Preformed system administrator activities like creating users, assigning responsibilities, and changing profile options.
• JRE upgrade in Oracle application environment.
• Vertex uploads (tax) through sqlloader.
• Oracle applications 11i refresh both database and application.
• Migrated the code to Production and other test instances manual for the CSR (change service request) approved.
• Applied database patches using opatch and oracle application patches 11i using ad patch.
• Worked with Oracle Support to resolve issues
• Performed logical backups like Export/Import, Data pump.
• Knowledge on HOT/COLD backups.
• Check database alert log and trace file manually to detect problems.

Environment: Oracle 9i, 10g, 11g, OEM, RMAN, TOAD, Data Warehouse, ERWin, Netback up, OEM, SQL*Loader, Grid Control, RMAN, ASM, Data guard, TOAD, Data pump.

Confidential

Oracle Application Database Administrator

Responsibilities:

• Worked under 24 x 7 production database and on call-support.
• Installed, configured, and maintained Oracle 11g & 12c.
• Performed system administration activities like creating users, assigning responsibilities, and changing profile options.
• Knowledge on Active database duplication.
• Oracle application R12.1.3 of both database and application.
• Migrated the code to Production and other test instances through manual and stat tool.
• Merged patches in Oracle application.
• Applied database patches using opatch and application patches using ad patch.
• Interacted with Oracle Support to resolve issues.
• Managing Tablespaces (creating tablespaces/adding data files to tablespace).
• Performed and managed logical backups like Export/Import, Data pump.
• Check database alert log and trace file manually to detect problems.

Environment: Oracle 10g/ 11g, ASM, RAC, AWR, ADDR, OEM, RMAN, TOAD, SQL*Plus, SQL*Loader.

Confidential

Oracle Application DBA.

Responsibilities:

• Worked under 24 x 7 production database and on call-support.
• Installed, configured, and maintained Oracle 11g & 12c.
• Oracle application R12.1.3 of both database and application.
• Migrated the code to Production and other test instances through manual and stat tool.
• Merged patches in Oracle application.
• Applied database patches using opatch and application patches using ad patch.
• Managing Tablespaces (creating tablespaces/adding data files to tablespace).
• Performed and managed logical backups like Export/Import, Data pump.

Confidential

Oracle Database Administrator

Responsibilities:

• Supported (VLB) Very large database leveraging (Oracle partitioning for data management is a plus).
• Designed complex logical and physical databases requiring additional specialized technical knowledge, and coordinates database development.
• Worked with team of DBAs in Upgrade databases from oracle 10g to Oracle 11g.
• Installed and Configured in ASM (Automatic Storage Management).
• Developed or modified some Oracle backup and recovery scripts, Used Oracle backup utility RMAN. Initiating Session Tracing using AWR, ADDR.
• Analyzed, designed, created and implemented multi-faceted and complex database applications in all environments.
• Worked on Oracle Database (10g, 11g) administration (Architecture, configuration, Security Management, Performance Tuning, Backup & Recovery).
• Created Table spaces monitored the data files space, resizing and adding new data files etc.
• Created and maintained users their Roles and Profiles.
• According to requirement Granted and revoked user’s privileges, assigned Quota on users.
• Worked on User, Group, Permissions and File System management skills and Created DBLINKS.
• Responsible for Backup and Recovery of database information and maintaining Hot Backups, Cold Backups, RMAN and Logical Backups using Exports and Imports and Data Pump.
• Supported high availability database infrastructure including Oracle RAC and Data Guard technology.
• Performed database Backup and Recovery in support of business continuity.
• Managed database performance and capacity , provides plans for increases and/or decreases, ensures improvements are successfully implemented and makes tuning adjustments as necessary.
• Participates in on-call rotation and provide first line after hours support as needed.

Environment: Oracle 12C, 11g R2, RHEL 5.5/Oracle6.6, SQL*Plus, Ticketing, Nagios, RMAN, ASM, OEM 11g, OEM 12c, 11g Grid Control, Oracle RAC Grid Control, and Data guard.