We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

Dublin, CA

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.

Hire Now