Resume 8

DATABASE ADMINISTRATOR / SYSTEMS ENGINEER

Computer Information Professional presenting more than twenty-two years of solid experience in Information Systems. Demonstrated Database Administration skills including, but not limited to Database and it s Instance/Engine planning, configuration, implementation, troubleshooting, performance tuning, disaster prevention and recovery skills to over 30 client-customer companies, for short/SWAT, medium and long term assignments. Displays excellent leadership, listening, assessment and persuasion skills. Highly effect in communicating technical information and issues to technical and non-technical end-users alike. Informix Database Administration expertise. Knowledgeable of Enterprise Replication. Pursuing MS SQL Server and DB2 UDB certification. Experienced UNIX Systems Administrator. Oracle Installation and use experience. B.S. in Computer and Information Science.

Tri-County Health

Performed Upgrade from Informix IDS Ver 7.3 UC8 to IDS 2000 Ver 9.21 UC4-1 and installed 4GL Ver 7.30. and SDK Ver 2.50.UC2, then tuned engine. Set up archecker utility. Evaluated/investigated the environment/infrastructure in general, implemented and made general "good practice" recommendations.

United Bank Of Commerce

Implemented a clone/semi-hot Informix instance, Ver 7.31UC7-1 from their production instance. Advised client on Informix backup tools available, pointed out the significant differences, advantages and disadvantages from IBOC s perspective, implemented chosen tool and assisted them with demonstrations and explanations to the staff of how to utilize it. Educated their staff on advantages that using Informix Enterprise Replication would provide, including near-instantaneous propagation of data from one server to another and some challenges that would need to be addressed in order to consider it s use.

AgriFarm

Performed, advised and implemented an instance Health Check & Performance Tuning tasks. Improved 3 categories of performance 20 , 30 and 50 while eliminating writes between checkpoints when no clean memory pages were available, besides reducing the polling workload for each cpu virtual processor.

Strategic Outsourcing, Inc.

Delivered Database tuning expertise on IDS 2000 Ver. 9.21.FC3. Helped uncover that the disk infrastructure was configured in a way that only partially utilized the high availability protection and performance capacity capabilities of the hardware and software.

Circuit Court, Florida

Due to impending capacity limit of disks, presumed inability to add more of that model to the given server and the length of time involved for the onbar migration being the major part of a week or longer , the task at hand was to get Informix 7.23.UC1, OnBar and Omniback2 OB2 working together sufficiently on a smaller scale, so that the staff could use the tools on a larger scale to perform a full blown migration later.

ABF

Performed Informix DBA services, such as performance monitoring and tuning, data archiving and log management, network connectivity for user workstations and daily database management. Reviewed and approved the suitability of using the Informix Storage Mgr SM , vs. other SMs, to reduce the 16-20 hours or more using ontape it took to back up the 80GB Informix production instance. Researched and troubleshot the previous ISM installation, which produced unusable backups. Re-installed and corrected the implementation, resulting in backing up 80GB in as little as, just over 2 Hrs in the development environment, which passed validation checking.

GTE, Fort Worth, Texas

Carried out General DBA Supervisory Skills. Oversaw and assisted in the establishment of on Oracle instance and in the migration of data from an Informix instance to it. Provided general DBA problem troubleshooting resolutions.

Informix Software SWAT Team

Responsible for reviewing current and implementing planned Informix instances, data migrations, apprising/advising site mgt., DBA s & UNIX system administrators of performance monitoring and tuning, disk RAIDing and/or layout, database installation and configuration issues; code reviews, UNIX script writing and maintenance for Informix customers. Implementing ISM for Informix s onbar utility usage.

GTE, Orlando, Florida

While at GTE-LES, performed installs, registrations and manipulations of the Informix and third party provided Datablades, a number of which dealt with webpages, webtags, webimages and facial recognition. Used Informix s blademgr and locally written utility scripts to do so. This ran within Silicon Graphic s IRIX OS. Produced detailed documentation/instructions of their locally developed methodology which was used to migrate integral metadata and data of their database, that included their web pages, tags, images; Informix engine and datablade software. This was used to migrate/synchronize the upgrade of their Bastille application from one server to another, while maintaining the versioning infrastructure on these servers which would allow, if needed, shutdown of their app. and instance while linked to one version of their instance environment, with a rapid restart of the application and all its necessary components after delinking & relinking, to a different instance environment .

Kmart

Assigned to Kmart to provide performance enhancements and methodologies for their existing warehouse database. This involved verifying the correct problem manifistation, in order to provide a correct diagnosis to the actual performance problem. Adapted scripts in order to report on the tables that had too many extents. Per customer request, produced Database Schema SQL statements and shell scripts to correct extenting problems. Provided on the job training for their Jr. DBA personnel. Diagnosed cause and implemented restorative solutions for down instances. Performed real time monitoring of system resources, which lead to identifying poorly performing SQL statements, and recommendations, which yielded the same/desired solution set, at a more robust speed.

The Signature Production Group

Informix DBA for the customer s production environment. Responsibilities included creating database-monitoring scripts to alert and notify operations and DBA support, based on alarming events in the database. Created Informix- fragmentation strategies for database and application performance. Implemented archiving strategy for recoverability. Standardization of Informix and OS versions for all telemarketing servers. Trained Signature associates to effectively handle DBA functions.

Informix Soft, Inc.

Responsible for the migration of data from Sybase to Informix 7.23 for the MCI Star OE project. The conversion efforts included the use of various Sybase, Informix and UNIX migration tools to export and filter data; analyzing, optimizing and configuring the disk layout, initialization and tuning of the Informix engine, manipulation of the database schema to take advantage of optimization techniques and migration of the data into the new database tables in a parallel fashion.

Performed Database Administration services for Informix Online Dynamic Server, such as performance monitoring and tuning. Developed an archiving strategy and created scripts for database archiving and logical log management. Responsible for reviewing and recommending changes to the composition of SQL statements, which optimized the performance of the Powerbuilder applications using them. UNIX & GCOS System Administrator. Other duties included assisting in the re-engineering of the Mainframe label application system, which included combining label data with data control commands, essential for the production of offset printing plates; roll labels or laser printed sheet labels. Assisted developers in various problem resolutions, including connectivity, code efficiency and communication issues.

Provided technical guidance in the use of the GCOS File Management Supervisor FMS utilities. Evaluated and performed file saves/restores of system and user files. Assisted programmers and functional users in resolving or working-around system software deficiencies. Adept at following the procedural and data flow of undocumented and/or documents program written in higher or lower level languages. Possessed TS/ESI security clearance.

Informix Database versions 5.x, 7.x, 9.x UDO, Informix Blade Manager, Informix Third Party Datablades, Informix High Perfomance Loader, Informix HDR High Availability Replication , Informix ER Enterprise Replication , Informix On-BAR, ISM, Informix Performance Tuning, SQL, Erwin, UNIX, Solaris, AIX, HP-UX, IRIX, Linux, K Shell, Bourne Shell & C Shell Scripting, Crystal Reports, MS Windows 2000, NT, 98, 95, 3.1, MS Office 2000 applications Excel, Outlook, PowerPoint, Word, etc .

B.S. Degree in Computer and Information Science, Ohio State

Informix Dynamic Server Backup & Restore Strategies onbar/ISM
Master Series Informix advanced Performance Tuning.
Using Informix Enterprise Replication.
Informix Dynamic Server Advanced Performance Tuning
Informix Dynamic Server Performance tuning.
Informix Dynamic Server Systems Administration Managing and Optimizing Informix Dynamic Server.
Veritas Volume Mgr and Netbackup.
BMC Patrol
Crystal Reports