SUMMARY

• Oracle RAC release version: 8i, 9i, 10g, 11g, 12c
• Total DBA experience: 9 years
• Oracle Database Backup Recovery: 9 years (RMAN backup/recovery, NET BACKUP set up)
• Performance tuning/Monitor Tools: 8 years OEM Grid, Toad, Quest Central/Performance Analysis
• Operating Systems:Linux: SLES 9,10&11/RHEL 4&5, 5.5, AIX, Solaris and HP - UX
• Shell Scripting. 9 years KSH, Bourne shell and Bash
• Oracle Data Guard and ASM: 9 years
• Total RAC experience: 9 years of 9i, 10g, 11g, 12c
• Fast Recovery Area:4 years
• RMAN/NETBACKUP:8 years
• 12c Pluggable Databases:1 year and
• Oracle 11g experience:7 years 11g from beta stage to 11.2.0.3 release
• Oracle 12c experience:2 years from 2012 till present
• External Tables/Data Pump:1 years/8 years
• Programming Language:Python, SQL, PL/SQL, c programing

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Senior Oracle Database Administrator

Responsibilities:

• UNIX shell scripting for implementing weekly code release and replicating data into production database.
• Provided daily Oracle DBA support, performance tuning and monitoring of daily schedule batch jobs.
• Scheduled, troubleshoot, fix and restart failed RMAN tape NetBackup level 0, 1, & 2 (Incremental, differential and archive log redo log backups), also restart and reschedule backups when they failed.
• Fix and re-create index issues especially constant “index unusable”.
• Uses OEM grid control for managing 29 production Oracle databases between (1 - 49 terabytes sizes) databases, hosts and other related components.
• Work on validating constant invalid database objects issues, by using scripts to generate and re-validate them during or after code releases.
• Gathered statistics on stale tables, indexes partitions and sub-partitions.
• Administer all nightly scheduled (weekly & monthly) production database code releases implementation.
• Support developers for efficient SQL tuning and performance monitoring, create explain plan to Troubleshoot database designers SQL and PL/ SQL code issues.
• Use OEM grid control, SQL*Plus and toad to monitor and troubleshoot database performance issues such as high CPU utilization, long running queries and batch jobs, blocking locks, create explain plan to tune badly written SQL statements, generate ASH reports etc.
• Work on ticketing request and request directed to the DBA email queues.
• Member of the weekly On-call database support rotation within 9 DBA members.
• Sometimes volunteer to baby sit the pager for DBA colleagues with family emergencies whenever.
• Documentation and review of spool (logs) from Putty to notepad of daily work activities to keep track of what was done to review them in case something goes wrong.
• Read documentations on oracle metalink and OTN websites for Oracle best practices and solutions to different kinds of oracle database situations.
• Dialing into the conference bridge line during scheduled and unscheduled emergency conference calls.
• Weekly implementation of import/export and data pump backups of key database schemas before jump starting the weekly code release onto production.
• Added ASM storage whenever spaces are used-up in production.
• Lead Database Administration night shift operations.

Confidential, Allentown, PA

Senior Oracle Database Administrator

Responsibilities:

• Recover oracle RAC database 11.2.0.2 release on AIX Version 5.3 with RMAN.
• Co-installed with another DBA oracle 12c RAC on a 2 node cluster of Linux Red hat 5.
• Also create oracle 12c pluggable database on
• Resolve performance issues by generating database snapshots info from OEM grid control AWR reports.
• Restore & recover RMAN database backup.
• Co-setup ASM database and create disk groups for a RAC Cluster ware.

Confidential, King of Prussia, PA

Senior Oracle Database Administrator

Responsibilities:

• Involved in Data Center move.
• Use OEM Grid Control and SQL*Plus to manage and monitor 1,000+ production, QA and development Oracle RAC 10g & 11g(10.2/11.2) databases between 4 - 32 terabytes sizes databases on HP-US and AIX platforms.
• Applied quarterly patches to oracle RAC databases, Database replication.
• Trained DBAs at company work locations in Poland, London, Malaysia and India via video conferencing about RMAN disk to disk setup, primary database failovers and Data Guard switchover to primary and vice-versa by scheduling pilot and dry-runs testing.
• Created databases and perform database and schema export/import using Data Pump.
• Configuring RMAN parallelism and backup compression, monitor & restart failed RMAN backup failures (Level 0 & 1) (weekly & daily) Disk to Disk backups and worked with Net backups Admins.
• Setup/Tested database switchover and failover processes.
• Monitored all database disks/tapes backups for production, development, QA and test databases.
• Install and manage all RAC 10g/11g databases.
• Creating/managing UNIX shell script and setting up bash Jobs to support oracle database services.
• Used Unix/Linux OS commands to administer database tasks.
• Used shell scripting to automatically kick-off RMAN backup process daily from CRONTAB i.e. deleting old achieve logs, backup new log files and completing database backups to tape and disk through RMAN.

Confidential, Philadelphia, PA

Oracle Database Administrator

Responsibilities:

• Involved in weekly on-call database support rotation.
• Upgraded database to Oracle 10g RAC.
• Recovered databases from backup via RMAN to upgrade onto Oracle 10g RAC 10.2.0.4 from 9i.
• Installed and deployed OEM agent and configured database into Oracle EM Grid Control.
• Generated database workload statistic report from AWR, ADDM and Stats Pack on daily basis.
• Recovered failed database from backup tape sets, and database refresh upon request from users.
• Applied Oracle quarterly security patches (PSU/CPU) to ALL databases.
• Unix/Linux shell scripting experience and setting up bash Jobs.
• Strong knowledge in using the Unix/Linux OS commands to administer databases.
• Create directories and files permissions and set up Oracle environment variables, starting and stopping Oracle services on Linux platforms during backup failures and upgrades. Knowledge of Unix/Linux root access.

Confidential, Burlington, NJ

Oracle Database Administrator

Responsibilities:

• Refresh and duplicate RAC database from VERITAS NetBackup using RMAN.
• Strong experience adding nodes to an existing RAC database setup.
• Experience in Unix/Linux shell scripting and setting up bash Jobs to automatically startup Oracle services during failure i.e. Oracle Cluster Ready Services (CRS), ASM databases, RAC databases, Listeners.
• Experienced in Unix/Linux OS commands to administer databases.
• Use shell scripting to administer Oracle services.
• Uses ASM commands such as ASMCMD to manage and create ASM diskgroups.
• Create directories, files and environment variables setup, starting/stopping oracle services.
• Strong understanding of creating UNIX accounts.
• Managed physical and logical disk systems and their impact on database performance.
• Install, configure and manage Oracle RAC 10g/11g databases in a 10 nodes Cluster ware setup.
• Experienced with RMAN backups/restore and VERITAS Net backup tapes.
• Applied patches to Oracle 10g/11g database cluster in CRS, ASM, RDBMS homes.
• Directed migration of Oracle database 9i to 10.2.0.3 and from 9i to Oracle 11gR1 RAC directly including, setting up and creating of 11g CRS and ASM databases.
• Setup of Oracle Net Services, tnsnames.ora and listener.ora.
• Experienced with redo data Transport Services.
• Use traditional Import/Export and data pump expdp/impdp.
• Experience with oracle SQL tuning.
• Build and manage Oracle data warehouse database.
• Experience setting up Data Guard databases on the opposite RAC cluster for every production & test database.
• Experience Migrating, upgrading and managing 10g RAC to 11g RAC database and ASM using RMAN.