TECHNICAL EXPERIENCE:

• Software: Oracle 7.3.4-11gr2, 9i/10g RAC/DG, Cluster Ready Services, 10g EM Grid Control, ASM, OEM, RMAN, Data Pump, Oracle Streams, OWB 11.2, Replication. TIVOLI Storage Manager 5.2, VERITAS Storage Foundation and Cluster Server 1.5-3.5, Oracle Utilities, PL/SQL, SQL Plus, PL/SQL developer, ERwin, ERstudio, Cygwin, Putty, DBArtisian, Various Unix utilities Bourne Korn shell, SUDO, RSYNC, SCP, Cron, etc. OEM 2.0/6.0/10.2/DBA Studio, Oracle Designer 5.0/6.0, Hummingbird Exceed 6-7.0, Oracle Data Mart Suite 2.0, Oracle Financials 9.0, DB2 V4.0, BMC Tools and Utilities, QMF, DB2 Utilities, PRO COBOL w/embedded SQL, SQL/DB2, OS/VS COBOL, COBOL II, CICS Command Level, VSAM, IDMS/R, ADSO, TSO/ISPF and all major MVS utilities.
• System: RHEL releases 3,4,5 i686 and x86 64, Solaris 2.6-2.10, HP TRU 64 TRU Cluster OS v5.1b, HP-UX 10.20 11i, IBM AIX, , Windows 2000/XP/NT 4.0, Novell LAN systems, MVS/XA
• Hardware: IBM Blade HS-22 and chassis, Sun Fire E2900, EMC Clarion series SAN CX4 EFD , Hitachi 9980-9990 series SAN, Sun T3 storage, Sun 420r, 480r, 240, 240r, 4500/5500. Sun Blade Servers. HP 9000 V-class Server, IBM compatible 486 and higher PCs, IBM 3090, 4341, 3270, 3380 and 3390 devices. HP GS1280 ES47, ES45

PROFESSIONAL EXPERIENCE:

Confidential

Senior ORACLE DBA

Currently managing all aspects of Oracle DB support for the OMIG including DB availability, recovery, storage, design, security, migration, duplication at all levels Prod/QA/Dev/Test . All databases currently on 11gR1/Windows 64-bit. Currently developing OMIG DW prototype using ORACLE OWB 11GR1. Supporting application developers writing/tuning sql for the FACTS Fraud Activity Comprehensive tracking System , OMIG's main application and related reporting Oracle Reports/Oracle Discoverer . Maintaining/executing ETL's for FACTS application and FACTS dashboard OBIEE R10 from EMedNY DW and DOH Data Mart. Technologies in use include Oracle 11gR1, Windows Server 2003/64-bit, OWB 11GR1.

Confidential

Senior ORACLE DBA

Designed/engineered migration/upgrade of 8-node 10.2.0.4 retail oltp RAC/ASM cluster to new IBM Blade HS22 hardware and eventually to 11gR2 using RHEL x86-64 5.0, currently supporting 10.2.0.4 8-node clusters in production, local failover, DR and performance environments as well as various stand-alone environments and latest 10.2.0.4 Grid installation. Installation, setup, configuration of 10GR2 rac/asm clusters and APEX 11gR2 installation using advanced replication to meet various state reporting requirements. These are currently running on VMWARE ESXI 4.0 /RHEL 5.0 environments for Hunt and Fish State contracts for OR, ID, and WA. Technologies in use include Oracle 10gR2, 11gR2, ASM 11gR2/10gR2, Oracle APEX, Grid 10.2.0.4, 10GR2 Data Guard setup and maint. RHEL x86-64 5.0, VMware Esxi 4.0, 3Par SAN Storage, EMC Clarion CX4 EFD technology, unix bash shell scripting, PL/SQL

Confidential

Senior ORACLE DBA/System Re-engineer

• Re-design/re-engineer NYS/NYC Agency data feeds into various upgraded Oracle systems including the NYS CNNX feed, the ACS system of record, as well as FISA, the NYC Financial Information Services Agency. Database design and ERD modeling for various projects using both ERStudio Erwin. Acting as additional capacity for in-house DBA's for additional project support and problem remediation. Initiate design and installation of ACS Data Warehouse for NYS CNNX data. Technical skills include Sun Solaris 2.10, Oracle 10gr2 EE, UNIX shell scripting, coding in ANSI Standard SQL and PL/SQL, Oracle reports/Discover support.
• Experience identifying business rules and database design, interpreting physical database models and understanding relational database concepts such as indexes, primary and foreign keys, and constraints using Oracle 10gR2 . Oracle programming tools: SQL PLUS. Oracle Utilities SQL LOADER, EXPORT, IMPORT . Experience writing, optimizing, and troubleshooting dynamically created SQL within Procedures.

Confidential

Senior ORACLE DBA

Completely responsible for all aspects of an Oracle Grid 10.1 installation, implementation, and upgrade to 10.2.0.3. Primary responsibility for DB component of highly visible internal and external DOT mission-critical applications including RIS Roadway Information System , HRIS HR , and CARS, CARS Google and CARS 511. Responsible for Backup Recovery policies and procedures for all Oracle DB servers in use. Technical skills included AIX 5.3, 10gR2 EE, Grid Control 10.1.0.2 and 10.2.0.3, RMAN, UNIX shell scripting, coding in ANSI Standard SQL and PL/SQL, OWB 10g 10.1 . Experience identifying business rules and database design, interpreting physical database models and understanding relational database concepts such as indexes, primary and foreign keys, and constraints using Oracle 10g R2. Oracle programming tools: SQL PLUS. Oracle Utilities SQL LOADER, EXPORT, IMPORT .

Confidential

Senior ORACLE DBA

Brought in to diagnose and troubleshoot tremendous RMAN performance problem on 7Tb retail data warehouse. Re-configure, performance tune, test and document current RMAN backup and recovery strategy in various failure scenarios. The warehouse currently runs on IBM I-series I5 AIX 5.3 5L Prod and RS6000 QA and Dev , Linux 2.6.9-22.Elsmp AS . Technical skills included Oracle 10gR2 EE with ASM, 10gAS, Grid Control 10.1.0.2, RMAN, UNIX shell scripting, coding in ANSI Standard SQL and PL/SQL, Oracle programming tools: SQL PLUS. Oracle Utilities SQL LOADER, EXPORT, IMPORT . Exposure to OWB 10g 10.1 , Apache http and Oracle Workflow, Discover 10g 10.1.2 , DB2 Connect, Robot Client. Experience identifying business rules and database design, interpreting physical database models and understanding relational database concepts such as indexes, primary and foreign keys, and constraints using Oracle 10g R2.

Confidential

Senior ORACLE DBA

• Provide database support including requirements definition for:
• Mercury ITG Governance Center database installations including the ITG 7.0 and Service Center 6.0 Oracle 10g Release 2. DB Control functionality managing backup and recovery using RMAN as well as DST daylight savings time patching and upgrading from Standard Enterprise Edition and Oracle9i/10g Directory Services System recording, managing audit applications and various other applications that are supported by OFT. All databases running on SUN Solaris Servers, using both manual and OMF oracle-managed files . Technical skills:Oracle 10gR2 EE, DB Console, Oracle Standard and Enterprise Edition, RMAN, UNIX shell scripting, coding in ANSI Standard SQL and PL/SQL, Mercury ITG Governance Center 7.0, Service Center 6.0, SUN servers, Solaris 9. Oracle programming tools: SQL PLUS. Oracle Utilities SQL LOADER, EXPORT, IMPORT. Experience identifying business rules and database design, interpreting physical database models and understanding relational database concepts such as indexes, primary and foreign keys, and constraints in Oracle 10g R2.

Confidential

Senior ORACLE DBA

• Provided 24/7 support and maintenance of the following systems:
• CJIS System Criminal Justice Information System
• Collects Projects on Oracle 9i RAC clustering using Raw Devices on SUN Clustering technology
• OBTS Offender Based Tracking System a stand alone Oracle 9i database on Solaris UNIX
• Technical skills included Oracle 9i, RAC clustering, SUNCluster OS clustering, Raw Devices, Oracle programming tools: SQL PLUS. Oracle Utilities SQL LOADER, EXPORT, IMPORT. UNIX shell scripting, coding in ANSI Standard SQL and PL/SQL, SUN Solaris Servers.

Confidential

Senior ORACLE DBA

• Cutover migration project for ASM II Ancillary Services Market Real-Time 24x7 Production Oracle DB from HP TRU64 9i RAC/DG to SUN Solaris Oracle 10g rel2 RAC/DG using Oracle Cluster Ready Services, EM Grid Control and VERITAS Storage Foundation. This includes all phases of analysis, installation, testing, documentation, and implementation of an almost entirely automated cutover procedure. Software and database installation and configuration, CRS, Grid Control, RAC, DG failover configuration and testing, extensive use of UNIX shell scripting, EXP/IMP, transportable tablespaces, RMAN cloning, Oracle Streams, XML DB, CTAS/Insert Into parallel processing, performance tuning, partitioning,. All of this is being done in an extremely short timeline for a highly-visible federally mandated corporate requirement.
• Responsible for all aspects of the cutover migration from Oracle 9i to Oracle 10g rel2
• Extensive UNIX shell scripting and performance tuning SQL and PL/SQL using STATSPACK and explain plans, coding in ANSI Standard SQL and PL/SQL.
• Extensive Experience identifying business rules and database design, interpreting physical database models and understanding relational database concepts such as indexes, primary and foreign keys, and constraints using Oracle 10g.
• Extensive configuration and documentation to automate the process reusability
• Experience writing, optimizing, and troubleshooting dynamically created SQL within Procedures.
• Technical skills included Oracle 9i, Oracle 10g Release 2, EM Grid Control, Oracle Cluster Ready Services CRS , RAC, Data Guard DG , RMAN, Oracle Streams, CTAS, XML DB, SQL, PL/SQL, PL/SQL Developer. Oracle programming tools: SQL PLUS. Oracle Utilities SQL LOADER, EXPORT, IMPORT, SERVER MANAGER , DB Artisan, ER Studio, Explain Plan, UNIX shell scripting, STATSPACK, VERITAS Storage Foundation, UNIX, SUN Solaris, HP TRU64.

Confidential

Senior ORACLE DBA

• Senior Oracle DBA responsible for establishing and implementing Oracle DBA policies and procedures for NYISO ensuring the reliable, safe and efficient operation of the State's major transmission system and to administer an open, competitive and nondiscriminatory wholesale market for electricity in New York State. Senior DBA responsibilities include infrastructure development for managing and maintaining all Oracle database servers, server set-up, software installation, licensing, back-up and recovery, failover planning, disaster recovery, upgrades, monitoring, and tool evaluation. Completely responsible for design, implementation and maintenance of Oracle 9i RAC/Data Guard configurations on HP TRU 64 TRU Cluster Server Architecture in a 24/7 environment. Support of oracle databases using the Oracle 9i/10g XML DB component
• Completely and ultimately responsible for all HA environments at the NYISO RAC/DG, Stand-alone DG,
• Shell scripting of automated DG switchover for stand-alone and RAC'd environments
• Stand-alone installs of Oracle 10GR2 for new apps on Sun HP
• All RMAN configurations for backup, recovery catalog maintenance
• Experience identifying business rules and database design, interpreting physical database models and understanding relational database concepts such as indexes, primary and foreign keys, and constraints using Oracle 9i/10g.
• Alert checker script for specific Data Guard problems and corruption
• Migration of production and QA environments off of HP HSG80 local storage to Hitachi 9980V SAN
• Experience writing, optimizing, and troubleshooting dynamically created SQL within Procedures.
• Technical skills included Oracle 9i, Oracle 10g Release 2, Oracle Enterprise Manager, XML DB, SQL, coding in ANSI Standard SQL and PL/SQL, PL/SQL Developer, Oracle reports/Discover support, CTAS, RAC, Data Guard DG . Oracle programming tools: SQL PLUS. Oracle Utilities SQL LOADER, EXPORT, IMPORT, SERVER MANAGER , DB Artisan, Erwin, ER Studio, STATSPACK, VERITAS Storage Foundation, UNIX shell scripting, UNIX, SUN Solaris, HP TRU64, HP HSG80, Hitachi 9980V SAN.

Confidential Senior ORACLE DBA within GEPS IM Oracle DBA Group

• Perform various Oracle application DBA responsibilities including 24x7 on-call responsibilities, Senior-level decision making in DBA group policies procedures for Oracle-based applications. Oracle Server installation configuration of both Oracle and Veritas components. Senior member of DBA staff responsible for all maintenance, monitoring, performance tuning, and upgrade of all Oracle servers/instances in operation for GEPS and GEPS Engineering Division. Installation configuration of database components supporting hundreds of Oracle-based applications employed throughout GEPS.
• Installation maintenance of the first Oracle 9i-based application at GEPS DART the most widely used and most important application in the GEPS Engineering Division. Including server setup, software installation configuration, instance creations configurations, and 9i Replication setup configuration.
• Perform installations for all Oracle 9i installations.
• Complete upgrade of the IMAN engineering application including Oracle configuration of new servers, software 8.1.6 Veritas configuration.
• Maintenance of internal UNIX script collection to monitor maintain all Oracle instances supported by GEPS DBA group. Including system monitoring auditing, backup export, performance tuning, and upgrade scripts.
• Installation and support of Greenville Finance servers including Oracle installation, instance creation, and application support.
• Standardization of all Oracle instances to Oracle 9i.
• Various projects coordinated with GEPS Unix team including Disaster recovery testing restores of Oracle servers from tape , migration of storage from Sun T3 to EMC Clarion SAN, and GEPS database security.
• Perform various complete and partial recoveries of entire instances and applications as needed.
• Backup support for all GEPS SFS Shop Floor Systems highly-visible 24x7 critical support applications, including upgrades, performance tuning, troubleshooting, change requests and restores.
• Experience identifying business rules and database design, interpreting physical database models and understanding relational database concepts such as indexes, primary and foreign keys, and constraints using Oracle 9i.
• Sybase support
• Experience writing, optimizing, and troubleshooting dynamically created SQL within Procedures.
• Technical skills included Oracle 7/8i/9i, 9i Replication, XML DB, coding in ANSI Standard SQL and PL/SQL, CTAS, DB Artisan, Oracle programming tools: SQL PLUS. Oracle Utilities SQL LOADER, EXPORT, IMPORT, SERVER MANAGER , Sun T3, EMC Clarion SAN, STATSPACK, VERITAS Storage Foundation, UNIX shell scripting, UNIX, Sybase, SUN Solaris, HP.

Confidential Data Warehouse ORACLE DBA Support/Systems Analyst

• Performed various DBA/Systems Analyst duties in all phases of analysis, design, and implementation of an Oracle 8i Data Warehouse on an HP 9000 server to support the Connections Child Welfare system. This included extensive daily use of PL/SQL, SQL Plus, HP-UX 11, Exceed, OEM, Designer and OWB. Major DBA functions include instance creation and maintenance, object and user creation and maintenance, space usage, performance monitoring, and database standards implementation. Major Systems Analyst functions include analysis and design of logical and physical models, source system data loading, editing, and validation.
• Technical skills included Oracle 8i, coding in ANSI Standard SQL and PL/SQL, Oracle programming tools: SQL PLUS. Hummingbird Exceed, CTAS, Oracle Enterprise Manager, Oracle Designer. Oracle Utilities SQL LOADER, EXPORT, IMPORT, SERVER MANAGER , ETL, UNIX shell scripting, UNIX, HP-UX 11, HP 9000. Experience identifying business rules and database design, interpreting physical database models and understanding relational database concepts such as indexes, primary and foreign keys, and constraints using Oracle 8i. Experience writing, optimizing, and troubleshooting dynamically created SQL within Procedures.

Confidential ORACLE Consultant

• Implementation of an Oracle Financial Data Mart ODMS 2.0 for The Rockefeller University including analysis, planning, and design of the data mart, its data acquisition, transformation, and metadata processes and implementing a Y2K assessment.
• Technical skills included Oracle 8i, Oracle Data Mart Suite ODMS 2.0 , SQL, PL/SQL, SQL Plus, Oracle Designer, CTAS, Oracle Utilities SQL LOADER, EXPORT, IMPORT, SERVER MANAGER , UNIX shell scripting, UNIX, HP servers.

Confidential Lead Programmer/Business Analyst

• Completed one-year assignment as Project lead at SUNY Research Foundation, the largest private higher education firm in NYS. Complete Y2K installation and operating system upgrade including all phases of planning, coding, debugging, testing, and implementation from start to finish. Working with and managing a four-person team on all project related issues to see it through to completion.
• Technical skills included COBOL II, VSAM, TSO, ISPF, and MVS JCL in an IBM mainframe environment.

Confidential

Lead Programmer/Business Analyst

• Served as lead programmer implementing Y2K and annual changes for the all Corporate Tax processing system for NYS DTF. Worked as a Business Analyst for the Y2K Conversion Project at Phoenix Home Life Inc. Tasks included planning and execution of all phases of the project lifecycle: scope, analysis, testing, user signoff, and implementation. Under my own initiative and client approval, constructed a re-usable inventory system in ACCESS 2.0 with a small database and fully functional, user-friendly forms. Also worked with QA Partner 4.0.2, an automated testing tool from SEGUE.
• Technical skills included COBOL II, VSAM, TSO, ISPF, and MVS JCL in an IBM mainframe environment, ACCESS 2.0, and SEGUE QA Partner 4.0.2.

Confidential Senior Programmer Analyst

• Analyst for Integration Management Department. Served all phases of migration of several in-house banking systems to the MAX DB2 Data Warehouse including project planning, analysis, design, DASD estimates, and data flow. Performed most DBA functions, testing, and implementation. This included daily use of the BMC family of software tools, QMF, SPUFI, IBM and BMC LOAD and UNLOADS utilities.
• Technical skills included COBOL II, DB2, SQL, DB2 Utilities, QMF, SPUFI, BMC Tools and Utilities, LOAD, UNLOAD, TSO, ISPF, and MVS JCL in an IBM mainframe environment.

Confidential

Oracle Developer

Consultant to the Confidential of Mental Retardation and Developmental Disabilities-performed analysis, design, and coding of various programs for the HRMS Human Resource Management and Voucher Contract Processing Systems using PRO COBOL under the Oracle 6.0/7.0 environment. Experience coding in ANSI Standard SQL and PL/SQL, Oracle programming tools: SQL PLUS and Oracle Utilities such as SQL LOADER, EXPORT and IMPORT on a daily basis as well as experience interpreting physical database models and understanding relational database concepts such as indexes, primary and foreign keys, and constraints using Oracle 6.0/7.0. Experience with writing, optimizing, and troubleshooting dynamically created SQL within Procedures.

Confidential

Programmer-Analyst/Systems Administrator

• Access Programmer/Tester/System Administrator at GE Industrial Power Systems on the CAN Customer Access Node R-engineering Project. Duties included programming an error-tracking database written in Access 2.0.
• System Administrator at GE Industrial Power Systems on the Oracle Financials 9.0 character-based FACTS Financial and Accounting Corporate Teleprocessing System. Responsibilities included: user access to any functionality in the system. Creating new users and sign-ons, access to screens, menus, printers, views, and read/update capabilities. Creating concurrent managers, directory structures, applications, menus, responsibilities, create/register Oracle user ids, add data-groups, define report security groups, and assign profile options.

Confidential

Senior Programmer

• Analysis, design, and coding of programs in IDMS/COBOL, ADSO, CICS, VSAM, IMS DL/I and EASYTRIEVE. Support of several systems including COBRA and PROVIDER, two back-end systems as well as two front-end managed care systems, UMS and ARIES. Leader of a four person team on the ITS Interplan Teleprocessing System Project, CICS programming, testing and documentation of a nationwide claims processing system.
• Technical skills included COBOL II, CICS, EASYTRIEVE, IMS, DL/I, IMS/DC, IDMS, ADSO, VSAM, MVS JCL, TSO and ISPF in an IBM mainframe environment

Confidential

Senior Programmer

• Worked on the Portfolio System. Managed multi-million dollar client portfolio system. Provided 24x7 support. Cobol, JCL, IDMS, VSAM.
• Technical skills included COBOL, IDMS, VSAM, MVS JCL, TSO and ISPF in an IBM mainframe environment.