Executive Summary
Over 24 years experience in the field of Information Technology. Extensive experience in all areas of the System Development Life Cycle including Project Management, Business Systems Analysis, Database Design and Administration, and Programming in a variety of platforms and languages.

Operating System
Unix, Linux, Solaris 6/7/8, HP-UX 9/10/11, IBM-AIX, SCO-Unix, Windows-NT, Windows 2000, OS/400, OS/38

Softwares
SAS Data Integration (ETL) Studio, Ascential DataStage XE, Lawson ERP, Oracle V6/V7/8/8i/9i/10g/11g RDBMS, Oracle PL/SQL, Oracle SQL*Plus, Oracle SQL*Loader, Oracle Enterprise Manager, Oracle Net*8, SQL*Net V2, Quest Toad, Oracle Developer 2000 Forms/Reports, Visual Basic 6, Pro*C, Korn Shell Scripting, Platinum Plan Analyzer, ERWIN data modeller, MagicDraw data modeller, Platinum DBVision & Server Vision, Perl, Crystal Report, Cobol-400, Control Language (CL) 400, AS-400 Screen Design Aid (SDA), AS-400 Query, AS-400 Data File Utility (DFU), CL-38, Cobol/38, Informix RDBMS, Informix 4GL, Informix SQL.

Work Experience

Confidential,Morris Plains, NJ 07950
May 2008 to Present
Feb 2010 to Present
3 ADP Blvd., Roseland, NJ 07068

Performed the following as a Database Administrator/Developer:

• Install oracle software and create databases in RAC and non-RAC environments
• Monitor and tune database performance using AWR, OEM
• Review and tune application (SQL) queries
• Develop logical and physical data models using TOAD Data Modeler
• Create the database objects in the database as per data models
• Extract/load data into databases using sql*loader, export/import utilities
• Write PL/SQL scripts, procedures and triggers
• Write automated jobs using shell scripts

Confidential, May 2008 to Feb 2010
470 Wall St., Princeton, NJ 08540

Worked as a Sr. Database Administrator for various projects using Oracle on Linux and Unix performing various database related tasks:
Database Administration

• Install and configure Oracle softwares and upgrades
• Install, configure, and manage Oracle Real Appication Cluster (RAC) databases and Oracle single-instance databases
• Create physical database and database objects (tables, indexes, views, etc) as per database design
• Monitor and tune database performance using Oracle Enterprise Manager (OEM), Statspack, and OS utilities
• Write unix shell scripts and database scripts
• Support application developers in their database requirements, such as, loading of test data, database refresh, writing and optimizing queries, etc.
• Optimize database application queries using tkprof, explain plan, and toad
• Gather data volume projections and plan for data growth
• Plan the back-up and recovery strategies for the different databases
• Implement back-up and recovery procedures using Oracle Recovery Manager (RMAN)
• Plan and Implement database archiving for fault tolerance
• Ensure database availability and performance
• Attend to all database and database-related problems

Database Architect

• Gather and analyze database requirements from application architect/s
• Plan and design logical and physical database models using MagicDraw
• Create tables, indexes, views, synonyms, database triggers, and other database objects for different applications

Database Developer

• Write Oracle PL/SQL programs using TOAD and SQLDeveloper
• Write and test stored procedures and packages using PL/SQL for different applications
• Write stored functions to implement FGAC using VPD dbms procedures
• Design the Extract-Transform-Load (ETL) process for Business Intelligence application
• Write and test ETL programs using DataStage

Lawson – Philippines
Confidential,Philippines
Feb 2007 to March 2008

Worked as a Sr. Oracle DBA for various projects. As an Oracle DBA:

• Install and configure Oracle softwares and upgrades
• Install, configure, and manage Oracle 10g Real Application Cluster (RAC) databases and Oracle single-instance databases
• Design logical and physical database models
• Create physical database and database objects (tables, indexes, views, etc) as per database design
• Monitor and tune database performance using Oracle Enterprise Manager (OEM) Database Control and Grid Control for RAC, Statspack, and OS utilities
• Manage users and user connections in RAC
• Write unix shell scripts and database scripts
• Led, managed, and coordinated a team of 5 people on a day-to-day basis
• Developed data quality assurance criteria and procedures

Aug 2001 to Jan 2007
Pasig City, Philippines

Worked as a Datawarehouse Designer/DBA for the Corporate Data Warehouse of the Manila Electric Co. As a datawarehouse designer:

• Translated business requirements into technical specifications
• Designed datawarehouse dimensional data models to support user requirements
• Designed datawarehouse ETL process.
• Identified data sources, constructed data decomposition/mapping diagrams, and documented the process.
• Wrote specifications for the ETL process.
• Developed normalized data models for the staging database.
• Wrote ETL jobs using Ascential DataStage ETL tool.
• Wrote stored procedures/scripts to capture data changes using Oracle Streams.
• Wrote stored procedures, packages for ETL process using Oracle PL/SQL; also wrote shell scripts.
• Wrote programs using Cognos Impromptu, Transformer, and Powerplay.
• Prepared project plan and schedules.

As a datawarehouse DBA (Oracle 8i/9i):

• Prepared initial data volume and data growth rate to determine data storage requirements.
• Wrote and Implemented physical database design for the datawarehouse
• Created database and corresponding storage and memory structures, e.g., tablespaces, rollback segments, redo logs, etc.
• Created tables, partitions, indexes, synonyms, etc.
• Wrote shell scripts for running the ETL process.
• Manage the ETL process and validate the results.
• Monitor and Fine-tune the database and the application SQLs.
• Performed regular database backups.