We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • Proficient in Oracle 11g and 12c Database Administration
  • Proficient in Enterprise Manager
  • Proficient in RMAN, Backup and Recovery
  • Proficient in Database Migration, Upgrade and Patch Application
  • Performance Tuning
  • A self - motivated, responsible and reliable team player wif a set of strong technical skills.
  • Strong in solving problems of diverse scope where technical analysis and evaluation is required
  • Results-driven IT personnel wif skills in team building and problem-solving wif an established reputation for effectively working wif diverse groups of people and adaptability to changing environments.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

  • Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12c databases on Linux and Windows OS
  • Expertise in teh creation of databases, table spaces, tables, indexes and other database objects.
  • Installs and manages Oracle Enterprise Manager.
  • Install and configures relevant network components to ensure database access as well as database consistency and integrity
  • Troubleshoots and resolves various Oracle connectivity problems.
  • Provides network troubleshooting and administrative support for teh development staff.
  • Installation and management of Oracle database using database control
  • Creates and manages documentation on teh configuration and support of teh Oracle databases
  • Performs bulk load into teh database using SQL Loader
  • Performs standard and fine grain database auditing.
  • Documents database structure, changes, problems, issues for future references
  • Administers database user accounts.
  • Creates, modifies and deactivate user accounts
  • Assigns and monitors user access rights
  • Create Testing and Development databases following OFA compliance rules.
  • Provide database administration on production, testing and development database servers.
  • Managing Schema Objects.
  • Regular Monitoring Alert log Files and trace files on Day to Day Basis.
  • Identifying and removing Fragmentation, row migration/chaining of database objects.
  • Analyzing teh Tables and Indexes on performance base regularly
  • Monitoring Tablespaces and Datafiles utilization.
  • Managing Undo Tablespaces, Redo Logs, Control files and Archive logs.
  • Implemented multiplexing control files and redo log files
  • Configures various RMAN parameters as per teh requirement.
  • Performs physical backups using RMAN utility.
  • Performs incremental backups using RMAN.
  • Identify and recover teh corrupted db blocks using Block recover option in RMAN utility
  • Performs Complete Media Recovery of Database depends on teh nature of failure.
  • Configure and implement teh use of Oracle Recovery Manager (RMAN) for cold and hot backup to teh databases
  • Extensive use of DATAPUMP and Export /Import utilities for logical backups.
  • Performs database cloning and duplication using RMAN.
  • Monitors teh user sessions and take appropriate action to kill teh inactive sessions
  • Creates and rebuilds indexes as necessary.
  • Moves data from one database to teh other using Transportable tablespace
  • Performs various performance goal oriented database tuning.
  • Use explain plan, AWR, ADDM and various Oracle Advisors to tune teh database.
  • Created and tuned various materialized views.
  • Tunes various slow running query
  • Performs instance tuning, memory tuning query tuning and complete database tuning.
  • Creates and implemented various table partitions for large tables
  • Resolves various complex issues wif teh database.
  • Applies quarterly CPU patches to different version of databases.
  • Upgraded Oracle 10g database to 11g and 11g to 12c
  • Upgraded Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set

Confidential, Edgewood MD

Product Management Intern

Responsibilities:

  • Provided testing and application support for Chemical and Explosive detection products ( Confidential )
  • Worked wif Product Management and teh Marketing Communications team to develop marketing collateral for teh US market
  • Supported full time staff on defined projects such as data collection efforts, technical evaluations, and internal testing of products.
  • Participated in teh submission of report to teh government explaining a yield issue by compiling information from several members of teh product management team, incorporating edits from several sources, and formatting teh report in a clear, concise manner.
  • Performed machine testing to ensure compliance wif government regulations

We'd love your feedback!