We provide IT Staff Augmentation Services!

Oracle Dba Resume

5.00/5 (Submit Your Rating)

DC

SUMMARY:

  • Seeking an Oracle DBA position in a goal oriented IT environment that will utilize my existing education and hands - on skills, and experience to achieve the organizations objectives.

ORACLE SKILLS:

  • Proven ability in installing, configuring and upgrading Oracle database software releases and applying related patches on Linux, UNIX and Windows Platforms.
  • Experienced in client SQL optimizations (partitioning, materialized views) and Oracle memory tuning
  • Implementing backup strategies
  • User account setup, management and database security
  • Experienced in performing backup and recovery using the Oracle RMAN utility
  • Experienced in creating and altering database objects
  • Experienced in database user security design and policies enforcement through roles, resource profiles, usage audits, among others
  • Conversant with Oracle data guard technologies
  • Experienced in data migration efforts using Oracle’s SQL loader
  • Frequently use Oracle Enterprise Manager (OEM) for database monitoring and some administration work
  • Frequently use performance tuning techniques like partitioning, indexing, and table compression.
  • Knowledge with creating materialized views to improve query performance.
  • Performance Tuning

TECHNICAL SKILLS:

  • SQL Language
  • Visio
  • SQL Loader
  • Oracle SQL Developer
  • Oracle Recovery Manager (RMAN)
  • Java
  • GNU/Linux OS - Red Hat
  • Microsoft Project
  • Virtual Box
  • Oracle Enterprise Manager (OEM)
  • Data Pump

PROFESSIONAL EXPERIENCE:

Confidential, DC

Oracle DBA

Responsibilities:

  • Install the Oracle client and server software & configuration settings, applying patches and migrate databases.
  • Use DBCA to create Oracle databases according to physical and logical database design based on Oracle’s recommended Optimal Flexible Architecture (OFA) standards.
  • Administer multiple instances of Oracle 10g and 11g databases running on the LINUX, UNIX and Windows Operating systems.
  • Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development and production environments for implementation and maintenance of user security.
  • Partition large tables and data shipping between partitions to improve performance.
  • Perform backups - full and incremental using Oracle’s RMAN backup utility.
  • Load and transfer data using Data pump and SQL Loader utilities.
  • Design and implement Oracle user audit collection and led the DBA team in architecting data flows to the presentation tiers for senior management.
  • Automate database administration routines in backup and recovery using Recovery Manager (RMAN), routine import/export activities, schema creation and disk usage monitoring.
  • Respond to end user trouble tickets and service requests using Remedy.
  • Implements monitoring procedures to maximize availability of the database.
  • Creates logical data models and translate into physical database structures that integrate with existing or proposed database structures
  • Restore and/or recover data as required
  • Implements Performance Tuning and Optimization by using monitoring and troubleshooting tools such as ADDM
  • Automate routine DBA tasks by utilizing scripts
Confidential, MD

Oracle DBA

Responsibilities:

  • Installed and configured oracle on VM Virtual Box for test and development purposes.
  • Monitored and maintained system security including database alert logs, managed file system disk space, resizing table space and defragmenting the database as needed, system shut down and restart, unlocking database table locks as well as monitor and creating additional tablespace and file space as needed.
  • Wrote scripts to create tables, views, indexes, synonyms and other database objects as required by developers.
  • Managed and created new users, roles and assigning users the appropriate roles and profiles to ensure database security and data integrity.
  • Coordinated with UNIX/LINUX administrators for space management on servers and space planning for data growth.
  • Monitored RMAN backups, data pump dump files, archive redo log files and fast recovering area.
  • Support DBA for service requests from developers, system administrators and client users.
  • Documented significant day-to-day database changes and maintained a monthly report.
  • Assisted database programmers with writing efficient SQL
  • Responsible for scheduled maintenance tasks including exports, backups, and database recovery

We'd love your feedback!