TECHNICAL SKILLS:

• Microsoft Office 2016
• Microsoft Windows 7/10
• Toad for Oracle 12.9
• Oracle 11g Rel 2 Database Enterprise Edition
• Oracle 12c Database Enterprise Edition
• Oracle Enterprise Manager Cloud Control 13c
• SQL Server 2016
• Microsoft Windows Server 2016
• MySQL 5.7
• AIX 7.1
• Redhat Enterprise Linux 7.5
• Attunity Replicate

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Administrator

• Currently performing out of place upgrade of Grid Infrastructure from 12.1 to 12.2.0.1
• Managed 4 node 12c RAC cluster and all oltp databases as well as 1.8 TB data warehouse.
• Supported 2 node 12c RAC cluster as well as Oracle Development Database Servers running 11.2.0.4 and 12.1.0.2/12.2.0.1.
• Database Performance monitoring and SQL tuning for both Oracle 12c RAC on Redhat 7.4 using TOAD session manager and Oracle OEM SQL Tuning Sets and Advisors.
• Perform Quarterly Oracle PSUs to all RAC clusters and databases.
• Manual configuration and monitoring of Oracle 12c active standby dataguard.
• Migration of SQL Server Point of Sales Database Server from SQL Server Enterprise 2008 to SQL Server Enterprise 2016.
• Installation and configuration of MySQL 5.7 on Windows 10 and RedHat 7.
• Utilized Oracle Virtualbox for lab testing of Redhat 7.4, Oracle Database 12c, Oracle 12c Clusterware (ASM), and MySQL 5.7.

Confidential

Senior Oracle DBA

• Production migration from 4 node 11g RAC to 4 node 12c RAC cluster and all oltp databases as well as data warehouse.
• QA migration from 2 node 11g RAC to 2 node 12c RAC cluster and all oltp databases as well as data warehouse.
• Performed database reorgs for production data warehouse which freed over 500GB of storage space. Created additional tablespaces for table/index partitions and separated objects by type in respective tablespaces by year.
• Managed and supported all application schemas for all pre - prod databases.

Confidential

Senior Oracle 11g DBA

• Worked as a member of the retail application database team.
• Managed all application schemas for all pre-prod databases.
• Setup and managed archival databases for all of retail bank using table/index partitioning.
• Assisted Promotion of all DDL into retail production databases as well as SQL performance tuning.

Confidential

Senior Oracle 11g DBA

• Performed silent installations of oracle database server and oracle grid agent using response files
• Performed database migrations from oracle 10g to oracle 11gR2 on the following platforms: AIX 7.1, Suse Linux, and SunOS
• Executed RMAN database restores using Symantec Netbackup solution ver. 7

Confidential

Senior Oracle 11g DBA

• Reviewed, tested, and applied all DDL scripts in our development, qa, and production database environments for all financial applications.
• Oracle 11g upgrades and migrations from Oracle 10g.
• Oracle 11g Grid Control upgrade from Oracle 10g (rel. 5) on Windows Server 2008
• Upgraded Grid control repository from 10.1.0.5 to 10.2.0.4 using DBUA on windows xp

Confidential

Senior Oracle 11g DBA

• Reviewed, tested, and applied all DDL scripts in our development, qa, and production database environments for all financial applications.
• Oracle 11g upgrades and migrations from Oracle 10g.

Confidential

Senior Oracle 11g DBA

• Oracle 11g upgrades and migrations from Oracle 10g.
• Oracle 11g Grid Control upgrade from Oracle 10g (rel. 5) on Windows Server 2008

Confidential

Senior Oracle 9i/10g DBA Consultant

• Supporting over 20 Oracle Database Servers and 15 Microsoft SQL Servers
• Performed Oracle database 9i to 10g migrations for the hospital.

Confidential

Senior Oracle 10g DBA Consultant

• Devised RMAN hot backup for database (including control file and archive logs)
• Provided General DB support to client

Confidential

Oracle 10g Development DBA/PLSQL Consultant

• PL/SQL development utilizing Oracle 10.2.0.1
• Maintenance of physical model using Erwin 4.1.4

Confidential

Senior Oracle 9i/10g DBA Consultant

• Installed, Configured, and Managed Oracle 10G RAC 2 node cluster for Development Group.
• Assisting with design and implementation of Confidential ’s new Data Warehouse

Confidential

Manager of Database Administration (Oracle 9i/10g)

• Installed, configured, and supported 2 node Oracle 10g RAC clustered environment on AIX 5L
• Manage over 106 oracle 9i/10g databases which encompasses development, qa, and production.

Confidential

Senior Oracle 8i/9i DBA Consultant

• Performed performance analysis of all oracle 8i database applications
• Migrated all oracle databases from oracle 8i to oracle 9i on AIX, Confidential, and Confidential platforms

Confidential, BenSalem, PA

Senior Oracle 9i/10g DBA Consultant

• Migrated 6 Oracle databases from AIX 4.33 servers to AIX 5.2 servers.
• Developed shell script which performs dbverify on each datafile associated with every database on a server for possible corruption.

Confidential, Philadelphia, PA

Oracle 8i/9i/10g PL/SQL and UNIX Developer

• Migrated an entire Oracle 8i loading application written in korn-shell utilizing PL/SQL packages from Confidential.
• Wrote enhancements to both shell scripts and PL/SQL packages.

Confidential, Allentown, PA

Oracle 8i/9i PL/SQL Consultant

• Developed PL/SQL programs based on program specifications written by Senior Developer.
• Developed using Oracle 8i Technologies and Quest Software(TOAD).

Confidential, PA

Senior Oracle 8i/9i DBA

• Install, support and maintain Oracle 8.1.7.4 & 9i on Confidential 2.7/XP.
• Help institute Systems Development Life Cycle for the Media, PA division by drafting procedures which are currently being followed by the company.

Confidential, Wilmington, DE

Oracle 8i Developer Consultant

• Developed and tested C/C++ programs, Pro*C programs and perl scripts for Oracle data extraction and validation purposes as written in the application specifications document authored by the architect. Wrote email application utilizing these programming languages for a database over 1 terabyte in size using parallel DML statements in the data warehouse development group.
• Developed Oracle PL/SQL packages/procedures/functions for FirstUSA

Confidential, Atlanta, GA

Senior Oracle 8i DBA Consultant

• Installed, designed, and implemented Oracle 8.1.6 40GB OLTP database using intermedia option
• Managed logical/physical model for our newly designed java-based application with Oracle 8i as our backend RDBMS using Erwin.

Confidential - Jessup, MD

Manager of Database Administration

• Responsible for hiring and managing 1 DBA, 1 Developer, 1 Network Administrator, and 1 Unix Systems Administrator.
• Provided overall direction for I.T. staff. Reported to CIO.

Confidential - Philadelphia, PA

Senior Oracle 8 DBA Consultant

• Managed an Oracle database and Oracle Web server for the adoption center

Confidential - Dover, DE

Senior Oracle 7/8 DBA Consultant

• Supported a Peoplesoft implementation with Tuxedo as the Middleware and Oracle as the back-end

Confidential - Hanover, MD

Unix Developer Consultant

• Wrote, documented, and maintained korn shell and PERL scripts for Systems Manager.

Confidential - Towson, MD

Unix Developer Consultant

• Wrote, documented, and maintained bourne shell scripts and C programs for Systems Manager.

Confidential - Dover, DE

Oracle 7/8 DBA Consultant

• Provided Oracle support to various agencies, and assisted with interface development.

Confidential - Newark, DE

UNIX System Administrator

• Acted as a help desk support specialist supporting Unix platforms.

Confidential- Dover, DE

Oracle 7 DBA

• Provided Oracle Database Administration