Summary

I am a Senior Level Consultant with over 20 years experience in the IT Industry experienced in all aspects of Oracle Database Administration (7.x/8.x/8i/9i/10g/11i/11g) in Unix, Linux and Windows NT environments, Oracle Database Replication, Oracle Real Application Clusters, Oracle application design and development using Forms, Reports and Designer in both Client/Server and Web environments and early career experience in mainframe application design and development. I also possess experience with Oracle Applications and Data Warehousing as a Database Administrator, developer and technical team leader. Very strong team leader with excellent verbal and documentation skills. Great planning skills with attention to detail. Strong motivation to learn, problem solve and assist others when needed.

Technical Skills

Operating Systems
UNIX 5.0, SUN Solaris 2.5.1/2.6/2.7/2.8/2.9,10, HP UNIX, IBM AIX, NT, XP
Applications/Databases
Oracle 7.X/8.0.X/8i/9i/10G/11G/11i, Novell Group wise, Windows NT/XP
Languages
Oracle PL/SQL, SQL*PLUS, SQL*LOADER, SQR Reports, COBOL, COBOL II, JCL, PASCAL, IDMS, ADSO, ADSA, ADSG, TSO, Roscoe
Hardware/Platforms
IBM 486 LAN Systems, IBM 3090, 4341, 3270, 3380, and 3390 devices, IBM and IBM compatible 486, 586, and 686 personal systems, SUN SPARC
Tools/Utilities
Oracle Financials 11i/10.7SC/9.0, Oracle Forms 3.0/4.5/6i/9i, Oracle Reports 2.5/6i/9i, Oracle Designer 2000/6, Oracle Discoverer 2000, Oracle Enterprise Manager, Oracle Application Express 3.0.1, Erwin 4.0, Embarcadero DBArtisian 5-7.X, Maximo 4.x, Citrix Metaframe, Microsoft Terminal Server, Apache Web server 1.3 and 2.0

Experience

Confidential,Albany, NY
Senior Oracle Database Administrator August 2007 – Present

Currently working on a Oracle Real Application Cluster project as a lead Oracle DBA in the Department Of Health DBA group.

• Responsible for the logical and physical architecture of the NYSDOH databases. This includes databases designed by in-house staff as well as the review and evaluation of designs provided by third party vendors.
• General database support and maintenance on SUN Solaris, Linux and AIX.
• Administration and maintenance of Oracle 11gr2 Grid control.
• Defined source to target mappings, data extracts, data transformation and data loading into staging tables for data mart.
• Created and maintained custom PL/SQL code and Unix Shell scripts.
• Upgrade of Oracle clusterware and RAC databases from 10g to 11gR2.
• Physical and logical data modeling for several data marts.
• Created automated data load routines to transfer data from real time databases to data marts.
• Wrote RMAN backup scripts for hot backups.
• Installation and maintenance of Oracle 10g Real Application Cluster Databases on SUN Solaris, AIX with offsite data guard.
• Configure Oracle RAC 10g to communicate with Weblogic 10.3
• Performed Oracle Database upgrades from 10g to 11gR2
• Installation, maintenance and upgrade of Oracle Enterprise Management Server 11g and 12c Grid Control
• Design and implementation of Oracle ASM 10g and 11g

Confidential,Albany, NY
Senior Oracle Database Administrator March 2006 – August 2007

Currently working with a team of Oracle DBA’s in the Data Management Group (DMG). The DMG Group is responsible for the support and management of all of the Department of Transportation’s enterprise data assets. A major role of DMG is enabling access to, and protecting the security and integrity of the Department’s data. Working in conjunction with the Information Security Office and Server Support Group, DMG employs many techniques to protect the department’s data from abuse, misuse unauthorized access and corruption.

• Created and maintained custom PL/SQL code and Unix Shell scripts.
• Physical and logical data modeling for several data marts.
• Installation and maintenance of Oracle 10g Real Application Cluster Databases on AIX with data guard.
• Conduct database/data mart monitoring and performance tuning.
• Manage database backup and recoveries.
• Performed database upgrades on RAC from Oracle 9i/10g to 11g
• Upgraded several Oracle 9i database to Oracle 10g Database.
• Setup RMAN 10g database repository.
• Wrote RMAN backup scripts for hot backups.
• Created technical documentation in support of several projects.
• Create Application Express applications in support of DMG internal processes.
• Installation and maintenance of Oracle Enterprise Management Server 10g Grid Control.

Confidential,Delmar, NY
Programmer/Analyst December 2003 – March 2006

Working as an Oracle forms Programmer/Analyst for New York State Office Of Mental Retardation(OMRDD) on the TIMES project. The TIMES system is a complex system which consists of 100 plus tables across multiple schemas on a multi-tiered environment. Responsibilities include:

• Creation and modification of Oracle 6i web forms and reports on Citrix and AIX using Oracle RAD on updatable and read only views, in a multiple tiered environment.
• Creation of Oracle 8i packages, PL/SQL code, triggers, procedures & functions across multiple schemas.
• Creation of application training manuals and test plans.
• Classroom training demonstration of application functionality.
• Creation of tables, packages, procedures and triggers using Designer 6
• Creation of Korn shell scripts on AIX.

Confidential,Atlanta, GA
Database Administrator/ Architect June 1999 – Present

• Working as an Executive Oracle Database Administrator for GE Power Systems. Lead Oracle DBA on several intranet, E-business and Oracle replication projects. Lead developer on GEPS infrastructure project for all GE sites. Implemented and now supporting 24 x 7 client server applications using Veritas Cluster and Veritas Net Backup technology architecture. Responsibilities also include:
• June 1999 – December 2003

Sun Solaris UNIX shell script creation and modification for database monitoring and loading.
Creation of Oracle 8i, 9i & 10G packages, PL/SQL code, triggers, procedures & functions.
Performance monitoring, tuning, Oracle database, data marts and third party application upgrades on Oracle 7.3, 8.0.5, 8i, 9i, 10G and 11i.
Implementation and modification of backup and recovery strategies including RMAN to Veritas Net Backup Server and korn shell driven backups.
Database server installation and setup on Sun Solaris, Linux and NT platforms for Oracle 8i, Oracle 9i and Oracle 10G.
Administration of Oracle 11i.5 modules - HR, PO, GL, AP and AR
Physical and logical data modeling for several data marts.
Creation and maintenance of online user help desk.
Maintenance and administration of SUN/Veritas clustered Oracle databases.
Created automated data load routines to transfer data from real time databases to data marts.
Configuration, implementation and maintenance of Maximo 4.x. & 5i using Oracle Java Virtual Machine, Oracle Ultra Search and Oracle Text.
Design and creation of procedure migration application using Java Servlets 2.2 and JDBC API on an Apache Server
Maintenance of Oracle 9i Replicated multi-master database.
Management of several Junior Level DBA’s both on and off shore.
Creation of solution design, testing and technical documentation.
Implementation of Security policy across all export controlled sites using Virtual Private Databases (VPD fine grain security).
Apply Oracle database patches as required for Oracle 8.1.7.4 through Oracle 10.1.0.3.
Created automated data load routines to transfer data from real time databases to data marts.
Apply Oracle client patches and database patches as required for Oracle Enterprise Suite 11i.5
Defined source to target mappings, data extracts, data transformation and data loading into staging tables for data mart.
Installation and maintenance of Oracle 9i & 10g Real Application Cluster Databases on Linux.
Participated in the migration of Sybase databases to Oracle 10g databases.
Installed and configured Oracle Fail Safe on Windows NT

• March 2001 – September 2003

Design and development of GEPS database infrastructure/security system across all sites (6 states, 3 countries, 54 servers, 103 instances, 546 schemas), using Oracle 8i & 9i, Oracle forms 6i, Oracle web reports 6i, Oracle 9iAS and Oracle Designer 6 and WebDB/Portal.
Created technical documentation for Advanced Replication.
Performed the upgrade of Oracle forms 6i to Oracle forms 9i.
Implemented and configured Oracle Enterprise Manager – Management repository.
Assisted with the design to interface with Windows NT/XP and Novell GroupWise servers to extract data for loading to GEPS Global Address List.
Installation and configuration of Oracle Application Server 9.0.3
Upgrade of Oracle Application Server from 9.0.3 to 9.0.4
Created and maintained custom PL/SQL code and Sun Solaris Unix Shell scripts.

• September 2002 – November 2002

Design, configuration and implementation of Oracle 9i Replicated multi-master database.

Confidential,Latham, New York
Senior Software Consultant/ System Design March 1998 – May 1999

• Worked on an Oracle financials project at New York State Education Department as technical team leader/developer and Oracle Financials database administrator on Oracle 8i. Responsibilities included:

Performed functional gap analysis and the created interfaces between existing legacy systems and Oracle financials 10.7SC.
Created solution, technical and test documentation.
Performed database software installation and configurations.
Created tables, indexes, procedures, functions, packages, and triggers.
Performed Oracle database tuning, patch application, modifications of custom library and creation of detailed documentation utilizing Oracle Application Implementation Methodology (AIM).
Created and maintained custom PL/SQL code and Sun Solaris Unix Shell scripts.

Confidential,Amsterdam, NY
Senior Programmer/Analyst October 1996 – March 1998

• October 1996 – January 1998

Worked as an Oracle applications developer and backup Oracle DBA on a data-warehousing project at GE Power Systems on Oracle 7.X & Oracle 8.X.
Responsible for analyzing and moving data from Sybase, AS400 and flat files to Oracle utilizing BCP and SQLLDR.
Designed and created Oracle Reports 2.0, Forms 4.5, tables, indexes, procedures, functions, packages and triggers using Oracle Designer 2000 RAD.
Assisted with the design, creation and implementation of the Oracle Data Warehouse database, Operation Data Store and several Data Marts.
Designed and created Oracle applications on the World Wide Web utilizing PL/SQL, Oracle Discoverer and Oracle Express Objects 6.0.
Created new and modified existing Sun Solaris UNIX shell scripts for database management. Assisted the Oracle DBA with daily database tasks, issues, tuning, software installations and configurations.

• January 1998 – March 1998

Worked as an Oracle Developer at New York State Department for Youth on an Oracle Forms 3.0 conversion project on Oracle 7.3.
Modified existing and created new Oracle Forms, PL/SQL code and triggers.
Created custom Sun Solaris shell scripts

Confidential,Latham, New York
Senior Consultant September 1994 – September 1996

August 1995 – September 1996
Worked as a COBOL, IDMS and ORACLE developer at GE Corporate Research and Development.
Designed and implemented a time and attendance system using Oracle Forms 4.0 and Oracle reports 2.0.
Converted payroll system from weekly to bi-weekly pay.
Assisted in the conversion of FACTS legacy data to ORACLE 7.0. Designed and implemented Oracle screens via Oracle Forms 4.0.
Created and maintained custom PL/SQL code and Unix Shell scripts.
Created Oracle reports using SQR 3.0 and ORACLE reports 2.0.
Created new and modified existing Sun Solaris UNIX korn shell scripts for Oracle weekly database loading and reporting.

• March 1995 – August 1995

Worked as a CICS, VSAM developer at Confidential,New York.

• September 1994 – March 1995

Worked as a CICS, VSAM developer at Confidential.

Confidential,Albany, New York
Senior Programmer September 1989 – September 1994

Responsibilities included analysis, design and development of programs in IDMS/COBOL, IDMS/EASYTRIEVE PLUS, ADSO and CICS/VSAM on Open VMS and MVS-90 Operating Systems.

Confidential,Albany, New York
Programmer/Analyst August 1984 – September 1989

Created new and modified existing COBOL and COBOL II modules on

• MVS-90 Operating Systems.

Provided application support via JCL, VSAM and RPF programming.

Education

Degree in Computer Science

11G Oracle Certified Professional (OCP) DBA

Training

Oracle 10g Advanced Replication
Oracle 9iAS
Oracle11g Database Administration
Oracle database 11g Data Guard Administration
Oracle database 11g Backup and Recovery
Oracle database 11g RAC Administration
Oracle database 11g Grid and RAC Administration Accelerated
Oracle Enterprise Manager 11g: Grid Control Essentials
Oracle Data Modeling
Oracle Designer 6
Oracle Forms 6i
Oracle 6i Web Reports
Oracle Forms 4.5
Oracle Reports 2.5
Oracle SQL*Plus
Oracle PL/SQL
Oracle Financials Technical Foundation SC
Maximo 4.X
PowerBuilder 6.0
Visual Basic 4.0
UNIX 2.6
SYBASE SQL Anywhere
SYBASE Adaptive Enterprise Server 12.0
OS/VS COBOL
COBOL II
Command Level CICS
IDMS Database Navigation
IDMS Database Design and Implementation