We provide IT Staff Augmentation Services!

Oracle Dba Resume

3.00 Rating

Davis, CA

SUMMARY

  • Nine years of IT experience which includes Seven plus years of experience in Oracle database (8i/9i/10g,11g) administration, backup and recovery, performance tuning, performance monitoring, schema maintenance on a various environment like Sun Solaris, HP - UX, AIX, LINUX, Windows 2003, Windows Bit.
  • Good understanding of Oracle Architecture.
  • Installation and Configuration of Oracle 9i, 10g and 11g Real Application Clusters (RAC) with multiple nodes.
  • Experience working with Golden gate for replicating the database.
  • Installing Oracle 10g RAC using ASM as a file system.
  • Extensive working on Oracle 10g on Solaris Zone for virtualization.
  • Experience in taking logical backups of data using oracle data pump utilities like exp, imp, expdp and impdp, to move Oracle data from one server to another server.
  • Experience setting up Backup strategy for Oracle DB using RMAN.
  • Experience in RMAN tape backups using net backup and data protector.
  • Install & Managed Physical Standby databases & Data Guard for disaster recovery.
  • Logical and Physical Data modeling using Erwin Data Modeler.
  • Oracle Streams configuration and performance tuning using Oracle 10g.
  • Migration of databases from Lower Version (8i) to Higher Version (9i, 10g and 11g).
  • Migration of SQL Server database to Oracle database
  • Experienced in Automatic workload repository (AWR) to collect memory statistics, automatic database diagnostic monitor (ADDM) to monitors and analyzes statistics and Active Session History (ASH) reports.
  • Involved in Performance tuning, database monitoring activities using STATSPACK with Perfstat User.
  • Monitoring of the queries with high response time and high disk reads per execution and tuning the same using Explain Plan, TKPROF, Auto trace of Multi Terabyte Database.
  • Applied DST Patches and Security Patches for production and development databases.
  • Experience in Tablespaces management both locally (LMT) and dictionary managed tablespaces (DMT).
  • Experience in writing scripts Proactive Monitoring like monitoring the disk usage and the memory usage of the server and monitoring Tablespaces.
  • Used various packages extensively like DBMS JOB, UTL FILE, DBMS STATS, and DBMS SQL, DBMS REORG, DBMS SCHEDULER.
  • Worked on PL/SQL for implementing Triggers, Procedures and cursors.
  • Extensively used tools like SQL*Loader, Toad, SQL developer, Oracle Enterprise Manager (OEM) using DBConsole.
  • Experience in creating Materialized Views specifically for Replication.
  • Experience in Extracting, Transforming and Loading (ETL) tool.
  • Writing ETL scripts for loading and unloading data for Dataware house environment.
  • Experience in working with Data Mart using SQL LOADER with direct or parallel option.
  • Worked both as a development and Production Support DBA and having experience in full life cycle of database administration.
  • Database Administrator (Oracle 8i/9i/10g) of the database size varying from Medium to Large (300 GB to 10 TB).
  • As a production DBA, troubleshooter and resolved several types of production issues during the off hours and over the weekends by 24x7.

TECHNICAL SKILLS

Database Skills: Oracle 8i/9i/10g,11g SQL, PL/SQL

Operating Systems: UNIX(Sun Solaris 8/9/10,Sparc - AIX4.3), Red Hat/Fedora Linux, HPUX-11.23,Tru64 Windows NT/ 2000/2003/2008

Applications Tool: SQL Navigator PL/SQL Developer 7.0, SQL *PLUS Oracle Enterprise Manager (OEM) Oracle Utilities (Import / Export, SQL*Loader, 10g Data Pump) Quest Toad 8.5, 11.0, PUTTY, Reflection, BMC, Oracle BI Publisher, Oracle BI Discoverer, WinRunner, Silk VERITAS Netback up 5.3/6.0, Netapp Filer Erwin 4.1, Rose 7.0, Hummingbird, Golden Gate Technology, Tivoli

Protocols: FTP, SSH, Telnet, TCP/IP,VNC Viewer

Languages: UNIX Shell Scripting, SQL, PL/SQL, C++, COBOL, PHP, Perl

PROFESSIONAL EXPERIENCE

Confidential, Davis, CA

Oracle DBA

Responsibilities:

  • Managed Physical Standby databases and Data Guard for disaster recovery.
  • Maintain database security and access permissions working with end users (technical and non-technical) in defining requirements
  • Involved in designing and creating database objects.
  • Up gradation from 10g to 11g database for using Oracle 11g new features.
  • Created Partitions on large tables for easier manageability.
  • Tested and implemented many backup and recovery scenarios on test environment (9i) using RMAN.
  • Configuration and installation of 11g RAC databases in dedicated server mode using ASM.
  • Performed day to day activities such as managing user privileges, tablespaces, file system, undo segments, temp segments and indexing.
  • Used Oracle GoldenGate to replicate between source and target Oracle databases
  • Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges And user logins
  • Installing and configuring Recovery Manager (RMAN).
  • UNIX Shell scripting in ksh.
  • Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing etc. kept in CRONJOB.
  • UNIX shell scripting in ksh to be controlled from Crontab.
  • Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
  • Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team.
  • Extensive familiarity with Tuning Tools like Oracle Enterprise Manager’s (OEM’s), Oracle cost optimizer, SQL analyzer, top session, top SQL, Performance Manager, etc., Statspack, TOAD.
  • Automatic workload repository (AWR) to collect memory statistics and automatic database diagnostic monitor (ADDM) to monitor and analyze statistics.
  • Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
  • Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
  • Cloning databases using scripts as well as RMAN.
  • Deciding the naming conventions of data file, redo log files, table spaces, and segments.
  • Writing scripts for backup and recovery, Import and export procedure. developing financial and business unit reports required in a manufacturing environment
  • Create and modify scripts used in daily batch jobs
  • Perform and test routine database backup and restore using HP-UX Ignite
  • MS Excel including Pivot Table development, complex formulas, and macros write and create reports from database queries against Oracle and MS SQL databases
  • Create and maintain relevant technical documentation

Environment: HP-UX, Windows 7, Visibility ERP, TOAD, OEM, Oracle 9i/10g/11g, PHP, RMAN, Data Guard, Goldengate, EXCEL 2007, 2010, IQPLUS, SQL 2008 Reports.

Confidential, San Francisco, CA

Oracle DBA

Responsibilities:

  • Configuration and installation 3 Node RAC on Oracle 10gR2 databases in dedicated server mode using ASM on Sun Solaris OS.
  • Configure Physical standby Dataguard using Oracle 10g for Disaster Recovery.
  • Working on Oracle 10g on Solaris zones.
  • Install and configure Oracle 10g Grid for the monitoring of RAC databases.
  • Tested and implemented many backup and crash recovery scenarios on test environment (9i/10g, 11g), using RMAN.
  • Configure Incremental and full Backup on Oracle 10 and 11g Databases.
  • Experience working in Oracle Application Server using oracle 10g (10.1.3.3) and oracle 11i.
  • Implementing High Availability using Oracle Fail Safe Software.
  • Duplicate and refresh Oracle DB from Production to QA and DEV boxes for testing purposes.
  • Extensively used export-import and Data Pump -- Expdp/ Impdp to take logical backup and Migrate databases at hardware level.
  • Hardware Migration from Sun Sparc to Sun Solaris x-86.
  • Migration of databases from Single Instance to Oracle 10g 3 Node RAC.
  • Identifying the poorly performing queries using Explain Plan, TKPROF, STATSPACK,AWR, ADDM, ASH reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace & SQL Tuning Advisor.
  • Sql tuning of Multi Terabyte Databases for improving the application performance.
  • Upgrade Oracle binaries in the development environment and production environment.
  • Participated in data modeling review for designing object relational database.
  • Experience implementing Streams on Oracle 10g server.
  • Implemented Oracle Downstream capture using Oracle 10g for capturing redo log at target Database.
  • Experience in working OLAP systems for data warehousing using Partitioning.
  • Experience working with different types of Partitioning methods.
  • Experience working with Extracting, Transforming and Loading (ETL) tool using the use of flat files with Sql Loader utility.
  • Experience in working with Data Mart using SQL LOADER with direct or parallel option.
  • Partitioning of big tables in Oracle Database to improve the Performance.
  • Write monitoring/health check scripts to database for alert team of database uptime/downtime status, sizing issues with help of grid controlling.
  • Design databases, Tables, Views, Indexes, Triggers, Stored Procedures, Functions and Packages using PL/SQL.
  • TAR/SR Management with Oracle when we had very critical issue with the oracle Database.
  • Extensive use of flat files with Sql Loader utility.

Environment: Sun Solaris 5.10, TOAD, OEM, Oracle 10g/11g.

Confidential, Foster City, CA

Oracle DBA

Responsibilities:

  • Configuration and installation of 10gR2 RAC databases using OCFS as a file system using Linux OS.
  • Configure Physical standby Dataguard in oracle 10g for high availability.
  • Tested and implemented many backup and crash recovery scenarios on test environment (9i/10g, 11g), using Netapp filer.
  • Responsible for scheduling full and incremental backups using Netapp filer.
  • Extensively used export-import and Data Pump -- Expdp/ Impdp to take logical backup.
  • Refresh the database using hot, cold backups and Transport Tablespaces.
  • Experience working with new feature of Oracle 10g called Database replay.
  • Using Database Replay from production system to test system for recreating the production workload environment.
  • Maintaining Oracle initializing parameters like (SGA, PGA, SGA MAX SIZE) for the Performance tuning of Database.
  • Sql tuning of Multi Terabyte Databases for improving the application performance.
  • Up gradation from 9i to 10g database for using Oracle 10g new features.
  • Used Oracle SQL Developer to migrate a SQL Server database to Oracle database
  • Logical and Physical Data modeling using Rational Rose Data Modeler.
  • Participated in data modeling review for designing object relational database.
  • Implemented Oracle Downstream capture using Oracle 10g for capturing redo log at target Database.
  • Experience in working OLAP systems for data warehousing using Partitioning.
  • Experience working with different types of Partitioning methods.
  • Experience working with Extracting, Transforming and Loading (ETL) tool.
  • Extensive use of OEM using DBConsole for monitoring purposes.
  • Write monitoring/health check scripts to database for alert team of database uptime/downtime status, sizing issues with help of grid controlling.
  • Worked on Oracle Enterprise Single Sign on using Oracle Application Server.
  • Extensive use of Data Links for accessing tables remotely from another schema.

Environment: Linux, Sun Solaris, Windows 2003, Net app filer, TOAD, OEM, Oracle 9i/10g, WINSCP, Rose 7.0.

Confidential, Brisbane, CA

Oracle DBA

Responsibilities:

  • Install & Managed Physical Standby databases & Data Guard for disaster recovery.
  • Configuration and installation of 10gR2 RAC databases in dedicated server mode using ASM.
  • Tested and implemented many backup and crash recovery scenarios on test environment (9i/10g, 11g), using RMAN tool.
  • Maintenance and troubleshooting of Oracle network files like listener, tnsnames.ora.
  • Responsible for scheduling full and incremental backups using export, RMAN.
  • Migration from lower Oracle Version to Higher Oracle Versions e.g. 9i to 10g and 11g database.
  • Upgraded Oracle binaries in the development environment and production environment from 10gR2 to 11G (11.1.0.7).
  • Logical and Physical Data modeling using Erwin data model.
  • Participated in data modeling review for designing object relational database.
  • Install Oracle Downstream Capture at high volume OLTP environment.
  • Identifying the poorly performing queries using Explain Plan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace & SQL Tuning Advisor
  • Performance tuning of SQL queries in oracle 9i, 10g and 11g environment for Multi Terabyte Databases.
  • Configured and implemented using 10g new feature BFT (Big File Tablespace) for storing large objects.
  • Creating and Managing stored procedures and triggers, distributed data, database replication, server tuning, automation of administrative tasks, database.
  • Experience in working high transacted OLAP systems for data warehousing.
  • Experience in working with Data warehouse environment using ETL solution, OLAP and data mining capabilities.
  • Experience in working with flat files using SQL LOADER with direct or parallel option.
  • Troubleshooting various Database Features like Mean time to recovery (MTTR), Flashback Query, LogMiner, Replication to keep database as available as possible.
  • Extensive use of Oracle BI Discoverer and BI Publisher for generating reports.
  • Using the DB Artesian /10g Grid, OEM for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc.

Environment: Oracle 9i/10g, 11i, Sun Solaris 5.8, TRU 64, HP-UX, SQL Navigator, Toad, RMAN, Net Backup, DB Artesian, ERWIN.

Confidential, Washington, DC

Oracle DBA

Responsibilities:

  • Managed Physical Standby databases and Data Guard (9i) for disaster recovery.
  • Successfully implemented Physical standby database using Oracle Data Guard feature for High availability configuration.
  • Experience working with third party tool Cluster Ware tool VERITAS for High Availability.
  • Implementing High Availability using Oracle Fail Safe Software.
  • Experience Upgradation of Oracle database from 9.2.0.5 to 10gR2.
  • Involved in upgrading application database from Oracle8i to Oracle9i/10g.
  • Performed logical backup using export and import utilities.
  • Design and implement database backup and recovery procedures (RMAN).
  • Designing the Oracle backup strategy, scheduling and implementing database backup.
  • Load data from flat files into Oracle using SQL*Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
  • Experience Working with Physical and logical Data modeling for developing application which is used for business purposes.
  • SQL query optimizing using CBO, overhead, bind variable, explain plan, TKPROF, Utlbstat/ Utlestat, Statspack and instance, latch contentions as per company’s requirement for high tuning.
  • Refreshing indexes and materialized views using data warehouse for consistency of data.
  • Worked on PL/SQL Errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT.
  • Experience in using packages like DBMS SECHDULER for scheduling tasks.
  • Working on an Indexing Strategy to create various types of Indexes rebuilding them and monitoring those indexes for better performance of SQL quires.
  • Created/Alter Partitioned tables for large customer related data.
  • Used DBMS STATS to gather the statistics along with analyze command.

Environment: Oracle 10g/9i, SQL Navigator, TRU 64, Toad 4.5, SQL*Loader, Windows 2003, Linux, Sun Solaris5.9

Confidential, Okemos, MI

Oracle Developer

Responsibilities:

  • Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures and Triggers
  • Developed Database triggers and PL/SQL Procedures.
  • Generated various reports using Crystal Reports
  • Created tables and indexes by analyzing and rebuilding of Indexes for better performance.
  • Developed the databases, Tables, Views, Indexes, Triggers, Stored Procedures, Functions and Packages using PL/SQL.
  • Experience in using Oracle supplied packages such as DBMS STATS, DBMS JOBS, DBMS SYSTEM and DBMS DDL.
  • Extensive use of Oracle BI Discoverer and BI Publisher for generating reports.
  • Worked on User-defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT etc.
  • Used PL-SQL features like Cursors, Ref Cursors, Exception handling records
  • Rewrote many ORACLE stored procedures, resulting in a performance increase.
  • Data Loading from Flat files using SQL*Loader.

Environment: Windows 2000, Oracle 8i (8.1.5.0 - 8.1.5.1 ), SQL, PL/SQL, PHP, TOAD 6.5, OEM, Developer 2000, SQL *Report, Form Builder6i, SQL*Loader, WinRunner

We'd love your feedback!