We provide IT Staff Augmentation Services!

Oracle Dba Resume

3.00/5 (Submit Your Rating)

Herndon, VA

SUMMARY

  • Overall 8 years of IT experience including 4 years as Oracle Database Administrator
  • Monitoring of Database - Health/Performance (Database, I/O, Memory, Processes, parameters), Database/Data-files/Tablespaces Growth Pattern, Space Utilization, Backups/Recovery, Security/User Management
  • Installation and Configuration of Oracle Instances(9i, 10g and 11g) on Unix/Linux environments
  • Oracle Software patching
  • Managing Database security: Users, Roles, Privileges, Profiles etc.
  • Managing Tablespaces, Segments, Extents and Indexes; Procedures and Triggers & Views
  • Database Backup and Recovery using RMAN
  • Database Clone using Hot/Cold Backup
  • Storage Management (RAID/ASM)
  • Performance Tuning
  • Standby/Data Guard Configuration
  • Managing Real Application Cluster (RAC) Databases
  • Oracle Database Replication - materialized views

TECHNIALS SKILLS

RDBMS: ORACLE 9i, ORACLE 10g & 11g R2

OPERATING SYSTEM: UNIX, LINUX, SOLARIS-10

REMOTE ACCESS TOOL: Putty, VNC

UTILITIES: Opatch, Export/Import utility, Net Manager & Oracle Enterprise Manager, TOAD, SRVCTL, CRSCTL

PROFESSIONAL WORK EXPERIENCE

Confidential, Herndon, VA

Oracle DBA

RESPONSBILITIES:-

  • Working on 24x7 production support.
  • Managing more TEMPthan 16 production, testing business critical databases
  • Managing Oracle 10g/11g releases RAC (2 Nodes) databases in production and development environment.
  • Worked on Recovery manager (RMAN) for backup and recovery.
  • Handful experience in Upgrading oracle databases from Versions 10g to 11g.
  • Involved in Installing and configuring of 11g Oracle Real Application Clusters (RAC) in Linux.
  • Rebuilding of Indexes for better performance, maintenance of Oracle Database
  • Oracle binaries installation, patching and upgrade
  • Managing Schema/Table level refreshes
  • Managing production deployments
  • Experience on implementing Datagurd Switchover and failover.
  • Database cloning from production Database.

Environment: Oracle 11gASM/11g RAC/10g, Flashback, Data Pump, Grid Control (OEM), Enterprise Manager Console, SQL*Loader, SQL PLUS, SQL Developer, Putty.

Confidential, Parsippany, NJ

Oracle DBA

RESPONSBILITIES:-

  • Working on 24x7 production support.
  • Monitoring Database Alerts and making report of some Critical Database’s Daily Growth size and Tables growth size and Top SQL events and Database Cluster’s Node Activity.
  • Managing RMAN Backups
  • Oracle binaries installation, patching and upgrade
  • Managing production deployments
  • Monitoring Growth of tablespaces and undertaking necessary re-organization of database
  • Create and manage Oracle users wif appropriate grants and privileges
  • Rebuilding of Indexes for better performance, maintenance of Oracle Database
  • Creating Knowledge Base Documents for Oracle Database
  • Installation and Configuration and Managing 2 nodes RAC database
  • Cloning production database on development servers.
  • Set up and maintain the listener.ora, tnsnames.ora and ORATAB file as per Security requirements
  • Full Database, Tables and Schemas refresh using logical backups
  • Handling Request for Schema change, modifying TNSNAMES.ORA & Parameter files, Database backup, Database Startup, Database Shutdown and Bounce
  • Create Accounts and Tablespaces
  • Monitoring of Cluster’s node of RAC database

Environment: Oracle 10g and 11gR1/R2, OEM, RMAN, RAC, Data Guard, ASM, Explain plan, AWR, SQL* Plus, PL/SQL, SQL* Loader, AIX 6.1, Red Hat Linux 5.0 and Windows MSCS 2003, TOAD 10.0

Confidential

Junior Oracle DBA

Responsibilities:

  • 24x7 Oracle Production Database Administrations.
  • Installation, Configuration, Upgrade, patching of Oracle RDBMS.
  • Refresh/Cloning of Database for development, testing
  • Create table spaces, tables, and users for custom applications.
  • Maintain user security.
  • Assist Programmers and Developers wif Oracle problems.
  • Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
  • Implementing range, list partitions, hash partitions.
  • Creating and refreshing materialized views.

Environment: Oracle 10g/9i, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, Data Guard, EXPLAIN PLAN, Cloning, OEM,Pl/Sql.

We'd love your feedback!