PROFESSIONAL CERTIFICATION

ORACLE CERTIFIED ASSOCIATE

TECHNOLOGY

• Oracle Warehouse /OLTP
• Greenplum /Big Data
• DB2
• Data Integration
• Ab-Initio ETL
• Attunity Replication ELT
• GoldenGate Replication
• Perl/Unix scripts

QUALIFICATION SUMMARY

• 12 years IT experience administering, supporting, maintaining and development using leading-edge technologies on Oracle Database Administration
• Resolved database performance, database capacity and other database integration issues
• Optimized and monitor long running operations and report queries.
• Development Java , Support Linux/Solaris/VMware Red Hat, Debian, ESXi System Administration and Network Administration

DATABASE Administration

• 10 yrs extensive experience on Oracle Database Administration on Linux/Unix/Windows platform using Oracle 9i,10g,11g, Oracle Grid and XE
• Data replication using Data Guard for HA, GoldenGate, Attunity and Ab-Initio
• Load, Transform and Extract data using Abinitio ETL, PL/SQL and Perl/UNIX scripts
• Migrate Oracle Datawarehouse to Greenplum Big Data platform using Attunity
• Support DB2 realtime OLTP database
• Support GoldenGate Realtime Replication
• Intensive Backup and Recovery experience with RMAN, FLASHBACK, Export/Import and Data Pump technology
• Solid experience on creating Stored Procedures, Pipelined Functions, Triggers, Materialized Views and Packages
• Substantial Experience on Table Partitioning as well as Oracle Scheduled Jobs
• Experience on dealing with database corruption, tablespace and datafiles monitoring
• Excellent knowledge using Enterprise Manager, iSQLPlus, SQL Developer, JDeveloper
• Excellent query optimization, database troubleshooting skill and bulk loading using SQLLoader
• Intensive experience on SQL/PLSQL and Unix Scripts automation statements
• 3 Yrs experience on Oracle Application Server Identity Management and Repository
• Strong background on Oracle Application Server10g Installation and Configuration
• Excellent background on Oracle Internet Directory Advanced and Two-Way Replication
• Strong LDAP and OID processes background for broadband and wireless authentication
• Manage relational Database system configuration, security, backup and recovery, replication and high availability
• Provide optimization and troubleshooting techniques to address performance problems
• Ability to address all aspects of database support/development activities independently, with minimal supervision
• Perform, monitor and enhance backup and recovery procedures for multiple databases
• Install, upgrade and patch database to suit client' requirements
• Good problem solving skills, ability to analyze and debug issues
• Good experience performing logical and physical database design to support network engineering team
• Developed, test and maintain database disaster recovery plans

Linux/Solaris/VMware Systems and Network Administration

• Intensive experience and training on managing and administering VMware Virtual Centers, ESXI 3.x Servers, ESXi 4.0, Microsoft HyperV and VMware Workstation.
• Fully administer UNIX based Servers, Solaris T120,V240,V440,V245 and Linux Red Hat ES 4, Centos 5 and Ubuntu Servers
• Setup multiple variety of Unix Servers snapshots with VMware ESXi 3.5, ESXi 4.0, VMware Workstation and HyperV technology,
• Administer and monitor, enhance and backup Virtual Machines using viClient, vSphere, vmwaretools, vcbBackup, vcbRestore and RESXTOP.
• Very good experience on Unix Shell scripts and automation BASH, SH , FTP, SSH, SCP and CRON Jobs
• Monitor Unix System processes, services, cpu and memory utilization, local area network and windows vpn/openvpn/vpnc connectivity
• Network Design, Hardware and Software troubleshooting.
• Server LAN/WAN/VPN optimization.
• System design and development, technical user support
• Remotely administer and manage Linux and Solaris servers in HyperV and VMware systems
• Administer utility servers Alfresco, Codestriker, Hudson, SVN, Fogbugz, Company Website, Email Server, DNS and Database

Software Developer/PLSQL programming

• Software Engineer with 7 years experience developing leading-edge technologies
• 5 years solid experience in Java J2EE,Servlet/JSP, Jasper Reports technologies
• Excellent skills on PL/SQL programming
• Apache/Tomcat load balancing
• Excellent knowledge on repositories Subversion, Artifactory, Hudson, Maven and
• Distributed computing using Remote Method Invocation RMI
• Strong knowledge on database programming with JDBC,JNDI and LDAP,WAP,WML and Value Added Services, Liquibase
• Extensive experience on XML, XSLT, DHTML, HTML, JSTL, CVS, Maven, Ant, Hibernate, Web Services and GWT
• Servlet programming, Servlet Sessions, Context and Collaboration, JSP and Tag Libraries/Ext.
• Solid Experience on Java SQL Statements Prepared Statements and Callable Statements
• Solid experience on AJAX, JavaScript and MVC Framework and IBM WebSphere Studio
• Extensive experience on JASPER Reports and Crystal Reports
• Extensive experience in Tomcat, Apache, JBoss, BEA WebLogic and Internet Information Server web platform
• Extensive experience using Eclipse, NetBeans, JDeveloper, SQL Developer
• Good Experience on PostGreSQL 8 and MYSQL 3, 4 database.
• Proficient in DDL,DML,Join statements and subquery on Oracle/SQLServer Database
• 2 yrs experience on Oracle Internet Directory OID
• Good troubleshooting skills on LDAP directory management and OID processes
• Solid experience structure query language SQL, PLSQL and other database scripts
• Strong LDAP, SSO and OID processes background for broadband and wireless authentication
• 3 yrs experience on Oracle Application Server AS10g infrastructure and repository

WORK EXPERIENCE'

confidential

Oracle Datawarehouse Administrator/Princial Application Engr.

• Confidential is the world's first full-service semiconductor foundry with a truly global
• manufacturing and technology footprint. Launched in March 2009 through a partnership
• between AMD NYSE: AMD and the Advanced Technology Investment Company ATIC ,
• GLOBALFOUNDRIES provides a unique combination of advanced technology, manufacturing
• excellence and global operations. With the integration of Chartered in January 2010,
• GLOBALFOUNDRIES significantly expanded its capacity and ability to provide best-in-class
• foundry services from mainstream to the leading edge

Projects:

• Administer Centralize DataWarehouse
• ETL and Native Data Loaders
• XML Data Loaders
• Factory Automation Wafer Data Extraction
• Realtime Factory Job Dispatching

Role:

• Deployed, Configured and Administered Oracle Datawarehouse in a clustered environment RAC
• Integrate Realtime Datawarehouse with Realtime Data Replication using GoldenGate
• Automate Abinitio ETL loaders on continous flow system
• Deloyed XML and SQL based loaders
• Manages JBoss Applications on clustered environment

confidential

Oracle Database Support

State Street provides the financial infrastructure and services that make it possible for the world's largest investors to make the most efficient use of the world's capital.

Projects:

- Database DataFlow Automation

Role:

- DBA Support, system integrations and create automated system for financial data flow.

confidential

DBA/Application/Network/Linux/Solaris/VMware Administrator

Texert's J-Port GRC Product Suite provides global business leaders the knowledge they need to effectively define, manage and monitor overall enterprise health and connect complex business processes across entire organizations to improve business performance. With its main client British Telecom BT , J-Port GRC enables companies to effectively manage Governance, Risk and Compliance standards including Financial compliance such as Basel II, Energy risk compliance such as NERC And other regulatory and compliance regimes.

Projects:

• J-Port Software for Governance Risk and Compliance
• HyperV to VMWare Migration
• VMWare ESXi Setup and configuration
• J-Port V2 / Jboss Server
• Hosted Environemt using ESXi 4.0 and Apache Server
• J-Port V2 to J-Port V4 migration

Role:

• Install and Administer Oracle Databases, Oracle High Availability, RAC, and Backup RMAN, Exp, Imp
• Backup Online ESXi Virtual Machines using VIM commands scripts.
• Creation and Configuration of Linux/Unix System, VMware, Tomcat, Apache , LDOM
• Monitor all database datafiles, memory activity and tuned up SQL and System parameters
• Build VM using Solaris based technology Logical Domain
• Create, configure ESXi virtual machines, Install Linux base systems and database
• Developed migration script instead of ETL to migrate old database to new database structure using PLSQL programming.
• Backup all applications using shell scripts and oracle scripts
• Create virtual host using Apache server to publicly publish J-Port application from virtual machines
• Configure, Tuned up, Build and Automate J-port Application with Maven, Hudson and shell scripts.
• Optimize system performance and monitor system load for database and network traffic
• Migrate system into VMware technologies to provide efficient administration
• Monitor critical servers such as SVN, Maven Hudson, Email, etc to ensure no downtime
• Design software and database solution like maven build automation and database replication
• Automate servers backup and product build process.
• Provide and support Sales using VMware standalone solutions for demo and presentation
• Support and resolved customer issues.

confidential

DBA/Software Engineer

One of the best network solutions provider dealing with one of the biggest telecommunication company in the Philippines. Globe Telecom which provides wide variety of Broadband and Wireless connection all throughout Asia Pacific region. The system is designed to verify records from the subscribers during authentication which is handled by the LDAP database and granted internet access after authorized. The accounting logs moves into Oracle RDBMS database and is being replicated into another node using Oracle Dataguard. The authentication records on the other hand are being relayed to another LDAP database through OID replication.

Projects:

• Postpaid and Prepaid Repository
• Value Added services
• Data Replication and Profiling

Role:

• Implement, configure, maintain and administer Oracle database for Telecom Broadband AAA Application.
• Day-to-day 24/7 support of production database and create automatic PLSQL script for database monitoring.
• Enhance configuration setup and query optimization on a large scale database
• Configure standby oracle database for failover and switchover options
• Maintain and consolidate data warehouse for client provisioned account.
• Backup repository on regular interval using database tools RMAN,IMP,EXP
• Build, optimized and design broadband Oracle Internet Directory application server
• Import data from text file using SQL Loader and import/export utility
• Implement Oracle Application Server infrastructure and metadata repository
• Design LDAP directory structure for authentication and authorization process.
• Uses ldap utility to create and modify directory structure within OID repository
• Comparing and reconciling records on per node basis on LDAP directory using oidcompare tools
• Install and configure new node for new repository in the network using OID asrsetup tools
• Implement Oracle Internet Directory replication for synchronization on other network nodes.
• Backup and restore LDAP directory and data using OID utility
• Developed standalone database application for administering records and transactions both prepaid and postpaid accounts
• Developed real-time replication using OID

Technology:

• Databases Oracle 10g, Oracle Application Server 10g, LDAP
• Applications OEM, LDAP, OPMN, SQLPLUS, OIDADMIN, PLSQL, XML, RMI and JNDI
• Platforms Solaris 10, Red Hat Linux ES4, OC4J

confidential

Software Engineer

One of the best integrator for time keeping software, Visionsoft had expanded its product to HRIS and PAYROLL system. Thus providing a complete package for each company for automatic record keeping and processing. This is used to synchronized separate applications data, gather records and produce printable reports. The system is used to automate Human Resource task of computing records base on time in and time out of employee on a specific given day. Thus providing a direct computation of payroll and deductions.

Projects:

• Timekeeping System Utility
• Human Resource Integration utility
• Data Administration

Role:

• Render on call 24/7 support for transaction monitoring
• Convert MYSQL database to ORACLE database.
• Developed Stored Procedures and PLSQL statements for automation of process
• Organized server side objects triggers and sequences
• Enhance Timekeeping Software interface to produce efficient output
• Load bulk data using SQLLOADER and conventional INSERT
• Recreate and import existing schema and objects
• Describe and implement role and privileges on new users.
• Secure application connectivity and monitor session overload
• Optimized and enhanced transaction query and remote connectivity
• Create materialized views for query enhancements
• Backup data on a daily basis using export EXP utility, RMAN and FLASHBACK
• Developed, test and maintain database disaster recovery plans
• Install, upgrade and patch database to suit client' requirements

Technology:

• Databases Oracle 9i, 10g , MySQL 4.1
• Applications SQLPLUS, EXP/IMP, OEM, RMAN, PLSQL
• Platforms Red Hat Linux, Windows