HAL MARK GUERRERO AMURAO

Bachelor of Science in Computer Engineering

**** ****. ******** ******* ****, Laguna Philippines

Mobile No.: +63-948-*******, +63-905-***-****

E-mail:ac49bd@r.postjobfree.com

SkypeID: 639*********

PROFESSIONAL STRENGTHS SUMMARY

11 years of experience administering, maintaining and supporting Oracle Database running on different platforms (UNIX,LINUX,IBM AIX, WINDOWS SERVER SYSTEMS).

Extensive knowledge on Database Administration activities (installation, configuration, maintenance, upgrade, patch, migration, back up and recovery) using various tools.

Strong implementationexperience of Oracle RAC, ASM Storage, Physical Standby Databases, Oracle Data Guard, OEM Grid Control and RMAN backup.

Knowledgeable in managing Oracle eBusiness Suite 11i/R12.

10 years experience of Web-Applications/ Website and Desktop Applications development, design, support and maintenance in production environment.

Strong experience in quick and professional analysis/trouble shooting for productionWebsite and Desktop Applications related escalation.

Broad skill in PL/SQL, DOS, UNIX SHELL/BASH script development.

With a high standard of professionalism and commitment to meet targets.

Ability to perform and meet deadlines on minimal supervision, in addition to having an appreciation of teamwork and personal problem-solving.

Team player, self-motivated, self-starter and can do multi-tasking

Adaptable with the ability to learn quickly

Striving for a mutual long-term employee-employer relationship.

Willing to be trained for career development and company strengthening.

SKILLS & PROFICIENCIES

Platforms/Operating Systems known: UNIX, LINUX,IBM AIX, Windows Servers

Extensive skills in managing databases like ORACLE 8i/9i/10G/11G/12c, MS SQL SERVER (Versions 2000/2005/2008/2012/2014/2016)

Oracle Database backup and recovery/restoration using RMAN.

Experienced in Oracle RAC, ASM Storage, Physical Standby Databases, Oracle Data Guardenvironment.

Website and Software development languages and technologies used - PHP, CODEIGNITER, LARAVEL, SYMFONY, CAKEPHP, REST, HTML, XHTML, JQUERY, AJAX, CSS, BOOTSTRAP, MYSQL, WPF, MVC,JSF, WEB API, ANGULARJS, NODEJS, RUBY ON RAILS,PHYTON, PERL, XML, JSON,C#.NET, ASP.NET, VB.NET, CASPIO,C, C++, MACRO, VBA, VB6, JAVA/J2EE.

Cloud Platforms – AWS, AZURE

Comprehensive knowledge with SQL, PL/SQL, MS/DOS, Perl, Phyton Unix Shell/Bash scripts.

Experienced with softwares, utilities and protocols, including the following:

ORACLE – SQL Worksheet, SQL PLUS, OEM, TOAD, EXP/IMP, DATAPUMP, SQL*LOADER,

WWW Servers – Apache, IIS, Weblogic, Oracle Internet Application Server

Networking – Telnet, FTP, ifconfig, netstat, xinetd, scp, PUTTY, XManager

Backup - tar, cpio, dump (ufsdump)

Office - OpenOffice, MS Office(MS Word, Excel, Access, PowerPoint)

Other – SAMBA, VI, CRON, VMWARE, CITRIX, ORACLE VIRTUAL BOX

Excellent troubleshooting and creative problem solving skills.

EMPLOYMENT HISTORY

ORACLE DATABASE ADMINISTRATOR

Outsourced Quality Assured Services, Inc. October 2016–Present

19F CyberoneBldg, Eastwood, Libis,

Quezon City1100 Philippines

Database health check and performance management of operating system and database instance.

Support of the product development team.

Database installation, patching and upgrade.

Task automation script writing and data mapping.

Reconciliation and verification of system data, liaising with the data source leaders to correct where necessary.

Develop, support and maintain Web and Desktop applications in production.

Modify Website and Desktop Applications configurations based on system performance. Review code and ensure delivery quality and integration to future versions.

Apply defect fixes of production applications with high level of quality.

Work with partner teams (Application support, Infra, DBA, Service desk, Monitoring) to provide support for tickets pertaining to all production Website and Desktop Applications outstanding issues.

Analyze, design, develop, and support various change requests from clients.

Develop and present proof of concept software for prospective clients.

Perform critical and non-critical support activities to ensure productionWebsite and Desktop Applications stability.

Execute application unit testing and document test results.

SENIOR ORACLE DATABASE ADMINISTRATOR

People Plus Tech, Inc. June 2015 –Apr 2016

9F JakaBldg, 6780 Ayala Avenue,

Makati City, 1226 Philippines

24/7 support of production database services to ensure the highest standards of availability, resilience, integrity, security and performance required by our business systems.

Perform migration of Oracle 11gR2 databases residing in Oracle Exadata X4 to X5 .

Design, create or replicate, configure and manage Oracle RAC databases running and usingDataguard environment and ASM storage technologies.

Perform Oracle database upgrade and patch in multiple environments.

Responsible in performance monitoring, reporting, and tuning of Oracle databases.

Management and maintenance of RMAN back-ups and restore/recovery procedures.

Design, review, tune and optimize SQL, PL/SQL code, database packages, views, triggers, functions and procedures to improve database response time and throughput.

Manage database security and access control.

Providesupport and assistance to Development team in the design, development, testing, tuning and implementation of database applications.

Writing ad-hoc queries based on schema knowledge for various reporting requirements. Writing / Tuning data ingestion procedures from external suppliers and partners using PL/SQL, SQL LOADER,3rd party tools e.g. Toad etc.

Design and develop UNIX BASH and SHELL scripts to automate database tasks and routines

Develops and revises Website and Desktop Applications configuration as prescribed in the Functional Requirement Specifications Document and following the Coding Standards of IT-Business Solutions.

Provides support to users by troubleshooting and correcting/debugging Website and Desktop Applications.

ORACLE DATABASE ADMINISTRATOR

Tieto Global Oy (Philippine Branch) August 2013 to February 2015

8th Floor, Cebu IT Tower,

Cebu Business Park,

Cebu City 6000 Philippines

Responsible for installation, upgrade and technical configuration of the Oracle Databases(10g and 11g) in multiple environments.

Provides systems and database administration for the Oracle Database technical environments and applies necessary patches and upgrade.

Evaluate, implement, innovate, manage, coordinate and supervise the database serversoperations.

Responsible for providing day-to-day support and maintenance for Oracle databases and services of our enterprise application platforms.

Develop, maintain and ensure that database backup and recovery procedures(RMAN), storage/space management and log archiving are functioning correctly.

Set-up, configuration and management of Oracle Dataguard environment.

Performs database migration.

Monitor database events and proactively optimize system performance.

Provides technical support to application integration teams.

Work with other teams to promote changes to production and other environments.

Work with the team to automate reactive procedures where possible, and to promote rapid response to known issues.

Manage Service Request with Oracle Support.

Design and development of Website and Desktop Applications tasks to enhance performance and functionality.

Debug and apply fixes to web applications deployed in Weblogic/IAS/Tomcat.

ORACLE DATABASE ADMINISTRATOR Nov 2011 – Aug 2013

Philippine Prudential Life Insurance Company, Inc.

Suites 510-513, 5F AIC BurgundyEmpireTower

ADB Avenue, Corner Garnet and Sapphire Roads, OrtigasCenter

Pasig City 1605 Philippines

Install, configure, deploy, monitor and troubleshoot ORACLE Database running on UNIX, LINUX, IBM AIX and WINDOWS platforms.

Performs database analysis and optimization (SQL and index tuning, adjusting database parameters, schema design) for optimum performance.

Performs migration, upgrade, recovery and cloning of production, test and development databases.

Review, evaluate, implement, automate, manage, coordinate and supervise the database server operations for the use of optimal technologies and methods to improve the efficiency of databases.

Conducts growth analysis & capacity planning in cooperation with Development teams and Support Organization.

Working conjunction with other IT, application development, and business groups to understand data standards, functionality, scalability, performance, security, and integration requirements from the database perspective.

Control user access permissions and privileges. Create and maintain all database processes and objects like tables, indexes, sequences, views, packages, functions, procedures, jobs etc.

Design, develop and implement customized codes and scripts (PL/SQL, DOS, SHELL scripts) as required, for system monitoring, data replication, storage management, backup, recovery, automated / ad hoc reports, daily database tasks and other maintenance activities.

Coordinates regularly with members of other teams for database related issues and concerns and to support changes to production and other environments.

Communicates/cooperates with external entities (e.g. vendors, developers) on trouble tickets / filed cases.

Provide 24/7 support of production database services to ensure the highest standards of availability, integrity, security and performance.

Writes new software, makes modification to existing software, or integrates software applications and modules in accordance with agreed upon specifications.

PRODUCTION SUPPORT ORACLE DATABASE ADMINISTRATOR May 2011 – Nov 2011

Accenture, Inc.

MSE Building, Ayala Avenue

1200 Makati City, Philippines

Troubleshoot and resolve database-related issues.

Perform root cause analysis and implement firm solutions to database related troubles.

Monitor, tune and optimize database performance problems and concerns.

Execute and manage sync of changes to database schema and data across all prod, dev and test environment.

Review and execute Database service requests.

Create, maintain and execute database work plans.

Schedules, implements, and documents database changes.

Proactive monitoring of the customer’s production servers and minimizing the downtime.

Create and submit required DBA reports to respective groups and individuals.

Create and maintain support documentation.

Support installation, migration and upgrade of Oracle Databases.

Design, load schedule and automate processes for Database Server.

Provide 24x7 maintenance and support.

Develop and design applications that conforms to the coding standards set by the organization.

Create code for new applications as well as enhancing or adding new features to the existing applications/systems.

JUNIOR DATABASE ADMINISTRATOR August 2008 - April 2011

Torres Technology Center Corporation

MakilingCalambaCity, Laguna Philippines

Responsible in Database Server (Oracle and MS SQL) system health check, monitor database performance, planning and implementation of database optimization, database maintenance i.e. database re-organization, database defragmentation, segmentation, indexing, ensures database integrity, etc.

Perform Oracle Database and Oracle Internet Application Server Software installation, upgrade, migration, cloning and configuration in different platforms such as Unix, Linux and Windows.

Manage and administer database backup and perform recovery or restoration of corrupted database.

Created and developed scripts for database and platform (Unix, Linux and Windows) to automate different database tasks and operations.

Create and manage database objects such as tables, users, procedures, triggers, etc. Control, approve or deny database schema change requests.

Fine tune, review or re-write database stored procedures/triggers and make necessary modifications as appropriate.

Resolve database issues including but not limited to performance management and data management to minimize unplanned downtime.

Implement and communicate database standards to the application development team to maintain database integrity.

Provide guidance to development team in terms of database issues and programming.

SOFTWARE DEVELOPER, TEST/CIM TECHNICIAN February 2008 to August 2008

Continental Temic Electronics Phils., Inc

16 Ring Road, LISP2-SEZ, RealCalambaCity,

Laguna, Philippines

Generate/maintain programs and utilities for the production line.

Responsible for software testing prior to usage of production in coordination with model engineers.

Responsible for loading of programs, modification, and standard procedure of testing.

Daily monitoring of product quality and productivity and report the recommendation / solution.

Responsible for the traceability of the products.

Design and implement applications using Manufacturing Execution System(MES) test scripts.

Perform computer hardware troubleshooting.

EDUCATION

Bachelor of Science in Computer Engineering

Laguna College of Business & Arts

Calamba City, Laguna, Philippines

March 2007

PERSONAL INFORMATION

Nickname : Mac

Date of Birth : March 17, 1985

Citizenship : Filipino

Civil Status : Married

Gender : Male

Religion : Iglesia Ni Cristo

Languages : English, Filipino

Interests : Sports, music, movies, etc.

CHARACTER REFERENCES

Mr. SedfreyRazal

Position: Associate Manager

Company: Accenture, Inc.

Address: MSE Building, Ayala Avenue 1200 Makati City, Philippines

Contact Phone: +63-917-***-****

Mr. Ronald Tio

Position: Team Manager, Information Technology

Company: Tieto Global Oy – Philippine Branch

Address: 8F, Cebu IT Tower, Cebu Business Park,Cebu City 6000 Philippines

Contact Phone: +63-917*******

Ms.Beverly Elena Gascon

Position: Head, Information Services Department

Company: Philippine Prudential Life Insurance Company

Address: 5FBurgundy Empire Tower, ADB Avenue, Ortigas Center, Pasig City, Philippines

Contact Phone: +63-908*******, +63-917*******

Mr. Ruel Masil

Position: Manager, Information Services Department

Company: Philippine Prudential Life Insurance Company

Address: 5F Burgundy Empire Tower, ADB Avenue, Ortigas Center, Pasig City, Philippines

Contact Phone: +63-917*******

I hereby certify that the information mentioned above is truthful to the extent of my knowledge.

Contact this candidate