SUMMARY:

Highly skilled and versatile database administrator and programmer with over 30 years of database administration and programming experience in a wide variety of Unix, IBM mainframe, and Windows Server environments since 1983.

TECHNICAL SKILLS:

Technical Database Administration Skills: Deep experience designing, creating, maintaining, migrating, installing, and recovering Informix, Oracle, Sybase, Sqlserver, IMS, and DB2 databases. Have experience with many Informix, Oracle, Sybase, Sqlserver, IMS, and DB2 databases tools (summarized below).

Sybase/Informix: Sybase Central, all standard utilities, isql, bcp, stored procedures, startserver, showserver, all standard Informix utilities including oninit, ontape, onbar, onload, onaudit, onspaces, isql, esql, dbaccess, dbexport, dbimport, dbschema, OpenAdminTool, Commvault for Informix

Sqlserver: SSMS (SQL Server Management Studio), MS SQL Reporting Services, SQL Server Configuration Manager, Sqlserver Activity Monitor

Oracle: Grid12C, Opatch, Sqlplus, server manager, dbexport, dbimport, DataPump Export/Import, LogMiner,Pl/SQL, RMAN,DBUA,Commvault, RMAN, SQL*Loader,Hot/Cold backup/restore experience, DBArtisan, TOAD, Commvault for Oracle others

DB2/IMS: Spufi,DB2I,Bind,Load,Copy,Recover,Reorg,Repair,Runstarts,etc. PSBGEN,DBDGEN,ACBGEN,DLT0,PSB/DBD/ACB MAP,IMF,MFS,IMAGE COPY, Reorg utils (various), CHANGE ACCUM, etc. and other HIDAM,HDAM,HISAM,GSAM, DL/I,DC utilities

Technical Programming Skills: Experience with Unix shell scripts, stored procedure coding with Sybase, IBM Mainframe Assembler, PL/I, Cobol, IMS batch and DC, IMS and MVS/ZOS EXIT programming, IMS OTMA exit coding, IMS MFS coding, DB2 and SQL coding, Dialog Manager, REXX, Clists, DBRC direct coding access, VSAM coding, Xpediter debugging tool, MicroFocus Cobol, Stingray IMS tool, XDB DB2 tools, mainframe tools typically used with IBM Mainframe coding (IE IDCAMS, JCL, utilities). Experience with Java, HTML, SQLPLUS, JDBC, Java Servlets, Apache Web Server and Tom - Cat setup and use, HTML, DreamWeaver.

Additional technical skills: Recently been studying via formal classes and online access MongoDB, Big Data technology, Map Reduce programming, Hadoop Operating System tools. Numerous technical courses with Informix, IDUG, Oracle, The Learning Tree technical courses and many others.

PROFESSIONAL EXPERIENCE:

Oracle, MS Sql server and Informix Senior Database Administrator

Confidential

Responsibilities:

• Have quickly learned MS Sqlserver tools and procedures necessary for support of numerous facilities, including SSMS (SQL Server Management Studio), MS SQL Reporting Services, SQL Server Configuration Manager, etc. Installed Sqlserver 2016 on several Windows Servers, created new databases, engaged in numerous restores of databases, and migrated numerous SQL Server databases from versions 2008 through 2016. Created several new stored procedures, maintenance plans, and Sqlserver auditing needed for Confidential services.
• Returned to Oracle DBA work and engaged in an aggressive self - learning schedule to refresh and upgrade my Oracle database expertise. Engaged in several oracle upgrades to version 12c, installed several Oracle PSU patches, restored and recovered several databases using RMAN, Commvault, and GRID 12c. Engaged in all aspects of 12c and 11g Oracle DBA support after a 10-year absence from supporting Oracle.
• Continued to support applications built on Informix version 12. This includes essential City services such as their 911 emergency system, and various Portland Police critical applications. Continued to support Informix HDR and ER replication systems. Upgraded the Confidential ’s OpenAdmin Tool to the latest version available (3.15.1)

Sybase and Informix Senior Database Administrator

Confidential

Responsibilities:

• Migrated over 130 Informix Instances from de-supported Informix versions to Informix 11.7
• Migrated over 50 Sybase Instances from de-supported Sybase versions to Sybase 15.7
• Reduced production pages and Call-to-work issues by 75%
• Senior Sybase and Informix database administrator supporting over 300 production Sybase and Informix IDS and Standard Engine instances as well as numerous development instances.
• Position consists of all dba functions from new installs of Sybase and Informix, migrating Sybase and Informix to new versions of Sybase and Informix or to/from Oracle, maintenance and tuning, fault analysis, developing shell scripts and stored procedures, design of new instances, 24/7 production support. Operating systems include all versions of Unix and Linux.

Technical Specialist

Confidential

Responsibilities:

• Migrated over 50 Oracle instances from older versions of Oracle to Oracle version 11g
• Updated IMS Exit Assembler programs that resulted in elimination of internal IMS DC Online bottlenecks
• Position consisted of two critical and discreet functions - the maintenance of a large system of Assembler, PLI, Cobol, Rexx, Clist, and Dialog Manager programs along with database administration work with Oracle, DB2, IMS, and Informix databases.
• The programs I maintained were used by most of the applications in the Confidential business billing system that performed critical functions such as IMS exit functionality, MQSeries and OTMA message routing, IMS database partitioning, IMS checkpoint functionality, DBRC access, and various common utility functions.

Programmer/Team Lead

Confidential

Responsibilities:

• Designed, coded, and implemented a complete re-architecture of a Cobol/DB2/IMS online error system that reduced throughput of a critical monthly billing cycle by 48 hours
• Performed a great deal of design and coding for an IMS DB/DC and DB2 system that processes heavy volumes of errored 800 and 900 business calls. Acting as the development project leader I served as the main focal point regarding all system design changes. Some of the programming technologies I routinely used included MicroFocus COBOL, XDB, Stingray, IMS DB/DC utilities, PC/Mainframe File-Aid, DB2 utilities, XPEDITER, and many other PC and Mainframe tools.