Thirteen years of professional experience in the technology field specializing in Informix products on UNIX operating systems. Skills and experience include Informix Database Administration 7.x, 9.x, 10.x, Microsoft SQL Server 2000 Administration, System Conversions, ETL Development and Project Management.

Professional Training 

• Informix Relational Database Design 
• Informix Managing and Optimizing Online Dynamic Server 
• Informix Online Dynamic Server System Administration 
• Informix Online Dynamic Server Performance Tuning 
• Informix Structured Query Language 
• Informix 4GL 
• Informix Advanced 4GL 
• Java 1.1 Sun Microsystems 
• Microsoft SQL Server Administration 
• TS Easy Language 7.1 
• BRIO

Professional Training

• Informix Certified Database Specialist
• Informix Certified Applications Developer
• Bachelor of Science in Business Administration

• Informix 7.x Disaster Recovery and Database Administration
  • Troubleshoot and restore down production systems
  • Re-architect disaster recovery processes to include 3 levels of recovery: localized loss of data; enterprise loss of data; unavailability of enterprise systems
  • Implement data redundancy and scheduled backups using alternate servers and robotic tape libraries
  • Data recovery from localized table corruption

     Skills: UNIX Korn Shell, Expect, SQL, SPL, Sed, Awk

Database Consultant  (Transportation Leasing)         June 2005 - December 2005

• Informix 7.x, 9.x, 10.x Database Administration
  • Responsible for database administration of 50 Informix, PeopleSoft and DB2 databases on 12 UNIX and Windows servers
  • Performed large database (500g) migration tasks, upgrades from 7.x to 9.x to 10.x, synonym development and Enterprise Replication maintenance
  • Specialize in troubleshooting, Informix performance tuning, and client support across all systems
  • Developed tool used for data fragmentation and load balancing analysis
  • Setup and maintain DB2 federated views

     Skills: UNIX Korn Shell, Perl, SQL, SPL, Informix 4GL, Sed, Awk

Senior Database Administrator  (Financial Services)         March 2000 - May 2004

• Informix and SQL Server 2000 Database Administration

  • Responsible for the security, integrity, and availability of over 4 billion dollars of client financial data
  • Created and implemented processes for continuous logging and daily
    backups using multiple tape towers
  • Performed HDR replication, configuration, installations, upgrades for
    Informix and SQL Server 2000
  • Managed vendor relationships for most software and data providers
  • Developed Informix data management strategies using fragmentation, striping, and redundancy from the database to the physical partition level
  • Designed and implemented multi-tier DR program for all database servers
  • Responsible for UNIX administration on RS6000s
  • Managed database development projects such as new database
    development (OLTP and OLAP) and legacy database reengineering.
    Experience with Entity Relational, Warehousing, Marts, ODS,
    Dimensional
• ETL Specialist
  • Developed, and managed numerous ETL processes into and between
    company databases including both data vendor and in-house
    databases
  • Experience with large file ETL and parsing for OLAP and OLTP
    environments
• Project Management
  • Successfully managed numerous conversions projects. All projects were completed on time and under budget. Conversion projects were from Informix/UNIX to MS SQL Server/Windows/Web (Cold Fusion 5.x) platforms
  • Implemented full software lifecycle procedures and online documentation archiving

Skills : Informix 7.x, AIX 4.x, SPL, SQL, ACE, Unix shell, MS SQL Server, DTS,
            ESQL-C, Cold Fusion 5.x, MS Access, ActiveX, Microsoft Project, UNIX
            Shell Scripting: Korn Shell, Sed, Awk, Perl ; DTS, SPL, bcp, Visio, SMIT  

Database Consultant (Inventory Systems)                     May 1998 - March 2000

• Informix Database Consultant
  • Saved client thousands of dollars in vendor consulting fees by resolving numerous Informix database issues
  • Responsible for performance tuning and troubleshooting Informix Online 7.x database servers, databases, SPL, SQL on UNIX
  • Lead project to perform relational database normalization to 3N
• Lead Software Developer and Project Manager
  • Informix 4GL on UNIX application development using full software lifecycle procedures
  • Promoted to lead developer role and assumed programming work load from 3 other developers
• Responsible for Y2K compliance on all UNIX/Informix platforms
  • Developed numerous tools to assist with Y2K analysis of source code using UNIX K-Shell and Perl. Tools were instrumental in identifying and resolving all Y2K issues

Skills: Informix 4GL, SQL, ESQL-C, ACE, SPL, triggers, UNIX K-Shell, Sed, Awk, Perl

Database Specialist   (Telecom)                                     May 1997 - May 1998  

• Informix 6.x/7.x Database Consultant
  • Server configuration and tune.  Everything from LOCKS to OPTCOMPIND
  • Troubleshooting tasks such as identifying and resolving constraint violations, index corruption, space, locking and performance issues using tools such as onstat, onmonitor, dbaccess, isql, iostat, vmstat, sar, top, monitor, oncheck
• Lead Engineer for various telecom applications
  • Front-end application development
  • Designed and developed UNIX Korn Shell applications for Y2K source code analysis
  • Full Software Lifecycle Development
  • Informix on UNIX application development
  • Responsible for Y2K compliance for all platforms. Developed numerous tools to assist with Y2K analysis in source code

Skills: Informix 4GL, SQL, ESQL-C, SPL, triggers, ACE, C, Perl, UNIX Shell script, C++, Motif, Rouge Wave  

Database Specialist   (Telecom)                                     August 1994 - May 1997

• Informix 5.x, 6.x Database Specialist
  • Database and Systems monitoring, troubleshooting and performance tuning using tools such as UNIX Shell scripting, sar, top, vmstat, iostat, tbstat, tbmonitor, isql
• Multinational telecom application development and maintenance
  • Developed and maintained Informix 4GL, SQL, ESQL-C and UNIX Korn Shell applications
  • Successfully troubleshot hundreds of application and database related issues on client production systems saving clients from costly downtimes involving
• Assisted in developing structured application lifecycle standards, procedures and guidelines to meet ISO 9000
  • Based lifecycle standards, procedures, guidelines from IEEE templates

Skills: Informix 4GL, Informix ACE, SQL, ESQL-C, SPL, triggers, UNIX K-Shell, C, Perl

Independent Consultant                                            August 1993 - August 1994  

• PC support, training and troubleshooting
  • DOS and Windows based product support
• Advised clients on hardware and software purchases

Skills: Windows 3.x, DOS

Operating Systems 

• HP-UX 9.x, 11i 
• AIX 3.x, 4.x 
• Sun Solaris 
• Windows: XP/2000/NT/98/95 
• Linux

Languages/Software

• Informix 4GL
• Informix ACE
• Microsoft SQL Server
• SQL
• SPL
• ESQL-C
• UNIX Shell Programming (Sed, Awk, Perl, Korn Shell, Expect)
• C
• C++
• Visio
• SCCS
• VSS
• ODBC
• TS Easy Language
• Data Transformation Service (DTS)
• Microsoft Project
• DOS Batch
• JavaScript
• HTML
• Cold Fusion 5.5
• SVG Databases
• Informix Online 5.x, 6.x, 7.x, 9.x, 10.x
• Microsoft SQL Server 7.x, 2000
• Access 97, 2000
• DB2 UDB

Databases

• Informix Online 5.x, 6.x, 7.x, 9.x, 10.x
• Microsoft SQL Server 7.x, 2000
• Access 97, 2000
• DB2 UDB