Post Job Free

Resume

Sign in

Oracle Data

Location:
Irving, TX
Posted:
June 02, 2017

Contact this candidate

Resume:

RESUME OF MARK J. CINQUE

Oracle Certified Professional Database Administrator

SUMMARY:

** ***** ** **********, ******* 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.

EDUCATION

Master of Science, Computer Science, University of Houston, 1993

Master of Science, Geology, University of Nevada, Reno, 1979

Bachelor of Science, Geology, UCLA, 1976

PROFESSIONAL CERTIFICATIONS

Oracle Certified Professional, Oracle 11g Database Administrator, 10/05/2012

Oracle Certified Professional, Oracle 10g Database Administrator, 9/22/2006

Oracle Certified Professional, Oracle 9i Database Administrator, 5/30/2002

Oracle Certified Professional, Oracle 8i Database Administration: 5/5/2001

Oracle Certified Professional, Oracle 8 Database Administration: 10/27/1998

Oracle Certified Professional, Oracle 7.3 Database Administration: 4/24/1998

International Oracle Users Group Certification, Oracle 7 Database Administration: 4/22/1997

PROFESSIONAL EXPERIENCE

4/16/2013 – 10/31/2016: Sr. IT Architect – Oracle Database Administrator, Energy Future Holdings, Dallas, Texas

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, 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 inpurt data for Oracle CIs into ServiceNow. Automation of database monitoring via PL/SQL packages and SQL scripts.

8/2010 – 4/15/2013: Senior Technical Consultant, Enkitec, LP, Irving, Texas

08/2011 – 04/2013: Brinks, Inc. North American Operations, Coppell, Texas

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).

9/2010 – 08/2011: The Container Store Corporate Headquarters, Coppell, Texas

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.

9/2008 – 06/2010: Senior Oracle Database Administrator, FSV Payment Systems, Houston, Texas:

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.

4/2007 – 9/2008: Senior Oracle Database Administrator, First Data, Houston, Texas:

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.

11/2006 – 4/2007: Oracle Programmer (Contract), Continental Airlines, Houston, Texas:

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.

4/2003 – 9/2006: Principal Consultant, Keane, Inc., Houston, TX:

Client: Entergy Solutions Ltd., Houston, TX. Lead Application DBA: 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.

5/2000 - 4/2003: Senior Consultant, American Information Systems, Houston, TX

8/2002 – 2/2003 Entergy, Houston, TX. Lead Application DBA: Schema management for a ERCOT application. Design and management of tables and indexes, implementation of complex business rules via triggers, review of developer code. Oracle version 8i, Solaris operating system.

8/2001 – 3/2002: Compaq, Houston, TX. Application DBA: 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.

9/2000 – 7/2001: Structure Consulting Group, Houston, TX. 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.

7/2000 – 9/2000: Luminant Worldwide, Houston, TX. Installation of Oracle on Windows NT, creation of database schema, design of reports for a Health, Safety and Environmental compliance system.

5/2000 – 7/2000: Compaq, Houston, TX. Data Warehouse design and construction using Oracle 8.

8/1999 – 5/2000: Consultant II, Hitachi Data Systems, Dallas, Texas:

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

6/1997 – 8/1999: Oracle Database Administrator, Schlumberger Data Management Center, Houston, Texas:

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 certification.

5/1996 - 6/1997: Oracle Database Developer, Halliburton Energy Systems, Houston, Texas:

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.

1/1996 - 5/1996: Senior Software Engineer, ABB Industrial Systems, Houston, Texas:

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

8/1995 - 1/1996: Senior Information Systems Analyst, Tenneco Energy, 1010 Milam St, Houston, TX 77252-2511 713-***-****. Preparation of requirement specification and design documents for a gas pipeline measurement system.

10/1994 - 8/1995: Product Specialist, Andersen Consulting, Houston, Texas:

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

5/1993 - 10/1994: Programmer, Valmet Automation, Houston, Texas:

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

5/1992 - 11/1992: Computer Systems Engineer, Intaq, Inc., Houston, Texas

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

8/1986 - 9/1991: Owner, Dove Services Inc, Humble, TX. Complete administration of a building maintenance company with 12 employees and 75 clients.

10/1980 -7/1986: Senior Petroleum Geologist, Exxon Company USA, 800 Bell St, Houston, TX 77002 713-***-****. Exploration for oil and gas in the Bering Sea, and petroleum development in East Texas.

6/1978 -10/1980: Geologist, Pathfinder Mines, Reno, Nevada Uranium exploration in California and Nevada.

PERSONAL DATA:

Address: 10203 Donley Dr, Irving, TX 75063 Cell phone: 682-***-**** Email: ac0mc1@r.postjobfree.com



Contact this candidate