Oracle DBA
Senior Database Administrator
With
more than 13 years as a DBA with a proven track record in performance and
troubleshooting on over dozens of high profile Oracle systems. Extensive experience in
setup and configuration of Oracle database servers versions 8.0 through 11g. Good
knowledge in
Troubleshooting, Performance Tuning, backup and recovery and Upgrading of
Oracle databases.
Considerable as Subject Matter Experts (SMEs) for Oracle Database Administration.
Possess the skills to quickly adapt to any environment during any point of the project
cycle and provide efficient response to company deadlines and system complications.
Energetic self-starter with excellent organizational, analytical, and creative skills
with an extremely in-depth knowledge of the Oracle database and other products.
Currently, Production Lead for DBA in DBHR project .
Main responsibilities to ensure
all production databases working and stable. Reporting from client and management.
TECHNICAL SKILLS
Operating System
Windows XP/NT/ 2000, AIX 4.5 and 5.3, Unix, Linux
Programming Languages/Tools
Oracle Developer forms, Oracle Developer Report, SQL, SQL*Plus, Oracle Utilities
(SQL* Loader, Oracle Export/Import), UNIX Shell Scripting, Oracle PL/SQL, Oracle
Enterprise Manager (OEM), SQL*Plus, RAC (Real Application Clustering)
Databases
Oracle 8i ,9i, 10g and 11g
PROFESSIONAL EXPERIENCE
ACCENTURE INC, Manila, Philippines
Associate Manager/ Senior Database
Administrator
April 2012- Present
Role and Responsibilities.
Fullfill Production DBA leads for daily activities including Application
support, Database monitoring and performance tuning
Performed analysis of current optimization model and provided recommendations to
move to Oracle’s cost-based optimization. Lead the stress test initiative to evaluate
the success of this approach.
Established and wrote the Performance Tuning guidelines for DBA to enhance the
quality of our product for all current and future code development.
Performed database backup and recovery using RMAN,Export/Import and datapump
Planned and implemented Backup and Recovery of oracle database
Performed capacity planning and enforced security to All production , Test and
Development database
Installed new version of Oracle database
including 10g, 11g
Create database user/roles base on business requirements
Responsible for Database patch installation
Provide status reporting of team activities against the program plan or schedule
Keep the project manager and product committee informed of task accomplishment,
issues and status
Serve as a focal point to communicate and resolve interface and integration
issues with other teams
Escalate issues which cannot be resolved by the team
Provide guidance to the team based on management direction
ACCENTURE INC, Atlanta Georgia
U.S.A
Team Lead/ Senior Database
Administrator
Feb 2011- April 2012
Role and Responsibilities.
Lead Database Administrator
for Deutsche Bank HR, responsible for logical and
physical design with a significant effort towards application and database
tuning,
production support. Major activities include performance tuning, database design,
capacity planning and establishing standards for Oracle installations, maintenance,
tuning, and coding standards.
Installation,configuration
of Oracle 10G and 11G
database
Performed analysis of current optimization model and provided recommendations to
move to Oracle’s cost-based optimization. Lead the stress test initiative to evaluate
the success of this approach
Established and wrote the Performance Tuning guidelines for DBA to enhance the
quality of our product for all current and future code development.
Performed database backup and recovery using RMAN,Export/Import and datapump
Planned and implemented Backup and Recovery of oracle database
Performed capacity planning and enforced security to all database
Installed new version of Oracle database
including 10g, 11g
Create database user/roles base on business requirements
ACCENTURE INC , Manila, Philippines
Team Lead / Senior Database
Administrator
January 2007- February
2011
Role and Responsibilities.
Accountable for the
production support and configuration and installation of
development and test Oracle database environments on AIX platforms. Major activities
include logical and physical database design, capacity planning, performance tuning,
database security, disaster recovery, installation and ongoing maintenance with a
special emphasis on web based server administration automation. Other activities include
evaluating and selecting Oracle database tools responsible for database and application
tuning, capacity planning and database stability.
Established standards for all Oracle database environments based on Oracle’s
Optimal Flexible Architecture (OFA). This initiative involved redesigning all new and
legacy environments to adhere to these newly established standards.
Established and wrote the Database Administrators Procedures document for the IT
department. This document outlines all standards for the DBA Group including
installing/upgrading Oracle, creating databases, DBA tools, administration and
monitoring, naming standards, policies, practices and procedures.
Redesigned a thorough backup and recovery strategy for all major production
systems. This initiative involved the design and development of several UNIX shell
scripts used for both physical and logical backups. Also included in this effort was the
development of various recovery strategies that included media failure, user failure and
block corruption.
Successfully maintain peak performance of all primary databases by providing
advanced tuning methods, customized scripts, Oracle Enterprise Manager
YAZAKI-TORRES MFG. INC, Laguna, Philippines
IT Technical Support/ DBA/Unix
administrator
Feb 1999-
Jan 2007
Role and Responsibilities.
Primary responsibilities included maintain the
Unix server(Solaris), Oracle
Database
and Oracle Application (9iAS/10GAS) server. Supported all phases of the system
lifecycle, including problem resolution, system fixes and major enhancements for
existing production applications , development and testing environment.
Successful
Migration Cobol system to Oracle system
Performed
Oracle tuning for payroll processing and improve performance from 22
hours to 30 minutes.
Managed a small group of developers responsible for researching and recommending
solutions for the department’s current and future Oracle Web infrastructure.
Develop and Maintain
Oracle Application using Oracle Forms/Report for
Manufacturing,HR, Engineering, Material and Planning, Payroll system
Implemented and configure Oracle Application Server for 9iAS/10gAS
Ensure proper network configuration of Oracle databases for client connectivity
Installation and configuration of oracle software (Client)
Conduct training to oracle application user (ie. Writing sql script using
sqlplus)
___________________________________________________________________________
EDUCATION & CERTIFICATIONS
LYCEUM of the PHILIPPINES –
Batangas,
Philippines
Bachelor of Science in Information and Computer Science
CERTIFICATIONS
Oracle Certified Associate
Database
Administrator 11G
-
2012
|