Earl Baldomero

Experience

• 

  I.T. WORKS CORPORATION

  Apr 1995 - Feb 1997

  Analyst Programmer

  • Systems Analysts/Programmer in a cargo forwarder.• Analyzed and developed user requirements into technical specification.• Enhanced existing systems.

• 

  UNISYS PHILIPPINES

  Feb 1999 - Jun 2002

  Project: Bureau Of Customs Port Area• As Unix System Administrator, installed and administered OS, user accounts, and applications on servers.• Responsible for he security, data integrity, system performance, and connectivity. Monitored disks, memory, and CPU usage before, during, and after working hours.• Updated site managers on server status.• Created scripts for scheduled tasks, manual, and as requested by the programmers and some other clients who connect to the servers.• As System Test Analyst/Programmer, worked in a three-man team and assisted the Bureau in developing test data and performing integration test on the business application systems according to specs prior to implementation, documenting exceptional findings during the acceptance test of the business application systems. Tested and Implemented Asycuda 1.x / EDI gateway on ESS Unisys Server BOC.• Environment: UnixWare 7.1.x, Informix Online, Window98, Onnet32 Show less

  • Sybase Database Administrator

    Feb 2002 - Jun 2002

  • System Test Analyst / Programmer / Unix System Administrator

    Feb 1999 - Feb 2002
• 

  Stradcom Corporation

  Aug 2002 - Dec 2003

  Sybase Database Administrator

  • Responsible for the database administration including database installation and setup, database upgrade, performance monitoring, backup and recovery, resolve data conflict on replication process, and implementation of the Land Transportation Office (LTO) application patches/fixes to ASE servers.• Handled all Region 3 LTO District Offices (25 Sites) and Region 5 LTO District Offices (10 Sites) monitoring and maintenance of the Central Office Server including deployment of packages for all jaguar servers.• Environment: Windows 2000 Advanced Server, Sybase Adaptive Server Enterprise 12.0, Sybase Jaguar Server 4.1.1 and 4.1.3, Sybase Replication Server 12.0, SQL Advantage, Embarcadero DBArtisan 5.4.1 Show less

• 

  Sybase Solutions Corporation

  Feb 2004 - Feb 2005

  Professional Services Consultant

  • Provided on-going advise and consultation of Sybase applications. Engagements generally focus on improving availability of service for a genuine 24x7 operations taking in recovery procedures, disaster planning and contingency, migration of ASE versions and performance and tuning. • Conducted Sybase training delivery of Intro to SQL, Fast track to ASE, Sybase ASE administration.• Involved in Globe Telecoms Billing and Collection (ASE Trouble Shooting), Autoloadmax (ASE12.5.1 and Replication server), Iris (ASE Installation and recommendation), Gentext (ASE Trouble Shooting), and Analog Devices (ASE and Replication server). • Responsible for the ASE Assessment and Performance and Tuning of LBC Courier Service.• Performed ASE Assessment and Performance and Tuning for Rizal Banking Corporation.• Tasked with the Public Safe Mutual Benefit Fund Inc.'s ASE Migration from 11.9 to 12.5.0.• Responsible for the QA systems and database(s) configuration and recommendation for the province of Malolos, Bulacan, Philippines.• Involved with the ASE Installation on AIX machine for the Capitol Medical Center, Philippines.• Performed support and troubleshooting for the 3D Industry.• Upgraded the EAServer of Makati City Hall, Philippines.• Installed ASE, Linux, and configured ASE for Sulpicio Lines Shipping Corporation.• Responsible for the ASE Performance and Tuning of E-KONEK. Show less

• 

  HCL Technologies

  Mar 2005 - Oct 2005

  Sybase/Oracle DBA

  Project : Prudential Life• Administers and maintain databases.• Creates primary database storage structure (tablespaces) and primary objects (tables, views, indexes, and so on) for application developers.• Modifies database structure requests of application developers after go thru impact analysis on applying the requested changes.• Creates user Ids and maintain system security with necessary document to keep track the use of each user ID.• Monitors database performance.• Plans and executes backup recovery for all the databases.• Crosscheck backup recovery for all the databases.• Performs startup and shutdown of databases.• Performs monthly housekeep on partitions tables and execute requested CMR’s. Show less

• 

  Sybase Solutions Corporation

  Jan 2006 - May 2006

  Professional Services Consultant

  • Installation of ASE 12.x , 12.5.x, RS 12, Sybase IQ• Provided consultation of Sybase applications. Engagements generally focus on improving availability of service for a genuine 24x7 operations.• Migration of ASE versions and performance and tuning. • Conducted Sybase training : Intro to SQL, Fast track to ASE, Sybase ASE administration.

• 

  Barclays Capital

  Jun 2006 - Feb 2011

  Sybase,Oracle,MSSQL DBA

  • Provide DBA support on a 24 x 7 database operations for Sybase/ Oracle/MS SQL database on Windows 2003/2008/Unix/Linux.• Creating schema/login accounts.• Extend database space/tablespace/file group in Sybase/Oracle and MSSql instance• Monitor and resolve Sybase replication environment if any issue.• Monitor and resolve weekend jobs such as DBCC, Reorg and index rebuild.• Resolve backup/restore for any issue for Sybase/Oracle/MS Sql. • Implement Change Request during weekend.• Experience in RMAN,Data guard Show less

• 

  UST Global

  Aug 2011 - now

  Sr. Sybase (SAP ASE) & MongoDB DBA

  • Provide DBA support on a database operations for Sybase.• Monitor and resolve database issues.• My role includes working with various groups,guiding peers by introducing best practice to improve the process.• Upgrade ASE servers from 15.0.3 to 15.7/ 15.7 to 16.0 which runs on AIX• Restore /Refresh dev servers from production backup upon request.• Write some shell scripts to automate admin functions for multiple accounts termination• Write some shell script to monitor, check files backup to TSM, compress monitoring output files to free file system space and consolidated backup report. Show less