We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

NJ

SUMMARY:

  • Database Administrator with 9 plus years of experience in Planning, Installation, Configuration and Upgrading of Oracle 11gR2, 10G, 9i, 8i databases and applying patches under Linux, HP-Unix, Sun Solaris, IBM-AIX and Windows platforms.
  • 4 + year’s of experience in Oracle applications DBA R12/11i configuration, Analysis, Design, Server Optimization Techniques, Production environment and Applications Support.
  • Expert in installs of release R12 12.0.4 & 12.1.3
  • Proficient in installation and upgrading Oracle Applications 11i e-business suite to R12.
  • Experience as Oracle Applications DBA providing support to many Production, Development, Test, CRP instances (Large and VLDB databases) comprising of some of the more complex and challenging environments from versions 11.0.3 through 11i with most affective modules being GL, Financials, AP, OM, INV, PO, AR, FA, MRP, ONT, MFG.
  • Good experience of setup & configuration, implementation of (Oracle 11gR2 RAC eight-node on Linux with ASM)
  • Proficient in Oracle Database Administration activities such as Upgrades, Patches, TAR support,
  • Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation.
  • Migrating and Upgrading the Databases between different environments and versions.
  • Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases.
  • Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
  • Design, document, implement, and maintain all backup, recovery including disaster recovery.
  • Procedures using RMAN, VERITAS Net Backup.
  • Extensively worked on Oracle Utilities Data Guard, Data Pump, Flashback, SQL LOADER and RMAN.
  • Strong Exposure on High Availability Concepts (RAC, Standby), Database Cloning, and Oracle Streams.
  • Good experience in applying Critical Patch Update (CPU Patches) on Databases.
  • Good experience in Oracle Clustering services (CRS), VERITAS Cluster Services (Quick I/O file systems) and High Availability features. Extensive Knowledge of 10g and 11g ASM.
  • Exposure in extracting, transforming and loading (ETL) data from other databases and text files using SQL* Loader utility and Oracle ETL tools.
  • Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems.
  • Strong programming experience in creating Packages, Stored Procedures and Functions, Database Triggers.
  • Strong knowledge and experience of managing Oracle 9i, 10g and 11gR1, 11gR2 RAC environments using the OEM Grid Control tools.
  • Proactive monitoring, identifying areas that need to be improved in the application and database using STATSPACK, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring.
  • Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
  • Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
  • Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
  • Experience in using GoldenGate to support data replication in the Oracle database environment.
  • Good experience in applying Critical Patch Update (CPU Patches) on Databases.
  • Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR, TKPROF and ADDM reports.
  • Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, SQL DEVELOPER, RMAN.

TECHNICAL SKILLS:

Operating System

Applications

RDBMS

Oracle Tools/Utilities

Backup Tools

Languages

UNIX,LINUX,Solaris, AIX,HP-UX and WINDOWS NT/2000,XP,2003

Oracle EBS 11i/R12, Oracle Application Server 10g AS and 9iAS

ORACLE 11g/10.x/9.x/8.x/7.x, Informix Dynamic Server 9.40.UC6 (IDS) and SQL Server 2008/2005.

RMAN, EXP/IMP, EXPDP/IMPDP, SQL * Loader,

DBVERIFY, TKPROF and STATSPACK,

AWR, ADDM, OEM , ODM, ERWIN, SQL Developer, TOAD.

VERITAS Netback up 5.3/6.0, BCV Snapshots, Legato

SQL, PL/SQL and UNIX Shell

PROFESSIONAL EXPERIENCE:

Confidential, NJ ,Oracle Apps DBA,

(Oracle Apps 12.1.3/Cloning/Patching/Performance Tuning/SQL Tuning/ Migration)

Project Atlas Physical separation: McGraw-Hill separated from it’s parent company McGraw-Hill Financial. Both the companies were using same R12 ERP system. They had to be separated in the ERP system by creating a new ERP system for one of them.

Project Atlas Data center migration: After physical separation of the two companies, McGraw-Hill had to be moved to a new Data Center which implied new domain name and new IPs for the servers.

Responsibilities:

  • Supporting Oracle Applications (R12.1.3) and Single Sign On (SSO) related FMW components.
  • Providing all round DBA support to resolve DB, Application, Tech Stack outages on production, performance, quality assurance, development, test and Staging On demand Customer environments.
  • Implemented Oracle Patches CPU & PSU on the Compliance databases Device a plan to patch them.
  • Involved in Production Support for Critical ERP Application and Databases when needed.
  • Daily responsibilities include troubleshooting and restoring Oracle Applications components Apache, Forms, Reports, Concurrent Managers, Workflow Managers, Single Sign-on.
  • Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
  • Worked on AD utilities like adpatch, adadmin, adctrl, adrelink, adsplice, admerge, adclone, adconfig, etc.
  • Cloning EBS (hot/cold).
  • Very strong in Auto Patch, Upgrade, cloning.
  • Apply DB and Application patches.
  • Configure SSL for Oracle EBS R 12.1.3
  • Build full monitoring system to monitor Oracle APPS and DB availability and performance.
  • Improving Oracle Apps and DB performance.
  • Apply DB and APPS patches .
  • Management of schemas, objects & Partitioning the tables & indexes.
  • Troubleshooting all DB and APPS technical issues .
  • Develop and implement full Backup and Recovery strategy using RMAN.
  • Checking Databases Backup and Restore validity periodically and Data refreshes from Production to Non-Production environment.
  • Enhance APPS cloning process by build scripts to automate cloning.
  • Enhance APPS patching process by build scripts to automate applying patches for EBS.
  • Configure Load Balancer for Oracle EBS R12 Application tier.
  • Scheduling jobs through oracle JOB SCHEDULAR, Crontab (UNIX).
  • PVCS Version Manager for revision control of files, in particular source code files.
  • Using PPM managed a crew of 8 people and the tasks and progress of all projects during the workday; handled all issues, concerns and problems within the group.
  • Using SDM12 tracking system managed and maintained lists of issues, as needed by an organization.
  • Unique individual who has both quality assurance and software configuration management experience. I also have administrative experience for tools such as PVCS Tracker and VM, Jira, and Subversion.
  • Communicated with guests, neighbors, and special event hosts to promote positive public relations.
  • Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.
  • Good presentation and communication skills to provide support to the Customer.
  • Ability to work flexibly as a team member.
  • Dedication with an inner drive to succeed and accomplish goals.
  • Ability to perfectly plan and execute the given job to perfection.

Environment: Oracle Applications R12 (12.1.3.) Oracle 11.2.0.3/11.1.0.7 , SOLARIS, LINUX, TOAD, SQL Developer, PPM, PVCS, SDM12.

Confidential , MI

Oracle Apps DBA,

(Oracle 11gR2 RAC/ASM/DATA GUARD/RMAN/SQL Tuning/Upgrade/Migration/Space Estimation/24*7 support)

Responsibilities:

  • Supporting Oracle On demand Customers running various versions of Database (Oracle 9i, 10g, 11gR1 and 11gR2), Oracle Applications (11.5.8, 11.5.9, 11.5.10 and R12.x), Tech Stack (Discoverer, iAS, JDK, Jinitiator, and Developer 6i) and Oracle Application Server.
  • Providing all round DBA support to resolve DB, Application, Tech Stack outages on production, development, test and Staging On demand Customer environments.
  • Daily responsibilities include troubleshooting and restoring Oracle Applications components Apache, Forms, Reports, Concurrent Managers, Workflow Managers, Discoverer plus/viewer, iAS, Single Sign-on.
  • Experience in 11i (11.5.10) to R12 (12.0.4) upgrade and applying patches up to this release 12.1.1.
  • Upgraded R12 from 12.0.4 to 12.1.1.
  • Running autoconfig, setting up DMZ, Discoverer, Oracle Sysadmin activities and other maintenance activities.
  • Performed Oracle Database and Applications Installations, Upgrades, Cloning, done extensive patching (both DB and Applications), applied CPU patches, Family Packs, Patchsets and single off patches.
  • Installation of 11.2.0.3 RAC (3 node) from the Scratch and the maintenance of the high available Databases.
  • Migrated OCR and VOTING disks to newer disks by adding newer disks from SAN and dropping the old disks by using ASM’s native rebalancing feature.
  • Installation of ASMLIB rpm packages. Initialize the asmlib using oracleasm init command. Portioning the disks using fdisk/dd command.
  • Installing and configuring Grid Infrastructure & Database software. (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole – bugs, network issues, configuration files issues, OCR issue,
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Performing Backup/Restore of all the Oracle databases using RMAN.
  • Performed migration of the oracle databases whose database sizes vary from 300 to 500GB from Oracle 10.2.0.4/11.1.0.7/11.2.0.1 to Oracle 11.2.0.3 using Exp/Imp and Expdp/Impdp.
  • Implementing Physical and Logical Standby setups Data guard Configurations.
  • Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
  • Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.
  • Ran Scripts for Health Check on Exadata Storage Servers.
  • Implemented Oracle Patches CPU & PSU on the Compliance databases Device a plan to patch them.
  • Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
  • Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
  • Involved in Production Support for Critical Application Databases when needed.
  • Installing agent 12c on the server. Adding High Available Database with CRS, Scheduling Backups through OEM12c.
  • Scheduling jobs through oracle JOB SCHEDULAR, Crontab (UNIX).
  • Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases.
  • Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.

Environment: Oracle Applications 11i (11.5.10) R12 (12.1.1.) Oracle 11.2.0.3/11.2.0.1/11.1.0.7/10.2.0.4 , OEM 12c, LINUX, IBM AIX, TOAD, SQL Developer.

Confidential , IL

Sr. Oracle DBA

(Oracle 10g/11g , 11i/R12, RAC/ASM/DATA GUARD/RMAN/SQL Tuning/Upgrade/Migration/Space Estimation/24*7 support)

Responsibilities:

  • Worked on Oracle Database and EBS cloning using RMAN and Rapid Clone.
  • Worked in migrating and Deploying code Using KINTANA.
  • Installed, Configured, Administered and upgraded multiple versions of Oracle Databases.
  • Installed and Configured Oracle APEX, Oracle Enterprise Manager 12C.
  • Created multiple scripts and Custom OEM jobs to backup databases using RMAN.
  • 24x7 On-call rotation.
  • Monitoring and Managing OEM Alerts like Space Utilization, Mount Point filling up, tablespace issues.
  • Scheduling and monitoring ETL jobs on TDE.
  • Worked on Cross Platform Upgrade of Oracle Enterprise Data Warehouse. Upgraded DW Database 10GASM on HP Unix to 11g ASM on OEL.
  • Experience working on Serene Masshups for taking care of any change management, SR , SC , RFC , etc.
  • Experience in Installing and Configuring ASM.
  • Worked on Oracle EBS performance issues related to Concurrent Managers, Form issues and resolved within SLA.
  • Worked on Oracle Tuning utilities like AWR, ASH, TRACE, TKPROF, ADDM etc.
  • Responsible for managing production, development & test databases and applications.
  • Implement Hot, Cold and Logical backup plans.
  • Worked on Daily maintenance tasks like Tablespace and Datafile creation, resolving blocking and locking issues, troubleshooting Workflow mailer issues etc.
  • Worked on SYSADMIN tasks like user creation and Granting them privileges and roles.
  • Worked on Oracle EBS upgrade project (from 11i to R12).

Confidential , NC

Oracle DBA

(Oracle 9i/10g RAC/ASM/DATA GUARD/RMAN/SQL Tuning/Upgrade/Migration/Space Estimation/24*7 support)

Responsibilities:

  • Involved in 24x7 Oracle Production Database Administration.
  • Involved in installation, configuration and support of Oracle 11g RAC.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
  • Performance tuning for optimized results using Explain Plan, SQL*Trace, TKPROF and Stats pack.
  • Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
  • Design, document, implement, and maintain all backup, recovery including disaster recovery procedures.
  • Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard, Replication.
  • Created physical standby database (for disaster recovery) from hot backup of primary database.
  • Resolved gaps between primary and standby databases (Gap Resolution).
  • Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
  • Creating Tables, indexes, & triggers to assist developers.
  • Managing, troubleshooting and resolving oracle database, RAC and applications issues.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Was involved in developing a disaster recovery (DR) plan.
  • Experience with Oracle Golden Gate software.
  • Proficiency using Oracle Golden Gate and csscan utility.
  • Implemented Oracle Golden Gate installation, configuration, troubleshooting GG issues
  • Performing Backup/Recovery of all the Oracle databases using RMAN.
  • Scripts for Health Check of Databases.
  • Reading Alert Logs and User trace Files and Diagnosing the Problem.
  • Writing UNIX shell Scripts and Scheduling through crontab.
  • Providing Solutions to the Problems Faced by end Users or Programmers.
  • OS level activities like space monitoring of Mount points.
  • Scripts for Analyzing of Tables and Rebuilding of Indexes.
  • Taking periodic backup of the database and the software.
  • Automation of Backups.
  • Interfacing with Oracle Corporation for technical support.

Environment: Oracle 9i,10.2.0.2,11.1.0.7,Maestro 7.0,HP service desk, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3,WebSphere,Solaris5.9,Informatica Power center 8.1x and 8.6.

Confidential , FL

Oracle DBA

(Oracle 8i/9i/10g /DATA GUARD/RMAN/SQL Tuning/Upgrade/Migration/Space Estimation/24*7 support)

  • Configured Standby Database in manually managed mode. Shell scripts and Cronjobs are written to transfer the logs to standby site (Disaster Recovery site) at frequent intervals and apply to the Standby Database as per Business requirements.
  • Scripts are developed to monitor the growth of the Database and purging policy is implemented at frequent intervals by raising change.
  • By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
  • Performed Smoke testing during the installation of every full build for application to validate the fitness of the application for testing.
  • Functionality testing has been performed against the identified modules.
  • Volume management using Verities Volume manager to configure Disk group.
  • Configured Verities Net Backup R3.2 is to automate the physical Backup of the Database.
  • Implementation of RAC, ASM, DATAPUMP,FLASH BACK Recovery
  • Configured Standby Database in manually managed mode. Shell scripts and Cronjobs are written to transfer the logs to standby site (Disaster Recovery site) at frequent intervals and apply to the Standby Database as per Business requirements.
  • Also involved in SQL performance tuning.
  • Creation of database links
  • Estimating the size of Databases.
  • Creating Databases
  • Migration of Oracle DB from 8.1.6.3 to Oracle 9.1.0.4
  • Upgraded the databases from 9.2.0.7 to 10.2.0.2
  • Monitoring Standby Database whether all the logs transferred to Standby site and applied properly.
  • Checking the Alert Logs of production Databases for any errors reported by Oracle.
  • Adopting change control Mechanism (Lotus Notes Server) for replicating the changes made to the production Databases.
  • Export and Import of databases from one database to another databases.
  • Monitoring the performance of production database through Instance Monitor (Quest Tool) and growth of the database and suggesting for change in parameters if required.
  • Writing the shell scripts to automate the Backup and copying the production copies to Test environment. (Scripts to copy from one test database to another database)
  • Attending specific requests from online, bug fixing, Bulk rate, Data warehouse Teams.

Environment: SQL Navigator, Oracle 8i, 9i, 10.0,WebSphere, data Stage, Remedy, clear quest, Sun Solaris, H.P, Windows2000, PL/SQL, Shell Scripts, Maestro,ERWin4.0, Informatica Power Center ,TOAD.

Confidential TX

Oracle DBA

(Oracle 8i/9i/10g /DATA GUARD/RMAN/SQL Tuning/Upgrade/Migration/Space Estimation/24*7 support)

  • Database Design, Backup & Recovery.
  • Tuning the Database and Analyzing the Database.
  • Coding PL/SQL & Shell Scripts, Design/Code reviews.
  • The activities included the database administration of the various databases assigned to the division for the internal as well as external clients.
  • Installation of the Databases, Environment Building to OFA compliancy.
  • Backup Cold, Hot, Online, Exports, Performance Tuning, Remote sessions tracing.
  • Recovery Manager (RMAN) Implementation and strategies, Various Database Recovery scenarios verification in advance.
  • Altering the Database objects and files during maintenance.
  • Implementation of RAC Technology.
  • Database Maintenance, Data warehousing. Data Modeling using Erwin.
  • Software design of medium/large business applications, Design methodologies.
  • Database (SQL) design, E-R Modeling, Design and Development Of database design.
  • Jobs Scheduling, Exports/ Imports, Space Management.
  • Hot and Cold Database Backups and recovery, Shell Scripting, Restoration Tuning Memory.
  • Troubleshooting and maintaining, Database Recovery, Automation of the Database Start up and Shut down. Database Migrations.
  • Writing Stored Procedures, functions, packages, triggers.
  • Managing the network and service changes on the network of the databases.
  • STANDBY Database implementation and Automation of the process (KSH, LOADER, PL-SQL scripting combination) of ftp download of files to proper load and update on tables.
  • Writing shell scripts, Loading data into the database from the flat files with SQL*Loader.

Environment: Solaris 2.6/2.8, Oracle 8.0.5, PL/SQL, shareplex, Perl, Windows NT shell scripting, TOAD.

Confidential INDIA

Oracle DBA/Developer

  • Involved in 24x7 Oracle Production Database Administration.
  • Performing all the Database Administration activities like installation, configuration, cloning, patching, upgrade, performance tuning, backup & recovery, space management in database, user and roles administration, schema management.
  • Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
  • Monitored Production Databases, Performed performance tuning, added data files, resized segments, and tablespaces.
  • Installed and configured Oracle 10g.
  • Migrated Oracle 9i database to Oracle 10g.
  • Storage and space management including table spaces and data files.
  • Monitoring Database for fragmentation and correcting them.
  • Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan
  • Monitoring and Management of table space growth, extent growth.
  • Planning and implementation of Backup and recovery procedures and Maintenance of Database.
  • Performed Backup/Recovery using RMAN.
  • Wrote scripts for Startup, Shutdown and automation of backups.
  • Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
  • Prepare the documents of the process and knowledge transferring about the project to the new team members.
  • Involved in the process of tuning and refining queries of various applications.
  • Written scripts for Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
  • Interfacing with Oracle Corporation for technical support.

Environment: Oracle Server 8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting

Hire Now