SALVADOR D. HERMANO JR.
Current Address: ***A Martan St. Brgy. Commonwealth Q.C. Metro Manila Philippines Permanent Address: Brgy. Camindoroan San Nicolas, Pangasinan Philippines E-mail: adfev7@r.postjobfree.com
Contact No. : +63-917-****-*** or +63-920-****-***-** years old 5’ 7 1/2” Single
August 19, 1988 154 lbs. Filipino
Job Description
Oracle Senior Database Administrator (IT Associate Manager) Education
Bachelor of Science in Information Technology (May 09, 2008) Polytechnic University of the Philippines - Quezon City Campus Don Fabian St. Brgy. Commonwealth, Quezon City
Employers
ACCENTURE Inc. - August 11, 2008 – present
Robinson Cybergate Tower 2 Pioneer St. cor. EDSA, Mandaluyong City Work Experience
Almost 12 years in IT industry supporting infrastructure operations and/or manage delivery for IT production systems and services based on operational requirements and service level agreements. 2019 – present – IT Associate Manager
2017 – present – DB2 DBA Supervisor
2013 – present – Oracle DBA Supervisor
2011 – 2013 – Sub-Team Lead
2009 – present – Oracle Database Administrator
2008 – 2009 – Infrastructure Support (Unix Admin, LDAP, TAM) Application Maintenance L2 and L3 support Primary Skill
Project and Team Management
Technical Skill Interviewer for Oracle and DB2 DBA – Company Internal and External Oracle Database Administration
8i, 9i, 10g, 11g, 12C
ASM and NFS Storage
PeopleSoft HR and Finance Applications
Windows, UNIX (Sun Solaris and HP) Platform
Real Application Cluster
Dataguard
Performance Management (Tuning)
RMAN, EXPDP/IMPDP, traditional Backup and Recovery DB2 LUW Database Administration
UNIX and Windows Scripting
UNIX, Linux and Windows System Administration
Ticket Management (Service Now, RTC, MSPS)
Other Skills
SQL Server Database Administration
PL/SQL and DBMS
MS Azure
PowerShell Scripting for Windows
MS Office
Certifications
ITIL v3 Foundation (2014)
Oracle 11g DB Admin Associate (2012)
Trainings
Information Technology
Oracle 11g Admin 1
Oracle RAC Admin
UNIX Shell Scripting
UNIX System Administration (Sun Solaris)
PERL Scripting
Leadership and Professional Development
Leaders Window
Coaching in the Workplace
Supervisor 101 Curriculum
Supervisor 201 Curriculum
High Performance Coaching
Understanding High Maturity
Client Relationship Management and Client Centricity Effective Cross Cultural Communication
Code of Business Ethics: Living the Code
Business Continuity Management
Client Data Protection
Environmental Management System
Character Reference
Available upon request
Project Portfolio
Project : Insurance - Oracle and DB2
Project Duration : May 2017 - present
Assigned Role : Managing DB2 and Oracle DBAs; Oracle DBA Technical Lead Project & Assignment Description
Oracle DBAs are currently providing production support, performance tuning and core DBA support for PeopleSoft Finance, ETL, Autosys, Hyperion Applications.
DB2 DBAs are currently providing production support, performance tuning, database maintenance for PeopleSoft Finance. Production Support
• responsible for end user satisfaction where applicable (e.g., during problem resolution).
• responsible for achieving assigned service level performance measures.
• provide technical support for the Level 2 Help Desk.
• assists in analysis, assessment and resolution of issues.
• testing and troubleshooting technical architecture.
• responsible for providing database technical support and expertise to Application teams.
• monitors database during major production cycles such as quarter closes. Change Management
• define the appropriate change initiatives including the skills, structures, tools and support mechanisms needed to manage organizational change.
• attend change assurance board meetings to raise risks and other concerns. Configuration and Deployment / Release Management
• plan and lead the execution of a comprehensive deployment plan, including work planning, scheduling, budgeting, metrics, training and resources.
• collaborate with all project teams and support groups to ensure alignment between all deployment-related activities.
Project : PeopleSoft Tools 9.2 and Oracle 12C Upgrade Project Project Duration : September 2016 - September 2017 Assigned Role : Database Administrator
Project & Assignment Description
Perform detailed analysis on the performance impact of critical batch jobs and provide recommendation on what parameter settings and 12C new features that the existing system could Performance testing, issue analysis and resolution Support project related request like Object creations, Security Management, Tablespace Management and application related issues.
Project : OPPM Project
Project Duration : October 2016 - June 2017
Assigned Role : Database Administrator Lead
Project & Assignment Description
OPPM Application in Oracle 12C RAC Database (Production Environment) Level 2 and 3 support including Database downtime, DB Backup and Recovery, DB refreshes, DB Performance Security Management, Tablespace Management, Maintenance Tasks and DB changes. Provide support to functional team.
Ticket Management including incident and problem tickets. Project : PeopleSoft – Performance Tuning
Project Duration : October 2016 - March 2017
Assigned Role : Database Administrator Lead
Project & Assignment Description
Performance Tuning on long running jobs for PeopleSoft Finance batch jobs. Project : Project Unity - Insurance
Project Duration : February 2011 - October 2016
Assigned Role : Database Administrator Lead
Project & Assignment Description
Oracle Database Administration in PeopleSoft Application for Finance and HR (UNIX Platform)
- Development and Production Support for Oracle 9i, 10g, 11gR1 and 11gr2 (RAC) Oracle Database Administration in Hyperion, Cognos (UNIX Platform)
- Development and Production Support for Oracle 11gR1 and 11gr2 The DBA Analyst works with the other teams to support and handle DBA requests, including database refresh requests, validating PeopleSoft, Cognos, Hyperion and ETL Table Build/Alter scripts and performance monitoring and tuning, and other ad-hoc requests.
-Responsible for end user satisfaction where applicable (e.g., during problem resolution).
-Responsible for achieving assigned service level performance measures.
-Provide technical support for the Level 2 Help Desk.
-Assists in analysis, assessment and resolution of issues.
-Testing and troubleshooting technical architecture.
-Responsible for providing database technical support and expertise to Application teams.
-Adhere to development standards and guidelines.
-Identify and implement initiatives as part of the unit's continuous improvement program.
-Provide day to day and on-call DBA support.
-Monitors database during major production cycles such as quarter closes. Project : FS - Insurance – Supercluster Project
Project Duration : May 2016 - August 2016
Assigned Role : Project Lead and Database Administrator Lead Project & Assignment Description
Project Lead
The Oracle Supercluster Lift and Shift project will improve overall performance of the current PeopleSoft Financials 9.1 Application and batch System. In the long term, it will also allow the client to have scalable framework and lay the grounds for the upcoming PS 9.2 Upgrade (and Oracle 12C).
Database Administrator Lead
1. Support the client's hardware upgrade project
2. Review performance test results and provide tuning recommendations 3. Resolve issues that will be encountered within the project duration 4. Manage team deliverables and coordinate work effort with offshore team 5. Provide status reports and handle communications with the clients Project : Upgrade Lab
Project Duration : July 2010 - January 2011
Assigned Role : Database Administrator
Project & Assignment Description
Oracle Database Administration in PeopleSoft Application (Windows Platform)
- PeopleSoft Tools Upgrade (DBA Support)
- Database Cold Backup (People Tools Pre-Post Upgrade)
- Statistic Management
- Database Start/Shutdown
- Oracle Parameter Management
- Technical Support (i.e. Ops' queries about DBA stuffs) Windows Scripting
- Created all the DB monitoring (batch) scripts.
Processes and Documentations
- Created User Manual for DBA Tools (monitoring scripts) Project : FS - Insurance Project
Project Duration : October 2009 - January 2011
Assigned Role : Database Administrator
Project & Assignment Description
Oracle Database Administration in PeopleSoft Application (UNIX Platform)
- Development and Production Support for Oracle 8i and 10g Databases (Finance, HRM, EPM, CRM, Portal, Perf Mon, Reporting)
- Database Creation
- Backup and Recovery
- Database Monitoring (Healthcheck and Availability)
- Database Support Migration
- DBA Support Security
Unix Shell Scripting
- Database monitoring scripts creation and modification. Processes and Documentations
- Work plans and Manuals creation and enhancement. Project : Telecommunication
Project Duration : April 2009 - May 2009
Assigned Role : Application Maintenance and Support (L2 and L3) Project & Assignment Description
Australian leader in integrated telecommunications, delivering cutting edge communications, information technology and entertainment services.
- Responsible for providing production support; troubleshoot and resolved all issues within the agreed SLA
- Update Knowledge Database for errors and workarounds
- Escalate issues to Production Support Manager, Level 3 Production Support Primary or Service Desk as appropriate Project : Banking
Project Duration : September 2008 - December 2008
Assigned Role : Infrastructure Support
Project & Assignment Description
Security Management including authentication and authorization of users accessing the system. Monitoring and health check of the system and troubleshoot issues (raised by the users).
- LDAP (Lightweight Directory Access Protocol) workloads
- Metadirectory workloads
- Maxware Connectors
- TAM's (Tivoli Access Managers) Webseal