SUMMARY:

• 26 years IT Experience, Masters degree in Computer Science.
• Certified Oracle dba: RAC, RMAN, DataGuard, Exadata, Solaris, Linux, AIX
• Expert in database design, data modeling, application tuning
• Mastery of SQL, PL/SQL, C, C++, ProC, HTML, UNIX/Linux administration and scripting.

PROFESSIONAL EXPERIENCE:

PL/SQL Developer

Confidential, Fort Worth

Responsibilities:

• Oracle programming for a aircraft logistics application.

PL/SQL Developer

Confidential, Irving, Texas

Responsibilities:

• Data modeling of database inventory and operations. Development of PL/SQL packages and triggers. Development of APEX gui. This was to be a three month assignment but I completed the work in two months.

Oracle Database Administrator

Confidential, Richardson, Texas

Responsibilities:

• Creation and administration of DataGuard physical standbys, performance tuning, planning for configuration and security standards. Cloning of databases for reporting purposes.

Sr. IT Architect - Oracle Database Administrator

Confidential, Dallas, Texas

Responsibilities:

• Administration of over 100 Oracle databases, up to 35 TB, (500+ TB total) on Linux and Solaris. RAC, DataGuard, ASM. Database upgrades, migrations, backups, administration of physical standbys, performance optimization using AWR and ADDM, capacity planning. Migration of Oracle database to VCE Converged infrastructure (RAC on VMs). Implementation of rman backups on standby databases. Cross-platform and inter-datacenter migration of databases. Generation of input data for Oracle CIs into ServiceNow. Automation of database monitoring via PL/SQL packages and SQL scripts.

Senior Technical Consultant

Confidential, Irving, Texas

Responsiblities:

• Migration of a 1.4 TB Oracle 10.2 database using ASM and RAC on AIX to Oracle 11.2 on Exadata via expdp/impdp. Construction and maintenance of physical and logical standby databases. Real Application Testing (RAT) capture from 10g database and replay on 11g database. SQL Performance Analyzer (SPA).
• Oracle database administration of over 50 databases, versions 10.2 to 11.2, using ASM, RAC, Solaris and Linux.
• Upgrade of Grid Infrastructure to version 11.2. Database upgrades and patching. Performance optimization, user administration, physical database administration, backup administration using RMAN. Migration of databases to new servers, configuration of Grid Control, provided developer support.

Senior Oracle Database Administrator

Confidential, Houston, Texas

Responsibilities:

• Administration of Oracle 10 and 11 databases for real-time financial processing system. Design and implementation of an ODS database in third normal form to support extended application functionality and reporting. Performance enhancement by query optimization and replacement of resource intensive queries with stored procedures. Use of Oracle Transparent Data Encryption (TDE). Migration of an Oracle 10.2 database to Oracle 11.1.

Senior Oracle Database Administrator

Confidential, Houston, Texas

Responsibilities:

• Database administration of large (>8 TB) databases: OLTP, ODS and Data Warehouse. Installation, configuration, upgrades and patching of Oracle 9i and 10g databases, administration of RMAN backup jobs, administration of Data Guard standby databases. Facilitation of database portion of data center moves.

Oracle Programmer (Contract)

Confidential, Houston, Texas

Responsibilities:

• PL/SQL development of an airline reservation and ticketing system. Updates to existing packages and procedures, development of new packages for extract and sqlldr scripts for input.

Principal Consultant

Confidential, Houston, TX

Responsibilities:

• Schema design and management for a ERCOT application. Data modeling using ERWin. Implementation of complex business rules via triggers. Review of developer code. Management of logical database objects (tables and indexes). Design and implementation of data model, procedures and automation of ERCOT FasTrak dispute resolution system. Support of Structure Group nMarket application. Oracle versions 8i and 9i, Solaris operating system.

Senior Consultant

Confidential, Houston, TX

Responsibilities:

• Designed a 3rd normal form data model for the sales history of Compaq’s personal products (115 tables). Implemented the physical database and wrote data loading routines in PL/SQL to extract data from SAP feeds into the normalized data model. The database was used to drive a CRM application and for reporting. Oracle version 8i, Tru64 (UNIX) operating system.

Confidential, Houston, TX

Responsibilities:

• Complete administration of multiple instances of Oracle 8i used for nMarket: a transaction management application for electrical markets. Responsibilities included installation and upgrades of Oracle software, database creation, database backup and recovery, tuning, monitoring, and developer support. Solaris platform.

Confidential, Houston, TX

Responsibilities:

• Installation of Oracle on Windows NT, creation of database schema, design of reports for a Health, Safety and Environmental compliance system.

Consultant II

Confidential, Dallas, Texas

Responsibilities:

• Design and development of Oracle Reports for Oracle Project and Oracle HR, version 10.7.

Oracle Database Administrator

Confidential, Houston, Texas

Responsibilities:

• Principal DBA for a Schlumberger’s “PowerHouse” data center. Administration of Oracle 7.3 databases on Solaris 2.6. Developed Unix and SQL scripts for database creation, monitoring, and backups. Developed recovery procedures and drills. Administration and support of users and developers. Developed a workflow management database and web site that was instrumental in the data center obtaining ISO 9001 .

Oracle Database Developer

Confidential, Houston, Texas

Responsibilities:

• Design, development and administration of a technical database and applications for an integrated energy service company. Data modeling of wells, service jobs, geologic entities, equipment and personnel. Development of middle tier data servers using TCP/IP socket level programming. Development of Windows NT clients using Visual C++ 4.2.

Senior Software Engineer

Confidential, Houston, Texas

Responsibilities:

• Application development within ABB’s Distributed Control System (C programming language). Object oriented design of a Universal Device Interface.

Product Specialist

Confidential, Houston, Texas

Responsibilities:

• Generation of Windows clients and UNIX (HP UX) data servers using Andersen’s proprietary Foundation CASE tool, pro-C pre-compiler and SQL Loader.

Programmer

Confidential, Houston, Texas

Responsibilities:

• Client-server development for a SCADA system: Sybase database, UNIX systems programming.

Computer Systems Engineer

Confidential, Houston, Texas

Responsibilities:

• Programming (C++) for a quality control system used in the manufacture of circuit boards, using Paradox database and Novell network.

Owner

Confidential, Humble, TX

Responsibilities:

• Complete administration of a building maintenance company with 12 employees and 75 clients.