(SNAP SHOT OF RESUME)
EDUCATION
St.Cloud State University, St. Cloud, MN
Bachelor of Science C.S., M.E., Business Administration
PROFESSIONAL EXPERIENCE
EDS July 08 – Dec. 08
Fort Knox, KY.
(Contract) USAAREC United States Army Recruiting Command
Linux Administrator, Sr. Oracle DBA
Managed 5 Oracle 10g instances. One Warehouse and the other a startup
development application.
Managed the MS SQL Server 2005 DW on a backup role and primary when primary was
absent or on vacation.
Warehouse size of 350gb and the Development application called ARIS was 4gb
initial size.
Managed Oracle 9i to 10g migrations.
Sole backup up for Oracle Data warehouse support.
Worked on scripting solutions using Perl and ksh.
Provided Oracle tuning expertise where data where house was concerned.
Performed Development architecture for the new Oracle 11i AS environment porting
over
10g AS code to new while also creating new code.
Utilized Sun Solaris 10.
Worked with Solaris admins to trouble shoot database errors.
Used Solaris knowledge to help in configuration of Solaris environment.
Responsible for creating Development Test and Production Environments for new
RMAN
Environment.
Sole architect and implementer of RMAN environment.
Blue Cross Blue Shield North Dakota Aug 06-April 08
Fargo, ND.
Linux Admin, Sr. DBA (Oracle, SQL Server, Sybase)
Created Dev, Test QA Databases from Production.
Created a RAC Test Environment using Several Small Linux HP Intel boxes to do my
Cost Analysis. This was done
To show management the cost of of switching All Oracle DB except the Data
warehouses to Linux and to show
The benefit of Switching over to the rac environment.
Our Dev environment consisted of DBs that were 1/2 the size of there production
counterparts.
Handled the creation of the Quest Architecture layout and installation for the
Blue Cross Blue Shield of North Dakota Enterprise Solution. This solution was
based on the Need for monitoring and DBA Control of all instances (90+ Oracle 9i
and 10g Instances, 200+ MS Sql Server (2000, 2005) Instances, 10 Sybase instances
10 & 11)
Worked as backup sql server dba when primary DBAs were either on vacation or
workload heavy.
Provided all enterprise monitoring for entire Database architecture for Oracle
SQL Server MySQL DB2 using Quest product called foglight and trained jr. sql
server dbas in configuration and rule creation as well as reports for management
to make strategic business decisions.
Our production Database systems ranged in sizes from 100gb up to 1 terabyte(Data
warehouses).
Our Test environment consisted of DB’s there were complete mirror images of
there production
Counterparts.
Our production system(s) were multi-home oracle 9i and 10g AIX LPAR system which
held 15 Oracle instances
With an LPAR completely devoted to just the running of Data Warehouses.
Worked on the creation of the Stellent (Oracle Enterprise Content Management)
System.
Handled the DBA responsibility for the Oracle Order Management System.
Performed initial analysis for stellent environment on AIX and Linux. Decided
On Oracle 10g running on Linux and placed Stellent software on Linux Server 4.
Worked on creating dev environment for stellent with Oracle support people.
Converted several generic web sites
To test stellent development environment.
Involved in the tail end of the migration of people soft 8.3 to 8.8.
Responsible for the creation of the QA, Production portion of the people soft
8.3 to 8.8
Supported All Production Databases as well as Test and Development.
Performed exports/load on all databases.
I handled installation and trouble shooting for all Database instances.
Handled in excess of 120+ oracle instances.
Handled oversight and management of 4 Oracle Data warehouses. The latest WH
will have input in excess 300+ GB per Night.
Provided Enterprise solution for Monitoring and trouble shooting entire Database
Environment.
Moved most of the entire Oracle environment over to Linux for cost saving
purposes and efficiency and performance. Turn around on moving was a gain of 60 %
on downtime and much easier management.
Handled re-architecting of database environments both 9i and 10g.
Selected overall monitoring software and DBA interfaces for Oracle, Sybase and
MS Sql Server Environments.
Handled Database creation as well as automation of manual duties.
Managed to utilize old tools like HP Open View to perform active monitoring of
DB environments.
Performed as backup administrator and created central server to perform backup
monitoring of failed Backups.
Worked with Development teams to create db environments.
Worked with Security and compliance officers to set Oracle Environment up
correctly.
Installed Full Quest Software Package for DBA Group to utilize in a forward
support model.
Worked with Development to Recommend Development Tools where DB was concerned.
Handled Multi Million Dollar High Transactional DB. Performed Trouble Shooting
and took corrective action while working in concert with Vendor and Oracle.
Performed Perl diagnostic and performance tuning on several Perl developments.
Configured Guardium for Database monitoring for the Internal Security and
Auditing Team against the Oracle Environment and AIX and Linux environment.
Handled Several Multi-Grouped Tasks.
Performed single handedly the migration of PeopleSoft 8.88 Oracle 9i to
PeopleSoft 8.89 Oracle10g in less than 60 hours with no room for errors or
defects. System performance increase of 45% from an IBM AIX 5.3 Lpar to an Intel
based quad core machine running RH 4. I did the Oracle configuration by hand
while helping with the architecture of the Linux Intel box.
Worked on the Conversion of PeopleSoft from 8.8 to 8.9. Provided all Oracle
migration from 9.8 to 10g.
Team Excel (Contract State of Minnesota Dept. of Natural Recourses) June
06-July 06
St. Paul, MN.
Sr. Network Engineer, Sr. HP Open view Administrator
Re-Installed Open view application on Sun Solaris
Worked out solution to incorporate Oracle into application to save data due to
my involvement with a company purchased by HP to incorporate into Open view
called Desk talk.
Re-Discovered entire state network found solution to deal with finding other
Department Devices. Re-created mapping of entire network of State DNR
Department. Created paging script to alert based on location and copy State
admin in Main office in St. Paul
Worked with HP to understand the New interlink between Open View and Tel Alert
Used Perl heavily to configure Open view to perform paging schema mapping and
emails.
Worked with Department Chief and Local Support staff on a Schedule for new
device discovery and limitations on that discovery.
UPP Business Systems (Contract) April 06-June 06
Fargo,ND.
Systems Administrator, Security Auditor, SOX Auditor, DBA
In my role as DBA during this project I managed several Sybase instances
totaling more than 1 terabyte in size on AIX.
Managing Oracle was scaled due to my resonsabilities as a SOX Auditor and
compliance person.
Read and Utilized Several DOD Security Documents to make Security Compliance
Document for Corporate Security Use.
Utilized the Security Compliance Web Site at http://csrc.nist.gov/pcig/cig.html
to provide Guidance in developing Security
Document for Government Standards Compliance And Security
Specifications.
Performed SOX Compliance Testing Utilizing Scripts I Had to Create Using Perl.
Performed Security Audits of AIX Systems Using Perl.
Performed All Scripting in Perl 5.8.0.
Utilized Object Oriented Programming with Perl.
Used Several Perl Modules including those I Had to Create to handle Specific
Security Tasks.
Performed Systems Checks using MD5 Hash had to create to handle File Changes.
Performed Systems Administration to Several IBM Risc 6000 Boxes.
Handled All Scripting for Connection To Sybase Database for Security
Compliance.
Handled DBA responsibilities for Oracle 8i and 9i Migration plans.
Performed DBA duties and planned for integration of new tools to help with
Monitoring and trouble shooting.
Helped admin Servers and provided Solutions for Critical DB’s to eliminate Down
Time.
Will be handling the STIG Requirements for MySql as well as PostGreSQL which
currently have no STIG compliance
Documentation other than General DB Security.
Created Oracle RAC test environment while maintaining current environment to
show benefits of both environments.
MegaHard Inc. Dec. 01 – Present
Buffalo,MN.
Linux,FreeBSD,Suse System Administrator,Sr. Systems Analyst, Sr. Software
Developer, DBA
I only work for them part part time at the present time. Mostly doing light
ticket support and minor development.
Handled All Network Installs and Setup.
The backbone of the Network is Sun systems running a mix of Solaris 2.6 to 9 and
Windows 2000 and Linux and
FreeBSD.
Utilized Perl and windows scripting and ghost for the various windows setups.
Manage Several MS SQL Server databases in all dev test and production.
Monitored All Security and Network and Web Traffic. Utilized various Software
packages to perform
Web and system monitoring.
Managed multiple SQL Server 2000 installations and performed daily DBA duties
and maintenance.
Managed multiple CPU and multiple Windows 2000 Servers install and network
monitoring. Also developed Proprietary scripts to utilize windows SNMP agent for
reporting of system utilization.
Developed Security Profile and Models
Developed Core Software Products and Marketed to Customers. Wrote Initially in
VB 6. Then migrated to VB.NET. The application uses several different Dart
Network Controls for SFTP, SSH.
Wrote several Stand Alone applications to handle customer information utilizing
VB.NET with C# and utilizing XML for loading into Small MS Access DB.
Wrote Media Application in C#.
Wrote Multiple Web Applications to handle various Business tasks in C#.
Wrote application to handle Customer Help Desk function in C#.
Wrote two install scripts one in MSI (Microsoft native) and one with the Wyse
installer. Went with MSI due to the knowledge That MSI is Microsoft and Wyse is
not.
Worked on Initial Setup and Install of Software at Customer Sites.
Worked hand in hand with customers gathering any and all information for
projects.
Handled IIS 5 and apache install and setup.
Setup Corporate E-mail Systems as well as Monitoring.
Handled Help Desk and created new trouble ticketing system for customers.
Wrote the auto-ticket system for customer trouble issues using vbscript and ASP
(Working on converting to ASP.NET).
Wrote part of the Internal Helpdesk Software in DHTML with XML.
Utilized UML for Architect work.
Process Methodologies: Understand and practice generally accepted systems
management and IT operations strategies and methodologies such as ISO, ITIL, and
a custom ITIL-based methodology; perform IT process evaluation, gap analysis, and
IT process re-mapping and re-structuring projects.
Project Management: Cultivate and improve ability to analyze, architect, and
manage project plans for IT tool implementation, configuration, development and
customization, and operations; perform client project management role,
interacting with IT management, developers, architects, analysts, and vendors.
Managed Customer interface development as well as customer requirements
gathering.
Handled Database Development and Architecture in both SQL Server 2000 and Oracle
8i (Investigating into migration to 9i at this time.)
Current Subscriber and Member of Several VB discussion Groups and mentor to
several thousand developers over the Internet.
Utilize Java for several data Server translations and monitoring of security. |