We provide IT Staff Augmentation Services!

Oracle Dba Resume

5.00 Rating

MD

SUMMARY

  • 7+ years of experience in Oracle Database Administration, tuning, development, analysis, design, Installation, patches, upgrades, migrations, configuration, space management, data modeling, cloning, backup and recovery, auditing, database security, SQL, PL/SQL, troubleshooting and documentation.
  • Experience in Installation, Configuration and Maintenance of Oracle 12c/11g/10g RAC database wif ASM, EXADATA and single instance database.
  • Experience in designing and implementing Disaster Recovery(DR) plan using Data Guard and Gloden Gate
  • Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
  • Experience in Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
  • Experience in system Monitoring & Database Performance Tuning using Explain plan, SQL Trace.
  • Performed fine tuning by creating indexes, TKPROF, EXPLAIN PLAN and TRACE events.
  • Experience in Supporting EDW wif OLTP and OLAP Data ware House applications.
  • Upgraded database from 9i, 10g to 11g and Migrated databases across different servers & platforms.
  • Experience in database full Backup (hot and cold), DataPump Export/Import, SQL Backtrack and Restore and Recovery procedures using RMAN.
  • Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
  • Proficient in performance tuning in large OLTP (40 TB) and data warehouse environments.
  • Expertise in Installation, Upgrade Configuration, Migration, Patching, RMAN, Performance Tuning, Backup & Recovery, and Data Guard on different Oracle versions, played different roles like Production/Development database administrator and Data Warehouse DBA.
  • Experience in working wif Grid Control and Oracle Enterprise Manager (OEM).
  • Job scheduling using cron utility and Shell Scripting for automating DBA tasks.
  • Back - end programming, database Triggers, stored Procedures and Functions using PL/SQL.
  • Experience wif SQL, PL/SQL coding, stored procedures, triggers, cursors, packages, performance Tuning, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement teh business logic.
  • Oracle Enterprise Manager Grid (10g, 11g, 12c) - upgraded 10g (10.2.0.4) to 11g (11.2.0.3) to 12.2.0.1 (including agents upgrades, etc.)
  • Experience in maintaining Oracle Data Guard
  • Setting up teh complete Database Security Implementation and troubleshooting Oracle Technologies as an Oracle DBA on OLTP and OLAP environment.
  • Experience in Standby Database and providing critical solution wif strategic disaster recovery plans wif different recovery procedures and methods.
  • Experience in Database Creation, Partitions, and Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage, resolving ORA-errors and network management.
  • Experience of Auditing, Oracle Security, OEM, SQL Navigator, TOAD and Opatch Utility.
  • Expertise noledge of Oracle Architecture, SGA and PGA
  • Proficient in SQL, SQL*Plus, SQL*Loader, TOAD Quest and Tuning of SQL Queries.
  • Resolved database network problems using Oracle Net Configuration Assistant (NETCA) and Virtual IP Configuration Assistant (VIPCA) and a very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS

Operating System: Red Hat Linux, HP UNIX, Solaris, AIXWindows 2000/2003/2008/2012

Database: Oracle 12c/11g/10g/9i/8i, RAC11g/10g, SQL Server

Storage Technologies: Oracle ASM, SAN, Net AppVirtualization Technologies VMware, Oracle Virtual Machine

DR Technologies: Oracle Data Guard, Data Guard Broker

Backup recovery Tools: RMAN, flash recovery

Programming Languages: SQL, PL/SQL, UNIX Shell Programming, Java, CC++, HTML.

Tools: / Utilities: Oracle10g/11g Data Guard, Oracle Enterprise Manager, Oracle 10g Grid Control, RMAN, TOADGloden Gate, SQL*loader, Datapump (Export/Import), RAC, ASHAWR, ADDM, Statspack, Taproot, Oracle Forms Report, Ablnitio, Informatica, Data Stage, Putty

PROFESSIONAL EXPERIENCE

Confidential, MD

Oracle DBA

Responsibilities:

  • Responsible for upgrading system from Oracle 10.2.0.1 (10gR2) to Oracle 11.2.0.2 (11gR2).
  • Performed teh migration and upgradation of Oracle databases by using import/export, oracle datapump.
  • Experience in HP-UNIX environments.
  • Implementation of high availability solutions wif Oracle 10g RAC, Physical and Logical Standby database, Data Guard, Materialized views, Bi Directional Streams Replication, Gloden Gate
  • Good noledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Experience in working wif EXADATA wif for OLTP and OLAP Databases.
  • Created database objects like tables, views, indexes and partitions.
  • Used Oracle backup utility RMAN to implement Oracle backup.
  • Scheduling meeting wif teh Application Team in different location to gather teh information for migration.
  • Applying patches whenever required in Exadata, RAC and standalone servers.
  • Performed SQL Tuning and database tuning based on reports generated by Run time SQL execution plans, AWR, ASH Reports, Explain Plan and monitor teh database performance
  • Estimating teh space requirements for database growth for next 12 months and availability of Hardware to support teh processes.
  • Carried out Performance optimization and Query tuning using Statspack, Tkprof and OEM.
  • Installed and Configured Oracle Enterprise Manager Grid Control for monitoring several databases.
  • Creating Users and Grant/Revoke roles, privileges on database objects and creating database links (dB link).
  • Monitoring teh Users, Tablespaces, Memory Structures, Rollback Segments, Redologs, Tables, Archived Redologs and Alerts.
  • Performed various database migrations, refreshes as per requirements.
  • Applied CPU patches each quarter to keep teh databases up to date.
  • Worked wif developers to tune, optimize code.
  • Worked wif Oracle support to resolve various issues wif teh database by opening SR’s.
  • As a team member, involved in interacting wif business users, gathering business requirement.

Environment: SQL, Oracle 10g, Oracle11g, RMAN, Import/Export, Oracle Enterprise Manager, IBM AIX 5.3

Confidential, VA

Oracle DBA

Responsibilities:

  • Performed teh migration and up gradation of Oracle databases on Oracle Super cluster half rack.
  • Installation of Oracle database and ASM (11.2.0.4) on Zones/Domains.
  • Involved in configuration of Super cluster half rack (11.2.0.3.19 BP) wif 2 compute nodes.
  • Involved in implementing replication using Gloden Gate
  • Involved in installation of database on Exadata half rack 4 compute nodes and 8 ZFS storage cell.
  • Developed and implementing Disaster Recovery (DR) plan using DataGuard.
  • Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
  • Good noledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Installed Oracle GlodenGate and configured heterogeneous replication.
  • Optimized lot of SQL statements and PL/SQL blocks by analyzing teh execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
  • Hand on experiences in creating Index optimization jobs to increase database performances.
  • Maintaining Production, Development & Test databases and applications which are in Exadata, RAC, single instance servers
  • Responsible for upgrading system from Oracle 11.2.0.3 to Oracle 11.2.0.4.
  • Hands on experiences on installing and maintaining of RAC databases.
  • Performed restoring of database via RMAN utility.
  • Experience in Knowledge Transfer of Gloden Gate Product and Installed Gloden Gate(10.4/11.1)
  • Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.
  • Hands on experiences on 12c Oracle Enterprise Manager Grid Control for monitoring several databases.
  • Used Oracle backup utility RMAN to implement Oracle backup.
  • Performed teh migration and up gradation of Oracle databases by using import/export, oracle datapump.
  • Production & Non-Production support for several mission critical/entity essential OLTP systems, which utilize multiple Oracle databases (TB Sizes).
  • Installed and Configured Oracle 11g.
  • Created database objects like tables, views, indexes and partitions.
  • Scheduling meeting wif teh Application Team in different location to gather teh information for migration.
  • Performed SQL Tuning and database tuning based on reports generated by Run time SQL execution plans, AWR, ASH Reports, Explain Plan and monitor teh database performance
  • Estimating teh space requirements for database growth for next 12 months and availability of Hardware to support teh processes.
  • Creating Users and Grant/Revoke roles, privileges on database objects and creating database links (dblink).
  • Monitoring teh Users, Tablespaces, Memory Structures, Rollback Segments, Redologs, Tables, Archived Redologs and Alerts.
  • Performed various database migrations, refreshes as per requirements on EXADATA environment.
  • Applied CPU patches each quarter to keep teh databases up to date.
  • Worked wif developers to tune, optimize code.
  • Worked wif Oracle support to resolve various issues wif teh database by opening SR’s.
  • As a team member, involved in interacting wif business users, gathering business requirement.
  • Applied CPU patches each quarter to keep teh databases up to date.

Environment: Oracle Super cluster half rack (11.2.0.3.19 BP), Exadata Half Rack, Oracle 10g/11g, Oracle Enterprise Manager (11g, 12c), SunOS SPARC 5.10

Confidential

Oracle DBA

Responsibilities:

  • Installation of Oracle 9i and creation of database.
  • Performed regular Backups and Recovery as per Organization Strategy to support teh database and also maintain 24 hours uptime for teh database while carrying out teh activities.
  • Optimized lot of SQL statements and PL/SQL blocks by analyzing teh execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
  • Experienced wif CDC/Gloden Gate 11g skills in large production environment
  • Worked in backup team and was responsible for configuration and implementation of backup strategies using RMAN.
  • Backup/Restoration, Scheduling Backups, taking Logical Backups.
  • Involved in Design and implementation of oracle 10g DataGuard both physical/logical standby databases.
  • Performed Partial, Complete and Metadata Exports & Imports.
  • Capacity Planning, Storage Allocation and Space Monitoring & Management.
  • Responsible for Oracle 9i logical and physical databases design, implementation and maintenance.
  • Created Tables wif appropriate Tablespace and Index.
  • Created Users, Roles and Schemas wif suitable Permissions.
  • Responsible for Partitions on tables and Indexes for managing large tables.
  • Maintained Logs/Backups using Imp/Exp Utilities.
  • Coordinated wif Unix Administrators for Space Management on various servers &help in Oracle.
  • Automating processes, Scheduling Jobs per user requirements using DBMS JOB.
  • Database monitoring for Deadlocked process.
  • Installation and configuration of Statspack and analysis of Statspack.
  • Performed SQL tuning by using Explain Plan and TKPROF and Oracle Enterprise Manager.
  • Responsible for Data Integrity and Concurrent Data, Locks, Latches and Deadlocks.
  • Created Users and Roles wif appropriate Privileges.
  • Created Materialized views and database links. Wrote shell scripts for monitoring teh database.
  • Designed logical and physical Data Models using ERWIN.

Environment: SQL, Oracle 10g, Oracle Enterprise Manager, PL/SQL, TOAD and SQL *Plus.

Confidential

Oracle Developer

Responsibilities:

  • Involved wif Maintenance and Support processes.
  • Analyzed teh software requirements of teh project by studying teh Software Requirement Specification document.
  • Created various database objects like table, indexes, sequence and views
  • Involved in creating, debugging and modifying stored procedures, functions and packages using SQL Developer and TOAD.
  • Used various forms of control structures including IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
  • Creating SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
  • Maintaining a Test Database for testing and research.
  • Documented business rules, technical designs, test cases, and user guides.
  • Testing teh system in and fixing teh errors.
  • Involved in unit testing, integration testing, system testing

Environment: SQL, PL/SQL, SQL*Loader, Oracle 10g, Oracle9i, UNIX (Sun Solaris 2.8)

We'd love your feedback!