We provide IT Staff Augmentation Services!

Oracle Database Resume

PROFESSIONAL SUMMARY

  • Over7+ yearsof professional experience inOracle Database Administration
  • Expert in areas ofOracle 11g/10g/9i/8i, PL/SQL, SQL, SQL*Loader, DataPump.
  • Experience with BuildingOracle 11gRAC, Oracle 10g RAC, Data Guard, ASM, Flashback and RMAN
  • Experience in Various Flavors ofUNIX (Sun Solaris, HP-UX and IBM AIX), LINUX (RedHat Linux, Oracle Enterprise Linux).
  • Implemented Active Data guard(Physical Standby) with Oracle 11g R2.
  • Participated in DR exercise (Switchover and Failover).
  • MigratedNon ASMdatabases toASM.
  • Experience with High Availability features ( RAC/ DG/ ASM / Flashback / RMAN)
  • Implemented replication using Oracle Streams, GoldenGate.
  • Upgraded databases from 9i to 10g, 9i, 10g to 11g
  • Experienced inOracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database accessandSecurity and auditing.
  • Troubleshooting ofPerformanceandTuningproblems in Oracle database using tools likeEXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK,AWR, ADDM, OEM Grid Controland manual scripts.
  • Refresh and Cloning of databases for development and testing
  • Expertise inMaintenance, Patching, Cloningandtroubleshooting.
  • Excellent knowledge inUser Managed / RMAN backups and Recovery.
  • Experienced in DatabasePoint in Time Recovery and Tablespace Point in Time recovery.
  • Enforcingsecurityby creatingroles, grantingsystem and objectprivilegeson the Tables, and stored procedures with DBA concepts.
  • Good understanding oforacle Data DictionaryandNormalization Techniques.
  • Created and modified Database objects likeTables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored ProceduresandPackages.
  • Experience in Working withOracle Supportto resolve issues and open TAR / SR
  • Enforcingdata integrityusing integrityconstraints& databasetriggers.
  • Experience in Capacity Planning & Benchmarking
  • Good experiencein SQL, PL/SQL Programming, Shell Scripting,Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
  • ExcellentAnalytical, CommunicationandPresentation skills.
  • Experience in providing 24x7 support.

TECHNICAL SKILLS

Languages :PL/SQL, SQL, SQL*PLUS, C, Java, Shell Scripting
Database :Oracle 11g RAC/10g RAC/9i/8.x, MS Access
Operating System :UNIX(Solaris, IBM AIX, HP-UX), Linux (Redhat, OEL), Windows
Tools :SQL*PLUS, SQL Developer, TOAD, Sql Navigator, PUTTY, OEM, RMAN, SQL* LOADER, Imp/Exp and DataPump, RMAN, ASM, OEM Grid Control
Other Technologies :ODBC, Crystal Reports, MS Office, SFDM, Erwin 4.0/4.2/7.6, Relational Database Design.

EDUCATION & CERTIFICATIONS:

  • B.Tech Computer Science & Engineering
  • Oracle Certified Associate.

Hire Now