RICHARD N. OLSEN

*** ****** *****, ****, **, **063 803-***-**** adi7y0@r.postjobfree.com

SUMMARY

An accomplished Database Administrator with 20+ years of experience in the design and implementation of application database solutions that support business functions and requirements. Possess a diversified technical background with DB2 and MSSQL.

COMPUTER SKILLS

Database Platforms

·IBM DB2 for z/OS (Versions 6, 7, 8. 9, and 10)

·IBM DB2 LUW (Version 11.1)

·Microsoft SQL Server (2000, 2005, 2008 R2, and 2012)

Software

·Database Maintenance Software: CDB & IBM Database Utilities

·Mainframe Software: JCL, ISPF, SPUFI, TSO, and z/OS

·Suse Linux (Version 12.5)

·PC/Server Operating Systems: Windows XP/7/8/10

·Windows Office (2007, 2010, 2013)

·CA ErWin Data Modeler

EXPERIENCE

4

4/2017 to 12/2020

6/2006 to 4/2017

Database Administrator I, South Carolina Department of Corrections

IBM DB2 LUW

·Upgrade of agency DB2 servers from Version 10.5 to 11.1.

·Implemented rating system to size existing/new schemas/tables to an appropriate table space/index space size.

·Successful move of 1700+ tables.

·Technical resource for programmers.

·Quality Assurance of programmer written queries using IBM Data Studio.

·Execution of programmer written table DDLs.

·Create and/or modify bash scripts

·Implementation of new bash scripts using crontab.

·Installation/upgrade of server software.

·Wrote “How Do I” documentation for department wiki.

Database Administrator I, South Carolina Disabilities and Special Needs

IBM DB2

·Serve as Principal DBA for 18+ medium to large scale in-house development projects.

·Use CA ErWin Data Modeler to design logical & physical table structures in accordance with project plans.

·Use IBM Data Studio to design and implement stored procedures and triggers in accordance with project plans.

·Use IBM Data Studio to perform query tuning for optimal system performance.

·Use DB2 Estimator to calculate index and table space requirements.

·Use CDB & IBM Database utilities to maintain database integrity with routine scheduled maintenance.

·Maintain table & view DDLs.

·Wrote training presentations for newly hired developers on DB2 SQL & Stored Procedures. Wrote stored procedure description with cross reference to associated triggers. Created a stored procedure historical (versioning) repository.

·Wrote “How Do I” documentation on DBA activities and functions.

·Serve as the Point of Contact for all Database related issues.

MSSQL Server

·Act as the lead for migration of SQL Server 2000 to SQL Server 2005, and SQL Server 2005 to SQL Server 2008 R2.

·Create new Databases/Tables or make modifications to existing Databases/Tables in accordance with project plans.

·Tune queries using Database Engine Tuning Advisor.

·Maintain System Security (Users, Roles, and Schemas).

·Wrote “How Do I” documentation for MSSQL DBA activities and functions.

3/2001 to 6/2006

Database Administrator I, South Carolina Dept. of Health and Environmental Control

IBM DB2

·Maintain the physical description of database attributes/entities, domain dictionary, documentation and standards.

·Maintain system integrity and compliance with standards.

·Serve as Point of Contact for customer support. Assist agency database users by providing support through problem solving; provided advice and direction to customers in the efficient use of the database and database software.

·Assist developers and information resource support personnel as necessary for database related issues.

·Monitor database performance, take appropriate action when necessary and/or report issues to the appropriate individual(s). Help to ensure maximum online availability of the databases.

·Plan, organize and administer the physical activities on the databases including but not limited to the promotion of new tables, table updates, unload/reload of data, and database maintenance.

MSSQL Server

·Maintained agency Home Health Care servers.

·Coordinated system updates with software vendor.

4/2000 to 1/2001

Contractor, American Roof Technology

·Wrote system documentation.

·Create proprietary database (Using Access).

·Create user interface with regard to B2B Roofing Network website.

·Performed other tasks as assigned.

6/1999 to 3/2000

Senior Change Control Analyst, AgFirst Farm Credit Bank

·Ensured operating systems & application files were successfully backed up.

·Provided technical support to programming and operations staff.

·Wrote, tested, compiled and promoted JCL used to support and/or enhance the MVS operating system.

·Verified JCL, programs, and documentation written by developers met AgFirst Standards & Procedures manual.

·Promoted programs to production.

·Performed additional tasks as assigned.

6/1997 to 5/1999

Business Analyst, Policy Management Systems Corporation

·Wrote DB2 Interface requirements for PMSC software to customer legacy systems.

·Developed new and/or modified existing rating algorithms.

·Provided clients with oral and/or written responses to product inquiries.

·Assisted in product packaging, delivery, and onsite software installation.

EDUCATION

5/1995 to 5/1997

Bachelor of Science, Management Information Science, University of South Carolina

1/1993 to 12/1994

Associate of Science, Midlands Technical College

PROFESSIONAL TRAINING

DB2

DB2 for z/OS & OS390: Building and Tuning High Performance Applications

DB2 Database Administration I: Object Creation & Administration

DB2 Database Administration II: Introduction to Internal Structures and Processing

DB2 Introduction (SQL)

DB2 Stored Procedure Programming Workshop

Relational Database Design

DB2 10 for LUW: Basic Administration for Linux and Windows

Linux

Introductory Course to Linux

MSSQL Server

Implementing a Microsoft SQL Server 2005 Database

Maintaining a Microsoft SQL Server 2005 Database

Maintaining a Microsoft SQL Server 2008 R2 Database

Querying Microsoft SQL Server (SQL Server 2014)

Administering Microsoft SQL Server 2012 Databases

Administering Microsoft SQL Server 2014 Databases

Contact this candidate