SUMMARY:

• Technical Systems Review and Analysis for Performance or Business Continuance
• Capacity Planning to accommodate natural growth, or corporate acquisition and integration
• Strategic/Tactical Planning/Implementation/Management of new or extant Infrastructure, Database Systems as well as the personnel managing same
• Planning and Managing Systems Integration of Acquired Systems
• Oracle Exadata Configuration on Oracle 11gR2, 12c, Implementation of Oracle Editions, Oracle Golden Gate, SuperClusters, Oracle Engineered Systems (ODA)
• Oracle Real Application Clusters (RAC) multiple nodes (4) & Grid Design/Implementation with Oracle ASM, ACFS and other cluster file systems (Veritas)
• Implementation of Solid State Devices for highly active data segments
• Advance Oracle Database Features with Oracle 12c, Container Databases, Pluggable databases, System, SQL, and Application Tuning.
• Planning and Implementation of Oracle Data Guard, Standby Databases, Logical Standby, High Availability, Fast Start Fail Over using Observers, Low to no data loss systems
• Deployment and Tuning of Oracle Streams, Advanced Queuing and Replication
• Replication through Redo/Archived Redo Log Mining
• Automated and Manual Database Recovery Operations
• Recovery through Redo/Archived Redo Log Mining as well as many backup methodologies
• Advanced SQL and PL/SQL Tuning and Analysis
• Conversion of “slow” PL/SQL to fast “pure” SQL
• Extensive experience with Very Large Databases (VLDB) over 100 terabytes
• Experience with large projects, e.g., PSU and Application patching on as many as 5000 servers
• Experience with ALL Oracle Versions from 5 on MSDOS Oracle 12c on various
• Experience with MySQL on Linux
• Adept using many Operating Systems: UNIX: Solaris, Dynix, AIX, HPUX and many extinct versions

PROFESSIONAL EXPERIENCE:

Confidential,Houston, TX

Senior Partner Consultant Oracle Database Administration

• I started WSI/ Confidential in 1997 to provide an easy mechanism for technically skilled professionals to provide staff augmentation for businesses primarily in the Houston market place. This organization provides for billing and contract negotiations where individuals might otherwise need to share bill more to the end client than needed to provide services requested. In some cases, the actual direct hires were done outsize the auspices of WSI/ Confidential to provide the best opportunity to the consultant and client.
• Following is the work history for Sr. Consultant John Kostelac. Double asterisks indicate where client required FTE to be allowed to execute contracted project. References available on request.

Confidential,Irving,TX

Vice President Infrastructure

• Support application teams; apply PSU patches after validation to more than 5000 servers worldwide including RAC, Data Guard, AIX, Linux; respond to escalations from Oracle DBA L2 groups; growth and capacitcy planning.

Confidential,Houston,TX

Database Engineer/Administrator/Architect/Linux Administrator

• Review several existing databases and tables for data belonging to multiple saleable entities; design and develop a means for separating the data for each entity to be provided to the purchaser. Task completed when sale was made earlier than expected.

Confidential,Warrendale,PA

Database Engineer/Administrator/Architect/Linux Administrator

• Review existing Windows based 10 Terabyte Oracle Database setup, Create/Implement plans for: upgrade from Oracle 10gR2 (10.2.0.5 SE to 10.2.0.5 EE); Standby Database at DR site; for upgrade to Oracle 11gR2 (11.2.0.5 EE); patch and upgrade ASM as needed. Install and configure Oracle Linux for Oracle 11gR2 primary and secondary databases; Performed daily maintenance.

Confidential,Houston, TX

Database Administrator

• Upgrade 20+ Windows based Oracle9 and Oracle10 databases to Oracle11gR2. Create DataGuard instances for production databases based in Oracle SuperClusters; Primary DBA for FLOWCAL conversion to Solaris on Oracle SuperCluster.

Confidential, Houston, TX

Database Engineer/Administrator/Architect/Linux Administrator

• Review existing Windows based 10 Terabyte Oracle Database setup, Create/Implement plans for: upgrade from Oracle 10gR2 (10.2.0.5 SE to 10.2.0.5 EE); Standby Database at DR site; for upgrade to Oracle 11gR2 (11.2.0.5 EE); patch and upgrade ASM as needed. Install and configure Oracle Linux for Oracle 11gR2 primary and secondary databases.
• Performed daily maintenance; much of which had not been done in more than 2 months.

Confidential,Houston,TX

Database Analyst/Engineer/Architect/Administrator/Architect

• Review of Oracle DEV/TEST environment to adapt it to new program initiatives; made hardware recommendations along with process changes to integrate the physical environment with the new Agile Program Development methodology to improve bug fix turn around.
• Created specification for automated rebuild/reload of TEST environment as needed without human involvement, including data management and space management; worked with Microsoft and Oracle to resolve the discrepancy (BUG) with Windows 8 Constrained Delegation and Oracle’s ASO/OID using Kerberos5.

Confidential,Houston,TX

Database Analyst/Engineer/Architect/Administrator

• Participate in all aspects of database maintenance, design and upgrade. Implemented Active Standby databases; Automated that and many manual procedures. Implemented application and database upgrades while maintain Five Nines uptime.
• This 60TB database ran at > 22K transactions/sec and was required to be available at all time. Used MYSQL front end databases to prepare data for the 60TB Oracle database.
• Requirements included < two minutes’ notification to parole office when person monitored strayed from designated area. Participated in development of new procedures and I/O Sub - system to accommodate the 45% growth rate.

Confidential,Houston, TX

Database Analyst/Engineer/Architect/Administrator

• Reverse Engineer a legacy application and develop support; Integrate said application into current suite of applications. Evaluate and tune database instance parameters along with model change recommendations. Provided 24/7 support for Energy traders in production and developers in all lower environments.