|
Contact us to be connected with this Informix DBA Consultant
Summary
Over seventeen years of professional experience in the technology field specializing in database administration, and project management. Experience includes database support, designing and implementing disaster recovery plans, managing whole system conversion projects, and software engineering.
Employment History
October 2010 - October 2011
Senior Database Administrator
Project Manager
Database Administrator and Project Manager for Informix IDS 7.31,11.x on UNIX, Linux and Informix 9.4 on Windows 2003/XP.
- Assumed responsibility of and supported billion dollar annual revenue producing systems
- Responsible for production server availability, disaster recovery operations and assisting developers
- Managed multiple projects to redesign backup and recovery processes, redundancy and migrations
- Architected plan and developed proof-of-concept for Informix IDS 7.31 on MP-RAS UNIX to IDS 11.x on Red Hat Linux 5.x migration
- Overhauled entire Informix/UNIX environment to reside on new hardware and performance tuned database servers
- Developed numerous shell scripts to report on availability of systems, and perform many routine administrative tasks
- Developed shell scripts to purge large amounts of obsolescent production data on routine basis and not interfere with production activities
- Extensive inventory, analysis and documentation of existing systems and applications as well as documenting administrative tasks
- Informix IDS installation, configuration and performance tuning
Skills: Informix IDS 7.31/9.4/11.x on UNIX, Linux and Windows; ISM/Onbar; shell scripting; 4GL; SQL; ISM/Onbar; Technical Documentation
April 2006 - October 2010
Senior Database Administrator
Project Manager
Database Administrator and Project Manager for the conversion of a complex financial services legacy billing system previously running Informix 7.x on AIX UNIX to Informix 11.x on Windows. This conversion effected all tiers of the billing system including application, hardware, database, ETL and vendor relationships.
- Performed complete Billing System architectural analysis and developed a plan to convert Informix 7.x on AIX UNIX to run on Informix 11.x and Windows
- Streamlined the ETL batch loading processes
- Developed Cold Fusion Web modules and ESQL/C (Windows) programs to perform ETL and replace ScreenSurfer and UNIX shell scripts
- Established process for unit testing batch load process by comparing relevant fields of the load file with queried data from the database
- Informix IDS installation, upgrade, configuration and performance tuning
Skills: Informix IDS 7.x/11.x UNIX and Windows; MS SQL Server; MS Access; Windows Administration; Informix SQL; ESQL/C; SPL; UNIX shell scripts; Cold Fusion; SQL; SPL; Windows 2003 Administration; Visual Basic; Technical Documentation; Project Management
January 2006 - April 2006
Senior Database Administrator
Project Manager
Database Administrator and Project Manager for Emergency Data Recovery Project in the Financial Services industry. This was a full life cycle emergency disaster recovery project to access damage, develop a recovery plan, appropriate resources, implement recovery and design an appropriate disaster recovery plan.
- Performed full data analysis for missing, duplicate, and corrupt data
- Recovered millions of records of critical production data
- Successfully extracted data from multiple databases in a corrupted backup instance and recovered data from archived tape media
- Developed data parsing and insert/update routines to re-introduce data into production
- Configured and implemented an additional UNIX backup machine and daily archive routines
- Informix IDS installation, configuration and performance tuning
- Architected a backup and recovery scheme to ensure minimal losses in event of another disaster
Skills: Informix 7.x UNIX and Windows; MS SQL Server 2003; AIX Administration; UNIX Korn Shell; SQL; SPL; Technical Documentation; Project Management
June 2005 - December 2005
Senior Database Administrator
Consulting Database Administrator for Informix 7.x, 9.x, 10.x on HPUX UNIX
- Responsible for database administration of 50 Informix, PeopleSoft and DB2 databases on 12 UNIX and Windows servers
- Performed large database (500gb) migration tasks, upgrades from 7.x to 9.x to 10.x, synonym development
- Informix Enterprise Replication development and maintenance
- Specialize in troubleshooting, Informix performance tuning, and client support across all systems
- Developed tool used for data fragmentation and load balancing analysis
- Created and maintained DB2 federated views
Skills: Informix 7.x/9.x/10.x Administration; Enterprise Replication; UNIX Korn Shell; Perl; SQL; SPL; Informix 4GL; Sed, Awk; PeopleSoft; DB2
March 2000 - May 2004
Senior IT Manager of Institutional Systems
Senior Database Administrator
IT Department and Project Manager for both application development and server administration teams. Responsibilities included working with executive management and end users to transform visions into reality for the betterment of the company.
- Responsible for a software engineering and support staff up to 15 employees with varying degrees of skill and experience
- 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
- Proven ability to develop and maintain teams for maximum productivity
- Managed vendor relationships, performed product and compatibility analysis
Database Administrator for Informix and SQL Server 2000/2003 Database Administration managing all production database servers, ETL applications
- 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 and Dimensional
- 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
- Informix IDS installation, configuration and performance tuning
Skills: Informix 7.x; AIX UNIX Admin; SPL; SQL; ACE; Unix shell scripting; MS SQL Server Admin; DTS; ESQL-C; Cold Fusion 5.x; MS Access; ActiveX; Microsoft Project; Sed; Awk; Perl; DTS; SPL; Visio; SMIT; Technical Documentation; Project Management
May 1998 - March 2000
Senior Database Consultant
Lead Software Engineer
Consulting Informix Database Administrator to the U.S. Department of Interior supporting Informix 7.x on AIX UNIX
- 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
- Lead project to perform relational database normalization to 3rd Normal
Lead Software Developer and Project Manager for Informix 4GL inventory management systems
- Developed inventory management system for the DOI in Informix 4GL on UNIX
- Implemented full software lifecycle procedures from requirement gathering to configuration management and support
- Promoted to lead developer role and assumed 4GL 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 shell scripting; Sed; Awk; Perl
May 1997 - May 1998
Informix Certified Database Administrator
Informix Certified Application Developer
Database Administrator for Informix 6.x/7.x supporting database servers used for telecom POTS services
- Informix IDS installation, configuration and performance tune
- 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
Software Engineer for various telecom applications
- Front-end application development using 4GL, C++ and UNIX shell scripting
- Designed and developed UNIX Korn Shell applications for Y2K source code analysis
- Implemented full software lifecycle development practices
- 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
August 1994 - May 1997
Database Administrator
Software Engineer
Database Administrator for Informix 5.x, 6.x supporting Telecom client workforce management production systems
- Database and systems monitoring, troubleshooting and performance tuning using tools such as UNIX Shell scripting
Software Developer for Informix 4GL on multinational telecom application projects
- 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
- Assisted in developing in-house structured application lifecycle standards, procedures and guidelines to meet ISO 9000 from IEEE templates
Skills: Informix 4GL; Informix ACE; SQL; ESQL-C; SPL; triggers; UNIX K-Shell; C; Perl
|
 |
Website Design Portfolio
Website Example This Month
Informix DBA Consultants
Providing remote Informix Support
Places2NETWORK.com is a division of
Cybercom Consulting, Inc
Complete Advertising Packages for Small Businesses
|
