Oracle Data
Resume:
Jeffrey E. Mueller
Greensboro, North Carolina 27410
*******@*****.***
OBJECTIVE: Oracle Development/Unix/DBA Position
SKILLS: HP-UNIX, Linux, Solaris, SunOS, Windows 2008, 2012
•Visual Studio, Visual Basic, UNIX, HTML, DHTML, XML, SQL Server 2012/14
•PL/SQL, SeeBeyond Middleware, ETL, C, SAS, OEM, Toad, Erwin
•ArcSde, javascript, vbscript, java
•ORACLE Database Versions 5, 6, 7, 8, 9, 10.1.0, 10.2.0, 11.2.0
EXPERIENCE:
Guilford County, Greensboro, NC
Accela Administrator/Analyst (4/2010-present)
•Administer Accela permitting system for county using Oracle as a back-end database. Perform ETL from Accela application to Lawson Financials using advanced pl/sql methods. Extract complex data sets and send through pl/sql and ftp to offsite web locations. Write ad-hoc queries and reports using pl/sql, sql, Crystal and SSRS. Administer Business Objects Server. Support iPad users. Link Esri Gis components with Accela Gis. Interview users and gather business requirements for application enhancements. Train county users and interface with general public. Assist DBA when requested.
North Carolina A&T State University, Greensboro, NC
Database Manager (5/2009-1/2010)
•Manage 30 Oracle Database instances on Sun hardware. Install and maintain application software for Banner ERP system. Perform upgrades of Oracle databases and ERP application code, including C, Cobol and pl/sql. Work with developers to ensure code is correct and suitable for production. Write unix shell scripts to perform routine maintenance. Perform database backups and instance clones. Analyze query performance using supplied oracle utilities: explain plan, tkprof, and sql access advisor. Use Oracle Grid Control to help discover and solve performance problems and to schedule jobs. Design and promote disaster recovery procedures. Perform the above tasks in development and production environments including on call requirements.
Analysts International (Consultant at Glaxo-Smith-Kline) Research Triangle Park, NC Consultant (1/2009-5/2009)
•Develop korn shell and pl/sql scripts to deliver large medical information datasets into Master Data Management (MDM) databases. Analyze data output to assure proper rules have been applied to the datasets. Work with DBA staff to check partition allocation/methodology on a weekly and monthly basis based on incoming data from medical providers. Migrate partitition data on a monthly basis to read-only locations for performance. Tune queries and pl/sql routines using hint analysis, tkprof output and plan statements for best performance. Upgrade Oracle MDM application and unix scripts from Oracle 9 to Oracle 10. Prepare data for load into Teradata Data Warehouse. Use Tivoli Workload Scheduler to interface with unix/oracle scripts.
TekSystems (Consultant at AT&T) Greensboro, NC
Web Developer/Assistant DBA (2/2007-1/2009)
•Develop web-driven pl/sql pages for high visibility internal commerce application. Write korn shell scripts to process incoming data for ETL needs. Prepare data for Oracle employing unix scripting, including sed and awk, sql loader and pl/sql.
Develop XML interfaces using HTTP listener, DBMS packages and XML DB. Design VBA macros for loading of interface files into database with pl/sql. Write and perform test plans, answer user queries, using full life-cycle development perspective. As assistant dba, perform application tuning, database tuning, and tar/problem resolution, including backups. Set up Oracle directory. Manage file transfers using ftp and connect direct. Set up SSH file transfers. Assist other staff members.
Syngenta Crop Protection, Greensboro, NC
Applications Developer VI (3/2002 – 12/2006) V(11/1999 – 3/2002) IV (3/97-11/99)
•Oracle and GIS Development: Create GIS spatial analysis applications using ESRI software to edit or view business and scientific data in maps on Web. Analyze data layers from 3rd party vendors and load into SDE. Join spatial and business data for crop progress reports using Map Objects. Use ArcInfo to modify datasets for load into Oracle and SDE. Set up versioned SDE for recovery. Set up VPD for Data Warehouse. Tune applications for best performance using Oracle utilities. Analyze and solve process issues using explain plan, sql tracing and tkprof utilities. Develop data extraction programs using pl/sql, C, daemons, and korn shell scripts to migrate legacy data into a new biology database and application. Set up materialized views for global database applications. Use Erwin to create logical and physical models for OLTP and DSS systems.
DBA work: installations, backups, restoration, performance tuning, troubleshooting, volumetric considerations, etc., in HP native and HP Tru64 environments including on-call duties. Install and manage Oracle SDE instances, perform upgrades.
•Web Development: Develop middleware communication components using java and Egate (SeeBeyond) for communication of heterogeneous database applications. Create Visual InterDev applications using vbscript, javascript, .net, XML and Oracle to report contract laboratory data from Documentum to Intranet toxicology application. Create scripts to report bulk tank site inspections using VB, .net and Oracle. Develop new ASP modules. Develop remote-hosted internet application using SQL Server for the reporting of soil conditions and chemical usages at remote sites. Assist other staff members with Oracle, Unix, Webservers and NT/pc issues.
UNC-Greensboro, Greensboro, NC
Database Administrator (April 1996-April 1997). Instructor 1997.
•Install and maintain ORACLE RDBMS on DEC and Sun platforms.
Create Oracle instances. Administer security for layered software products.
Configure Oracle WebServer. Configure ODBC drivers for third-party products.
Develop scripts for backup and recovery. Teach Oracle classes to Computer
Science students. Perform staff training.
Perform tuning functions on server. Install/Maintain Banner application package.
Glaxo Wellcome, Inc., Research Triangle Park, NC
Project Analyst/Senior Systems Analyst (July 1991- April 1996).
•Develop sales analysis programs using Visual Basic, pl/sql, and SQR.
Migrate data from DB2 to ORACLE on Sun using links and SQL*Loader.
Automate database refreshes on Sun using netrc UNIX/TSO connections.
Develop and maintain application using Visual Basic, SQR, C, and DCL for Glaxo's
Pre-Clinical International Toxicology System. Developed application using Visual
Basic, ODBC, DCL, SAS and Excel to generate PC-driven statistical reports from an
ORACLE database. Implemented Visual Basic/DCL socket communication. Converted ORACLE V6 systems to V7. Developed time management system using Microsoft Access. Developed statistical modules using SAS for reporting.
Analysts International Corporation, Durham, NC
Systems Consultant at Glaxo, Inc. (August 1990 - July 1991).
Research Triangle Park, NC. Research Computing Department.
•Create a dynamic and interactive forms-driven information system using Oracle Forms to facilitate the sharing of data among chemists and biologists. This system became a world-wide application for pre-clinical research.
Converted Oracle 5 applications to Oracle 6. Created reports using SQR, C, and DCL.
Vanguard Cellular Systems, Inc., Greensboro, NC
Database Administrator (February 1990 - August 1990).
•Create and maintain nine ORACLE instances including Oracle Financials. Supported in-house Call Reporting System. Assisted ORACLE Financials users with core reports and forms. Perform database tuning. Plan for hardware and software resources. Analyze programming staff's code for optimization.
Halstead Industries, Inc., Greensboro, NC
Applications Development Specialist (September 1988 - February 1990).
•Develop ORACLE applications to support sales and manufacturing using SQL*PLUS, SQL*FORMS 2.3, SQL*REPORT, SQR. Compose DCL procedures. Automate data load procedures with SQL*LOADER. DBA functions.
Thomas Printing, Inc., Greensboro, NC
Contract Programmer/Analyst (April 1986 - September 1988).
•Install LAN. Develop Accounting System using dBASE III+.
EDUCATION: Elon University, Elon, North Carolina.
Master in Business Administration.
University of North Carolina at Greensboro.
Bachelor of Science, Information Systems & Operations Management
3
Contact this candidate