We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

5.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY:

  • Around Six years of experience in the following areas: Database Administration, System Analysis and Design, Software installation and upgrade, Data Migration/Conversion and development of Oracle forms and reports. Have knowledge about Data Discovery Tracking and Management.
  • This involves hands on experience in Oracle, Visual Basic and Internet related applications Tools.
  • Willing to learn and adapt to new challenges, has excellent communications skills and strong interpersonal skills, which provide the ability to interact with end - users, managers, technical personnel, self-motivated, a quick learner and team player. Has excellent work ethics, and is team oriented with strong analytical and leadership qualities.

TECHNICAL SKILLS:

Hardware & software: Worked under SUN, SOLARIS, HP-UX 11i, SCO UNIX, LINUX, NT and WINDOWS on various hardware platform HP - 9000 Series, SUN 6500, C, FoxPro, Oracle Enterprise Manager, Toad, Develpoer/2000, Designer/2000, Developer 6i, SQL*PLUS, Reports, Pascal etc.

Primary Skills:

  • Installation and upgrade Oracle Databases
  • Worked as an Oracle DBA
  • Oracle Database REORG and Database Growth Monitor.
  • Performance tuning of Oracle Database
  • Experience identifying latch and locks
  • Used tkprof to analyze trace file
  • 24*7 databases and application support
  • Experience in OEM
  • Used PFT
  • Evaluate Statspack and AWR reports
  • Experience in scripting
  • Expert in writing Stored procedure, Database Triggers and Database Procedures
  • SQL*LOADER and Export/Import utility
  • Worked on various UNIX environments
  • Worked extensively on Oracle 7.x, Oracle 8.x, Oracle 8i, Oracle 9i, Oracle 10g and 11g Databases
  • Experience in database design and modeling
  • Responsible for Database maintenance and Support
  • Experience in SQL optimization
  • Team player and excellent organizational, interpersonal and communication Skills
  • Replication of Tables
  • Setup, Configure and Implemented DR database
  • Create Database Triggers and Procedures
  • Conversion of Data using Data Junction
  • Toad

Secondary Skills:

  • Experiences in developing Oracle forms/reports
  • Worked on Visual Basic 6.0

WORK EXPERIENCE:

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

  • Manage Oracle Databases
  • Oracle Production Database 100 GB (iPROC,AR, FA, AP, GL, PO, ONT, INV, WSH, WIP etc.)
  • Oracle Development, Test Database 100 GB
  • Database administration, Installation, creation, tuning, backup and recovery
  • Ensure Oracle Database and Application availability 24*7
  • Apply Database patches and application patches
  • UNIX System Administration activities including user maintenance, backup and restore.
  • Refresh Database/Application from Production
Confidential, Maywood, New Jersey

Oracle Database Administrator

Responsibilities:

  • Manage Oracle Databases
  • Oracle Production Database 200 GB (AR, FA, AP, GL, PO, ONT, INV, WSH, WIP etc.)
  • Oracle Development Database 200 GB
  • Database administration, Installation, creation, tuning, backup and recovery
  • Oracle performance tuning using TKPROF, Explain Plan, Enterprise Manager and OS utilities.
  • Oracle Database conversion and upgrade
  • Ensure Oracle Database and Application availability 24*7
  • Apply Database patches and application patches
  • Monitoring/tuning both DSS and OLTP operation
  • Design and Implementation of Database backup procedures
  • Databases restore procedure design and implementation
  • UNIX System Administration activities including user maintenance, backup and restore.
  • Refresh Database/Application from Production
  • Planning and testing Disaster Recovery
Confidential, Cary, North Carolina

Oracle Database Analyst

Responsibilities:

  • Conversion voters data into Oracle Database
  • Creating Tables/Indexes
  • Creating Procedure/Function and Packages
  • Load data into Production Database using Data Junction Tool
  • Tuning SQL
  • Analysis of Data

Confidential, Raleigh, North Carolina

Developer

Responsibilities:

  • Functions, Procedures and packages
  • Creating tables and indexes
  • Create Users

We'd love your feedback!