SUMMARY:

• I have been a DBA for 14 years with extensive experience installing, configuring, and maintaining Oracle - based technologies including 8i, 9i, 10g, 11g and 12c RDBMS, Fusion Middleware, and WebLogic servers.
• I have extensive experience performing database and application server upgrades, managing backups and cloning through RMAN, and monitoring system and database performance tuning through tools like Database Console or Oracle Grid Control.
• I understand RAC, and high availability.
• I have been involved in numerous upgrades and cloud migrations.
• And done a lot of database recoveries.
• I understand how to setup database to replicate to a target location using tools like standby data guard database, Oracle Goldengate.

SKILLS:

Oracle release versions: 8i, 9i, 10g, 11g, 12c

Total DBA experience: 14 years

Oracle Database Backup Recovery: 13 years (RMAN backup/recovery, NET BACKUP set up)

Performance tuning/Monitor Tools: 10 years OEM, Toad, Quest Central perf. Analysis, Foglight, Spotlight.

Operating Systems: Linux SLES 9,10&11/RHEL 4,5,6, AIX, Sun Solaris & HP-UX

Shell Scripting: 12 years KSH, Bourne shell and Bash

Oracle Data Guard and ASM: 10 years

Total RAC experience: 12 years (from 9i, 10g, 11g, 12c)

Oracle 11g experience: 9 years 11g from beta stage to 11.2.0.4 release

Oracle 12c experience (PDB & CDB): 5+ years from 2012 till present

Import/Export Data Pump: 11 years

OEM Grid/Cloud Control: 12 years/3 year

Cloud Engineer: 3 Years

Amazon Web Services (AWS): 3 years

SQL Server: 4 years SQL Server 2012, 2014

Programming Language: SQL, PL/SQL, c programing

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Manager Database and Application Services

Responsibilities:

• Platform Architectural Designer.
• Worked with Development team to deploy Web & Applications to new Virtual Private Servers (VPS).
• Upgraded MySQL database from 5.6 to 5.7 and MariaDB to 10.1
• Fixed MySQL component issues affecting production database.
• Implement critical metric alerts on OEM 12c for tablespaces, disk space usage, filesystems, database up/down.
• Day to day Oracle and SQL Server databases supports.
• Resolve website/Apps Performance issues.
• Participate in daily and weekly team meetings.
• Primary on call and for all database and Application supports escalation.
• Helped deployed database and Applications services to Amazon Web Services. (AWS).

Confidential, Malvern, PA

Senior Cloud Engineer

Responsibilities:

• Used service now (SNOW) tickets to schedule Production & Non-production takes i.e. patches, upgrades etc.
• From Akta platform constantly updating confluence and box pages with tasks related updates and documentations with customers (collages/universities) servers/database/application information.
• Vetted and documented Vulnerability & Remediation cases for 1000+ server environments from assigned Confidential customers (universities / colleges), which includes RDBMS (10g/11g/12c), WebLogic INB/SSB servers, JAVA, Tomcat, Banner server environments.
• Experience upgrading to Banner 9 XE from banner 8 and upgrading to latest release of Oracle Forms, WebLogic, TomCat, Middleware on Banner environments, patched and updated hundreds of servers.
• Patched/Upgraded Oracle RDBMS 11.2.0.4, 12.1.0.2 with July 2016, Oct 2016 & Jan 2017 for 1000+ universities/colleges.
• Patched WebLogic servers’ for 100+ universities/colleges server environments (Production/Non-Prod)
• Great experience working in DiDATA / AWS Cloud environments.
• Upgraded Oracle RDBMS databases to 12R2.
• Participate in daily and weekly team SCRUM meetings (Director of Engineering SCRUM meetings, Team Manager SCRUM meetings, Team SCRUM meetings.)
• Opened and solved over 1000+ Service Now (SNOW) Tickets from different tacks / projects assigned to me from over 100+ colleges and Universities, by upgrading services to a specific latest benchmark release versions in order to prevent/remediate any form of vulnerability threats to customer services.
• Schedule & Monitor Oracle database (RMAN / Data Pump) backups before upgrading or patching and environment and also provide a rollback measures in documentation.
• Upgrade Oracle and SQL Server databases depending on the database technology used by the institution.
• Downloads and staged oracle, Java, WebLogic etc. software to S3 buckets in AWS cloud environment.
• Creates and Updates Confluence pages for all prod/no-prod java, oracle RDBMS, WebLogic patches schedules.
• Creates EOC tickets to request manage / un-managed All services during implementation of Remediation & Vulnerability tasks upgrades and patch maintenance.

Confidential, Allentown, PA

Senior Oracle Database Administrator

Responsibilities:

• Take data pump expdp/impdp backups for database migration.
• Installed multiple Oracle EM Agents and Deployed Agents and databases for all hosts using OMS agents.
• Migrated databases to Amazon Web Services (AWS) RDS/RHEL and EC2/RHEL servers using Data pump.
• Worked on Amazon GovCloud database migration RHEL platform.
• Worked created and supported SQL server database.
• Plugged in many SQL Server environment into Oracle 12c Cloud control platform.
• Installed Oracle 12c grid infrastructure and configure ASM disk group +DATA on AWS.
• Created ASM disk groups to support database test migration.
• Migrated test databases using RMAN backup & restore.
• Installed multiple Oracle EM 12c 12.1.0.5 Agents on Microsoft SQL Server and setup plug-ins version 12.1.0.6.
• Implement critical metric alerts on OEM 12c for tablespaces, disk space usage, filesystems, database up/down.
• Day to day Oracle and SQL Server databases supports.
• Troubleshoot Performance tuning.

Confidential, Akron, OH

Senior Oracle Database Administrator

Responsibilities:

• Performs RMAN backups restore, also take data pump expdp/impdp backups.
• Work on flashback recovery of databases.
• Used Golden Gate for data replication from cross-multiple platform database migration Confidential to Red Hat Linux.
• Used materialized Views to reduce query execution time and help with Database Performance.
• Work on Database migration from Confidential to Linux Red Hat and prepare databases for AWS cloud test Migration.
• Works on footprint incident ticket request.
• Installed SES 11.2.2.2 and Oracle 11.2.0.4 and also apply all appropriate patches for SES and Oracle.
• Installed Oracle 12c 12.1.0.2 on Linux Red Hat.
• Installed Oracle 11g 11.3.0.1 on Linux Red Hat and patched oracle 11.2.0.3.
• Worked with developers on database support bases.
• Created standalone databases for test and development purposes per user request.
• Implemented production code releases.
• Resolved tnsnames.ora & listeners confliction issues due to multiple Oracle database releases on server.

Confidential, Denver, CO

Senior Oracle Database Administrator

Responsibilities:

• Create databases use every semester by students, such as standalone, container and pluggable databases.
• Installed Oracle Apex into 11g & 12c oracle database.
• Used Oracle Apex to generate SQL & PL/SQL codes that was deployed into the Test and production database.
• Used Apex as tool to create EPR used to create database warehouse.
• Troubleshoot and resolved Oracle 12c EM Cloud Control issues such as OMS heartbeat failure, Management Agent failure and Repository Database with Agent.
• Implement Oracle ASM to fixed high CPU & memory utilization students Databases.
• Participate in the weekly practicum progress/project meeting and discussions on database issues.
• Creating Standby Data Guard database on the DR server for some sensitive databases.
• Use RMAN shell script to implement RMAN backup to FRA.
• Involve in weekly on-call database support between 13 DBAs.
• Experience generating SQL development codes with Oracle 12c APEX system.
• Work closely with instructors to resolve their database requests for their classes, such as login issues, performance, creating new Multitenant databases (Container DB, Pluggable DB and Standalone).
• Receiving escalation from database issues and tasks.
• Used materialized Views to speed up DML queries.

Confidential, Marlton, NJ

Senior Oracle Database Administrator

Responsibilities:

• Research and document snapshot standby database to support disaster recovery.
• Participate in weekly DBA meeting, offered helpful suggestions on database security for Confidential environment.
• Research and document strategy to upgrade to Oracle 12c cloud control in Confidential environment.
• Used Oracle Enterprise User Security to manage user access through Active Directory etc.
• Used Oracle Data masking in Oracle Database also Research and document Active Standby database.
• Offer helpful suggestion to diagnose Database Performance tuning such as the implementation of Oracle Automatic Memory Management (AMM) to fixed high CPU & memory utilization issues etc.
• Create script for RMAN backup validation (Disk & NetBackup-TAPE).
• Used Oracle Advanced Security for data encryption.
• Work with other Oracle DBA to design Disaster Recovery plan for Data center move to Confidential .
• Research cross multi-platform data replication implementation between Linux and Sun Solaris platform for the Data center move to Defense Information Systems Agency ( Confidential ) Headquarters.

Confidential, Exton, PA

Senior Oracle Database Administrator

Responsibilities:

• Work as part of a database team with focus on production support
• Review designs offer alternatives and implement changes to schemas
• Monitor systems for availability, fail-over and replication errors
• Analyze, monitor and tune databases for optimal efficiency
• Review code, run explain plans, tune queries
• Restore and recover corrupted databases
• Ability to work on-call and after hours/weekend support
• Analyze tables, add indexes, and create partitions
• Implement security (create users, apply certificates, update registries)
• Provide support for testing effort, including developing scripts to load and archive test data.

Confidential, Wilmington, DE

Senior Oracle Database Administrator

Responsibilities:

• Used shell scripts with control-m to implement weekly production code release.
• Provided database support, performance tuning & monitoring daily batch job schedule.
• Used Shell scripts to schedule, troubleshoot, reschedule & restart failed RMAN tape NetBackup level 0, 1, & 2 Incremental, differential & archive redo logs backups.
• Modify RMAN backup shell scripts by adding flag to script to allow or disallow archive log shell script before restarting failed backups in order to clean-up the archive logs that are filling up the archived directory.
• Worked with NetBackup team to fix fail backup issues such as Media layer channels etc.
• Fix and re-create index “index unusable” issues, resulting from production release.
• Used OEM grid control to manage 29 production Oracle databases between (1 - 49 terabytes sizes) databases, hosts and other related components.
• Gathered statistics on stale tables, indexes partitions and sub-partitions.
• Implemented all nightly, weekly & monthly production database code release.
• Support developers for efficient SQL tuning and performance monitoring, create explain plan to Troubleshoot database designs SQL and PL/ SQL code issues.
• Use OEM grid control, SQL*Plus and Toad to monitor, troubleshoot and fix database performance issues such as high CPU utilization, long running queries, batch jobs, blocking locks, create explain plan to tune badly written SQL statements and generated AWR/ASH reports etc.
• Worked on trouble & incident tickets and requests directed to the DBA email queues.
• Participated in the weekly On-call database support rotation between 9 DBA.
• Document and review of spool (logs) from Putty to notepad of daily work activities to keep track of work activities in order to review them when troubleshooting.
• Dialed into the bridge line during scheduled and unscheduled emergency conference calls.
• Imp/exp and backed up key schemas before starting the weekly production code release.
• Added ASM storage or data files whenever spaces are used-up in the production database.
• Handled the night shift database supports.

Confidential, Allentown, PA

Senior Oracle Database Administrator

Responsibilities:

• Recovered oracle RAC database 11.2.0.2 release on Confidential Version 5.3 with RMAN.
• Co-installed oracle 12c RAC with another DBA on a 2 node RAC cluster on Linux Red hat 5.
• Create oracle 12c pluggable database.
• 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 as a DBA support team.
• Supporting Test, Development and Production databases.
• Used 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 on HP-US and Confidential 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 using Shell scripting.
• Created databases and perform database and schema export/import using Data Pump.
• Used Shell script for 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.
• Installing and managing all RAC 10g/11g databases.
• Used Unix/Linux OS commands to administer database work activities.
• Used shell script to automatically kick-off RMAN backup processes 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:

• Participated in weekly on-call database support rotation.
• Supported Development, Test, Quality Assurance (QA), and Production databases.
• Upgraded database to Oracle 10g RAC from Oracle 9i.
• Worked and supported Oracle Database on Windows SQL Server.
• Recovered databases from backup via RMAN to upgrade onto Oracle 10g RAC 10.2.0.4 from 9i.
• Installed and deployed agent and configured database into Oracle EM Grid Control.
• Generated database workload statistic report from AWR, ADDM on daily basis and emailed to DBA manager.
• Recovered failed database from backup tape sets, and database refresh upon notification.
• Applied Oracle quarterly security patches (PSU/CPU) to ALL databases.
• Worked closely with NetBackup team to resolved failed RMAN backup issues.
• Used the Unix/Linux OS commands to administer database activities.
• Created 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:

• Refreshed and duplicate 10g RAC database 2 node database instance from Confidential NetBackup using RMAN.
• Supported Production, Test, QA and development databases.
• Used shell script to set up bash Jobs to automatically startup Oracle services during failure i.e. for 8i databases, Oracle 10g CRS, ASM databases, RAC databases, Listeners. Setup Oracle Net Services including tnsnames.ora and listener.ora.
• Used shell script to administer Oracle Net services and Creating UNIX accounts.
• Used Oracle EM Grid Control, Quest Central, Performance Analysis and Foglight to monitoring Database Performance activities.
• Used ASM commands such as ASMCMD to manage, create ASM disk groups & add ASM storage.
• Creating directories, files and set Oracle environment variables, start/stop oracle RAC/CRS services.
• Worked on AIX, Sun Solaris and Linux (Red Hat/SUSE) OS platforms.
• Monitor physical and logical disk systems and their impact on database performance.
• Installing, configuring and managing Oracle RAC 10g/11g databases in a 10 nodes Cluster ware setup.
• Strong knowledge/understanding of adding nodes to an existing RAC database setup.
• Experienced with RMAN backups/restore and Confidential Net backup tapes and redo data Transport Services.
• Applying quarterly PSU patches to Oracle 10g/11g database cluster to CRS, ASM, RDBMS homes.
• Used traditional Import/Export utility and data pump to import and export tables, schema and databases.
• Performed SQL tuning, database & server tuning, to resolve high CPU utilization & contention issues during db code release into production database.
• Built and maintain Oracle data warehouse standalone database (BCF’s first Database Warehouse).
• Setup 2- 4 nodes RAC Data Guard databases each on the DR server at Edgewater Park, NJ data center for every single production database located on the Burlington location data center.
• Upgraded Oracle 10g RAC database to 11g RAC database with ASM using RMAN.
• Upgraded Oracle database 9i directly to 10.2.0.3 and from 9i to Oracle 11gR1 (2 node RAC), also configured the CRS and created ASM database.