We provide IT Staff Augmentation Services!

Oracle Dba Resume

3.00/5 (Submit Your Rating)

Richfield, MN

OBJECTIVE:

A position as an Oracle DBA.

SUMMARY:

  • I am an enthusiastic, confident, and reliable professional with vast experience in Oracle Database Administration for 5+ years, including extensive IT experience.
  • I have a multi - platform technical background in UNIX, Linux (Red Hat, OEL, Solaris), and Windows.
  • I have vast expertise in Oracle-related applications, strong knowledge of Oracle database architecture, performance tuning, backup and recovery, schema management, installation, configuration, upgrades, patches, database security, cloning, replication, migration and documentation.
  • I possess excellent interpersonal and analytical skills tied in with a great aptitude for problem-solving and attention to detail.
  • With an aptitude for understanding the ‘big picture’, a great customer service oriented attitude, I excel at being a good team player.

TECHNICAL SKILLS:

  • TOAD for Oracle
  • Putty
  • WinSCP
  • SQL Developer
  • CYGWIN
  • Blue J
  • Eclipse
  • Proficient in Excel, Microsoft Word, PowerPoint, Access, and Outlook, MS project 2013, SharePoint.
  • Knowledge of Java programing.
  • Speak French

WORK EXPERIENCE:

Confidential, Richfield, MN

Oracle DBA

Responsibilities:

  • Planned, configured and implemented Oracle RAC & Data Guard resulting in highly available database solutions.
  • Performed periodic refreshing/cloning of production databases and schemas to development & testing environments using RMAN.
  • Database security, auditing, monitoring, user access management, and user resource management using OEM 12c Grid Control.
  • Capacity planning of tables, indexes, tablespaces and databases to allow for growth potential.
  • Performed space management of all databases, especially data warehouse specific databases.
  • Performed troubleshooting of various database performance issues utilizing various tools, such as the Automated Workload Repository (AWR), Explain Plan, Automatic Database Diagnostics Monitor (ADDM), Active Session History (ASH), Statspack and OEM 12c Grid Control.
  • Enforced corporate business rules through adequate user/resource/object management.
  • Substantial involvement in SOX compliance planning, implementation and review processes.
  • Worked with developers to create PL/SQL function, stored procedures and package to support reports.
  • Used Data pump (IMPDP/EXPDP), SQL Loader, Data Guard, conventional export/import utilities for loading data to and from databases, logical backups and migration of databases.
  • 24/7 on call support for production and lower environments to ensure maximum uptime and high availability.

Confidential, Irvine, CA

Oracle DBA

Responsibilities:

  • Worked on incident tickets supporting 24/7 support and on call for Production database and supporting developers & end users.
  • Managed users, privileges, roles, profiles, schemas, and passwords using Oracle Enterprise Manager (OEM) and Oracle Access Manager (OAM).
  • Set up scheduled jobs using Linux Shell Scripting in a Red Hat Enterprise Linux environment and Oracle scheduler in a Windows environment to automate tasks.
  • Administered and managed an Oracle RAC environment using OEM (Grid Control) and SRVCTL utility.
  • Loaded Data using Custom PL/SQL Programs (Table Functions, Merge and External Tables) EXP/IMP and SQL*Loader.
  • Utilized SQL and PL/SQL to generate reports for business and risk purposes.
  • Performed cloning and migration of Oracle databases.
  • Analyzed and interpreted security, inventory, accounting and financial systems data and made recommendations to the Risk Management department and other stake holders within the company.
  • Worked with BI tool, Halo Prism, to build, edit, and modify cubes and views.

Confidential, Plymouth, MN

Oracle DBA

Responsibilities:

  • Worked as an Oracle DBA supporting health insurance implementation infrastructure and operations.
  • Installation of oracle 11g databases in different environments depending on project requirements.
  • Transitioned network connectivity from TNS method to DNS directory method, and configured connectivity for new database server environments to in corporate them with the already existing architecture.
  • Created and maintained database links between multiple database server environments for remote object access.
  • Planned and implemented database backup strategies and methodologies using Golden Gate and RMAN and third party tape backup software
  • Collaborated with the UNIX and .NET system Administrator to configure software and hardware requirements that served to optimize the performance of the Oracle databases.
  • Went through planning and testing for the implementation of Huge Pages memory management at the OS level for our production database environment.
  • Refreshed development/test databases from production using Export/Import & RMAN backups.
  • Performed continuous monitoring of space usage, and enacted database resizing of tablespaces, and datafiles for optimal performance and server usage.
  • Managed database user access, privileges and roles.

We'd love your feedback!