Database Administrator System

Doug Stuns

**********@*****.***

Mobile: 480-***-****

Professional Summary

As an information services professional, I have extensive experience in the following areas: data engineering, database development, software development, database administrator, application server administrator, system administrator. I have senior experience with NoSQL and RDBMS database development, design, implementation and support in high availability replicated environments in on prem, AWS, Azure and Google Cloud. I also have excellent leadership experience including project management, new product adoption and technical team leadership for most all implementations. I have a proven track record for exceeding deliverables for all aspects of the product lifecycle.

Professional Qualifications

Development experience: Spring Boot, .Net, C++, Groovy, PL/SQL, TSQL, XML, JSON, SOAP, REST, Shells, Power Shell, Python, Spark, Pro*C, C, Spark, Scala, APEX

Database experience: MySQL/MariaDB, MS SQL, PostgreSQL, Oracle, Exadata/ODA(Linux and Solaris), DB2, CouchDB, Cassandra, Scylla, MongoDB

Cloud Experience: AWS, Azure, Google Cloud, Oracle Cloud

Virtualization experience: VMware ESX, ZEN, OVM, IBM LPAR, Solaris Zones, HPUX Partition

Database Applications experience: Salesforce, Workday, NetSuite, Oracle Applications EBS, JDE EnterpriseOne, SAP ECC/Hana, Manugistics, JDE, Siebel, Remedy, HP Openview, Oracle Utilities, Facets, PeopleSoft, Oracle Clinical

Application Server experience: Oracle Weblogic, Exalogic, Websphere, Apache, Tomcat/JBOSS, Glassfish, IIS

DevOps Monitoring Automation experience: OEM/Grid Control, Orion, Interscope, AppDynamics, Dynatrace, Splunk, Nagios, Zabbix, DataDog, PagerDuty, Ansible, Terraform, CloudFormation, Chef, Autosys, Jenkins, Maestro, Slurm

Data Warehousing experience: OBIEE, ODI, Cognos, Informatica, Syncsort, MicroStrategy, Axiom SL Reporting, Spark/Scala, Databricks, Data Lake, Delta Lake, Tableau, PowerBI, Redshift, Oracle Exadata, Teradata.

DBA tool experience: OEM/Gridcontrol, Quest TOAD DBA/Modeler, CA ERwin Data Modeler, Hackolade, Workbench, PGADMIN, SSMS

Development Tools experience: SVN, GIT, AGILE, Rally, JIRA

Operating systems experience: Linux (RH, CentOS, SuSE, OEL, BSD), Unix (Solaris, HP-UX, AIX), Windows 200x, Win7-11, Mainframe(zOS, VM/ESA, MVS, zLinux)

Storage experience: EMC(VMAX, VNX, DD, Isilon,), Brocade, Hitachi, HP, SUN ZS3-4, NetApp FAS/FSX, Oracle Storage Cells

ATT Nov 2021 – Present

(Contract GA)

Senior Oracle DBA/Azure Migration- Lead migration of multi-terabyte OL Broadband Oracle databases on 5 node 12c RAC and 12c standalone Oracle from on prem to Azure Oracle. Oracle DBA responsible for migrations, ongoing support of 50+ databases from on prem VM private cloud to a hybrid Azure environment for the OL Broadband Database. Migrate MySQL/Maria, PostgreSQL and MS SQL to Azure. Support and maintain databases in Azure for optimal performance. Work with automation team to create standard build pipelines in Azure for automations for lower environments. Setup cloning from PROD environments to lower environments. Support, deploy and maintain all databases in Azure Cloud. Perform upgrade to from 12c to 19c in Oracle. Support, maintain and optimize MariaDB 10.x in Azure. Introduce Oracle database@Azure Oracle Exadata Solution for large databases. Support GGMA 21 for AVDF auditing and other unidirectional databases. Implement AVDF 20.12 for auditing of databases. Design and implement modernization practices for Azure Oracle Databases to support java spring boot applications to make application function better in the cloud. Work with developers to optimize java spring boot application database performance. Reduce footprint of PROD environment by designing purging mechanisms for unused data reducing 10s of terabytes of data to right size and improve performance of the database. Setup OEM 135 for monitoring and tuning and alerting of all databases.

Database Developer- Tune and redesign PL/SQL, python and shell scripts process in the cloud. Design SPI encryption for IMEI/IMSI data in the database tables to assure encryption of sensitive data utilizing Voltage Java API for Oracle, MySQL/MariaDB and PostgreSQL. Integrate Oracle database with Service Now with python programs utilizing JSON/REST calls to integrate Service Now data with Broadband OL database. Design shell script PL/SQL purging utilities to maintain large terabyte tables data from growing for multi-terabyte databases utilize MERGE DML, BULK COLLECT for batch processing. Tune PL/SQL and SQL for optimize performance for database performance for memory and processing limitations for large tables. Implement table partitioning for faster data retrieval in nightly PL/SQL Batch processes.

Transportation Insight Nov 2018- Nov 2021

(Contract NC)

Oracle DBA/PostgreSQL/ MS SQL DBA/Sr Cloud Data Engineer – Lead Data Engineer responsible for on prem private cloud and cloud Azure support of Oracle 19c Environment, MS SQL 2018, 5 node Mongo cluster, MySQL, PostgreSQL, Snowflake and 20 node ScyllaDB cluster supporting transportation and logistics IOT data. Support migration team for JDE Oracle from on prem to Azure. Support and optimize JDE Oracle in Azure. Support development and tuning in .Net and Java Spring boot applications. Tune Oracle with OEM 133 and Toad. Utilize Studio 3T and Opsmanager for Mongo support and optimization. Setup migration plan for on prem Mongo cluster to Azure using MongoDB Atlas. Migrate optimize and support MySQL, MS SQL, PostgreSQL and MongoDB in Azure from on prem. Work with PostgreSQL timeseries data stores for large volumes of daily logistic data. Work with developers to redesign MongoDB to utilize TTL tables reduce excessive growth. Work with Azure Data Factory, Blob Storage Containers and Databricks for ETL pipelines from multiple sources internal and external AWS cloud to Azure Data Lake and Snowflake. Support ScyllaDB cluster upgrades and cluster maintenance with Scylla Monitor. Develop data loading process from real location IOT data of truck locations into ScyllaDB. Work with developers to create Tableau Dashboards displaying customer facing applications.

Database Developer- Develop powershell, TSQL and SQL operations for ETL migrations to improve load times by 3 hours using table partitioning. Develop shell and PLSQL, SQL ETL migration to improve load times by 5 hours using table partitioning and MERGE and BULK COLLECT for large ETL operations. Develop shell script and python to extract large ETL from NoSQL databases MongoDB and ScyllaDB for BI Publisher and Tableau reporting in Data Lake.

Comcast Jun 2016- Oct 2018

(Contract Colorado/Florida)

Oracle DBA/Exadata Consultant- Oracle DBA Exadata consultant responsible for designing, developing, upgrading, supporting and implementing DW and ODS on multiple Exadata X3-2 and X5-2 half Rack for Marketing division EDW. Lead all patch events with Oracle Platinum Service. Support multiple DW in 5-50TB DM/DW utilizing HCC, storage cell offloading optimization of queries and ETL processes. Upgrade database from 11.2.0.4 to 12.2.x. Design, implement and support Data Guard for multiple databases in active/active utilizing standby for reporting database. Provide custom PLSQL for DW and DM in both ODS and Star Schemas. Develop and tune ETL process to optimize partitioning strategy. Support storage cell cluster flash and disk replacements. Support DG and Golden Gate 12c for unidirectional database for development and HA failover. Support R12.1 EBS on X5-2 environments for Financials modules. Support and upgrade Cognos 8.x/9.x implementations and upgrades in Exadata platforms. Support JDE 9.x migration from on prem to AWS. Support, develop and upgrade IBM Campaign(Unica) in Exadata platforms supporting market segmentation design of customer base. Design, develop and implement ETL servers supporting Oracle, Teradata, PostgreSQL, MySQL and MS SQL database ETL and daily support. Support and maintain PostgreSQL, MySQL and MS SQL databases in AWS ec2 and RDS. Support external table creation from 192 node Hadoop Cluster of raw datasets to Oracle Exadata DW via external tables and materialization. Support external table creation from Teradata DW to Exadata environment. Setup, configure and maintain Oracle RMAN backups to NetBackup Media Managers and Data Domain 4500/6800 with DD Boost.

AWS Cloud Consultant- Migrate Oracle to AWS utilizing Oracle EC2,Oracle RDS, Redshift, Hadoop and Cassandra. Utilize AWS services such as S3, ElastiCache, RDS and EC2 to downsize and migrate Oracle while utilizing new more efficient methods and process EDW data while providing the same business functionalities.

Oracle Developer- Oracle Developer for DW design, development and implementation of custom PL/SQL ETL process to support DW and ODS builds. Utilize TOAD for Oracle to develop PL/SQL procedures, functions and SQL to support build and extraction processes. Optimize intensive PL/SQL and SQL Batch operations to improve ETL loading times by over 6 hours using efficient PL/SQL operations. Write custom shell scripts and python for automation and integration with other Oracle and NoSQL data sources.

Technologent Nov 2014-Mar 2016

(Multiple Companies) (Contract Colorado, Florida, Texas)

Oracle DBA/Exadata Consultant- Oracle DBA Exadata consultant responsible for designing, developing and implementing migration plans for multiple Exadata implementations for Fortune 100 customers in Financial and Banking Industries such Great West Financial, US Bank, and American Express. Lead migration of all Oracle databases from Solaris M8000 10.2.x/11.2.0.4 to 10 Exadata X5-2 (Linux and SPARC architectures) running Oracle 12.1.0.2 RDBMS running 10-20TB DW and OLTP. Mentor and train team of 5 DBA’s and DW Developers on Exadata new features and technology. Develop patching strategy with Oracle ACS for PB maintenance and perform rolling patches for one off Database and Grid issues. Lead Platinum Service BP patching events. Migrate both OLTP, Reporting and DW databases. Design, develop and implement partitioning and compression plan utilizing Advanced Table/Index and HCC compression. Install, implement and support DG and Golden Gate 11g/12c for unidirectional database. Improve GG transfer time across WAN to sub second for critical financial elements. develop and implement ASO implementation utilizing TDE with AES256 encryption. Design, develop and implement Oracle Text option using PL/SQL to retrieve contractual 401k information. Utilize context and ctxcat indexing schemes for query support of word documents and investment information accessed by Text queries using contains and catsearch operators. Implement ODA X5-2 environment Support and maintain. Utilize golden gate 11/12c for unidirectional/bidirectional data loads to ODA X5-2 from outside oracle and non-oracle database for DW and failover. Design, develop and implement Services to segregate different applications workload for Weblogic 11gR2/12c, Forms 11g, custom Java and Pro*C applications. Work with Weblogic Administrators to implement RAC aware data sources for failover of applications. Support ZFS ZS3 storage subsystem to manage Exalogic environments. Migrate J2EE custom applications to Exalogic platform. Build and implement support and optimize DW/DM to support 401K results using and supporting PL/SQL, Tableau, SAP Data Services 4.2, MS SQL DM and ODI 12.1.0.3 ETL processes to DW/DM.

Oracle Cloud Consultant- Oracle HCM Cloud and DW consultant for custom databases. Work with HR team to implement HCM Cloud for HR processes for entire organization. Migrate from on prem Oracle HR modules using

HDL. Work with techno-functional teams for different module loading. Load analytics data with Oracle Data Gateway 5.x via datasync.sh. Support DaaS in Oracle Cloud for DW operations migrated from on prem Oracle Exadata and Oracle Data Appliance. Write custom integrations with PL/SQL and shells for database migrations. Optimize PLSQL SQL for efficient loading and processing.

Choice Hotels International Sep 2013 -Nov 2014

(Contract Arizona)

Oracle Fusion Middleware Consultant– Middleware consultant implementing OEM 12c working with Weblogic and DBA teams to configure and monitor Weblogic and OSB 11g to support JAVA development team utilizing Oracle 11g/12c database on RH and Solaris. Work with java developers, Oracle DBA’s and performance support group to monitor and develop and integrate with Weblogic, and OSB in SOA 11g utilizing OEM 12c to monitor and optimize. Integrate OEM 12c with OID, Oracle Wallet certs and AD for user credentials and centralized management. Implement event management RCA, JVMD, RUEI and BTM in support Oracle Service Bus Cluster and Coherence. Create customized APEX 3-4.x/HTML reports in OEM 12c with SQLDeveloper and 12c APEX utilizing PL/SQL and JavaScript. Manage deployments of J2EE applications. Debug and trouble short performance issues for Java Engineers. Utilize OSB console and Weblogic consoles for management of xml processing layer. Change monitoring from legacy Tomcat and JBOSS Informix environments to Weblogic and Oracle 11g/12c environments.

Oracle DBA/RAC Consultant – Oracle RAC DBA/consultant for multiple 3 node clusters utilizing Dell Blades servers in RH Linux 5/6.x. Install configure and maintain databases utilizing Oracle 11.2.0.4/12.1.0.2. Migrate databases from RH Linux and SUN Solaris standalone environments to Oracle RAC. Tune and troubleshoot database performance. Setup procedures for DBA’s to perform repeatable processes and runbook.

L3 Harris Jul 2009 -Sept 2013

(Contract NY/DC)

Oracle DBA/Exadata Consultant – Oracle DBA responsible for architecting and implementing a Oracle 10g and 11g high availability environment utilizing Data Guard, Streams and Oracle RAC 10g/11gR2 for multiple projects. Design, develop and implement new database design thru production support 10g and 11g databases utilizing Oracle RAC and multiple Exadata Machines X2-2/X3-2 for 10+ TB databases in Linux and Solaris. Create and implement Solaris Zones and VMware ESX 4.x/5.x environments. Develop and implement migration plan from Solaris and HPUX Oracle 10g and MySQL, MS SQL Server 2005-2012, PostgreSQL to OL Linux 5/6 86_64 on Exadata platforms. Install and implement OEM 11g and 12c to manage databases. Utilize ZFS 7410/20 for backup devices with RMAN. Provide PL/SQL development and redesign of existing applications. Design, develop and implement Oracle Text/Context option to retrieve information from documents. Design, develop and implement Oracle Spatial option to retrieve GIS information from database. Utilize EM, ASH/AWR, tkprof, TOAD and oradebug to tune and optimize query performance in 10g and 11g RAC environments of Java Hibernate and native SQL based applications.

NoSQL Developer/Administrator– Design, develop and implement CouchDB and Cassandra databases to support image management parsing databases. Store JSON from REST services for metadata supporting image management. Setup and maintain Lucerne index structure for multiple projects in CouchDB with couchdb-lucerne. Utilize replication to multiple CouchDB environments. Access and data with cURL and Java and Groovy and Python for CouchDB. Provide integration with other data stores to support custom Java application from MySQL PostgreSQL and Oracle RDBMS. Support CouchDB virtualized environment with ESX 5.x for replicated nodes.

Database Developer - Utilize TOAD/Erwin/SQLDeveloper to design and update ERD. Utilize Agile/SCRUM process for database logical and physical designs development. Develop, implement and optimize ETL in PL/SQL to ODS and DW from OLTP environment for large data loads. Install, configure and implement OBIEE 11gR1 for DW front end utilize BI Publisher, Dashboards and BI Reporting. Create and implement ETL and DW design. Incorporate data feeds form MS SQL, MySQL, PostgreSQL and Oracle databases with shells, PL/SQL, TSQL and SQL for source databases.

AWS Cloud/Virtualization Engineer- Designed and implemented Virtualized environments utilizing Linux variants supporting open-source virtualization and Solaris Zoning/Containers virtualization to support Oracle 10g and 11g database and application server environments. Implement Zen, OVM 2/3.x, VMware vSphere 4.x/5.x and vCenter 4.x/5.x environments for development. Support full development environment of Oracle RAC and standalone databases in OVM and VMware environments. Implement AWS GovCloud to incorporate specific customers data and operations from on prem DC to AWS for application servers JBOSS, Weblogic, Oracle, MS SQL, MySQL, PostGreSQL database to Oracle 11gR2 on Linux Platform.

Dell Oct 2013-Jun 2014

(Contract Texas)

Oracle DBA - Responsible for architecting and implementing a Oracle 11g/12c high availability environment utilizing 3node RAC, DataGuard, Streams/xStreams, Golden Gate and Oracle 11gR2/12c. Design, develop and implement new database design thru production support 11g/12c databases utilizing Dell Blade servers for DataGuard and RAC environment utilizing ASM on dedicated EMC VMAX SAN running RH 6.3 for multiple 10+ TB databases. Migrate databases from ADA, VSAM, MS SQL and DB2 to Oracle 11gR2/12c. Patch, Install, clone and administrate 11i/r12 EBS databases for client. Develop and implement migration plan from z10/iSeries to RH Linux 86_64. Provide PL/SQL and SQL development and redesign of existing applications converting Pro*Cobol and Pro*C. Utilize iSpire SQLWays 6.x to convert cobol and DB2 stored procedures to Oracle. Support DB2 and other Legacy environments. Integrate applications with OID LDAP.

EMC/VMware Jan 2011 – Jan 2012

(Contract NY)

Oracle Exadata/Virtualization Consultant - Oracle consultant responsible for physical conversation of Physical Oracle 11gR2 RAC environments in RH Linux 5/6 and support 11g Weblogic Fusion Middleware environments utilizing J2EE developed applications and Oracle 12.x EBS environments to virtualized environments using vSphere 5.x/vCloud 1.5. Automate processes with JavaScript in VMware workflows. Support OBIEE BI Publisher 11gR2. Build DW Environment utilizing 2 Full Rack Exadata X2-v2 utilizing Golden Gate to aggregate data from multiple source databases to new DW. Work with Software groups to debug, migrate and clone environments J2EE, Unix shell and perl applications. Implement and support OBIEE 11g for Data Warehouse custom development accessing 10+ TB Oracle Exadata databases. Support EBS 12.x on Exadata platforms for Financial and CRM modules. Integrate Financials Data into DW on Exadata platforms.

Wolters Kluwer Pharma Solutions Jul 2009– Jul 2012

(Contract Arizona)

Oracle DBA/Exadata Consultant- Oracle DBA responsible for physical and logical database design of DW. Provide partitioning strategies for Staging, ODS and EDW 50+TB databases. Provide Oracle 11gR2 RAC database design utilizing ASM in Solaris and IBM environments. Design, develop and implement a 24 node Oracle 11gR2 Oracle Exadata v2a nd X2-2 migrating databases from SUN E25K. Support legacy DB2 databases Enterprise 8-10.x on AIX 5.x/6.x, and zOS. Migrate and integrate Teradata and Netezza DW to Oracle Exadata so that these platforms could be disabled. Provide tuning, administration, development for Informatica PowerCenter 8.x ETL, custom PL/SQL ETL and Data Mart builds in MS SQL and Oracle from EDW. Provide production support, tuning and troubleshooting for Oracle Exadata 11gR2 for customer facing queries utilizing AWR, ASH, tkprof, TOAD and EM 11g. Provide data modeling changes in Erwin to support complex patient healthcare matching and clinical data requirements. Improve Informatica mappings and ETL to staging tables. Develop and implement backup and recovery for Exadata utilizing SUN 7420 ZFS backup device with Oracle RMAN.

Database Developer- Develop and implement PL/SQL procedures for data propagation between environments and improve Informatica mappings and ETL to stage tables supporting Netezza, MS SQL and Oracle databases. Write custom PL/SQL procedures and scripts at OS level support custom ETL operations using TOAD 9.7. Optimize and redesign inefficient java programs to access the Oracle 11gR2 database for end customers and backend processes. Upgrade and develop Micro Strategy Dashboards on DW on Exadata platform in support of migration from Solaris 10/11 environment. Integrate MS SQL databases residing on VMware to Oracle Exadata .Develop APEX 3.x applications supporting pharma JSON metrics for outside customers.

AWS Cloud/ Virtualization Engineer- Designed and implemented virtualized environments in utilizing VMware ESX 4.x/5.x vSphere and OVM 3 for multiple Oracle 11g solutions on Dell 710 servers clustered servers. Performed virtual to physical conversions of 70 Windows and Linux environments. Migrate smaller Oracle and MS SQL server DW to AWS EC2 cloud environments RDS. Integrate to off prem DC for data ETL ingress and egress.

Presbyterian Health Plan Jan 2008 – Jan 2011

(Contract New Mexico)

Oracle DBA - Consulting DBA responsible for architecting and implementing a Oracle 9i to 10g and 11g upgrade and re-architecture of FACETS database application and ODS/DW databases on IBM P590 AIX and Linux OS. Redesigned and implemented production and development databases including all data model, hardware and database configurations. Support legacy databases enterprise DB2 databases 8.x/9.x on AIX 5.x and migrate to Oracle 10g/11g on AIX 5.x Facets Applications Administration for core FACETS, Networx, HIPPA gateway and IHMF, Create custom cloning process of multiple 10+ Terabyte databases. Utilize TOAD Data Modeler for all logical and physical design changes. Update and modify all PL/SQL stored procedures and packages that was invalid during upgrade using TOAD. Rewrite custom propagation stored procedures in PL/SQL for DW/ODS to resolve performance issues and integrate with DW star schemas. Implement Oracle ASO TDE for data encryption and security for HIPAA requirements. Utilize Oracle DW Builder to modify mappings as necessary to support OLTP changes.

Database/Application Developer- Develop PL/SQL procedures to support custom FACETS applications supporting batch data processing for adjudication process of high volume OLTP environment customer facing. Develop custom ETL PL/SQL to build ODS in support of large volume DW operations. Migrate data in MS SQL and Oracle to multiple DW in Oracle and MS SQL supporting different functions of FACETS. Build custom Web application utilizing APEX 3.x html and JavaScript for GAP functionality not supplied in FACETS core application utilizing 10gAS.

Virtualization Engineer- Developed, designed and implemented virtualized environments in utilizing VMware ESX 3.x/4.x for multiple Terabyte Oracle 10g and 11g solutions. Implement IBM LPAR/VPAR virtualization to support Oracle 10g and 11g database environments for multiple terabyte Oracle 10g and 11g database solutions. Architected a OEL4 10g solution for DW and reduced cost VMware ESX 3.5 solution utilizing Red Hat/OEL Linux to support development environments of FACETS 4.31/4.71/5.01. Utilize HP DL580 to support VMware host OS. Design and implement backup strategy utilizing RMAN to backup virtualized environment.

Hewlett Packard Mar 2009 – Mar 2011

(Contract Chicago/Hawaii)

Oracle Architect/Developer/DBA– Oracle consultant responsible for installing, configuring, and maintaining Oracle 10g/11g and MySQL 5 databases on VMware 4.x with Solaris x86 and Linux. Administer, develop and deploy Java applications on JBOSS/Tomcat utilizing JPA/Hibernate Frameworks with offshore team. Build and design database logical and physical design with CA-ERWIN and TOAD. Develop optimize and tune Java and SQL to meet SLA requirements. Develop design and implement PL/SQL and SQL code utilizing TOAD, EM to optimize backend processing and query retrieval in java applications.

Oracle DW Engineer- Oracle consultant responsible for re-architecture 10TB DW using Informatica 7.x and Oracle 10gR2 on SUN M5000 on Solaris 10 and NetApp FAS. Optimize Informatica data mappings and process to improve load times. Optimize and tune database to support database ETL process utilizing PL/SQL and Informatica PowerCenter 7-8.x in large DW environment for end customers. Tune and improve query performance SQL and OBI frontends utilizing TOAD 9.7..

Boeing Jun 2003 – Feb 2009

(Contract California/Denver/Alaska)

Oracle DBA- consulting Oracle DBA for 9i and 10g database on HPUX including Oracle RAC performing day to day management of space allocation, performance tuning, patching, upgrades and all troubleshooting. Perform application DBA maintenance for all Oracle COTS Applications including Remedy, Openview, Nortel, Cisco IP Solutions/Transport Manager and custom applications for GIS systems and network provisioning of dark fibre network. Implement Oracle ASO for data encryption for DSS requirements. Develop and integrate all custom Expect, Shell Scripts, PL/SQL and SQL code to support custom and COTS applications. Develop data model using CA-ERwin and Quest TOAD.. Design and implement backup strategy using RMAN and HP Data protector. Tune all database queries and explain plans utilizing TOAD, AWR and ASH reports.

Software Developer- Oracle developer and administrator for 9iAS and 10gAS Portal/Forms and Reports/J2ee Server and 9i-10gAS SOA suite application performing performance tuning, redeployments, patching, application maintenances and upgrades. Integrated 10gAS OID with Active Directory LDAP. Develop and integrate custom Remedy Application using JavaScript, SQL and PL/SQL. Administrator of Apache and Tomcat developing and supporting Java and JavaScript Applications in full product lifecycle.

Oracle Application Developer- Oracle consultant for 9iAS to 10gAS Web Portal upgrade to new hardware running SUN Solaris 10 and Oracle 10gR2 RAC. Redesign Oracle Web Portal application to Oracle 10gAS SOA suite using JDeveloper and Web Portal and JavaScript for customer facing application.

The Dial Corporation 1999 – 2003

(Contract Arizona)

Oracle Applications DBA- Consulting Oracle DBA leading the production, development and application Oracle for Oracle Process Mfg application and JDE OneWorld, including: Oracle Financials 10.7 and 11i EBS, PeopleSoft 8.x/9.x HRMS, JDA Manugistics, Oracle Process Manufacturing, Remedy 5.x and a custom DSS on HP-UX HP r8400 servers and EMC SAN. Provide all tuning for development and production databases utilizing TOAD, Qwest Spotlight, tkprof and statspack. Utilize HP Service Guard Clustering for failover and HA requirements.

Data Warehouse Developer- Architected and Designed a Decision Support System and Data Mart for the Oracle Financials, Processing Manufacturing and Order Management System. Create custom PL/SQL ETL and load process to the ODS and DW utilizing TOAD.

Oracle Corporation 1995–1999

(FTE Full-time National)

Technical System Architect – lead consulting practice for recruiting and hiring for the practice consisting of 40+ technical consultants. Lead technical design and development proposals and architecture designs for all new major project efforts. Provide and create system design and architecture for projects. Provide project plan, scheduling and budgeting of hardware and labor costs to meet SLA for client projects.

Oracle Applications DBA- consulting Apps DBA for 10.x thru 11.x environments supporting all Oracle apps modules available.

Oracle DBA- consulting DBA for version 7.x thru 9.x for numerous clients in VLDB environments using Oracle Parallel Server and HA solutions.

Database Designer- for custom applications using Oracle Designer 2000 to design logical and physical models. Implement and maintain models and associated code.

Database Developer- for custom applications using JDeveloper Java, Pro*C, Oracle Objects for OLE, Oracle Developer Forms and Reports, Oracle WebDB and PL/SQL.

Education

Bachelor of Arts in Business and Information Systems from Seattle University. Graduated cum laude.

Awards and Notables

Oracle Consulting Exceptional Performance Award 1998

Boeing Exceptional Performance Award 2002 and 2003

Oracle Certified Professional DBA

Author of Oracle 8i Backup and Recovery for OCP published by Sybex Publishers - Nov 8, 2000.

Author of Oracle 9i DBA Fundamentals II for OCP published by Sybex Publishers - May 01, 2002.

Author of Oracle 10g DBA Fundamental II for OCP published by Sybex Publishers - Jan 25, 2005

Author of Oracle 11g DBA Administrator for OCP published by Sybex Publishers – April 18,2009

Contact this candidate