TECHNICAL SKILLS:

Relational Databases: Oracle 7, 8i, 9i, 10G RAC, 11g R2 RAC, 12C, Banner 2.0 - Banner 8.x, Banner XE

Oracle Tools: OEM 11g, Grid Control 11g & 12c, OAS Forms 9 & 10, OFM 11, WLS 10, RMAN, Toad, AppWorx

Operating Systems: RHE Linux, AIX, Solaris, Unix, HP-UX 11, OpenVMS

Languages: SQL*Plus, Perl, Shell, C, C with eSQL

PROFESSIONAL EXPERIENCE:

Oracle/Banner DBA

Confidential, Glassboro, NJ

Responsibilities:

• Upgraded Oracle to 11.2.0.4 on TEST RHEL 6 server.
• Applied Banner 8 upgrades to converted Oracle 11.2.0.4 database as needed.
• Upgraded Oracle to 12.1.0.2 on TEST RHEL 6 server.
• Created and deployed applications for Groovy/Grails implementation of Ellucian’s Banner XE.

Oracle Middletier DBA

Confidential, Morgantown, WV

Responsibilities:

• Upgraded Oracle Fusion Middleware 10g to 11.1.1.7.
• Upgraded WebLogic to 10.3.6 on AIX server.
• Created and deployed applications for Groovy/Grails implementation of Ellucian’s Banner XE.
• Upgraded Apex to version 4.3

Banner/Oracle DBA

Confidential, Harrisburg, PA

Responsibilities:

• Applied Banner 8 upgrades to converted Oracle 11g, R2 database as needed.
• Solved a TEMP tablespace performance issue, enabling conversion work to continue unimpeded.

Oracle DBA

Confidential, Harrisburg, PA

Responsibilities:

• Developed shell scripts to monitor 6 databases used by the Geographical Information Systems through Toad and RMAN backups.
• Cloned 10G Oracle/Windows XP development database for User Acceptance testing.

Banner/Oracle DBA

Confidential, Columbia, SC

Responsibilities:

• Applied 75+ Banner 8 upgrades to converted database in preparation for a Banner 8 Production conversion on an Oracle 11G, R2 database.
• Created an 11G R2 Oracle database on a SAN using ASM to be used for AppWorx/UC4 installation.
• Verified RMAN backups, developed shell scripts that monitored space issues in all instances, on all servers using Oracle 11g grid control.

Banner/Oracle DBA

Confidential, San Antonio, TX

Responsibilities:

• In a RHEL 5, Dell Power Edge server environment, migrated Oracle 10g on Solaris, Banner 7 to Oracle 11g on Linux, Banner 8, using export/import method of characterset conversion.
• Applied 75+ Banner 8 upgrades in preparation for a June 1 Banner 8 Production conversion.
• Created and managed 5 application servers using Oracle 10G AS.
• Managed the upgrade of Evisions Intellecheck & Form Fusion software to connect to the Oracle 11g database, allowing reports and checks to be formatted correctly and printed.
• Applied Production Banner 7 database upgrades, verified RMAN backups, tuned performance using statspack, and monitored disk space for all instances.
• Installed Oracle 10.1.2.3 Oracle Application Server for both Production and Training instances.

Oracle DBA

Confidential, Physicians Baltimore, MD

Responsibilities:

• Windows 2003 environment, monitored, administrated thru 10g grid control 5 Oracle 9.2.0.7 instances on 5 servers with Centricity’s Logician EMR 5.6, used by physicians and support staff.
• Cloned Production instance to TRAIN, allowing up-to-date training of personnel.
• Developed and implemented security plan that included creating and assigning Oracle roles.
• Verified RMAN hot backups, performance tuned with statspack, monitored disk space on 5 host servers and used Dataguard to ensure archive log transfer to Production’s standby database.

Banner/Oracle DBA

Confidential, Baltimore, MD

Responsibilities:

• Proactively monitored thru Grid Control 9 Oracle 10g databases in a 4 node RAC configuration involved in 24X7 operations of an online education corporation.
• Created and managed 5 Application Servers using Oracle 10G OEM Grid Control.
• Administrated and managed Oracle 10G/SunGard Banner security for 9 databases on RHEL 4 servers, involving the setup of Oracle roles, and classes of 10G Oracle forms.
• Managed the Banner software code tree on 2 development and 2 production Linux batch servers and aided in the customization of Oracle 10G Forms used in SunGard’s Banner product.
• Installed, created & administrated an Oracle 10G database used for installation and integration of Address Validation software as a key part of a large project with 22 integration points.
• Actively created and modified shell and Perl scripts to obtain reports regarding instance status and space management.

Oracle DBA

Confidential Jacksonville, FL

Responsibilities:

• Actively monitored 9 production and 7 standby databases involved in the day-to-day operations of EverBank, including Financials, and Commercial & Wholesale lending, totaling 370G.
• Assisted in the Oracle Financials upgrade from 9i database to 10G.
• Developed and administrated Oracle 10G security roles for 9 production and 11 development/test databases on Solaris & Red Hat Enterprise Linux servers.
• Managed and administrated security of vital bank information using Ingrian Networks encryption.
• Installed Oracle 10G on production and development IBM P Series servers using RHE Linux.

Banner/Oracle DBA

Confidential

Responsibilities:

• Upgraded the Oracle/SunGard Banner test database and HP-UX 11 database server in preparation for the conversion and migration from SunGard Banner 6.x to version 7.3.
• Applied upgrades under a strict timeline for the Banner 7.3 migration to 50+ instances.
• Converted and migrated Oracle Forms from 6i to 9i.

Banner/Oracle DBA/Analyst

Confidential, Durham, NC

Responsibilities:

• Created and managed 5 Oracle 9.2.0.6 instances Unix servers with Solaris 9, in readiness for the implementation of the SunGard SCT Banner implementation.
• Planned and implemented AppWorx installation, user setup, security, job scheduling and creating the AppWorx database linked to Oracle.
• Managed upgrade of Banner 6 to 7 that involved coordinating 14 module upgrades with users and IT.
• Upgraded and migrated Oracle from 9.2.0.3 to 9.2.0.6, including Forms upgrade to 9i.
• Developed security policy, created/managed Oracle roles based on job duties, created capacity plan using Toad matrices, backup/recovery plan, and cloned production database.
• Installed & implemented Evisions Form Fusion and Intellecheck interfaces to Banner Finance.

Banner/Oracle DBA

Confidential, Bentonville, AR

Responsibilities:

• Organized the Oracle/SunGard SCT Banner test database and database server with AIX 4.3.3 in preparation for an upgrade and migration from Oracle 8.1.7 to Oracle 9.2.0.3.
• Consulted with the DBA on daily database activities, including design of backup/recovery strategy, tuning parameters, capacity plan, table sizing issues and table/schema management.

Banner/Oracle DBA

Confidential, Malvern, PA

Responsibilities:

• Co-managed the installation of SunGard Banner, an OLTP system that included installing Oracle database server 8i & 9i, Oracle 9iAS, Developer 2000 and Oracle Forms & Reports 9i.
• Ensured communication between servers, along with network protocols and TCP/IP configuration, on Sun Solaris 8 & 9, HP-UX 11, AIX, Windows NT & 2000 and OpenVMS.
• Planned and executed upgrades to SCT Banner to bring it to the current release.
• Applied Oracle patches for the 9i database and 9iAS Application Server.

Banner/Oracle DBA contract

Confidential, Fort Wayne, IN

Responsibilities:

• Utilized OEM to assist the DBA with the daily Oracle 8.1.6 database activities, including the backup/recovery strategy, tuning parameters, capacity plan, specific table sizing issues and table/schema management.
• Developed database triggers that allow execution of an application report based on the value of the applicant’s status.

Banner/Oracle DBA/Analyst

Confidential

Responsibilities:

• Managed a 9.2 GB Oracle 8.1.6 database with over 2000 tables. Daily activities included writing and monitoring reports on database health, management of 4 instances, performance tuning, database security, and creation, testing, execution, maintenance of backup/restore procedures.
• Planned & executed 4 major upgrades of SunGard Banner that involved 11 modules. As project leader, developed and administrated, the upgrade schedule and processes, including patches, major and minor releases and communication with users regarding project status.
• Upgraded Oracle 3 times: 7.1.5 to 7.3.3.4, 7.3.3.4 to 7.3.3.6, and 7.3.3.6 to 8.1.6. Developed and managed the upgrade/migration schedule, applied OpenVMS and Oracle patches, configured listener.ora and tnsnames.ora.
• Converted and migrated Oracle Forms from 6i to 9i

Developer/Programmer

Confidential, Piscataway, NJ

Responsibilities:

• Managed a UNIX server installation that coordinated the receipt of 52 data files via FTP from 4 external data centers and produced files sent to 6 data centers.
• Developed Oracle scripts in C shell on Sun workstations that reported on database health.
• Trained and Mentored 4 new employees in the operations of the OLTP Order system.
• Designed, created, tested & maintained ProC programs for online use by operators.
• Managed development of 5 conversion programs, written in C with embedded SQL.
• Designed and coordinated an inter-system test with 6 systems.

Programmer Analyst

Confidential, Rockleigh, NJ

Responsibilities:

• Coordinated and managed the design, programming, testing, documentation and implementation of a Special Meals project for on-line reservations.
• Developed code in TPF Assembler for maintenance and display of flight inventory facts.