SUMMARY:

• Database administation, architecting, consulting for solutions in Oracle database environments.
• Redhat & Oracle Linux Oracle system engineering.
• Oracle RAC 11g, 12c: Migrations to 12c; performance tuning; patching...
• This role presented a high number of complex performacne tuning opportunities for me to find solutionis for. This was one of the most enjoyable aspects of having a wide variety of enterprise Oracle database customers to support.
• Database migrations, upgrades, duplication, cloning, restore, recovery, patching.
• Shell programming for performance & problem monitoring and automating DBA tasks
• Managed production, development, QA, test, & stage Oracle environments
• Tuned at the SQL, Oracle server, hardware, & operating system layers.
• Team leadership, project management, & primary customer DBA roles
• 24x7 on - call technical support rotation, troubleshooting & problem resolution
• Continuous technology review and learning to facilitate appropriate, cost-effective solutions.
• Disaster Recovery / Business continuance planning, testing, engineering, implementation
• Storage and networking experience.

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, Washington

Senior Database Administrator

• 11g physical database & RAC design; 32  64-bit RAC migrations; 11.2 upgrades & patching.
• Converted 100+ GB tables to partitioned tables online with dbms redef and automated partition maintenance and its data archival.
• Redesigned an oracle backup & recovery system: RMAN scripts housed & scheduled by Grid Control and redundant shell/RMAN scripts launched via DBMS SCHEDULER..
• Built, configured, managed and patched ... Grid Control 10.2.0.5.
• Redesigned and extensively simplified and improved an Oracle database clone/refresh procedure; Automated RMAN duplication & Data Pump dev/QA refresh ...
• Improved the response time for database rebuild/refreshing. Both response time and delivery combined have improved from 1-2 weeks to 1-2 days on average. This is enabled by better & faster backup restore infrastructure, better database duplication tools, and improved preparation of archive log retention and backup availability on the dev/QA servers.
• Implemented Flashback Database in production; for QA databases for substantially speeding up frequent data refresh.
• Designed oracle replication using Streams & Basic Replication (materialized views).
• I fixed a severe table space fragmentation problem in a production RAC database. The procedure was to rebuild or move all affected objects online to several new tablespaces.: I separated a ~1 TB size data file into multiple data files. This was a complex operation to do live with minimal application downtime. The result was improved efficiency and speed of backups but more importantly, it dramatically improves the recovery time in the event that is needed. An immediate goal and benefit was met: reducing a 2 TB database to 1 TB by removing severe fragmentation.
• Leveraged Grid Control for multiple improvements is DBA services including;
• Faster and less error-prone dev/QA database refreshes (DB duplications from prod)
• Access to Grid Control for dev & QA people
• Quicker responses & knowledge of errors & performance issues
• Quicker and more efficient user account management
• Expanded, upgraded, & improved dev/QA database server environments:
• Built a test Oracle Grid Control server.
• Provided, on demand, more database server capacity when needed development and testing.
• Built many new additional dev & QA databases when needed.
• Building a test RAC & Data Guard environment for a new set of applications.
• Built an Oracle 11.2 development server with ~20 databases.
• Provided Oracle Flashback Database service for the QA databases to improve refresh time by 2 orders of magnitude ... from a day or two  a few minutes.
• I provided on-demand assistance with development and QA database performance issues and challenges. Help of this type is all over the map from reviewing code, offering alternative coding approaches, tracing & analyzing database calls, creating triggers & hints, adjusting oracle initialization parameters, providing more database resources, providing knowledge of oracle features and usage ...  
• I upgraded Oracle Grid Control to 10.2.0.5 (latest current release) to improve the backup, recovery, and 11g management. This provides much quicker diagnosis and repair of oracle database availability issues. A large part of this upgrade also included learning the new Grid Control tools and software to improve DBA efficiency.  

Confidential, Seattle, WA

Oracle DBA II

• Data Guard builds & support.
• SQL & Oracle server tuning, research.
• SQL design & database code review.
• On-call support rotation for over 200 databases.
• Database fleet automation & reporting.   Automated several reporting, diagnostic, and maintenance operations for 260 database servers:
• Performance data collection and HTML reporting.
• Automated AWR & ADDM hourly & daily reports and consolidated rollups.
• Automated mining of the alerts logs and trace files for reporting errors.
• Automated finding extensive literal SQL statements including source server, module, count, and statement text...
• Automated finding failed-long-running SQL & generating HTML based reports.
• Automated find core-dump and deadlocking SQL & generating HTML based reports.
• Automated extending tablespaces as needed.
• Automated a custom database migration from 9i  10g using exp/imp for speed & accuracy.

Confidential, Golden, CO

Oracle DBA

• Engineered & designed 64-bit Oracle RAC environment on Oracle-Linux, 4Gb/s FC, ASM.
• Extensive RAC tuning: server, network, storage, instance, objects, SQL.
• Designed, purchased, & setup a 4Gb/s FC SAN to replace iSCSI SAN.
• Designed development & test DB environments.
• 32-bit 10.1 RAC, 32-bit Linux, GFS  64-bit 10.2 RAC, 64-bit Linux, ASM.
• iSCSi   FC RAID-5 SAN for RAC DB.
• FC RAID-5 SAN FC RAID-10 SAN
• Manual Segment Space Management  Automatic Segment Space Management.
• LONG data types  CLOB data types.

Confidential, Denver, CO

Oracle DBA

• Provided support for over 100 Oracle databases 10g, 9i, 8i
• RMAN, DataPump, PL/SQL, SQL, shell scripting...
• Production, Development, QA environments.
• Documented existing, Planned new 10g backup & recovery system.
• Oracle installations, patches, software upgrades.
• Disk space management, troubleshooting DB problems.

Confidential, Bay City, MI

Consultant

• Provided consulting services in the areas of networking, security, Linux administration, Windows 2003/XP administration and Oracle database administration  
• Provided production and development Oracle database support, assisted with planning & testing Oracle 8i to 9i database migrations.  Designed, tested, and implemented a custom backup & recovery system for Oracle servers using shell & SQL scripts and Veritas NetBackup.
• Resolved multiple SQL & shell program performance issues and solved performance issues with Oracle servers.  Assisted the UNIX team with shell scripting and backup & recovery design.  

Confidential, Englewood, CO.

Oracle DBA

• Responsible for the administration of numerous Oracle 8i and 9i database instances.  Resolved issues with Oracle Data Guard; scripted procedures and tuned databases to minimize downtime on production servers.
• Performed Oracle 8i to 9i migrations, SQL and Oracle server tuning, DB cloning.  Developed SQL materialized views, PL/SQL triggers, ksh scripts, and SQL scripts.
• Assisted UNIX team with disk volume setup.  Responsible for installation and configuration of new Oracle server environments; cloned new development environments from standby databases to save time and allow for repeatable processes.

Confidential, Golden, CO

Oracle DBA and Senior UNIX Administrator  

• Responsible for managing and maintaining the UNIX and Oracle infrastructure consisting of more than 45 systems used for both Corporate IT and Operational Support Systems for wholesale telecommunications service offerings.  
• Identified and resolved numerous Solaris and Oracle performance and operational support issues related to the processing of approximately 300 million call detail records each month.  These changes helped ensure proper resource utilization and ultimately saved the company hundreds of thousands of dollars.
• Provided analysis and recommendations to Sr. IT management in relation to UNIX and Oracle issues.  Provided leadership and project management for Oracle database migration (8i to 9i), LDAP testing, security enhancements and Hitachi Storage Area Network (SAN) implementation.
• Proposed and lead successful data center migration from a sub-standard ‘warehouse' facility to a commercial/hosted data-center that would provide the business with the required reliability and security as well as improved disaster recovery.
• Lead project in conjunction with consultants to upgrade Oracle Applications 11 (Financials) underlying database from 8i to 9i to allow integration with production RMAN backup infrastructure.
• Managed and maintained support contracts and provided systems architecture guidance to the software development team.   Experience included utilization of Veritas Netbackup, Veritas Foundation Suite, numerous open source network management and monitoring packages and security packages.

Confidential, Denver, CO

UNIX Administrator  

• Provided UNIX and network administration for a team of JAVA developers on Solaris and LINUX platforms.  Built backup and recovery system utilizing Veritas Netbackup on Solaris ADIC Scalar 100 LTO and DLT robotic tape libraries.
• Installed and administered Netscape iPlanet, Inprise App Server, Inprise J-Builder, Vitria Businessware, Oracle 8i.
• Set-up Cisco Multi-Layer-Switching on two Catalyst 6509 switches, MLS-SE and MLS-RP interconnectivity and trunking, VLANs. Responsible for all production network issues including routing, switching, cabling, firewall (PIX). Network troubleshooting.
• Setup & migrated between LDAP, NIS+, NIS for authentication and naming.