We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

SUMMARY

  • 3 years of experience in the IT industry. 2+ years of experience as an Oracle Database Administrator.
  • Responsible for Administration, Installation, Upgrading, Configuration, Maintenance, and Troubleshooting of the Oracle Databases.
  • Complete range of Oracle DBA activities including day - to-day production database monitoring, Backup & Recovery.
  • Administering the Database users, Managing all types of database objects and responsible for data/database security and protection.
  • Use DBCA to create and DBUA to upgrade Oracle databases.
  • UNIX Systems Administration, Help desk assistance, Hardware troubleshooting, Issue logs tracking and Patch management with excellent technical skills
  • Provide administrative database security role by protecting the database, creating and managing users.
  • Provide system management role by troubleshooting, reviewing and monitoring database performance.
  • Performs general DBA duties (install software, create databases, table spaces, add redo log files, managing storage & work closely with Sr. DBA on capacity planning and performance tuning
  • Performs daily database backup of development and test environments, use production data to refresh development and test schemas for testing
  • Excellent troubleshooting skills
  • Performance tuning and monitoring
  • Identify and make recommendations per database performance issues
  • Knowledge of managing Oracle on Windows
  • Knowledge of database design
  • Use DBCA to create and DBUA to upgrade Oracle databases
  • Prepare documentation for DBA department
  • Implements/maintains database security with roles and system privileges
  • Experience working in a help desk and call center environment.
  • Demonstrate ability to quickly diffuse heated customer situations.
  • Excellent troubleshooting and logical problem solving skills.
  • Creative ability to solve unusual or difficult problems when logical methods have failed.
  • Demonstrate ability to meet deadlines and set priorities.
  • Strong communication and interpersonal skills.
  • Ability and desire to learn new technologies quickly.

TECHNICAL SKILLS

Relational Databases: Oracle 10g, 11g, 12c

Operating systems: Microsoft, Unix( Linux)

Networking Topologies / Protocols: Ethernet, TCP/IP & router configuration

Programming Languages: SQL,SQL*PLUS

Software Applications/Tools and Utilities: OEM, RMAN, DATA MIGRATION-EXPORT-IMPORT,BACKUP &RECOVERY PERFORMANCE TUNING-SQL-LOADER, DATA GUARD, AWR.ADDM.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

  • Participate as an active member of the operational support team to monitor, report, troubleshoot, escalate and resolve technical issues with Oracle databases and associated systems
  • Execute SQL queries against Oracle databases
  • Transferring, cleaning and validating client data
  • Documenting processes, standards and methodologies for working with client data and systems
  • Developing, updating and maintaining reporting processes and tools
  • Provided Oracle network troubleshooting, technical and administrative duties
  • 24/7 production environment support
  • Applied security features to 10g and 11g databases
  • Tuned the database and applications for faster and better performance also performed goal oriented tuning as necessary

Confidential

Oracle Database Operator Intern

Responsibilities:

  • Planning, installation, configuration, management and troubleshooting of oracle 10g and 11g databases on Linux and Windows OS
  • Assisted in database upgrade from 10g to 11g and 11g using DBUA.
  • Assisted in Installation and Management of Oracle using Grid 11g and database control by installing the software and agent, this I used to manage multiple databases.
  • Assisted in Installation and application of several oracle critical patches to various database versions looked for critical path for the OS and also had to check the location of my O-Patch.
  • Monitored, optimized and allocated physical data storage for database systems
  • Implemented the use of Oracle Recovery Manager (RMAN) to back up the databases.
  • Performed import and export as needed on each database.
  • Assisted in Performing various daily RMAN backups and recovery for numerous oracle 10g and 11g databases using physical backup (RMAN) and logical backup (export, import and data pump).
  • Install and configure Physical Standby on Windows and Linux environment.
  • Troubleshoot and resolved various oracle problems such as connectivity problems, back up and performance issues
  • Provided Oracle network troubleshooting, technical and administrative duties
  • Created and managed documentation on the configuration and support of the oracle databases.
  • Created and managed user accounts, profiles and system policies.
  • Performed a flashback and point in time recovery
  • Migrated data using the data pump export (expdp) and import (impdp)
  • Created non-default listeners for databases.
  • Provided Oracle database administrative support to various user groups (application developers, data managers etc.);
  • Control and monitor user access to the database using roles, and profiles
  • Performed hands-on monitoring, troubleshooting and administration of Local Area Network (LAN) resulting in performance and minimum downtime in the organization.
  • Create and Maintain of Databases through DBCA
  • Knowledge in Database performance monitoring & tuning
  • Investigate potential problems and issues raised by business users
  • Create and Assign Roles, Privileges and Profiles to Users
  • Monitoring Alert logs for any errors, problems or processes running
  • Configuration and working with RMAN (Recovery Manager).
  • Knowledge in cloning using cold backup, hot backup and RMAN

Hire Now