We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

3.00 Rating

IL

EXPERIENCE SUMMARY:

  • Over 7 Years Of experience in Information Technology working as an Oracle DBA on Linux, Unix and Windows operating system environments.
  • Oracle Database (9i, 10g, 11g) Installation/Creation, upgrades, patching, Maintenance, Table space Management and Administration.
  • Expert in maintaining very Large Databases involved in Data warehouse and ERP Applications of various sizes - 5TB, 10TB.
  • Strong experience in working 24/7 production support environments.
  • Designed and implemented centralized backups and recovery strategies using recovery manager (RMAN).
  • Experience in logical backup using export/import and DataPump.
  • Generating/analyzing performance reports like AWR, ADDM and ASH.
  • Experience in providing backend Database support.
  • Tune poor SQL using SQL Tuning advisers.
  • Using EXPLAIN PLAN, SQL TRACE and TKPROF and giving recommendations to developers.
  • Experience in Installation, Configuration, Maintenance, Administration, Node addition and Troubleshooting Oracle Real Application Cluster (RAC).
  • RMAN Duplicate command to clone the Oracle Database.
  • Experience in implementing Automatic Storage Management for simple storage interface.
  • Experience in Patching Oracle Database using "opatch".
  • Experience in Cloning of Oracle Databases.
  • Expertise on performing cold backups, hot backups, advanced recovery methods like PITR, flash back recovery.
  • Experience in Installation, Configuration, Maintenance, Administration and Troubleshooting Oracle Dataguard.
  • Experience in Golden Gate installation and creation.
  • Handling Tools such as Toad, SQL Developer, Formatter Plus, OEM and SQL Worksheet.
  • Oracle database upgrade from 10g to 11g.
  • Experience in Oracle Enterprise Manager (OEM) 11g Installation and configuration.
  • Writing backend procedures, functions, Packages and triggers using PL/SQL.
  • Expertise in Writing Shell Scripts for managing day-to-day transactions.
  • Excellent communication skills, strong analytical & logical abilities, problem solving skills and fast learning.

TECHNOLOGY EXPERIENCE:

Database: Oracle (8i, 9i, 10g, 11g), MS SQL 2000/2005.

Operating Systems: Sun Solaris, AIX, Windows 2000/2003/2008 , Windows NT, Redhat Linux.

Programming & Scripting Languages: SQL, PL /SQL, Shell/Perl scripting.

Tools: Oracle Grid Control 12c, RMAN, Toad, Quest tools, Sql developer, Statspack Golden Gate, TKPROF, Data-pump, DBCA, DBUA.

PROFESSIONAL EXPERIENCE:

Confidential, IL

Sr. Oracle DBA

Responsibilities:

  • Installation and maintenance of 10g, 11gR2 on AIX, Linux platforms.
  • Worked on upgrading the oracle database from 10.2.0.4.0 to 11.2.0.3.0.
  • Responsible for installing and configuring Golden Gate on Oracle Servers.
  • Replication and Extracting data and applying on production database’s using Golden Gate.
  • Experience in setting backup and recovery using RMAN and Flashback Technologies.
  • Configured Data Guard (physical standby database) for the production database.
  • Configured oracle wallet for RMAN.
  • Creating profiles for the users and managing users.
  • Installation of Oracle Enterprise Manager 11g and managing the database.
  • Expert in utilizing the database tools like TOAD and performance tuning tools like Explain plan, AWR, ADDM, Grid control or similar technologies from other vendors like Quest.
  • Creating Materialized views for resultant tables and refreshing them to eliminate the full table scans in the SQL.
  • Experienced with creating DB Links across databases and performed advanced replications.
  • Experience in ASM patch upgrade for 11.2.0.3.
  • Performed Cross platform migration using transportable tablespaces and RMAN.
  • Implement Backup and Recovery Procedures using RMAN for Oracle Databases and test regularly in conjunction with operations. Configuring scripts for backups (Level 0 and Incremental).
  • Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
  • Performing Grid Infrastructure installations and creating RAC databases.
  • Successfully done Oracle ASM diskgroup migration activity and Migrating an existing Non-ASM Database into ASM.
  • Detailed experience in systems disaster recovery, maintenance and security.
  • Carried out DB Cloning and provided the cloned database for development side.
  • Monitoring Standby Database, Comparing parameters during Drill Activity.
  • Coordinated with application team and performance team to help them tune their queries.
  • Administered (10g/11gR2 RAC) environments adding and removing nodes to the cluster.
  • Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
  • Configured, created and Managed Oracle Data Guard in a real Applications Clusters (RAC) Environment.
  • Installation and administration/troubleshooting of RAC with 2 Node DG in 11.2.0.* on Linux/Solaris.
  • Experienced on UNIX shell scripting.
  • Performing numerous hot and cold backups, recoveries.
  • Setting up logical back-up (exp and imp) by making use of pipes.
  • Database Refreshing / Replication from production to testing using Data pump.
  • Provided on-call support for production environment including deployments, migrations, running patch, bug fix scripts, and routine maintenance.
  • Support and maintenance of Transactional Replication between Primary Servers and Read-Only servers, and experience in troubleshooting replication problems.

Environment: Oracle 9i, 10g, 11g, AIX 6.1, RHEL, OEM/Grid, SAN, TOAD, RMAN.

Confidential, TN

Sr. Oracle DBA

Responsibilities:

  • Supported more than 30 databases including development/production sizes up to 5 TB for 24/7.
  • Perform database upgrade from 9.2.0.8 to 11.2.0.2 for 1.5 TB of OLTP database.
  • Migrated 1.5 TB of production database from WINDOWS-2003 to Red-Hat Enterprise Linux 6.2 with Advance Data Pump.
  • Database migration from 9i to 10g to 11g.
  • Patched/Upgraded ORACLE 9i Databases to ORACLE 10g databases using DBUA/Manually.
  • Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
  • Data Guard configuration, Failover/switchover using DGMGRL.
  • Setup and Configured Physical Standby and Logical Standby Databases for various production systems.
  • Implemented High Availability solutions with Oracle 10g RAC and Standby databases (Oracle Data Guard).
  • Manages backup and recovery for RAC, and Determines RAC-specific tuning components.
  • Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
  • Uses Oracle Cluster ware to make applications highly available to clients and end users.
  • Installing ASM environment and migrating database from NON-ASM to ASM.
  • Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
  • Worked extensively on RMAN backups and recoveries and database cloning using RMAN Duplicate. Trouble shooting and maintenance of RMAN backups and user managed backups.
  • Resolving TEMP/UNDO tablespace full issues.
  • Creating tablespaces and Re-sizing data files on table spaces according to requirements.
  • Experience with the Oracle Enterprise Manager Grid control.
  • Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
  • Does Oracle Database capacity planning, space management, storage allocation and different type of storage structure (DAS/NAS/SAN-Based Solutions).
  • Partitioned Tables, Index for increased query performance and easier maintenance.
  • Created Indexes-Bitmap/Join Indexes, Function-Based Indexes etc. as per the given structures, operations, data in the tables for increased performance.
  • Trouble shooting RAC instances. (TAF, load balancing, ocrs check, failover).
  • To accept requests (Tickets) through mails on LOTUS tool for any problem related to Database Administration and to resolve the same.
  • Used oracle Golden gate for Real time data integration.
  • Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution in DBBC and Shared pool.
  • Worked in conjunction with the development team to fine tune SQL and PL/SQL Code using Execution Plan, SQL TRACE, ANALYZE, DBMS STATS and evaluating and monitoring database to resolve performance issues including troubleshooting errors, recovering database and failures as needed.
  • Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.

Environment: Oracle 9i/10g/11g, Oracle ASM, Solaris 10, REDHAT Linux, Oracle Grid ControlSAN, Data pump, RMAN, Golden Gate, SQL *Loader, Exp/Imp, Toad.

Confidential, IL

Oracle DBA

Responsibilities:

  • Worked on Installation, administration and upgrade of Oracle 9i/10g production and development databases.
  • Upgraded the single instance database from 9.2.0.8 to 10.2.0.2.
  • Responsible for installation and configuration of Oracle 10g Grid Control and agents, Managed databases using Oracle 10g Grid Control.
  • Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
  • Performed logical backup through export and import utility.
  • Planned and performed HOT and COLD backups.
  • Worked in FRA systems for quick restoration and recovery.
  • Worked on the Restore/recovering the data using incremental backup to resolve archive log gaps.
  • Used SQL Loader to load data from external files into Oracle Database.
  • Installed and updates critical security Patches using Enterprise Manager and O-PATCH.
  • Worked on AWR repository, Statspack report find/fix root causes for performance degradation in the databases.
  • Instance Tuning by running AWR, ADDM report.
  • Converted Standby databases into Physical Standby databases.
  • Fail-over done in Data Guard due to Primary failure.
  • Installing and configuring the ASM instance.
  • Query tuning when SQL is taking much time.
  • Monitoring and detecting the locked objects and releasing the same for usage then if needed Killing unwanted sessions.
  • Worked on setting up ORACLE 10g RAC Databases for test prototype environment with three nodes-clusters on Red Hat Enterprise Linux 4.
  • Responsible for administrating Single instance databases and administrating ASM, RAC database instances and standby database.
  • Monitored database health using tools like MM, TOAD, OEM and SPOTLIGHT.
  • Creating new databases and users accounts, setup backups, and other monitoring scripts.
  • Cloning/Refreshing development/test database from production.
  • Transported the Tablespace from production database and plugged-in it in development/ Test database for the usage of developers.
  • Adding and resizing datafiles if needed.
  • Recovering the database from Block corruption, Objects-drop and using TSPITR.
  • Create Database maintenance plans, including updating statistics, re-indexing, structure modification, capacity planning and index analysis.
  • Participated in 24x7 production support rotations.
  • Create multiple 11g databases on RHEL5 in development.
  • Worked with RAC implementation team. Added nodes.
  • DBA Support during different phases of the project DEV, Integration, System Testing, UAT, Pilot and Launch.
  • Creating and maintaining Materialized views for replication.
  • Database backups and restoration, backup strategies, scheduling backups and setting up the recovery drills time to time to crosscheck the backed up database files.
  • Raised SR# to fix database issues.

Environment: Oracle 8i/9i/10g/11g, Solaris 9, Red Hat Enterprise Linux 4.0, 5.0, RAC, Windows2003, Grid Control, TOAD, and SQL developer.

Confidential

Oracle DBA Developer

Responsibilities:

  • Worked on 24/7 production database.
  • Installing, maintaining, and configuring 9i and 10g databases on LINUX and SOLARIS 10, Windows 2003.
  • Cloning Database from Production Databases for Testing and development.
  • Applying Oracle Patches 10.2.0.3 and 10.2.0.4.
  • Worked on ASM and configured few instance on ASM in Oracle 10g.
  • Designed and implemented hot backups using a combination of incremental differential and full backups using RMAN and Hot/Cold.
  • Monitoring database performance using Oracle Enterprise Manager.
  • Controlling and monitoring user access to the database for new and existing databases.
  • Managed disk space requirements for growth of data tables and indexes.
  • Given suggestions on rewriting the SQL queries which elapsed more time for execution.
  • Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning by using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.
  • Configured Monitoring and Housekeeping scripts across the database-servers.
  • Using DB Link to link schema objects residing on remote database.
  • Developed PL/SQL packages, procedures, functions and triggers to support application.
  • Create TAR to Oracle for Bugs & work with oracle to resolve the issues.

Environment: Oracle 10g/9i/8i, Sun Solaris 8, AIX 5L 5.3, Windows 2003, TOAD, RMAN, OEMExport/Import utility.

We'd love your feedback!