Rod Merritt

*** ******** *****

Lakeway, Texas **734

Home 512-***-****

Mobil 512-***-****

abmek0@r.postjobfree.com

Dear Sir or Madam,

Since earning a Bachelor's in Computer Science from the University of

Texas, I have gained experience with all phases of software projects and

aspects of database management, OS support and storage and server room

configuration. This includes but is not limited to requirements, analysis,

design, coding, testing of applications; and production and development

database logical and physical design and administration, storage

configuration and monitoring; and even doing load balancing and racking

UPSs and servers. I have worked with a variety of hardware and operating

systems, and with many programming languages and DBMSs.

At every job, I have earned appreciation from Lead Developers for being

service oriented, and from Management for being proactive on the production

servers, and from Project Managers for tackling the hard projects by

learning and doing what is necessary to complete them on schedule. I enjoy

all aspects of DBA work and I am always interested in learning new skills

and taking on new challenges. I believe my resume shows I am flexible and

have steadily progressed in my career. I have been in the hiring and

training position as well, and believe that aptitude and attitude are more

important than a perfect skills match, and I have a plethora of each!

My resume is a little long because I believe it helps everyone to get

specific on my experience up front since I have a lot of it, but hopefully

it's organized so you can also scan for highlights and keywords.

I recently added Database Web Development using HTML/ASP/SQL Server,

Failover Clustering on SQL Server, Visual Basic development, and some

Teradata experience. I have also become a security analyst and implementer

for networks, database applications and web sites. I also recently

performed two hardware migrations for SQL Server Database Servers, one was

for our clustered production servers using PowerPath for HBA failover to

the SAN, Navisphere for SAN Configuration, and Command Line Interface

through Fabric View to do zoning on Brocade Switches to SAN.

Personal and job references and more information are available at your

request. Thank you for taking the time to consider me.

Sincerely,

Rod Merritt

Resume updated: 07/07/2010

DESIRED WORK

Database Administration and Development on Client-Servers or Mainframes.

Production DBA, Development DBA, Database Engineer for Warehouse Databases

including Extract/Transform/Load of data. Web/Database developer and

Security. Something to use my skills and build new ones!

SKILLS LIST

OS: Win 7, Win XP, Win 2k Advanced, Win NT, VM, MVS/ESA, OS/390, AIX/RS6000

DBMS: SQL Server 6.5/7/2000/2005/2008(home), Oracle 11g(home), MS Access,

DB2, DB2/UDB 5.2/6.1, DB2/UDB EEE

Lang: SQL, Transact SQL, HTML, VBScript, Jscript, ASP, Visual Basic, Visual

FoxPro 6, Java,

JDBC, SQLJ, ODBC, Perl, ISQL, REXX, CLIST, C, Cobol, C-370, SAS, Pascal,

Modicon Ladder Logic, Series/1 EDX/EDL/CF/IAM, Assembly, ASEA Robot Native

Lang,

Tools: Visual Studio 2008/6, IIS, Embarcadero ER Studio, ERWin, Navisphere,

PowerPath, Fabric View, Teradata Netvault, Regedit/Regedt32, DNS Admin,

UltraVNC, RDP, SQL Compare, MSBSA, IISLockDown, IISMgr, URLScan, Log

Analyzer, Cognos, Data Joiner, Visual Warehouse, Excel, UDB Stored

Procedure Builder, DBArtisan, SQL Advantage, TSO, TSO/I, SPF, DSNJU004/006,

DSN1PRINT, DSN1LOGP, JCL, FTP, QMF, SPUFI, DCLGEN, DSN/DSNUPROC, IDCAMS,

IKJEFT01, DSN1COPY, DSNTEP2, CSA's Expediter, Work flow diagrams, Data

Dictionary, DFDs, ERDs, HIPO Charts, Decision Tables, Professional Write,

Harvard Graphics, Smart II Spreadsheet, Flowchart II, EasyCase Plus,

CP/CMS, ToolsRun, VMServe, SFS, RSCS, VTAM/AVS, VMTape-MS, CP/CMS,

ToolsRun, VMServe, SFS, RSCS, VTAM/AVS, ISPF, OPCA, Script/GML, Profs

PROFESSIONAL EXPERIENCE

June 1, 2010 - Present * Sapphire Consultant on Bench Time

Updating Skills at home.

. Developing with Visual Studio 2008 VB against a SQL Server 2008 backend

running on Windows 7. Imported a VB 6 project and built the test database

and the app runs on my laptop.

. Configured laptop as IIS Server and porting asp to asp.net for my largest

web site and have it partially running against SQL Server as well.

. Downloaded and installed Oracle 11g on my laptop running Windows 7 64

bit.

. Configured Oracle 11g security using Administration Assistant for

Windows, built a database using Database Administration Assistant.

. I am going through online tutorials and using Oracle's Database Control

interface to create objects in, monitor, and execute SQL commands against

the installed sample database and my own database.

August 1, 2000 - May 30, 2010 * Sapphire Tech Consultant at Tx Dept of

Health, Austin

Development and Production DBA on SQL Server, Web Developer, Security, MS

Clustering, SAN config and Zoning, Windows Support. SQL Server DBA on many

Win2K Advanced servers used for development, testing and production, and a

web server. Environment is batch processing and reporting as well as

transaction processing, supporting thousands of remote users. I also am a

Web developer and security analyst. System processes almost 3 million

dollars a day and supports over 1 million clients in Texas.

. Performed all the usual production DBA tasks like monitoring,

troubleshooting blocking and performance hits, creating physical objects,

permissions, producing audit and performance reports and automating them

for email delivery to management, setting up linked servers between SQL

Servers and with MS Access, installing new versions and patches, updating

virus defs, testing and updating Cluster Service to keep servers in sync

and make sure it still worked, monitor news for new viruses and attacks

to take preventive measures before they can attack us - one time I

proactively changed the SQL Server protocol to use named pipes instead of

tcp/ip to keep us up when all other agencies went down to thwart the

Slammer worm, move databases between servers, writing SQL Scripts as

needed to automate processes - like when a Clinic loses all its data my

script and procs will rebuild the entire clinic from data stored at the

State level using existing communications and processes therefore not

requiring any other new processes or procedures, creating and documenting

reboot procedures for servers and maintenance window schedules, producing

data comparison reports for dev and prod in order to sync them up.

. Used Visio to build a Data Flow Diagram to map intra-server and inter-

server data movement for WIC automation system from field through state

systems.

. Developed and implemented automated backup and recovery jobs, and

produced capacity and maintenance plans.

. Wrote DTS Scripts to transform and transfer data, from Foxpro tables to

SQL Server, and from transaction server to batch servers.

. Created data dictionary of WIC databases.

. Worked with over 30 developers on transformations, table definitions,

transaction control and Transact SQL. Wrote stored procedures for

implementing business rules for WIC/EBT Application.

. Redid physical design of WIC Database to allow table level recovery using

an automated script that read system catalogs and dropped and recreated

keys and moved the data.

. Configured SQL Server error detection and notification through SQL Mail.

. Monitored SQL Server, Windows, Network and SAN and tuned all for

performance.

. Gathered requirements and wrote stored procedures for all Client

Transfers within Texas, processing over a thousand per day for several

years. Maintained this code for changes to business rules as needed.

. Created and tested fallback plan and performed upgrade to SQL Server 7-

sp3. Then migrated developers from NT/SQL7 to WIN2K/SQL2000 in a failover

configuration on two 8-way servers. Also performed several moves to new

hardware, new OS, new SAN.

. Produced requirements through implementation for a National USDA Web Site

assigned to TDH for a UPC Database. I did everything - Determined user

requirements and business rules, planned IT architecture for server

hardware and software, programmed web application code, did database

design and implementation, installed IIS and configured it and wrote data

conversion scripts for ETL (Extract, Transform and Load). Secured

application against attack on many levels including configuring the

FireWall. This app was never successfully attacked in 2 years with many

attempts from around the world. USDA picked up code and database.

. Created a Web Site for Order Tracking between WIC Clinics and Food

Vendors using XML to COM Objects (written by teammate) with secure login.

Installed and configured the WEB Server IIS.

. Wrote and maintained Visual Basic utility pgm which hit the State

databases to enable our Help Desk to vastly decrease response time to our

clients, using Visual Studio 6.

. Lost our Teradata DBA, so I set up the user data and catalog backup jobs

on Teradata 4475 through NetVault.

. For migration of a SQL Server 2000 Production Server to new hardware, I

installed SQL Server 2000, moved and restored all database objects and

IDs and ODBC Data Sources, swapped static/DHCP IP Addresses, and updated

our Master DNS to point to new hardware still using old Server Name. This

achieved seamless, transparent migration without involvement from the

developers.

. For a later migration to new production hardware cluster, I personally

installed and configured new clustered database servers, including MS

Clustering Service, EMC PowerPath Failover Management, HBA Device

Drivers, Zoning on Brocade Gigabit Switches, Used Navisphere for SAN

LUN/Storage Group Configuration, SQL Server 2000, ODBC Drivers, ODBC

DataSources using registry export/import, assigning static IP Addresses,

configured private and public NICs, and set up SQL Mail with an SMTP

Exchange Profile.

. When DSHS moved to a new building, the contractors did a horrible job

with power distribution, causing server failures from overloaded circuits

and UPSs. I did power calculations with load balancing and redundancy

across circuits and across UPSs for all power in server room, then racked

the new UPSs and wired all power, we never had another problem, and

during city power outages I had time to bring things down gracefully

before the UPSs gave out.

. Briefly supported a few DSHS Web sites using DreamWeaver against local

development and remote production Web Servers.

. Installed and converted SQL Servers and Clients from 2000 to 2005,

supported and performance tuned several 2005 servers.

. Set up transactional and snapshot replication between SQL 2K and SQL 2005

production servers.

. Projected all hardware and software (except switches) with capacity

planning and costs for development, test and production servers for AARA

grant.

. Since we were pushing old hardware/software past its limit, I did a lot

of Windows and SQL Server performance tuning and worked with developers

to change their code. Some reports and data aggregation programs would no

longer run in their windows so I was able to modify the database and code

to run in a few minutes instead of 3 to 10 hours for a few of them.

. Drove the requirements for purchasing and configuring the LUNs on a new

SAN.

. Used Dell Server Administrator to rig an email alert for the server room

A/C becoming overloaded by using a server incoming air temperature probe

and checking when it is out of bounds.

. Interviewed many applicants, wrote job requirements and interview

questions and employment test, hired and trained my replacement full time

State employee for two years.

June 18, 2000 - July 31, 2000 / Dec 19, 2000 - Jan 3, 2001 / May 16, 2001 -

May 31 2001

July 19 - August 5, 2001 * American Cancer Society National Computing

Center, Austin

Production/Development DBA for DB2 on ES9000-Gen4/MVS and for DB2-UDB on

NT. First engagement, two weeks training and then replaced permanent DBA

for four weeks while he went out of the country on vacation. Other

engagements followed under same circumstances.

Administered DB2/MVS and DB2-UDB on several servers in Austin and Atlanta,

using SA Authority. Responsible for production support of national

operational databases on IBM mainframe and on NT Servers.

. Monitored performance and locking using Omegamon for DB2 and for MVS.

. Performed backups and recoveries, did database maintenance and

alterations on mainframe and servers.

. Did data recovery using Platinum's (CA's) Log Analyzer product and

tracing down BSDS's (boot strap sata sets).

. Had 1000 to 1800 online users attached through DDF DB2 Connect and

CICS/Sybase replication.

. Home computer set up for Host Connection to mainframe, Lotus Notes, and

UDB Connections to Austin and Atlanta.

. Once saved all of California's data after someone dropped all databases

for that State, I tracked down backup tapes needed and drove down in the

middle of the night to recover the data, turns out the tapes were just

about to go into the scratch queue.

March 10, 2000 - July 15, 2000 * Aim Technologies, Austin, TX

Database Engineer in the Business Intelligence Dept. Install and Administer

DB2 UDB and SQL Server on many servers and various platforms for startup

company.

. Responsible for production support of corporate operational database on

SQL Server.

. Installing UDB EEE on AIX and migrating data from SQL Server for

warehouse use.

. Various other activities with monitoring and data transfer from 83 remote

servers at sports stadiums across North America.

. Wrote backup and recovery plans, did disaster recovery rehearsals.

November 15, 1998 - March 5, 2000 * Harte-Hanks, Austin, TX

DB2 UDB Development Database Administrator, supporting 10 developers

Production DBA on NT servers, responsible for assisting in all phases of

development and production of web based applications using ODBC and JDBC

interfaces. Doing both Production DBA and Development DBA work.

. licenses, security, server and client installation, capacity planning,

tuning

. responsible for physical implementations, recoverability, availability,

performance of development and production databases on two servers

. performed logical design, did forward and reverse engineering of

databases

. wrote Visual FoxPro program to automate a netchange process from ftp site

. attended International DB2 User's Group convention for 1 week

. obtained certification as DB2 UDB DBA

. attended UML and Java training at ACC (Austin Community College)

. Migrated to UDB 6.1 and set up Java development environment

. wrote a perl administration program for handling backup libraries

. worked on database design and object/relational translation for

persistence

. wrote data conversion programs in VFP

May, 1998 - November, 1998 * BMC Software, Austin, TX

Product Support Representative for DB2 products

Supported customers, developers and QA. Installed and tested BMC products.

Helped customers with a wide range of problems and questions.

. Modified c program to generate test data and make massive updates to

database.

. Wrote rexx program to generate test data.

. Set up test environments using data sharing and ran various tests.

. Worked with customers using Recovery and Log products.

March, 1994 - May, 1998 * IBM Global Services-Madison, WI

(Started with subcontractor Advanced System Design, then IBM hired me

direct)

Production DB2 Database Administrator for KIDS Project

Administered online, development and test DB2 Databases in 10 subsystems

for the Wisconsin KIDS project, a highly visible child support system with

1000+ users. Responsible for preventing potential problems and for trouble-

shooting when a problem occurs to ensure availability and performance.

. Completed courses in DB/2 Installation, Systems Administration, and

Performance Tuning

. Wrote partitioning, performance, and archiving plans for production

database.

. Identified batch programs which can use extracts to shorten batch window.

Wrote rexx/jcl to automate extract job creation weekly.

. Involved in all scheduling activities to ensure database integrity and

recoverability.

. Debugged PL/I program with dynamic SQL and wrote REXX programs to

automate utility generation. It would take months to build all necessary

jobs, so I automated the process to use templates, parameters and the DB2

System Catalogs to generate over 11,000 utility jobs.

. Tuning physical parameters for table and index spaces based on row

lengths, cardinality, update frequency and index sizes using spreadsheets

for calculation.

. Set up and scheduled backup jobs to run nightly under OPCA and Control-M

into tape GDGs, and performing recovery as needed.

. Supporting Development and Test by manipulating data within and across

environments. Performed all physical object creation.

. Maintain CopyLibs and DCLGENs.

. Wrote Cobol2/SQL Batch report programs.

. Created Plan Tables and tuned programs/databases using explain.

. Performance tuning using OmegaMon for Batch and Online, tracing deadlocks

for 2nd agent.

. Ensure online availability by automating and tuning utilities for

fastest setup and execution.

. Wrote many REXX programs to automate generation of jobs to eliminate

extents, wasted space, do DSN1COPYs, and others.

December, 1991 - September, 1994 * SCECO, Dammam, Kingdom of Saudi Arabia

Chief Business Analyst, Project Manager

Produced requirements of a large Work Management System (WMS) for the

distribution area of an electric utility which replaces or interfaces with

several existing systems.

. Developed project structure, responsibilities and design methodology for

6 man team: reviewed resumes, evaluated performance, and gave

presentations to executive management.

. Established deliverable agreements with EDP Department, surveyed and

ordered CASE tool.

. Roughly followed SSADM from business area analysis to detailed

requirements. (structured systems analysis and design methodology)

. The team published General Requirements Document for the whole project

and Detailed Requirements Document for New Supply subsystem.

. Performed business analysis for GIS (Geographic Information Systems)

department and completed a function/data interface study between WMS and

GIS for integration between the two projects.

. Produced the analysis of the Plot Plan Design and Engineering Support

subsystems and wrote the test plan for the New Supply subsystem.

June, 1984 - December, 1991 * IBM, Austin, Texas

May, 1991 - December, 1991

DB2 Admin, Host Application Programmer

IBM was losing market share because of long lead times in product

introduction. Automated the release of manufacturing control data from

various design systems to floor machines through a common relational

database.

. Administered DB2 Databases, performed table design, VSAM allocations,

table space, table and index creation.

. Wrote programs to interpret CAD output files (IFF Format) and store as

relational data.

August, 1988 - May, 1991

Host Systems/Application Programmer/Analyst, Team Leader

Maintained data collection and report generation system for electronic card

assembly and test using PS/2s, VM and MVS systems.

. Wrote JCL/SAS/SQL programs to extract data from DB2 databases and

transfer it across MVS systems and produce life cycle tracking reports

and failure feedback for products. These reports were distributed and

viewed on MVS and VM systems using VMSERVE, IOS3270, and VM Disc IDs.

. Wrote data blocking and transmitting routines in C/370.

. Supported dual 9370s as system programmer, administrator and C/370 maint

programmer for data transfer from PS/2 through 9370 to MVS/CICS.

. New product introduction increased by three times, straining report

generation methods. Automated code generation and testing (JCL, SAS,

REXX, etc.) and passed to team member. This enabled us to keep up by

reducing cycle time from five days per product to 1.

. Aided other departments by writing SAS and SQL queries .

August, 1985 - August, 1988

Series/1, Modicon and PC Programmer/Analyst

Manufacturing was losing two circuit board testers because the PCOS

communications lines were being removed from the site. Changed host

communication modules on a Series/1 mini from PCOS to SNA based protocol

for two way communications used in tester control. Tasks included

working with host programmers for protocol and line definition, and using

CF to implement SNA on Series/1s.

. Responsible for maintenance programming and modification of Series/1 code

and configuration files for an automated data collection and process

control system.

. Responsible for the debug and maintenance of vendor supplied Pascal code

on PCs used in materials handling, process control and LAN/Async

communications.

. Vendor supplied code was causing production stops for frequent manual

intervention. Coded error detection/recovery routines and communications

on Modicon 584 materials handling controllers to ensure smooth operation

of conveyors, barcode scanners, and control points.

. Performed systems analysis, process, interface and code design and

Series/1 system generation for an automated packaging line area

controller to provide: flexible, real time control of packaging materials

and product, communication with programmable logic controllers and

scanners for data gathering and equipment control, and a menu driven

operator interface.

June, 1984 - August, 1985

PC and Robot Programmer/Systems Architect Responsible for analysis, design,

coding and implementation of materials handling robots and associated work

station controllers for two automated assembly lines in a "lights out"

factory featured in Fortune 500.

. Tasks included detailed requirements specifications, interface

specifications to other controllers and vendor supplied Modicons.

. process design, coding of workstation controllers and robot programs

using PCs and Asea robots IRB90S/2, documenting with Script/GML and

training manufacturing engineering on the use of the system.

. Achieved operator free operation by using automation techniques such as

shadow disking of state, critical and communications data, start up

routines, and extensive use of sensors.

. Assisted in design and installation of robot end of arm tooling and

electrical interfaces.

January, 1979 - May, 1982 * Houston Instruments (CalComp), Houston, Texas

Field Service Representative - Electronics Tecnician

Managed one person office, maintaining digital electromechanical equip

in S.E. United States.

. Handled lease contracts and billables for preventive maintenance and

repairs, occasionally to the component level. Equipment was controllers,

plotters, tape readers, printers, and digitizers.

EDUCATION

. Bachelor's degree in Computer Science from the University of Texas at

Austin, May 1984

. Technician's degree in Electronics from Elkins Institute in Houston,

March 1973

Course work at U.T.: Operating Systems, Networking, Databases, Artificial

Intelligence, Computer Architecture, Numerical Methods, Engineering Physics

and Geology, Astronomy, Statics and Dynamics, Probability and Statistics,

Calculus through O.D.E., and Engineering Chemistry at Lee JR. College.

OTHER EXPERIENCE

Apartment Manager for two properties while attending U.T. from 82 to 84.

Electrician's assistant for Brown and Root at Mobay in Baytown. Diesel

Mechanic's assistant for Parker Brothers in Houston during high school and

junior college. Chemistry lab assistant at Lee Jr. College.

PERSONAL DATA

Healthy non-smoker, enjoy hiking, diving, sailing, mountain biking, tennis,

golf, water skiing, playing drums, gardening and snow boarding. Raced

sailboats for five seasons and placed 1st in top class at Austin Yacht

Club. PADI certified diver, certified by ASA as a Sailor for offshore

chartering in May of 2010. Drummer for alternative metal TzolkinElement and

progressive country Safer Rhodes bands. Amateur astronomer with 12" Fast

Dobsonian. Have a mechanical aptitude. Hobbies include home remodeling,

building and flying radio control sailplanes and electric planes and

electric cars, and building and repairing electronics with my sons and

cooking. Have volunteered on children's soccer, scouts, t-ball and school

outings and activities.

Contact this candidate