TECHNICAL SKILLS:

Databases: Oracle 6/7/8/8i/9i/10g/11g/12c, SQL Server 6.5/2000/2005/2008 , MongoDB 2/3, MySQL (3/4/5), Sybase System 11, DB2/UDB, and Ingres

Languages: Java, C, Perl, SQL, PL/SQL, Uniface 4GL, and Visual Basic 6

Systems: AIX 3/4/5/6, Red Hat Enterprise Linux 3/4/5/6/7, Solaris, Windows NT/2000/XP/ 2003/2008/7/10 , HP - UX, IRIX, SunOS, OpenVMS, and macOS

EXPERIENCE:

Confidential, Broomfield, CO

Principal Database Engineer (DBA/DBE), Team Lead

Responsibilities:

• Built, managed, patched, upgraded, and tuned development, test, and production Oracle 11g and 12c (3-5 node) RAC and non-RAC databases on RHEL 5/6/7 and enterprise grade IBM, Cisco UCS, EMC, and NetApp hardware to support software engineering projects and 17+ million video customers
• Acquired, built, and deployed new Oracle X6-2 and X7-2 engineered systems with Oracle Enterprise Linux 7.4 and Oracle 12c to increase workload capacity
• Served as a team lead for a group of Oracle administrators and engineers Installed and administered MongoDB (NoSQL, document) 2/3 databases on RHEL 6including replica sets over disparate data centers and Ops Manager monitoring
• Designed, developed, and optimized Oracle SQL, PL/SQL, and Bash shell scripts for cable TV, video on demand (VOD), and back office applications
• Worked alongside Java/Web/REST API developers to analyze, model, and satisfy application data and persistence requirements using DeZign data modelingJIRA issue tracking, and Perforce source control/version management tools
• Installed, configured, and managed Oracle GoldenGate 11g/12c, GoldenGate
• Monitor Server 12c, Active Data Guard 11g, and Enterprise Manager Cloud
• Control 12c/13c for Oracle replication, failover, monitoring, and reporting
• Used RMAN to backup, clone for Data Guard, and restore Oracle 11g databases Installed and configured Oracle Gateway for ODBC and PostgreSQL ODBC drivers n RHEL 5 and Windows to migrate 50+ ProgreSQL 8 databases to Oracle 11g Built a Proof-of-Concept Oracle 11g Data Guard environment on AWS for DR

Confidential, Broomfield, CO

Sr. Oracle DBA

Responsibilities:

• Designed, planned, and executed Oracle 10g/11g database migrations for a global pharmaceutical company using FDA/ISO-regulated SQA validation (Software Qualification) procedures, RMAN, and Data Pump on RHEL 4/5 and Solaris 9/10 servers clustered with Veritas Cluster Server
• Consulted and planned for Oracle database disaster recovery at a hot site Coordinated Oracle lead activities with project managers and IT colleagues

Confidential

Sr. DBA/Developer

Responsibilities:

• Built a new Oracle infrastructure to support 6 distribution centers in 4 regions of the world, architected and implemented automated data sharing from the regions back to North America using Oracle Streams over a private
• WAN and database replication for disaster recovery using Confidential
• Developed database and system level scripts to produce business performance metrics, harmonize data between environments, automate data reconciliation and alerting, and migrate/synchronize Development/QA/Test/Production builds
• Installed and managed the database side of high - volume, global SOA Suite
• 10g and 11g implementations, including RCU and OEM/WebLogic/adapter installations, creation of a custom data purge process to reduce SOA Suite s database footprint by an order of magnitude to enhance runtime performancedeveloping a continuous purge process to support 2.5 million instances/dayand analysis/tuning to remove significant database performance bottlenecks
• Installed, administered, and tuned Oracle 10gR2 and 11gR1/2 databases on
• AIX 5/6, RHEL 5, and Windows 2003 for global Data Warehouse and Business
• Intelligence (Informatica/Cognos: OLAP), Manhattan warehouse management
• (WMOS/EIS 2006: OLTP), and Oracle Fusion Middleware 10g/11g using Oracle tools (e.g. OEM, Data Guard, Data Pump, RMAN, SQL*Loader, and SQL*Plus)
• Configured and maintained robust OEM Grid Control 10gR5/11gR1 environments for Oracle database monitoring, alerting, backups, tuning, and management
• Developed PL/SQL, SQL, and Unix shell scripts to meet application, systemperformance, and Sarbanes-Oxley (SOX) compliance requirements Served as an architectural and technical resource for business and IT colleagues on database and system development/administration issues
• Provided backup DBA support for a single global instance of a multiple terabyte Oracle JD Edwards EnterpriseOne database
• Administered Unix (AIX 5.3/6.1 and RHEL ES 5) and Windows servers

Confidential, Broomfield, CO

Sr. Oracle Database Administrator

Responsibilities:

• Installed, administered, and optimized performance and reliability of Oracle (8i,9i,10gR2) databases on Windows 2000/2003 Server

Confidential, Longmont, CO

Sr. Oracle Database/System Administrator

Responsibilities:

• Implemented new Oracle 10gR2 Real Application Clusters (RAC) and non-RAC databases on Solaris 10, ASM, Oracle Designer, Data Pump, and Oracle Enterprise Manager (OEM) Database Control
• Used Oracle Streams to create a 3-way multi-master database prototype

Confidential, Broomfield, CO

Sr. Oracle DBA

Responsibilities:

• Developed ETL code for data acquisition from OLTP databases into a 60TB corporate data warehouse and departmental data marts using Ab InitioOracle9i, SQL, TOAD, and ClearCase in Solaris and Windows environments Updated logical and physical data mapping matrix for ETL planning
• Analyzed ETL process performance issues, recommended/implemented Ab Initio /Oracle improvements and data archiving to increase runtime performance
• Installed, updated, and administered Oracle8i, Oracle9i, and Oracle 10g R1/R2 active and standby databases (24x7 OLTP and OLAP/Data Warehouse) n AIX and Windows Server 2000/2003 with EMC CLARiiON and Symmetrix SAN storage, utilizing Oracle 10g OEM Grid Control, OEM 10g Java ConsoleData Guard, SQL, Export/Import, and Data Pump

Confidential, Boulder, CO

Sr. DBA/Developer/System Administrator

Responsibilities:

• Installed, updated, and administered development and production Oracle8iOracle9i, and Oracle 10g databases on Red Hat Enterprise Linux AS/ES, AIXand Windows Server 2000/2003 using Oracle and third party tools Installed a physical standby database with Confidential
• Developed functions, packages, procedures, triggers, and views using
• PL/SQL and SQL with Perl and Unix/Windows script wrappers
• Created custom interfaces to customer databases and applications Performed data and PL/SQL migrations between development, test, and production databases using Change Management Pack and PL/SQL Developer for database schema comparisons and synchronizations
• Tuned Oracle SQL and databases and profiled PL/SQL code performance Installed, updated, and administered Red Hat Enterprise Linux, AIX, and
• Windows Server 2000/2003 operating systems; Tomcat/WebLogic app servers
• Re - engineered existing logical/physical Oracle infrastructure and security Developed and maintained Java, J2EE, MVC, MySQL, IVR, and VB6 software Performed VB6 and Web technology builds, migrations, and installations using Apache Ant and Visual SourceSafe

Confidential, Boulder, CO

Sr. DBA/Developer

Responsibilities:

• Created a new Oracle8i database infrastructure on Windows 2000 Server Installed, configured, and administered a SQL Server 2000 database
• Created Oracle8i databases in a Solaris/Veritas/EMC 24x7 environment Installed 120+ Oracle8i for Linux and Solaris clients
• Developed 130+ PL/SQL and Java stored procedures to provide all back-end processing for two distributed Internet applications, including generation f static HTML pages and management of Web application state information Converted Sybase stored procedures and migrated associated data to Oracle Provided technical and management oversight to database administrators

Confidential, Broomfield, CO

Sr. Oracle Database Administrator

Responsibilities:

• Installed and administered Oracle8i development and production databases n Solaris, including a 1.6TB data warehouse
• Acquired, installed, and maintained Oracle8 and Oracle8i databases on
• Solaris and Windows NT, supporting Windows NT clients using Net8, JDBCand ODBC for Web and client/server access
• Migrated all company DB2 data to Oracle8; converted DB2 SQL to Oracle8 Developed automated data download and transformation routines with SQLPL/SQL, Perl, Unix shell scripts, and SQL*Loader to in corporate, analyzeand transform data from Internet servers on a scheduled basis using cron Provided technical and managerial oversight to database and IT staff