SUMMARY:

• Over 15 years DBA experience in OLTP and data warehouse database environment including mission critical and e - commerce environment (10+ years solid experience in Informix, 5+ years in experience in MySQL, and about 2+ years of experience in DB2, Sybase, MS SQL, and Oracle).
• An active member of the International Informix User Group (IIUG) and was awarded as one the 10 fastest Informix DBA in the Informix DBA contest of the 2011 IIUG Conference in Kansas City, Kansas.
• Experience with Informix 4.x, 5.x, 7.x, 9.x, 11 .x, and familiar with version 12.x.
• Experience with 24x7 and rotational supports and with high pressure environment.
• Experience with very large database environment.
• Experience with SQL development and with shell script development in ksh/bash/csh/perl.
• Proficient in logical data modeling and physical data modeling.
• Proficient in system administration function and in storage topologies and RAID.
• Experience in SQL performance tuning, troubleshooting, monitoring.

TECHNICAL SKILLS:

Operating Systems: AIX (IBM), HP-UX (HP Unix), Dynix/Ptx (Sequent), SunOS, SunSolaris, Red Hat Linux7.X. MS-Windows/NT, Macintosh, VmWare, and SunVirtual Box

Commercial Database Engines: Informix, MySQL, SQL Server, DB2 version 7/8, Sybase, Oracle version 8/9.

Languages: SQL, stored procedures, triggers (Informix SQL, SQL Server T-SQL, and MySQL language), Unix/Linux Shell Scripting ( ksh/bash/csh/perl ), AllFusion Erwin 4.1.2x, FORTRAN, Assembly, C, and BASIC.

Some Relevant Trainings: MySQL DBA training, Informix-Online Dynamic Server System Administration, Performance Tuning Informix- Online Dynamic Server (Unix), Informix Dynamic Server Internal Architecture and Advanced Administration, ORACLE 8 Database Administration, Sun Solaris 2.x Administration I”, AIX Ver.4 System Administration.

PROFESSIONAL EXPERIENCE:

Independent MySQL DBA Consultant

Confidential, Falls Church, VA

Responsibilities:

• Administer MySQL database server on virtual Linux environment - Manage MySQL software releases - Download, install, configure MySQL database server, create and manage tables in different storage engines
• Enforce MySQL directory standardization - Enforce MySQL database security - Proactively monitor MySQL to minimize problems may potentially impact the database environment
• Develop processes, procedures and defines metrics for database performance tuning and capacity planning - Configure MySQL backups - Set up and administer MySQL replication such as Master-Slave and Master- Master topologies - Maintain and create documentation for HOWTOs, standards and best practices.

Informix DBA Consultant

Confidential, Dallas, Texas

Responsibilities:

• In addition to monitoring database space usage, developed scripts that sent detail information on queries defined as long running queries, on queries used large amount of memory, and on queries involved sequential scans
• Also developed and implemented numerous database monitoring scripts that detected potential problems and sent alerts
• To manage database security, developed scripts that detected changes in database objects and privileges - Developed scripts that captured database structures, database sizes, dbspace sizes, table row counts, table sizes, table extents, table fragmentations, etc. and stored as historical data for auditing and for future capacity planning purposes.
• Provided 24x7 supports to ensure database systems availability where responsibilities covered installing and upgrading Informix software, monitoring, troubleshooting, maintaining security, tuning, modifying the database structures as necessary
• Also developed a process that regularly copied selective production data to development environment which involved data movement of many large tables -
• Supported application team with issues relating to ETL process mostly involved query performance as well as failed load jobs - Introduced incremental backup to the production database to reduce weekly backup time - Developed script that monitored backup process.
• Designed a database that stored disk I/O statistics information captured by the Unix administrator; the database was intended to be used by DBA to identify busy tables or to pinpoint read/write hot spot areas of the disks - Developed a complete ETL process that automatically populated this database on a daily

Informix DBA Consultant

Confidential, Fort Worth, Texas

Responsibilities:

• Main responsibility was to create an offsite QA database environment by duplicating the large production database instance with chunk renaming option - Based on the current available resources, implemented a workable backup/restore solution including a detail written procedure
• To minimize human intervention, provided the customer the consultation on how to automate and append all database level 1 backups to one single DLT tape - Evaluated the performance of the production database and provided recommendations -
• Also alerted the customer on outstanding issues such as table limit, data inconsistencies, and index corruptions - Developed statement of work for possible phase

Informix DBA Consultant

Confidential, Vienna, Virginia

Responsibilities:

• Provided ongoing operational DBA support to more than 100 productions, development, and testing Informix databases on HPUX, Solaris, and Linux environment - Responsibilities included backup/recovery, replication, tuning, troubleshooting, database refresh and etc.
• Improved the existing refresh job currently used text-based dbexport/dbimport utilities with a faster binary based backup/restore utility via “pipe” option which prevented frequent failures due to run-out-of space on file system directories
• Also enhanced the existing drop database module in the refresh script reducing the execution time for this part from 45 minutes to 5 minutes - Another improvement was to enhance the kill database process by associating with revoking privilege preventing application processes from spawning new connections to the database
• In supporting the data population activity where the space resource information on the target instance must be known, developed a complex database utility in Unix/KSH/SQL to generate a detail report on dbspace usage by a given database such as information on database size, location of the databases and tables, space usage by tables.

Database Administrator

Confidential, Westminster Maryland

Responsibilities:

• Provide backend Informix and MySQL database supports for Confidential ecommerce websites - Responsibilities covered many areas: transaction monitoring, troubleshooting, performance tuning, data purging, table re-org, space management, database security, backup/restore, etc.
• Introduce table fragmentation feature to resolve table limitation (maximum 32GB per table) - For purging data, developed a workable solution involved the use of stored procedures to delete hundred of million rows from dozen large tables all at the same time with no downtime and with very minimal impact to the performance of the instance - Additional responsibility was to provide database performance tuning to a dB 2 database version 8 on Windows 2003.

Informix DBA Consultant

Confidential

Responsibilities:

• Served as the Informix advisor to assist CSC’s DOL Black Lung project in their Mainframe/Cobol to Unix/Informix data conversion project - Made necessary database parameter changes for optimal performance
• Set up backup and recovery strategy, policies, and procedures - Set up database redundancy plan such as High-Availability Data Replication (HDR) - Set up monitoring and set up maintenance such as database validation (oncheck) and database update statistics - In addition, provided remote Informix support to CSC’s Energy project in Lanham Maryland (10 hours/week) and to CSC’s MSA project in Baltimore Maryland (10 hours/week).