SKILLS HIGHLIGHT:

Oracle Products: Oracle server, Enterprise Manager, Grid Control, PL/SQL, Data Guard Oracle Replication, Streams, Backup and Recovery - RMAN, Oracle partitioning, RAC

Third party Products: Confidential ( Shareplex, SQL Navigator, I/Watch, Knowledge Xpert, Quest Central, Space Manager with LiveReorg, Spotlight, SQLab, Toad

Operating Systems: UNIX (IBM AIX, HP-UX), Linux (Open Source RedHat, unbreakable), Solaris, SunOS, OpenVMS, Primos, Novell, Window NT, Windows 2003&2008

Management/Leadership Skills: Project Management, Operation Management, Technical Team Leader, Client Lead Consultant, and Design Team Leader

Life Cycle Expertise: Database/system Administration and Audit, Database/Application performance Tuning, Systems Architecture Planning and Design, Logical/Physical, Data Conversion, Database Design, Application Development, Test Plans, Capacity Planning

Specialty Skills: Database Administration, Database Tuning, Application Migration, Data Warehouse, Application Tuning, Symmetric Replication, Database

Communication: Token Ring, DECNet/Pathworks, SQL*Net, TCP/IP

WORK EXPERIENCE:

Senior Oracle Database Administrator

Confidential, Dublin, CA

Responsibilities:

• Supporting set of 7 database servers and over 200 oracle database instances.
• Setup monitoring and notification for troubleshooting system and database incidents.
• Monitoring and tuning databases, SQL queries, and application code using OEM.
• Shell scripting and scheduling regular/repetitive tasks thru crontab.
• Developing/publishing system policies, procedures, and coding-documentation standards.
• Supporing multiple tasks in a dynamic environment, designing, creating and maintaining Oracle databases and migrating databases into Oracle.

Senior Oracle Database Administrator

Confidential, Pasadena, CA

Responsibilities:

• Supporting a large data warehousing set of 7 database servers with 100TB of metadata.
• Supporting tables that are more than 50 billion rows.
• Set up/test Oracle Dataguard for Standby database environment.
• Install/configure Oracle OEM Cloud control 12C.
• Monitoring and tuning databases, SQL queries, and application code using OEM.
• Shell scripting and scheduling regular/repetitive tasks thru crontab.
• Developing/publishing system policies, procedures, and coding-documentation standards.
• Supporing multiple tasks in a dynamic environment, designing, creating and maintaining Oracle databases and migrating databases into Oracle.

Senior Oracle Database Administrator

Confidential, Los Angeles, CA

Responsibilities:

• Implement and maintain Oracle Database Software.
• Setup monitoring and notification for troubleshooting system and database incidents.
• Respond, prioritize, and escalate incidents or service requests as necessary according to defined SLA’s and operational Processes.
• Assist developers and data modeling teams with database architecture and design.
• Perform database and system capacity planning and storage space management.
• Setup/schedule system and database jobs in Oracle job sub-system and thru Linux crontab.
• Setup database security, auditing, and data masking and encryption.
• Refreshing the DEV/TEST/QA databases from the production instance.
• Work with the Linux Engineering team to automate Proactive/ Reactive procedures where possible, and to promote rapid response to known issues.
• Transformation of business requirements into logical and physical database designs, and testing, implementation and maintenance of efficient and secure system environment.
• Monitoring and tuning the various databases, SQL queries, and application code.
• Develops standards and procedures affecting database management, design and maintenance, data management/dictionaries and documentation across multiple computing environments.
• Set up physical Data Guard for high database availability and recoverability.
• Apply Oracle maintenance/security/critical patch updates after investigating potential issues that may be encountered as a result of patch application in the development environment.
• Developing/publishing system policies, procedures, and coding-documentation standards.
• Researches and evaluates alternative solutions and recommends the most efficient and cost effective database solution for the systems design.
• Test/Install the migration/upgrading/patching of Oracle RDBMS and its tools as needed.

Senior Oracle Database Administrator

Confidential, El Segundo CA

Responsibilities:

• Install/configure Oracle Enterprise Manager 12c cloud control.
• Setup monitoring and notification for troubleshooting system and database incidents.
• Setup/test DR site using oracle standby for backup and production switch-over.
• Setup physical DataGuard for high database availability/Recoverability/Reporting.
• Assist developers and data modeling teams with DB tuning, architecture and design.
• Perform database and system capacity planning and storage space management.
• Setup/schedule system and database jobs in OEM12c job sub-system and thru Linux crontab.
• Setup database security, auditing, and data masking and encryption.
• Refreshing the DEV/TEST/QA databases from the production instance.
• Works with client and DP management and staffs to establish and maintain consistent process and data definitions across computing environments
• Monitoring and tuning the various databases, SQL queries, and application code.
• Apply Oracle maintenance/security/critical patch updates after investigating potential issues that may be encountered as a result of patch application in the development environment.
• Developing/publishing system policies, procedures, and coding-documentation standards.
• Test/Install the migration/upgrading/patching of Oracle RDBMS and its tools as needed.
• Evaluate database administrative tools and provide recommendations to management.

Senior Oracle Database Administrator

Confidential, Santa Ana, CA

Responsibilities:

• Install/configure Oracle Enterprise Manager 12c cloud control.
• Migrate oracle databases from new hardware plateform, and converting database between Oracle endian using RMAN and transportable table spaces.
• Setup monitoring and notification for troubleshooting system and database incidents.
• Assist developers and data modeling teams with database architecture and design.
• Perform database and system capacity planning and storage space management.
• Setup/schedule system and database jobs in OEM12c job sub-system and thru linux crontab.
• Automate Oracle DB tasks (monitoring, backup, notifications, etc…) using shell scripts.

Technical consultant/Senior Oracle Database Administrator

Confidential, Los Angeles, CA

Responsibilities:

• Upgrade Oracle Enterprise Manager to 12c Cloud control from 11g Grid.
• Setup monitoring and notification for troubleshooting system and database incidents.
• Assist developers and data modeling teams with database architecture and design.
• Perform database and system capacity planning and storage space management.
• Monitor/Troubleshoot database/servers/application problems/issues.
• Setup and schedule system and database jobs in 12c job sub-system scripts.
• Automate daily/weekly oracle maintenance jobs using oracle job scheduler and crontab.

Technical consultant/Senior Oracle Database Administrator

Confidential, City of Los Angeles, CA

Responsibilities:

• Upgrading Confidential ’s environment from Oracle10gR2 to Oracle11gR2.
• Leading Oracle RAC configuration/implementation project on Oracle11gR2.
• Set up physical and logical Data Guard for high database availability and recoverability.
• Assisting developers and data modeling teams with database architecture and design.
• Troubleshooting database/application problems reported by system developers & users.
• Setting up/modify/schedule database/shell scripts as needed.
• Monitoring and tuning the various databases, SQL queries, and application code.
• Testing the migration/upgrading/patching of Oracle RDBMS and its tools as needed.
• Acted as the backup DBA for the Sybase financial database systems.
• Prepared business requirements reports, findings, recommendations, feasibility studies, DB/system capacity planning & storage space management, and cost justification statements.

Senior Oracle Database Administrator

Confidential, Diamond bar, CA

Responsibilities:

• Monitor projects/service requests for progress and timely completions.
• Assisting developers and data modeling teams with database architecture and design.
• Performing database and system capacity planning and storage space management.
• Apply security policies for data access to oracle databases and Linux servers.
• Troubleshooting database/application problems reported by system developers & users.
• Developing/publishing system policies, procedures, and coding-documentation standards.
• Work with auditing firms to ensure SOX and PCI compliance.
• Monitoring for unauthorized access attempts and manage database user accounts.
• Tuning the various databases, SQL queries, and application code.
• Disaster recovery planning, testing, and documenting/publishing.
• Provides technical support and and acts as mentor to other data administration staff.
• Refreshing the DEV/QA/TRNG databases from the production instance.

Technical consultant/Senior Oracle Database Administrator

Confidential, CA

Responsibilities:

• Monitoring and tuning the oracle production environment.
• Assist in the interviewing, Hiring, mentoring, and of new and existing employees.
• Assisting developers and data modeling teams with database architecture and design.
• Monitored the data loading and migration into the data mart and data warehouse instances.
• Configured/installed Oracle Real Application Cluster (RAC)
• Testing the Migration of production to ASM and Oracle RAC.
• Performing database and system capacity planning and storage space management.
• Assisted the Data Warehouse team with tools and techniques in Acquiring, cleaning, transforming and making data available for analysis, reporting and presentation using informatics and Hadoop.
• Developing and publishing development-coding and coding-documentation standards.
• Set up physical DataGuard for high database availability and recoverability.
• Create and maintain database links between oracle databases and user’s accounts.
• Troubleshooting database/application problems reported by system developers & users.

Technical consultant/Senior Oracle Database Administrator

Confidential, Woodland Hills, CA

Responsibilities:

• Performing regular database backups for instance refreshing and disaster recovery.
• Refreshing the Oracle development and QA databases from the production instance.
• Monitoring and tuning the oracle development environment.
• Performing capacity planning and space management.
• Troubleshooting database/application problems reported by system developers & users.
• Administering user accounts, roles, tables, indexes, sequences, views, etc.

Senior Oracle Database Administrator

Confidential, Pasadena, CA

Responsibilities:

• Creating and setting up new scripts and schedules for the hot/cold backups and exports.
• Managing offshore resources for successful production implementation and release Control.
• Refreshing the QA database from the production instance using RMAN and Oracle streams.
• Developing and publishing development-coding and coding-documentation standards.
• Troubleshooting database/application problems reported by system developers & users.
• Administering user accounts, roles, tables, indexes, sequences, views, etc.

Technical consultant/Senior Oracle Database Administrator

Confidential, Los Angeles, CA

Responsibilities:

• Creating and setting up new scripts and schedules for the backups and exports.
• Replicating production database instance for development and proposes.
• Monitoring and tuning the oracle development environment.
• Assisting developers and data modeling teams.
• Performing capacity planning and space management.
• Developing and publishing development-coding and coding-documentation standards.
• Troubleshooting database/application problems reported by system developers & users.

Technical consultant/Senior Oracle Database Administrator

Confidential, Torrance, CA

Responsibilities:

• Performing Oracle database, application, and network tuning and debugging.
• Monitoring, test, and tuning oracle applications/databases.
• Performing capacity planning and space management.
• Developing and publishing development-coding and coding-documentation standards.
• Administering user accounts and database objects.
• Data warehouse configuration, management, and performance monitoring & tuning.

Shareplex Development Escalation Manager

Confidential, Irvine, CA

Responsibilities:

• Day to day management of support issues, technical triage and assignment of these issues to the SharePlex Developer Support team.
• Work with the build and release engineering team to manage the software deployments and rollouts, emergency customer fixes and patch releases for SharePlex.
• Work with the SharePlex Developer Support team and the Technical Support Escalation Manager to provide quick workarounds for key customer issues.
• Document the procedures and workarounds given to customers via Technical Support.
• Improvise processes and procedures for managing customer issue escalations to Development, and emergency fix/patch procedures.

Senior Oracle Database Administrator

Confidential, Santa Monica, CA

Responsibilities:

• Creating and setting up new scripts and schedules for the backups and exports.
• Performing Oracle database, application, and network tuning and debugging.
• Monitoring the production and development and other environments.
• Assisting developers and data modeling teams with database architecture and design.
• Performing capacity planning and space management.
• Weekly refreshing of the production databases with the latest data from the master databases to the modeling, development and QA environments.
• Working on providing a solution for HA setup of the production databases.