Mr. RENE L. BUTCHER
PO Box 702

Cypress, CA. 90630-0702

714-828-1734

Butcher_Rene@databaseconsulting.com

Specialization:
With over 20 years of ORACLE experience and over 10 years of DBA experience, in both Web and networked client/server environments, I can provide DBA, Development, Design, Project Management, and Unix/Linux Administration skills that are valuable to companies using ORACLE. My mentoring and management skills provide additional value by providing training and guidance to technical and non-technical team members.

Education: Bachelor’s Degree in COMPUTER SCIENCE, Austin Peay State University, Clarksville, TN. Minor: Math

Work Experience:

Sep 2022 to Nov 2022: (Contractor) REMOTE PL/SQL Developer for Cast and Crew, Burbank, CA. Development of Oracle PL/SQL (EPG) procedures/packages, BASH, Python scripting, UI web pages (AJAX/Jquery), move from on-prem to OCI 19c.

Jan 2022 to Aug 2022: (Contractor) REMOTE Senior Database Developer with Mediant Healthcare. Performing DBA and Developer duties Oracle PL/SQL stored procedures, Weblogic12c configuration, Oracle Forms/Reports 12c, Shell Scripts, and Java.

Jul 2021 to Dec 2021: (Contractor) REMOTE Senior Database Developer with Collabera. Performing DBA and Developer duties converting Oracle PL/SQL procedures (refactoring) into Postgres Stored Procedures. Duties including moving Oracle database tables, indexes, sequences, schema, and data into Postgres.

Aug 2020 to Jun 2021: (Contractor) REMOTE Senior Database Developer for Daybreak Games, San Diego, CA. Performing DBA and Developer duties converting Oracle PL/SQL procedures (refactoring) into Postgres Stored Procedures. Duties including moving Oracle database tables, indexes, sequences, schema, and data into Postgres, including Java programming to connect Oracle and Postgres, using JIRA. Examination of DMT code (Oracle APEX) for conversion to Postgres and Java development (JPA, OpenXava).

Nov 2019 to Jul 2020: (Contractor) REMOTE Database Developer, Cypress, CA. Performing Developer and DBA duties on a part-time, as needed basis to various Oracle and PostgreSQL based projects; PL/SQL development, PL/SQL-to-PLPGSQL migration, data conversion/migration, PostgresSQL development, and web development.

Mar 2018 to Oct 2019: (Employee) REMOTE Senior Programmer (Oracle PL/SQL) for University of Southern California (USC), MOSIS project, Marina del Rey, CA. Performed DBA and Developer duties converting Oracle Forms and Reports from 6i to 12c, installed Oracle Fusion Middle Ware 12c, editing PL/SQL stored procedures, upgrading PHP web site to PHP 7, and building web pages (PHP, SQL, Javascript, AJAX). XYALIS MDP (GOTsuite) Tools training, golang, Python, and TCL automation. Financial, VSLI engineering, and project mgt. reports and Excel. VBA macros in Excel.

Sep 2015 to Jan 2018: (Contractor) REMOTE Senior DBA/Developer/Architect (Oracle/PostgreSQL/SQLserver) for Cast and Crew, Burbank, CA. Performed DBA and Developer duties included monitoring OLTP systems for E-Business Suite (EBS 12.1) and in-house applications, Data Guard, participating in On-Call rotation, working with QA/Development team members, adding indexes and Materialized Views to improve application performance, resolving Service Desk tickets, adding/removing EBS users and roles, promoting code releases between Dev/Test/UAT/Production, providing data models(Erwin) and DB documentation, executing SQL fixes for Production data, writing SQL queries to resolve issues, pulling reports to analyze the data, DB/SQL tuning, and data cleansing. Additional duties include developing a web-based Self-Service application allowing QA/Analysts/Developers to move data/files between systems as needed and generate ad-hoc web-based reports. Development of Oracle PL/SQL (dynamic SQL) procedures/packages, BASH, Excel, ETL scripting, Python scripting, UI web pages (AJAX/Jquery), EM-CLI Jython OEM Job scripting. Setting up Oracle and PostgreSQL databases on AWS using EC2 and RDS. Created Container and Pluggable databases. Configuration of SQL*NET and Pro*C. Tableau, Crystal, Jasper Reports for financial reporting.

Self-Service application automating export/import activities to allow team members to create and move data sets/baselines (PL/SQL web pages calling shell scripts via DBMS_SCHEDULER jobs and EM-CLI jobs in OEM 12c) (Web PLSQL Tool Kit with AJAX calls for XML and JSON)

Highcharts Javascript pages generated by PL/SQL packages displaying drill-down graphs of DB Space Usage: Container/DB/User

Developed Java/JDBC programs to port/migrate Oracle metadata/data into PostgreSQL

Development of Web Services and ETL processes using PL/SQL stored procedures (dynamic SQL) including ORDS (Oracle REST Data Services), automation of file transfers, and data conversion/transformation/quality processing,

Provided Stored Procedures interfacing Oracle logins to MS Active Directory via LDAP

Developed web pages to allow interactive upload of data files into EBS queues for data processing

Developed Data Pump routines to regularly refresh data from Burbank servers into Amazon EC2 Oracle instances

Installed, configured, and managed virtual servers on AWS

Jan 2012 to Sep 2015: (Employee) REMOTE Senior Database Administrator (DBA/Architect)/Server-Side Developer (Oracle/Javascript) with SICOMM.net in Carlsbad, CA. Performed DBA duties included hot and cold RMAN backups. Additional duties include developing and releasing DB and web code from Dev to Test to Production, DB/SQL tuning, providing data models and DB documentation, providing Production support including database changes in support of the Sicomm B2B (https://basec.sicomm.net/login) and G2B web-based application, providing Linux administration, including NTP, DNS, and NAGIOS activities. (iPlanet app server with Perl/PHP cgi and Server-Side Javascript) Worked closely with Vendor and Agency Support Staff to resolve technical issues, including creating reports with Embedded PL/SQL Gateway (EPG), JasperSoft, Subversion, RedMine, SqlDeveloper, jDeveloper, REST Services, Toad, and Oracle Forms/Reports. Installed Wordpress and setup initial site pages (PHP). Configuration of SQL*NET and Pro*C. (http://www.sicomm.net)

Moved Oracle database from local host to Amazon Cloud EC2 servers installing Oracle 12c on Enterprise Linux (also moved NFS server)

Moved Oracle database from local host to vCloud Air servers installing Oracle 12c on Ubuntu Linux (also moved NFS server)

Installed, configured, and managed virtual servers on AWS and vCloud Air, including security groups and network routing (NAT)

Converted standalone ASP/SqlServer based application to integrated Oracle/iPlanet, including System/Web Testing (eCatalog)

Insured database quality by adding auditing triggers, tables, additional keys, and practicing Quality Control Activities

Supported Software Development Life Cycle (SDLC), including test environment management and test execution and closure

Worked with node.js using oracledb npm module and angular.js . (AJAX using JavaScript/Jquery)

Developed PL/SQL stored packages, triggers, etc. in support of web applications, including System/Web Testing, Quality Review, and release mgt.

Developed extensive PL/SQL (dynamic SQL) procedures for web-based reporting system, including API’s for returning data as HTML/JSON/XML

Developed Administrative subsystem using Oracle Forms for maintaining customizable options and direct data access

Implemented Oracle TDE (Transparent Data Encryption) on AWS instances using both auto-login and password-based key-stores

Feb 2011 to Oct 2011: (Employee) Senior Database Administrator (DBA) (Oracle) with Computer Sciences Corp (CSC) (Navy contract: Corona) in Norco, CA. Performed DBA duties included hot and cold backups using RMAN and shell scripts, SQL Loader, Export/Import, SQL Plus, recovery management, DB/SQL tuning, Data Guard, database migration from 10g to 11g, on-line reorg, etc. Oracle Forms (10gDS), ERWIN, VSS, and Toad. Additional duties include administering ORACLE 11g classified and unclassified datamarts and data warehouses on Windows servers, releasing Stored Procedures and DDL from Dev to Test to Production following CM controls, assisting Product Development with all aspects of the Development Life Cycle including coding and review of stored procedures (PL/SQL), materialized views, issue investigation, etc., development of audit procedures and supporting database auditing reports. Providing Logical and Physical Modeling using Erwin and release management using Visual Source Save. Development of ETL processes using PL/SQL with dynamic SQL.

Jan 2005 to Feb 2011: (Employee) Senior Production Database Administrator (DBA/Architect)/Developer (Oracle/MS SQL Server/mySql) (80% DBA/10% Design/10% Development) with Ceridian Tax Services of Fountain Valley, CA. Usual DBA duties included hot and cold backups using RMAN and shell scripts, SQL Loader, Export/Import, SQL Plus, recovery management, DB/SQL tuning, Data Guard to Disaster Recovery Site, database migration from 8i to 9i to 10g to 11g, on-line reorg, etc.  Oracle Enterprise Manager, Oracle Advanced Security, Oracle Forms/Reports (10gDS), Spotlight, Quest Central, Toad, FogLight and SharePlex.  Additional duties include administering ORACLE 11g/10g/9i/8i datamart on HPUX/Win2K servers, releasing Stored Procedures and DDL from Dev to Test to Production following CM controls, assisting Product Development with all aspects of the Development Life Cycle including coding and review of stored procedures (PL/SQL, Java), materialized views, issue investigation, etc., development of SOX procedures and supporting database auditing reports. Providing extensive operational background in establishing and implementing operational standards for installing and maintaining/patching Oracle binaries, establishing and implementing DB monitoring, DB backup/recovery, access management, performance troubleshooting, DB upgrades, DB migrations, test, and validation in a large scale enterprise implementation. Implementing Disaster Recovery procedures and geographically separate site, Services Management, ITIL (Foundation), SCRUM, Service Desk, and 6-Sigma. Providing Logical and Physical Modeling using Oracle Designer 10g and PowerDesigner.  Implementation of data partitioning, compression, and archive automation.  Support of COTS products such as Appworx and Business Objects.  Participating in on-call rotation, project and time tracking using PlanView, weekly status reporting, and virtual elimination of unplanned database downtime. Development and deployment of Web Services and ETL processes using PL/SQL stored procedures, JDeveloper, and WebMethods. (12TB payroll data warehouse) Worked with on-shore and off-shore teams. Lead DBA in 3 member team. Configuration of SQL*NET and Pro*C.

Supported Software Development Life Cycle (SDLC) and Information Technology Lifecycle Management (ITIL)

Designed and created test data, executed test cases, logged defects, managed defect resolution, ensured reproducible and verifiable results

Assisted with Use/Test Case development, execution, and closure. Provided strong analytical and problem solving skills

Provide Quality Control Activities, such as database integrity, verify data criteria, consistency, processing movement, and completeness

Designed, Developed, and Implemented Wage Garnishment system written in Oracle Forms and PL/SQL procedures saving $2million/year

Developed extensive PL/SQL (dynamic SQL) procedures managing Business Rules and Workflow using Roles

Replaced dozens of Cobol ETL programs with SQL/Loader and PL/SQL

Developed EDI process using External Tables, PL/SQL, and DBMS/Scheduler to automate Linux scripts for file processing

Developed Java/JDBC programs to nightly load MS SQL Server data into Oracle data warehouse

Aug 2004 to Jan 2005: (Contractor) Oracle Developer (10% DBA/90% Developer) with UBC of Las Vegas, NV.(a dot.com) This position involved working with other project DBAs and Developers, logical and physical design using Designer 9i/10g and Erwin, and coding of stored procedures (PL/SQL and Java), and XML/XSLT. Move Stored Procedures from Dev to Test to Production. Develop Reports and Forms using 10gDS. Administer 10g Application Server. Source code management using CVS.

Apr 2001 to May 2004: (Contractor) Oracle DBA (70% DBA/30% Designer/Developer) with Toyota Motor Sales of Torrance, CA.(a dot.com) This position involved administration of ORACLE 9i/8i datamart on HPUX and Win2K servers, working with other project DBAs, logical and physical design using Designer 9i/6i and Erwin, change management of both code and models, development of physical and logical standards documents, and coding of stored procedures (PL/SQL and Java), MS SqlServer, XML/XSLT, and Informatica. Oracle DBA duties included hot and cold backups using RMAN and shell scripts, SQL Loader, Export/Import, SQL Plus, recovery management, DB/SQL tuning, database migration from 8i to 9i, etc. Toyota Order Management System (TOMS), including working with ADO/COM+ programmers and tuning n-tier applications. Data uploads and downloads nightly between various systems, including SqlServer, and other mainframe applications. Configuration of SQL*NET and Pro*C.

Developed extensive PL/SQL stored procedures, functions, packages, triggers, object views, object types, including PL/SQL server pages (PSP)

Created tables, indexes, views, materialized views, including range partitioned tables and indexes

Developed in-house encrypt/decrypt database function in Java for application level security

Developed extensive HP Unix shell scripts, including Perl and Oracle Forms using 9iAS, for DBA activities: automating development and testing schema level refreshes (also converted FORMS from 6i to 9i)

Tuned SQL and PL/SQL (dynamic SQL) for max performance, including extensive DBA and Architectural problem solving, replacing looping with Bulk Collections, use of temporary tables, and Statspack

Performed code reviews on backend and middle tier VB code

Use of ClearCase for source code management, Oracle Designer for models, and ClearQuest for defect tracking and call tracking (IBM Rational)

Training: IDEF Modeling Techniques and LEVERAGE workshops by D. Appleton (DACOM). ORACLE DATABASE DESIGN, MODELING, and ADMINISTRATION, BEGINNING and ADVANCED SOFTWARE DEVELOPER courses by Oracle Education Services (included all ORACLE development tools, including Designer, SQL*Forms, SQL*ReportWriter, SQL*Menu, PRO*C, PRO*Cobol, etc.). IEEE Networking Course. Control Data Corp.'s CREATE (Computer Resource for Effective Author Training) curriculum for Developing and Designing Computer Managed Instructional Materials.
2001: Introduction to Java by Oracle Education.
Introduction to XML by Learning Tree International.
2002: Administering the Oracle9i Application Server by Oracle Education.
2004: Oracle Database 10g: New Features for Administrators by Oracle Education.
2005:  6-Sigma White Belt training.
2006:  ITIL training.
2009:  Sun’s MySQL DBA training.

Awards:
3rd Place in CODA-94's CDE Tools Programming Contest. (CDE SQL*FORMS 4.0, SQL*REPORT 2.0, and SQL*GRAPHICS )

Security Clearance: Final Secret Clearance, Defense Security Service, granted 26 May 2011 (expired 2015 due to lack of extension)

As of Jan 2023