Lead projects in Database Migration to AWS, Database Compliance, and Custom Database Monitoring Platform.

Peapod Digital Labs is the ecommerce engine of Ahold Delhaize USA, one of the nation’s largest grocery retail groups.• Evaluated current database monitoring solutions in place. Proposed monitoring for the Informix databases using InformixHQ.• Successfully troubleshot and fixed DW loading processes that had been failing for months.• Wrote new scripts to improve data loading, and to provide SQL tracing without Informix’s SQL tracing.• Changed existing scripts to provide better logging for troubleshooting.• Started database documentation: Inventories, process documentation, data flow, data dictionaries and relationship diagrams onboarding procedures, among others.

Informix Database Administrator at Onyx CenterSource, a privately held company, which is world's leading provider of hospitality technology solutions for commission payments, reconciliation and billing for hotels and travel distributors. Worked in an online transaction processing environment, having recently completed a migration from Solaris to Linux, while upgrading from IDS 11.50 to IDS 14.10, including a complete storage reorganization which reduced out storage footprint by 50%. This environment is currently on Informix 14.10.FC3 on RHEL 7.6.· Provided, implemented and enforced database administration, object naming, DDL, storage, indexing, release to production processes and documentation standards.· Analyzed queries and processes, recommending adequate indexing and appropriate parallelization parameters to optimize performance on reports and batch processes, improving performance by many orders of magnitude.· Created and successfully implemented an OS and data center migration roadmap, plan and implementation schedule for all database servers and tiers, while upgrading our DB servers from IDS 11.50 to 11.70 to 14.10.· Coordinated project to tighten up data security, via database and table level permissions, firewall access review, admin accounts password enhancement, as well as user audit to comply with GDPR requirements.· Proposed, planned and implemented a complete database storage reorganization, which reduced our storage footprint by 50%.· Negotiated the IBM SW licensing and support contract with an IBM business partner, evaluating many different options and pricing schemes.· Managed IBM SW licensing compliance using the IBM Licensing Metric Tool (ILMT), BigFix Enterprise System and DB2.· Contributed to implement a proof of concept to merge data from different internal applications in different RDBMS vendors to an AWS Aurora database using CDC, to data mine the resulting dataset.· Contributed with the setup of the Nagios Monitoring system.

Principal DBA Consultant for Raytheon at Caltech’s IPAC (Infrared Processing and Analysis Center), a NASA funded science center where astronomical data captured by science satellites launched by NASA is processed, archived and served to the international scientific community and general public. Worked in a data warehouse environment, managing instances holding descriptive metadata of astronomical objects currently totaling 164Tb in size, with tables reaching a total row count in excess of 60 billion records, expecting an estimated instance size growth to a total of over half of a petabyte, having tables with a total row count well over one trillion records, growth to occur within the next 3 to 6 years. This environment is on Informix 11.50 and Oracle 11g R2, running on Solaris 10 on SPARC and x86.• Designed ETL procedures and scripts to handle massive data loads/unloads.• Problem root cause identification and diagnostic when database related problems arise.• Released database schema/data changes in test and production servers.• Designed physical storage layout towards improved database performance.• In charge to migrate all databases from Informix 11.10.FC3/11.50.FC7 to Oracle 11g R2: Oracle SW installation, DDL migration, data ETL, performance testing and tuning.• Assisted to setup the Nagios Monitoring system.• Day-to-day DBA support, both on the Informix and the Oracle environments.

Senior Informix DBA Consultant for Xtivia Inc/IBM Global Services at Walmart, the largest retailer in the world. Part of a team that managed 11,000+ Informix instances, that varied from Store and Pharmacy management systems, distribution center management to Walmart’s home-office systems.• Database software upgrades.• Problem root cause identification and diagnostic.• Released database schema changes in production and test servers.• Day-to-day DBA support.• Managed Informix versions ranging from 7.31 to 10.00 on HP-UX, AIX and Linux.

Lead Informix DBA at DHL Information Systems (Americas), Inc, the global market leader of the international express and logistics industry. Coordinated the efforts of 4 Informix DBA team that provided support for over 200 Informix instances serving several dozens of legacy systems.• Coordinated DBA tasks among a team of 4 Informix DBAs.• Delimited and documented implementation for a comprehensive Global Informix Database Security Policy, documented applications data flow and procedures, as well as database architecture.• Served as liaison between the DBA team and other workgroups, local and overseas.• Extracted and processed server, instance and database data, as well as their relationships, to populate the local CMDB. Defined procedures and trained overseas personnel to follow suit in their own environment.• Created Korn shell scripts for database monitoring, rapid deployment of DBA tools, and database inventory.• Day-to-day DBA support (i.e. monitoring, performance tuning, application/database releases, troubleshooting, data purges, backups and restores, 24/7 pager on rotation, etc.).• Managed Informix versions ranging from 7.24 to 10.0 on HP-UX, Solaris and Linux.

Senior UNIX Systems Database Administrator at First American CREDCO, the largest provider of specialty credit-reporting and information management products. Provided DBA services for their high-speed credit reporting application serving the mortgage industry.• Delimited and implemented database security and auditing policies. • Documented applications and databases architecture, data flow and procedures.• Day-to-day DBA support.• Managed Informix 9.3 and Oracle 10g R1 (RAC and non-RAC) on IBM AIX 5L.

Senior Informix DBA Consultant at WagerWorks, an Application Service Provider for the online gambling industry. Developer of popular slot machine style games such as Monopoly, The Price is Right, Wheel of Fortune, among others. Service provider for the WPT (World Poker Tour), Hard Rock Café Casino, Virgin Casino Online, Paddy Power, among others. • Created Korn shell scripts for database monitoring. • Released database schema changes in production.• Drafted a project to create a new reporting database replicated from production using CDR.• Day-to-day DBA support.• Managed Informix 9.4x on Solaris.

Senior Informix DBA Consultant for IBM Global Services at Sprint, a leader in telecom services. Provided a comprehensive range of Production DBA services for several telecom network control applications.• Achieved peak database performance through database engine and SQL tuning.• Created Korn shell scripts for database monitoring, maintenance and periodic schema change migrations.• Migrated data to and from production servers, using HPL, SQL unload and onunload/onload.• Released database schema changes to production.• Day-to-day DBA support.• Managed Informix 7.3x/9.2x/9.4x on AIX, HP-UX and Solaris.

Senior Informix Database Administrator at Brandes Investment Partners, a leading global investment advisory firm, manages assets for institutional and individual clients worldwide.• Achieved peak database instance performance through database engine and SQL tuning, based on analyses of all Production instances to identify potential performance gains.• Installed and upgraded Informix database software.• Created Korn shell scripts for database monitoring.• Day-to-day DBA support.• Worked on Informix 7.31 for NT.

Senior Production Informix Database Administrator at Merck-Medco, the premier internet-based pharmacy, providing prescription drugs to contracted corporate users thru an internet store front, as well as offering drug and pharmacy usage analysis. • Performed analyses on all Production databases to identify potential performance enhancements.• Designed database disk layouts to fit data fragmentation strategies and data growth analysis.• Reviewed permission-based data security for HIPAA compliance.• Created and updated Korn shell scripts for database monitoring and automation of maintenance activities.• Installed and upgraded Informix database software.• Migrated data to and from production servers, using HPL and SQL unload.• Released database schema changes to production.• Day-to-day DBA support.• Managed Informix 7.31 on 32-bit and 64-bit HP-UX 11.

Senior Production Informix Database Administrator for WebMD, the first end-to-end Internet healthcare company, connecting physicians and consumers to the entire healthcare industry. • Installed and upgraded Informix database software.• Setup HDR on new servers for new applications.• Migrated data to and from production servers, using HPL and SQL unload.• Planned, organized, and coordinated the physical relocation of production database servers from an alternate rented site to the new data center located on the company’s premises. • Created and updated Korn shell scripts for database monitoring and automation of maintenance activities.• Reviewed database permissions and firewall access for data security to meet HIPAA compliance.• Provided thresholds to be implemented on HP’s OpenView IT/Operations (Informix plug-in), to monitor production databases.• Performed data growth analysis.• Worked closely with the project’s System Administrator to implement hardware changes, hardware requirements for new servers (production and test) and disk layout rearrangements.• Delimited the work scope of the DBA team.• Created, designed and deployed an internal web site to document all DBA activities, documentation, utilities, processes and standards for future DBA hires.• Day-to-day DBA support.• Managed Informix 7.31 on Sun Solaris 5.6.

Informix Database Administration Consultant at First American CREDCO, the largest provider of specialty credit-reporting and information management products. • Tested, implemented, monitored and troubleshot Informix Enterprise Replication (ER).• Implemented data migration between data centers.• Provided support for the Y2K project. • Day-to-day DBA support.• The project’s environment was Informix 7.30 on IBM AIX 4.1.

Informix Database Administrator at Lockheed Martin IMS / CVO, for PrePass, a project dedicated to allow heavy commercial vehicles to bypass weight stations in several states, using advanced technology to weight the vehicles at highway speed, and fast speed communication relays to verify credentials, registration, safety records, and related data.• Developed a maintenance schedule for the production database, to improve overall instance performance.• Restructured the database server disk layout, to improve parallel scans and data availability.• Performed data growth analysis.• Migrated data to and from production servers.• Database engine and SQL tuning.• Created a performance benchmark suite of SQL queries to measure performance.• Worked on Informix 7.26 for DEC UNIX 2.6.

Informix Database Administrator and Software Developer at UniDirect Inc., now known as Rainmaker Systems Inc., a direct hardware, software, and subscription services retailer for large software and hardware corporations.As Database Administrator:• Designed and implemented new processes and procedures to migrate data from OLTP production systems to a data warehouse.• Proposed and implemented table fragmentation strategy, to solve availability issues.• Performed database monitoring and maintenance (backups with On-Tape, oncheck).• Created and loaded a testing environment.• Created monitoring and maintenance Korn shell scripts.• Day-to-day DBA support.• Managed Informix 7.24 on SCO UNIX Ware 7.0.As Software Developer: • Developed a custom generic data loader to handle data sent by new clients, capable of file handling (through AWK scripts) duplicate row checking, auto generation of new customer codes, automatic restart in case of failure and precise error logging. • Maintained various customized systems (Contact Management, Quoting / Ordering, and Accounting), using Informix 4GL and SQL.• Served as a liaison between the Development Team and the users.

Programmer-Analyst and Junior Informix Database Administrator for Andersen Consulting (now known as Accenture) at Pacific Bell, as a Member of a team that provided support to a critical inventory tracking system (Plug-in Asset Control Environment - PACE).As Programmer-Analyst:• Coded application feature updates. • Reduced data corruption by fixing bugs and enhancing the application. • Created new and maintained existing application interfaces between PACE and six other legacy systems. • Performed legacy systems data exchange analysis, scheduling and monitoring.• Served as a liaison between the PACE team and teams from other departments within Pac Bell.(Continued)As Junior Informix Database Administrator: • Performed database monitoring (onstat, onperf) and maintenance (On-Tape, oncheck).• Created and altered tables and indexes as requested by the application support team.• Performed data analysis to provide optimum table fragmentation and space usage.• Monitored the database’s performance.• Worked with Informix 7.11 on HP-UX 9.