We provide IT Staff Augmentation Services!

Oracle Dba Resume

Redmond, WA

PROFESSIONAL SUMMARY

About 10 Years of experience in IT industry experience as an Developer and Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security.

  • Extensive knowledge on database administration of Oracle 8i, 9i, 10g, 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
  • Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g on Windows, RHEL platforms.
  • Extensive hands on experience on building 11gr2 RAC databases on EXADATA X2 - 2 HALF RACK servers.
  • Expertise in building RAC environments on RHEL using ASM block level storage
  • Expert in converting single instance databases to RAC using RCONFIG, MANUAL CONVERSION and RMAN.
  • Installed oracle GOLDENGATE 11.2.0.9 one-way replication on Oracle database 11.2.0.2.
  • Configured oracle goldengate classic and Integrated capture modes on Linux server.
  • Extensive knowledge on Creating physical standby databases using Active database and syncing the databases using DGMGRL.
  • Expertise in upgrading the databases from Oracle 10g to Oracle 11g.
  • Installed Oracle 10g RAC software with ASM & OCFS2 File systems.
  • Installation, maintenance and tuning of RAC Applications
  • Created development, testing, staging, production, RAC and standby databases for OLTP systems
  • 24*7 production database support with Support to developers & end-users.
  • Have implemented ORACLE STREAMS (GG), and two type of standby databases supported by DATAGUARD, logical standby and physical standby databases
  • Having hands on experience in Hot/Cold Backup , Recovery and Cloning of databases using RMAN.
  • Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
  • Implemented the secure backup of the data using RMAN.
  • Implemented automated backup strategy using the UNIX shell script CRON UTILITY
  • Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
  • Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
  • Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
  • Database replication using snapshots, materialized views and advanced replication methods.
  • Experience in applying security patches to the databases.
  • Effective troubleshooting of database and Performance problems.
  • Good experience in Data Migration using export/import.
  • Management of Objects, Schemas, Partitioning the tables and Indexes.
  • Worked on Developing PL/SQL packages, stored procedures, functions, Cursors, triggers.
  • Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
  • Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN).
  • Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
  • Good Interpersonal communication skills and Documentation Skills.

Technical Skills
Operating Systems: Sun Solaris 9.0/10.0, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows 98/NT/2000/2003.

RDBMS: Oracle 11gRAC/10gRAC/10g/9i.

Languages: SQL, PL/SQL, C, UNIX Shell Scripting, XML

DB Management: TOAD, OEM 9.2x

Tools/Utilities: RAC, OEM Grid Control, ESM, SQL Navigator, SQL* Loader, ASM, Export/Import, RMAN, TOAD, Patch Management, SQLNET, Oracle Streams, GoldenGate Data pump, Data Guard, VMware, MS Office.

Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, ASH, ADR

PROFESSIONAL EXPERIENCE

Client: Confidential, Redmond, WA

Database Administrator

Responsibilities:

  • Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) databases including a 4 Node RAC on EXADATA.
  • Setting up Hugepages - Calculated the recommended values and setup hugepages on linux severs. Also configured hugepages for the EXADATA X2-2 half rack boxes.
  • Implemented DBFS (Database file system) on EXADATA servers.
  • Installed 1 1g 2node production and development RAC CLUSTERWARE and DATABASE on linux server
  • Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually .
  • Migrated databases on standalone server to 2 node RAC cluster.
  • Setup physical standby’s (DATAGUARD ) for several Databases.
  • Setup the standby via OEM cloud control 12c for several databases.
  • Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the dataguard status via DGMGRL and GUI.
  • Converted physical standby to Snapshot standby and back to physical standby.
  • Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.
  • Storage Migrations: Solely responsible for migrating the Prod/Tst/Dev Databases from NetApp to HNAS and also to block level storage . (Migrating the databases from Non-ASM to ASM )
  • OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM. Monitoring the databases using OEM 12c.
  • Implemented PARTITIONING using EXCHANGE PARTITION method.
  • Datapump including database links and network links.
  • Problem diagnosis and Performance tuning by implementing Partitioning, Parallelism, Compression .
  • Performed Database and SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor, ADDM, Real Time ADDM, Database Replay and EXPLAIN PLAN an alysis for query optimization.
  • Built databases with different blocksizes and tested the performance with various parameter settings.
  • Capacity planning for the projects owned in the environment.
  • Backup and recovery procedures using RMAN . Created scripts for RMAN incremental backups and also for full database backups using datapump.
  • Provided backup/Restore & Recover of the databases using RMAN and FLASHBACK database procedures.
  • Upgrade the binaries by applying patch set and interim patches using OPatch and OPatch Auto .
  • Creation of new PL/SQL procedures and triggers based on the project requirement.
  • UNIX shell scripting as and when required based on the requirement.
  • Provided 24*7 production supports as was always on call for maintenance activities.

Environment : Oracle EXADATA HALF RACK, Oracle 11gr2, OEL 5.8, OEM 12c, RAC, Dataguard including DGMGRL, RMAN, Partitioning, Compression, DBFS, Performance tuning, OPatch Auto, TOAD for oracle 11, Storage Migrations.

Client: Confidential, Princeton, NJ

ROLE: Oracle DBA

Responsibilities:

  • Installed and configured 11gR2 RAC databases on RHEL 5 Unix environments.
  • Worked in both Development and Production environment.
  • Involved in building Testing and Development environments for more and intense application testing.
  • Supported Databases which hold data of multiple applications varying from large data to low data.
  • Worked on database Sizes >= 3TB.
  • Installed 11gR2 databases on standalone servers and created RMAN Repositories.
  • Restored Databases to lower environments using Datapump.
  • Expertise in Migration of databases to new servers using Datapump.
  • Provided 24*7 production supports as was always on call for maintenance activities.
  • Communicated well with the client and end users for setting up and working on their requirements in providing support from the database perspective.
  • Worked extensively on Performance tuning involving the tuning of oracle queries by using AWR, ADDM Reports.
  • Configured Oracle Dataguard for Oracle Disaster recovery
  • Involved in configuring, managing and monitoring both Physical standby and Logical standby database using Data Guard.
  • Performed up-gradation databases from 10g to 11g on RHEL.
  • Worked on Exporting and importing the statistics of particular schemas from production to Development for Testing.
  • Used Toad for oracle and SQL Developer for query tuning and testing.
  • Gained knowledge and experience on middleware administration such managing JBoss and Tomcat application servers.
  • Involved in setting up database connections with application servers and managing deployable in the deployment folders.
  • Bounced the application servers on various occasions in the lower environment for the clearing hung threads and sessions.
  • Worked on setting up jobs using third party tool such as Job Scheduler for scheduling jobs for end application users.
  • Schemas restore using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases.
  • Restored and Recovered databases using RMAN for the migration of the Databases from 10g to 11g.
  • Creating Database Monitoring scripts and batch files for schedule jobs.
  • Installed OEM agents for databases to be monitored and administered through 10g Grid Control OEM.

Environment : Oracle 11g RAC, RDBMS, Data Guard, RMAN, RHEL 4.x, 5.x, shell scripting, and 11G OEM Grid control, Toad, SQL Developer, Stored Procedures, Production Support 24*7 JBOSS, Tomcat, Apache, Job Scheduler etc.

Client: Confidential, Boise, ID

ROLE: Oracle DBA

Responsibilities:

  • Installed and configured 11gR2 RAC databases (3 node) on RHEL 5 for the migration of databases from RHEL 3 to RHEL 5.
  • Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
  • Worked in both development and production environment.
  • Migrated databases from RHEL 3 (node 4) to RHEL 5 (node 3).
  • Installed 11gR2 databases on standalone servers and created RMAN Repositories.
  • Migrated the RMAN catalog’s from database running on RHEL 3 to RHEL 5 and upgraded the databases from 10g to 11gR2 (11.2.0.1).
  • Migrated the Oracle Managed Server OMS from 10g database to 11g database.
  • Installed and configured Weblogic Server Application Server (10.3.5.0) and Fusion Middleware Enterprise Manager for the deploying and administration of 11g Oracle Internet Directory OID (11.1.1.3.0 ).
  • Setup Multi-Master Replication between 10g OID and 11g OID using OEM.
  • Setup One way Replication between 11g OID using ODSM.
  • Schemas refresh using Export/Import . Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases
  • Performed HOT/COLD backups and Logical backups .
  • Restored and Recovered databases using RMAN for the migration of the Databases from 10g to 11g.
  • Creating Database Monitoring scripts and batch files for schedule jobs.
  • Installed OEM agents for databases to be monitored and administered through 10g Grid Control OEM.

Environment : Oracle 10g RAC 11gR2 RAC, RDBMS, RMAN Catalog, Data Guard, RHEL 3.x, 5.x, shell scripting, 10G, and 11G OEM Grid control, OID (11.1..1.3.0 ), OMS.

Client: Confidential, Milwaukee, WI

ROLE: Oracle DBA

Responsibilities:

  • Installation, Upgrade and Configuration of Oracle (11gR1 and 11gR2) for the new projects/surveys.
  • Installed 10g RAC (2 Node) on RHEL and converted/added an additional node to the existing RAC for production databases.
  • Worked on database Sizes >= 3TB.
  • Installed CRS, ASM lib on oracle 10g Databases and added nodes to existing RAC Databases .
  • Migration: Duplicated database using RMAN of Oracle 10g database and upgraded it to oracle 11g and applied latest patch set.
  • Efficiently used Transportable (XTTS)/Data pump in 10g migration from prod to test and test to prod.
  • Applied the bundle and CPU patches to all test, development and production databases.
  • Restore and Recover, Cloning and Duplicating databases using scripts as well as with RMAN .
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Implemented and Configured Advanced Queues over streams and set up loading the files from XML to Oracle database tables.
  • Setup Advanced Queues (enqueue/dequeue/propagation/subscriber/agent) on prod databases.
  • Configured, Setup and Implemented oracle Streams (Upward and downward) on 10g Databases.
  • Replicating schema/table level database using Streams. Performed entire database replication using Streams.
  • Implemented Physical Standby 10g databases with and Without RMAN using Data guard .
  • Experience with handling of medium to large Oracle OLTP (Online transaction processing).
  • Performance tuning i.e. Tuning RAC , tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
  • Configured Oracle data guard and Streams.
  • Involved in designing of disaster recovery using Data Guard , High Availability using 10gRAC .
  • Schemas refresh using Export/Import . Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases.
  • Worked on Building schemas, cursors, developed stored procedures and database triggers in PL/SQL .
  • Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls.
  • Developed UNIX shell scripts to perform the above tasks efficiently .
  • Creating Database Monitoring scripts and batch files for schedule jobs.
  • Configured Recovery Manager (RMAN) like Advice on data recovery, parallel backup of the same file, and virtual catalogs and Secure backups for security.
  • Extensive Performance Tuning, Memory (SGA) Tuning, RAID, RAW Devices .

Environment : Oracle 10g/11g RAC, RDBMS, RMAN, Data Guard, Streams, RHEL 4.x, 5.x, shell scripting, Oracle 9i, 10G, and 11G OEM Grid control.

Client: Confidential, Lansing, MI

Role: Oracle DBA

Responsibilities:

  • Involved in 24/7 Production Support of Databases.
  • Installation/creation and maintenance of 9i and 10g databases for Testing, Development and Production.
  • Installed and Configured 10g RAC with ASM disks on Linux (Red Hat Enterprise Linux) servers
  • Converted Single instances to RAC
  • Performed 10G RAC switchover and failover configuration, implementation, and testing
  • Monitored the Grid Control components such as OMS and OMR
  • Performed Database and SQL tuning of Multi Terabyte size databases spread at various sites by using various Tools like STATSPACK, AWR, TKPROF, EXPLAIN PLAN, ADDM, ASH and Optimizer Hints
  • Troubleshooted various RAC Performance Tuning Issues
  • Performed RAC Backup/Recovery of Oracle databases using backup tool Upstream
  • Developed and monitored tools such as OEM and Oracle Enterprise Manager 10g Grid Console to administer production, test and development databases.
  • Migrated Databases.
  • Monitored RAC Backup & Recovery
  • Configured Database level Streams Replication and One way schema level Streams Replication
  • Setup Schema level Down Stream Capture
  • Automated the backup jobs using RMAN for all production databases.
  • Used RMAN Duplication to migrate the database to ASM
  • Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
  • Upgrade of Database from 9i to 10g and applying patches whenever required.
  • Simplified data distribution between Data warehouse and Data Mart using Transportable tablepaces
  • Data refresh from production to test and development using RMAN cloning or exp/imp utility.
  • Implemented Oracle Streams 9i (replication) server. Scheduled exporting of entire database to off-site repository
  • Used Materialized Views to replicate data to remote databases
  • Extensively used dynamic performance views (v$ views or internal views) for various performance issues.
  • Scheduling Jobs through Crontab on RHEL.
  • Scheduling jobs through Oracle job Scheduler.
  • SQL Tunings for Performance of Objects
  • Participated in developing backend Oracle batch processes, developed PL/SQL packages and procedures.
  • Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
  • Automation of Startup Shutdown on all Production and Development Database.
  • Scheduled conference calls with Offshore team for status reporting.

Environment : Oracle 9.0.1, 9.2.0.3, 10.2.0.4, RAC, RHEL, Windows 2003, Enterprise Manager, Data Pump, RMAN, Data Guard, Streams, SQL, PL/SQL, shell scripting.

Client: Confidential, Denver, CO

Role: Oracle DBA

  • Upgrade of 9i database to 10g release 2.
  • Deployed Management Agents on various hosts
  • Configured Oracle Streams for replication between two databases
  • Cloning the instances for testing, development and integration testing.
  • Responsible for optimizing the queries and application tuning.
  • High-Availability Setup using 10g Data guard.
  • Developed Complex Resource Plans for Optimum utilization of Resources
  • Performed Database Migration from one platform to another using Transportable Tablespaces
  • Used RMAN and Oracle Secure Backup to back up and restore the database
  • Configured fast refresh for Materialized Views
  • Used various internal views for monitoring the database.
  • Developed RMAN scripts for database backup and recovery.
  • Designed and implemented the database servers for two new data centers
  • Supervised, coordinated and controlled a team of junior DBAs performing developer support and end-user support
  • Configuration of Oracle OEM (Oracle Enterprise Manager) to monitor database and report on events as defined by the DBA group.
  • Generated scripts for daily maintenance activity like analyzing the tables/indexes, monitoring their growth rate, monitoring the effective use of SGA etc
  • Perform production system problem analysis and recommend corrective measures in a timely manner.
  • Managed security in a complex and sensitive environments.

Environment : Oracle 9i/10g, streams, data guard, RMAN, HP-UX, Red hat Linux, shell scripting.

Hire Now