TECHNICAL SKILLS:

Computer Skills: Architect, DBA Software Development, & Devops - Oracle 12C RAC, 11g R2, ASM ACFS, OEM, Exadata, RMAN, Data Guard, Goldengate, Data Pump, PL/SQL, SQL, Expert C, C++, Oracle OCI V8, Pro*C OCI, Pro*Cobol, PHP, DW Star-Schemas & Multi-Dimensional Schemas, ETL, ERwin ERD logical & physical data modeling, R, SAS Base & Macros, SPSS, Business Objects, SQR Crystal Reports, EJB Java Beans, Scala, MongoDB NoSQL, Cassandra NoSQL, Hadoop & MapReduce, Hive, MariaDB, MySQL, MS SQL Server, Confidential -SQL, Sybase ASE & IQ, Transact-SQL, Oracle EBS Peoplesoft, Micro-Focus Cobol, IBM MF & IBM AIX DB/2, Legacy EBCDIC to ASCII, Syncsort, MS Excel Pivot Points, Linux & Unix Systems Admin, Bash Bourne Csh Ksh Shell Scripting, Perl, Python, Apache Spark, HP Proliant, HP OpenVMS, Solaris, Oracle Performance Tuning TKProf, Trace Files, CBO Tuning, Explain Plan, Toad v12.1, SQL Developer v4.2

EMPLOYMENT HISTORY:

Confidential, Naperville, IL

Sr. Architect Consultant & Sr. DBA

Responsibilities:

• Available for direct hire or contract with option for hire after finishing six month extended short-term contract Confidential Alcoa Aluminum Arconix in Davenport, IA.
• Was Oracle DBA, coded, & tested Oracle 11g R2 OCI v8 and PL/SQL subroutines with Oracle OCI PHP web pages on Apache server running Oracle Linux Unbreakable Enterprise Kernel, UEK 3.8.13 and Oracle Linux RHEL Server 7.2. Did DEVOPS coding in PL/SQL, in PHP & OCI V8, and “C” with “C” Unix sockets and “pthreads” in Oracle Pro*C.
• Devops designed and coded 140 PL/SQL lines per day, over 3000 PL/SQL package lines. Discovered and fixed Linux
• Tested shop floor RPC data interchange between new HP production Oracle Linux UEK system and legacy DEC OpenVMS on HP OpenVMS v8.4.
• Utilized SQL Developer and Toad v12.1 for PL/SQL, database updates, and row / column data tracking during testing.

Confidential, Oklahoma City, Ok

Senior DBA Lead

Responsibilities:

• Oracle 12C, v12.1.0.2 upgrade from Oracle RAC 11g R2, v11.2.0.4. resistant against a water / fire event. Also discovered and fixed both Oracle RMAN and MySQL failed backup deficiencies, fixing and validation verifying production backup data sets. My technical reviews revealed that there were no valid ones for over six months due to previous production scripting errors, with no logging
• Worked in RAC Grid running Oracle ASM ACFS Raid 6 Mirror under Red Hat RHEL 6.3 on HP Proliant Intel x86-64 Oracle HA cluster.
• Architected Oracle Goldengate upgrade conversion from Data Streams for heterogeneous database replicas. Set up and tested production Oracle RMAN, Recovery Manger daily and weekly backup scripts.
• Performed Oracle OEM, Oracle Enterprise Manager RAC Grid production support,
• ASM disk management, follow ups on DB OEM console & log alerts, and MySQL DBA duties.

Confidential, St. Louis, Mo. & Chicago, IL

Sr. DBA & Sr. Consultant

Responsibilities:

• consulted with SAPI below on Oracle 10g data warehousing and multi-dimensional data analysis and data presentation with Unix and SQL . Architected Linux Cassandra NoSQL data warehouse for completed sales and customer returns storing data using column organization by Cassandra keyspace, column family, accessed by CQL .
• Working with Silvon, SAPI, & Lenovo contracts, did consulting as a senior DBA on Oracle Exadata and 11g R2 & R1 using OEM & ASM, Oracle PL/SQL.
• I accomplished Oracle performance tuning improvements of 400% for batch OLAP PL/SQL and 300% on complex OLTP PL/SQL using TKProf with Explain Plan and trace files,
• Wrote "C" and Oracle Pro*C OCI, as well as MS SQL Server 2012, Confidential -SQL, Sybase, Transact SQL, with hardware infra structure for reliable terabyte RAID data OLAP. Architected high performance servers and OLTP transactional processing
• I used CA ERwin for large ERD data modeling projects.
• Modeled and setup development data lake with MariaDB MySQL for analytic data exploration and queries.
• Architected MySQL development conversion into long term data repository
• I also architected hardware enabled SSD RAID arrays and SSD hosted OS, encrypted data storage. Did computer consulting and hardware sales, data warehousing ETL into star schemas and fact tables data backups & recovery, systems integration, disaster planning.
• Architected Apache Spark streaming ETL and MongoDB NoSQL data warehouse data model built from NoSQL collections of key

Confidential, St. Louis, Mo

Senior Consultant

Responsibilities:

• Devops program development and fixes for Cass Information Systems with HP Unix apps calculating transportation routes, carriers’ rates, & best economical solutions for shipments, utilizing operations research methods, route / cost algorithms and statistics.
• Implemented new, faster production algorithms with reduced delivery costs for customers .
• For hospitals and healthcare supply chains, worked on OLAP data warehousing design & ETL with multiple targets, Oracle with PL/SQL apps and modular MS SQL Server Confidential -SQL, & IBM AIX DB/2 on Unix.

Confidential, St. Louis, Mo

Sr. DBMS DBA Instructor

Responsibilities:

• Taught 3 Database courses, Relational Data Base Design - E/R Diagramming and Data Modeling, Client / Server DBMS, and Emerging Relational DBMS Technologies.
• Worked on new data warehousing course for Oracle 9i, PL/SQL on Unix & Linux and MS SQL Server.

Confidential, St. Louis, Mo

Contractor

Responsibilities:

• Finished 3-month contract using Oracle 8i / 8.0.6 and EJB Java Beans to implement Internet web system.
• Did all DBA "create table" schema work and coded complex EJB SQL views & PL/SQL for Java Bean programmers.
• Wrote ETL "C" Oracle 8 Pro*C OCI interface in PL/SQL to load Oracle tables for production use on Sun Solaris and IBM AIX web hosts.
• Developed mission critical hierarchical phone customer product catalog in Confidential & Confidential national master DB via EJB, SQL, and view tables.
• Developed & TKProf tuned efficient PL/SQL group access queries.

Confidential, Alton, IL

Sr. Production DBA

Responsibilities:

• Completed 3- month contract managing 28 production Oracle v8.0.5 DBMSs & Oracle EBS PeopleSoft HR / Financials on IBM AIX RS/6000 S70.
• Wrote Oracle PL/SQL & created PeopleSoft data conversion DBs. project lead on verified audit, successful disaster recovery Confidential IBM Recovery Services in NY.

Confidential, Chicago, IL

Technical Project Leader

Responsibilities:

• Completed 6-month contract as Oracle DBA Lead & Solaris 2.6.1 Unix admin on dual Sun E-450s running Oracle 7.3.4 for Apache PHP Web.
• Configured Oracle DBMS Disk Suite RAID, wrote, tuned, and installed Oracle PL/SQL apps. Did Apache V1.3.1, HTML, & PHP web setup.
• Successfully did hardware set ups, OPS recovery procedures, and implemented v7 to v8.0.5 row-id upgrades, and rolled out turn-key systems for 23 production Oracle U.S. sites.

Confidential, Chicago, IL

Technical Manager & DBA Specialist

Responsibilities:

• Was technical data architect and DBA technical team lead on 500 GB size Marketing Data Warehouse System with Sun E-10000 StarFire production server & EMC Symmetrix disk farm. Wrote "C" and PL/SQL parallelized Oracle V8.0.5 apps on Solaris 2.6.1.
• Oracle V8.0.4 for Sun UE-6000s under Solaris 2.6.1 with Sun RSM-219. Developed OLAP ERD in ERwin ERD data
• Supported PeopleSoft Financials, AR/AP & GL.