We provide IT Staff Augmentation Services!

Oracle Dba Resume

Schaumburg, IL

PROFILE SUMMARY:

Over 8+ years of experience in wide array of technologies with variety of clients with primary focus in Oracle database administration on Production and non - production environments. Skilled in testing, developing and implementing database upgrades with Business needs. Experience in planning, installing, configuring, upgrading, patching, Implementing, and administering Oracle database management. Ability to Excel in team environment. Excellent working relationships across different teams, strong Verbal, technical-writing, coordinating and Communication skills by achieving continual results.

EXPERTISE:

  • Oracle Database 9i,10g,11g,12c Database Administration& Security
  • Database Backup and Disaster Recovery
  • Database User Management
  • Software Installation& Upgrade
  • Data Migration

TECHNICAL PROFICIENCIES:

Databases: Oracle (Oracle 9i, 10/11g/12c), RAC.

SQL Tools: RMAN, OUI, SQLPLUS, OUI, DBCA, DBUA, X-Clock, ADDM, ASM, TKPROF, SQL Trace, STATSPACK

Data Export/Import Utilities: Toad, DBConsole, Data Pump.

Networking: TCP/IP, FTP, DNS.

Shell Scripting: Unix shell scripting, Crontab.

Office: MS Office 2003/20072010.

Operating Systems: Red Hat Enterprise Linux(RHEL), Sun Solaris, AIX, XP, Windows 7, Windows server 2005/2008, XP, Windows

.PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA, Schaumburg, IL

Responsibilities:

  • Installed, Upgraded and Configured Oracle 12c, 11g/10g databases, handled performance tuning and conduct regular system backups.
  • Ensure technical and functional designs meet business requirements.
  • Applied quarterly CPU/PSU Patches.
  • Created and managed Oracle Users, roles, privileges & created profiles for database objects, while maintaining both System level and Object level Roles & Privileges for various users.
  • Maintained existing User / System databases.
  • Decommissioned the databases.
  • Tuned the Database using AWR, ADDM and STATSPACK utility.
  • Performed database refreshes using Data pump Utility.
  • Used RMAN Utility for HOT/COLD backups.
  • Perform Database Refreshes and Database Copies for Development, and testing
  • Worked as primary on-call DBA.
  • Review alert logs and dump files to check for any problems related to the database
  • Create and maintain groups, users, roles and privileges.

Confidential

Oracle DBA, North Brook, IL

Responsibilities:

  • Responsible for Installation, planning, creation, configuration, implementation, maintained and supported 10g, 11g, 12c on multiple Oracle databases with stand-Alone and RACenvironment for production, development, test and staging purposes on Linux, Unix, Solaris and Windows environments by ensuring technical and functional designs meet business requirements.
  • Created and managed Oracle Users, roles, privileges & created profiles for database objects,while maintaining both System level and Object level Roles & Privileges for various users.
  • Maintained existing User/ System databases.
  • Used RMAN Utility for HOT/COLD backups and performed Disaster Recovery.
  • Implementing Datapump import/export utility of Oracle 10g, 11g, 12c for re-organizing Databases/Schemas/Tables to improve the performance.
  • Resolved clients/users connectivity issues, and solved listener problems.
  • Upgraded Oracle databases from 10g to 11g, and 11g to 12c.
  • Applied quarterly CPU patches upon release.
  • Performed database tuning using tools like OEM, AWR, ADDM.
  • Performed Database Refreshes and Database Copies for Development, and testing environment databases.
  • Provided 24/7 On-Call support for the Production databases.
  • Excellent verbal, written, and technical skills with ability to adapt to the nature of thejob.

Confidential, Wayne, NJ

Oracle DBA

Responsibilities:

  • Successfully Installed, Upgraded and Configured Oracle11g/10g/ 9i/ databases.
  • Created Databases, Table spaces, Profiles etc.
  • Created and granted Roles and Privileges to Users.
  • Capacity Planning, Estimating Database Size and SGA size.
  • Applied quarterly CPU Patches.
  • Designing and developing backup and recovery strategies.
  • Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
  • Successfully recovered corrupted data files.
  • Resolved user connectivity and password issues.
  • Enhanced overall performance by performing SQL tuning.
  • Performed database refreshes using Data pump Utility.
  • Tuned the Database using AWR, ADDM and STATSPACK utility.
  • Allocating system storage and planning future storage requirements.
  • Used TOAD for tuning.
  • Monitoring the growth of Table spaces and file system space for growth.
  • Experience using Oracle Enterprise Manager (OEM).
  • Decommissioned the databases.
  • Involved in monitoring backup checks logs by using Oracle utilities like RMAN, Export/Import and Data pump by developing and modifying Shell Scripts and scheduling it on the crontab.
  • Successfully provided 24x7 supports and monitoring of databases.
  • Implemented the data migration strategies from the historical database.
  • Set-up technical standards and procedures and ensured their implementation.

Confidential, Dubuque, IA

Oracle DBA

Responsibilities:

  • Experience in Installation, configuration and upgrade of Oracle 10g/11g/12c binaries on the Stand-Alone and RAC on RHEL Linux, AIX, and Solaris platforms using OUI and DBCA for installation and Configuration and DBUA for Upgrades on production and non-production environment.
  • Successfully Installed, Upgraded, Configured, Supported, and Administered Oracle10g/ 11g/12c databases.
  • Created Databases, Table spaces, Profiles, and granted Roles and Privileges to Users.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Applied quarterly CPU/PSU patches upon release.
  • Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/ Export).
  • Monitored Production Database Using O.E.M.
  • Responsible for maintaining Every Day Backups and performed backup validation using RMAN.
  • Maintained standby databases for production and staging environments.
  • Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
  • Implementing Datapump import/export utility of Oracle 10g, 11g, 12c for re-organizing Databases/Schemas/Tables to improve the performance.
  • Worked as a part of global team to provide 24/7 supports on-call production environment.
  • Experience with the Process management. (Change & Incident).
  • Maintained all the documentation including all the procedure plan documents.
  • Worked with multiple cross-functional teams of engineers, and production OS server project managers and service delivery managers to understand business process and develop functional specifications as required completing projects in time.

Hire Now