Oracle Database Administrator
Resume:
HAL MARK GUERRERO AMURAO
Bachelor of Science in Computer Engineering
**** ****. ******** ******* ****, Laguna Philippines
Mobile No.: +63-948-*******, +63-905-***-****
E-mail:**************@*****.***
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