SUMMARY:

• Over 20+ years experience in database administration, design, development, maintenance and production support of relational databases, business applications, data warehousing and Oracle applications including new server setup, Oracle installation, upgrade and patching, and migration.
• Successfully managed production systems for manufacturing and businesses applications using Oracle Architect and Oracle Application. DBA, SQL Server, & MySQL
• Strong Oracle skills but also significant general system administration skills on VMware,Linux/SUSE/Sun, UNIX/HP, UNIX/Sun, Open VMS and Windows environments
• Proficient writing Perl and shell scripts
• Knowledge in general systems administration tasks
• Significant experience with Oracle E - Business Suites database support
• Creative thinker, team player, results oriented, Business Analyst experience,
• Excellent communication skills and human relations abilities.
• Ability to work independently as well as part of a large team.

TECHNICAL SKILLS:

Hardware: Sun, HP, HP V Class, RS6000,IBM Mainframe, Dell PowerEdge R620 and Pentium-based Micro Computers from IBM and Compatibles Software, EMC VMAX / EMC VNX

Operating Systems: UNIX/Linux (Almost ALL “flavors” such as HP-UX, Sun-OS and SUN Solaris HP Open VMS Alpha, HP True 64bit, Suse V10,DOS, Windows 3.11, Windows 95, Windows NT 3.5/4.0,Windows/ 2000/2003//2008/2008 R2 /2012 and XP

Languages/Packages: Perl, UNIX Shells (C, Korn, Bourne), Visual Basic, Crystal Reports, DBASE, Excel, MS Access, Word, INFOMAN, and almost ALL Oracle tools such as Designer 2000, Developer 2000, Discoverer 2000, SQL*Forms 4.5, Oracle Reports, ODBC, Microsoft’s complete suite such as MS-Office 97 including MS Word, PowerPoint, MS Project

Database Administration and Monitoring tools: Oracle’s Enterprise*Manager/Grid Control, SQL*DBA, Statspack, Trace Analyzer, AWR; Server Manager, and tools from third Parties such as BMC Patrol, Quest SQL Navigator and TOAD on Oracle. 4GL RDBMS Oracle’s Versions 7.x, 8.x, 9.x,10g,11g,11gR2 and 12c.), SQL, SQL*Plus, PL/SQL, Almost ALL ORACLE tools such as SQL*Forms 3.0, 4.0,5.0 and Oracle Forms 6.0 Report*Writer, Reports 2.0, 3.0 Oracle*CASE, Designer2000, Developer 2000, SQL*Loader, SQL*Net, Oracle Name Server, Oracle’s Apps 11i, Oracle Enterprise Manager 10g Grid Control, Data Guard, SQL Developer Other RDBMS include MS-Access, MS SQL Server 2004. Sybase and DB2 and MySQL, MS-SQL Server 2000, 2003/2003 R2, 2008/2008 R2. 2012 MS-SQL SSIS, SSRS DBA (Database Administrator)

EXPERTISE AREA:

• Vast experience in Database Administration using Oracle 7/8/8i/9i/10g/11g/12C on various platforms such as HP-UX, SUN SOLARIS, HP True 64 bit, Open VMS, Windows NT and Windows 2000/2003/2008/2012 , Vmware 5.1
• Worked on various projects and served as DBA role for new server setup, installation, upgrades, applying patches and migration.
• Worked with developers to support ongoing Oracle issues/errors and bugs. Developed Applications with Oracle using SQL Developer, SQL, PL/SQL, Oracle Forms and Reports.
• Used SQL Loader, RMAN, Standby Database, Oracle Enterprise Manager (OEM). Also worked with MS-SQL Server and MySQL Databases.
• Created complex data mart middle tier platform using Oracle Datapump
• Installed, migrated and patched Oracle E-Business Suite version 9/10 and Version 11
• Managed OPS (Oracle Parallel Server) and stand by databases. Managed Disaster
• Recovery plan and performed Disaster Recovery Exercises at Weyerhaeuser recovery center in Tacoma Washington

WORK EXPERIENCE:

Confidential, Appleton, WI

Oracle DBA

Responsibilities:

• Currently an Oracle DBA Consultant working a Secura Insurance Company with the responsibility of migrating their Oracle 11.2.0.2 database to Oracle 12c RAC on a Linux platform. This is a three phase project with phase one and two to be completed by March 1 2016.
• Member of a performance team that is evaluating a new Vendor product that is under consideration by Secura Insurance for the commercial line of business. This team is providing bench marks under different configuration of VM/OS/Database platforms in our performance environment.
• Implemented their backup system using RMAN and Com-vault software.
• Member of a project team to update their Predictive Modeling application to Oracle 12C database and version 12C of WebLogic. This project involves migrating the current client server app to a web based application running or Oracle 12C with the potential to implement RAC (Real Application Clustering) due to the number of users.
• Reasonable for the day to day support for three production environments on a 24/7 on-call rotation support.

Confidential, Milwaukee, WI

Sr. Database Analyst

Responsibilities:

• Implementation of the IFS ERP system to one of Rockwell Automations major business systems. GMS also known as Global Manufacturing System with over 1200 active users. Candidate was a core member involved with the startup pilot system to the final implementation of the live system taking 18 months. Role in the early stages of this project was as Technical Resource Analyst using Oracle skills to install Oracle 8.x on a Windows 2000 environment which was configured to host the IFS ERP system. During later stages of project, wrote PL/SQL procedures to interface the IFS data with other external databases and applications. Once the pilot project was declared a success, candidate’s role then switched to working with the UNIX DBA to move the Oracle instances from Windows 2000 to UNIX/Sun environment. When the move was complete and the IFS environment became stable, candidate then became a member of Rockwell’s operation DBA support team.
• Became a member of Rockwell’s Global Processing Transformation (GPT) team. As a member of this team our responsible was to identify the GAP between SAP and current Rockwell applications. Through this process an intensive research though customer interviews, application flow and system process identified the need of a middle tier to be known as SAP Natural Layer. This middle layer or tier architect will consist of hardware and process to move data between SAP and existing Rockwell key Applications.
• Key technical resource in the creation of a middle tier data mart collecting data from SAP and other ERP systems like Factory Talk, Kronos, IFS and MSE. This middle tier become Rockwell’s primary messaging service between all major applications. This highly visible data mart is updated 24/7/365 with other 1500 Datapump jobs running per day.
• Candidate is currently working with Confidential operations support team supporting a very large and complex environment with more than 250 Oracle databases on 40 Unix/Linux and Windows servers.
• Responsible for physical and logical changes of some critical production systems and provides day to day support for all database instances. This includes a rotation 24x7 for on-call support.

Confidential, Marshfield, WI

Senior Technical Analyst

Responsibilities:

• Worked in a dual role as Oracle Applications developer and core DBA teams that implemented Oracle’s ERP solution to Weyerhaeuser’s Door Division. This system replaced a 25 year old Cobol/VSAM legacy system, which decreased the lead time for customer orders from 14 weeks to 6 weeks.
• The decrease in lead time increased the Door Divisions market share in architecture door business from 30 percent to nearly 50 percent.
• Team member that developed a front end Web Client Order Entry system for external customers.
• Candidate’s main responsibility was to create the PL/SQL interface from the Confidential order modeler and the Oracle Application order interface import tables.
• This application reduced the number of door architect analyst from 30 to 12.