We provide IT Staff Augmentation Services!

Oracle Database Administration Resume

Memphis, TN

PROFESSIONAL SUMMARY:

Over 8 years of IT experience as Senior Oracle Database Administration (Oracle 11g RAC, 10g RAC, 9i,8i) on a variety of UNIX (Solaris, HP-UX, AIX), LINUX, Windows NT 4.0/2000/2003

  • Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 7.3.4,8 to 8i, 8i to 9i and 9i to 10g, 9i to 11g, 10g to 11g applied oracle patches.
  • Installation, maintenance and tuning of Oracle 10gRAC, Oracle 11gRAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM.
  • Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
  • 24*7 production database support with Support to developers & end-users.
  • Have implemented ORACLE STREAMS, 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.
  • Logical and physical modeling using Erwin.
  • Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database (Data Guard).
  • Implemented automated backup strategy using the UNIX shell script CRON UTILITY
  • Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)
  • Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, SQL Trace, TKPROF, EXPLAIN PLAN, AWR, ADDM 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
  • Installation and Configuration of Oracle Grid Control.
  • Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
  • Extensive experience with designing and implementing Oracle databases, data warehouse design, implementation and tuning.
  • Capacity planning and bench marking
  • Data loading using SQL*LOADER, External Tables, Logical backups using DATAPUMP.
  • Database replication using snapshots, materialized views and advanced replication methods.
  • Worked on different types of storage structures (SAN/NAS).
  • Good co-ordination and communication with system administrators, business data analysts and development teams.
  • Proven ability to work effectively in a team environment and capable of learning new technology and adapt to a new environment quickly.
  • Strong analytical, problem solving & Communication Skills

EDUCATION

  • Master's in Computer science
  • B. Tech (IT)

TECHNICAL ENVIRONMENT:

OPERATING SYSTEMS:

HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, IBM AIX 5.1, 5.2,5.3, Red Hat Linux RHEL 3.x, 4.x, 5.x and Windows 95/98/NT/2000/XP.

RDBMS:

Oracle 11g RAC/10g RAC/9i/8.x/7.x, SQLServer2005

LANGUAGES:

SQL, PL/SQL, Java, C, XML, UNIX Shell Scripting.

SOFTWARE APPLICATIONS/ TOOLS:

Recovery Manager (RMAN), Real Applications Cluster (RAC), STATSPACK, AWR, ADDM, ERWIN, Teradata, Clusters, Veritas Backup, Developer 2000, SQL*Loader, exp/imp, Datapump, TOAD, Oracle Enterprise Manager/Grid Control, Goldengate

WEB TOOLS

HTML, XML

PROFESSIONAL EXPERIENCE:

Title

Sr. ORACLE DBA

Client

Confidential

Work Location

Memphis, TN

Duration

Feb 2010 - Till Date

Environment

Linux and Solaries, Oracle 11g and 10g, TOAD 9.7.2, RMAN, SQL*Plus, PL/SQL, SQL*Loader, DBArtisian 8.7, MS Visio 2010.

Project Scope (DART):-
Confidential, provides the capability for testing team to validate Automation Clients, backend systems and Revenue Systems independently.This project creates the ability to certify large dependent systems without having to execute from beginning to end, i.e. certify shipping solutions without running full revenue job stream. This will mitigate limitations for key initiatives by providing capabilities for incremental testing of interfaces, reducing overall maintenance and support requirements for our test environments and processes

Responsibilities:

  • 24x7 production database and applications support
  • Installation and configuration of multi node Oracle 11g RAC, 10g RAC, Standby databases (Dataguard) for high availability and disaster recovery purpose.
  • Re design the existing database based on Business rules to overcome the existing issues in the Application and drawn Visio Diagrams to give high level presentation to Manger.
  • Configured server/client side load balancing.
  • Added node for the existing two nodes RAC and also configured the services.
  • Involved in designing and creating database objects.
  • Created Partitions on large tables for easier manageability.
  • Performed day to day activities such as managing user privileges, tablespaces, file system, undo segments, temp segments and indexing.
  • Migrated single instance database to multiple instance database (RAC) Performed cross-platform migration (AIX to LINUX) using Transportable Tablespace (TTS).
  • Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges And user logins
  • Installing and configuring Recovery Manager (RMAN).
  • Extensive UNIX Shell scripting.
  • 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 csh, 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.
  • Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM to improve the performance.
  • Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck.Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments.
  • Assisting customer setup, tune and maintain Oracle database.
  • Deciding the naming conventions of data file, redo log files, table spaces, and segments.
  • Writing scripts for monitoring, problem detection, backup and recovery, Import and export procedure.

Title

Sr. ORACLE DBA

Client

Confidential

Work Location

Reston, VA

Duration

April 2009 - Jan 2010

Environment

Windows NT/ 2000, AIX and Linux, Oracle 9i and 10g, TOAD Space Manager with LiveReorg, Erwin 7.2, Citrix, Oracle Enterprise Manager, RMAN, SQL*Plus, PL/SQL, SQL*Loader, Oracle Streams, RAC

Project Scope: Confidential, is the world's leading designer, manufacturer and distributor of prescription frames and sunglasses in the premium and luxury segments. In addition to an extensive global network, the Group manages leading retail brands such as Lens Crafters and Pearle Vision in North America, OPSM and Laubman & Pank in Asia-Pacific and Sunglass Hut globally. The goal was to implement the Streams Replication for store data and provide the failover through Datagaurd for the target Database.Configured Grid control to monitor the Streams. And provide the on call support to Streams related issues.

Responsibilities:

  • 24x7 production database and applications support
  • Installation and configuration of multi node Oracle 11g RAC, 10g RAC, Standby databases (Dataguard) for high availability and disaster recovery purpose.
  • Responsible for administration and supporting Oracle 11g RAC, 10g RAC, 9i databases.
  • Translated Business requirements to Data mart design.
  • Used start schema for approaching for designing of Data warehouse design
  • Performed upgrades from Oracle 9.2.0.8 to 10.2.0.3 on Linux and AIX Boxes.
  • Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) HP Unix
  • Installation, Upgradation of the databases.
  • Designed Star datamartfor their clients using Visio and translated business requirements into it and implemented logical design physically into Oracle Database
  • Installed Oracle Grid Control
  • Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges And user logins
  • Configuration, maintenance and tuning of Oracle11g RAC and 10gRAC.
  • Configured Failover Database using Datagaurd.
  • Installing and configuring Recovery Manager (RMAN).
  • Extensive Performance Tuning, Memory (SGA) Tuning
  • Cloning databases using manual method as well as RMAN.
  • Extensive UNIX Shell scripting.
  • Data Modeling, Database Design and Creation.
  • Downsizing and defragmenting the Very Large Databases, cloning those using RMAN duplicate features and then upgrading.
  • Writing Shell scripts for Alerts for ORA error backup and recovery, Import and export procedure.
  • UNIX shell scripting in csh, ksh to be controlled from Crontab.
  • Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
  • Extensive Performance Tuning, Memory (SGA) Tuning, etc.
  • Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM to improve the performance.
  • Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck.Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments.
  • Create database maintenance plans, including updating statistics, re indexing, structure modifications, Capacity plans, and index analysis.
  • Used Oracle Internet Directory to leverage the scalability, high availability and security features of the Oracle Database.
  • Taking Hot and Cold Backups, Exports etc.
  • Security User Management, Privileges, Roles, Auditing, Profiling, Authentication. Used Oracle Advanced Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
  • Data Modeling, Database Design and Creation.
  • Deciding the naming conventions of data file, redo log files, table spaces, and segments.
  • Writing scripts for backup and recovery, Import and export procedure.
  • Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.
  • Applying patches both Server side and Client side.
  • Setting up new environments (Development, Production).

Title

Sr. ORACLE DBA

Client

Confidential

Work Location

Pikesville, MD

Duration

April 2008 - Mar 2009

Environment

Sun Solaris 8.0/9.0/10.0,HP-UX 11, Red Hat Linux, Windows 2000/2003, Oracle 9i/10/11g, Oracle Enterprise Manager, RMAN, ORACLE Warehouse Builder, Reports, 10G RAC, Streams, Data Guard, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2005, 2008, Toad V9.7 and SQL Navigator V6.1.

Project Scope: Multi Plan Implementation
Confidential, is the small Network of Providers and Facilities (Doctors and Hospitals) in US. They reprise the claims for the Insurance Companies for additional savings. Multiplan receives around 6000 claims every month and they need to be matched with the Provider Arrangements to reprise. Matching process can match about 50% of the claims; the other claims would be pushed into another application called as Manual Match when the matching finds more than one Potential Match or when there are no matches for the claim. Once the claim gets into Manual Match application, the users would go and match the claim with the appropriate provider from the potential matches for this claim.

Responsibilities:

  • 24x7 production database and applications support
  • Responsible for administration and supporting Oracle 9i, 10g and 11g databases.
  • Performed upgrades from Oracle 9.2.0.8 to 10.2.0.3 on Intel and HP boxes.
  • Installation, Upgrade and Configuration of Oracle (8i, 9i, 10g and 11g). Installed and created 10g databases and 10g OEM. Installed RAC on Oracle 11g and worked on ASM.
  • Involved in designing of disaster recovery using Data Guard, High Availability using RAC.
  • Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings
  • Configuration, maintenance and tuning of Oracle 10gRAC and 11gRAC.
  • Installing and configuring Recovery Manager (RMAN) and Flash Recovery.
  • Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
  • Cloning databases using scripts as well as RMAN.
  • Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases. Assisted a team of DBAs in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
  • Data Modeling, Database Design and Creation using ER-Win.
  • Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
  • Performed database tuning using Explain Plan, TOAD, and Enterprise Manager. Establish standby/cloned databases via Data Guard for Database Disaster Recovery. Created, procured, and maintained various database-related documents such as manuals and spreadsheets.
  • Oracle replication using streams.
  • Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
  • Writing Shell scripts for Alerts for ORA error backup and recovery, Import and export procedure.
  • UNIX shell scripting in csh, ksh to be controlled from Crontab.
  • Used Active Dataguard makes a read-only replication of a given database.
  • 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 based optimizer, SQL analyzer, top session, top SQL, Performance Manager, Statspack, TOAD. For SQL tuning using "Explain plan", "TKPROF", "SQL_TRACE", Optimizer modes, using Optimizer hints, Gathering statistics, Statspack.
  • Create database maintenance plans, including updating statistics, rebuilding indexes, structure modifications, Capacity plans, and index analysis.
  • Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
  • Used Oracle Internet Directory to leverage the scalability, high availability and security features of the Oracle Database. Taking Hot and Cold Backups, Exports and Applying patches both Server side and Client side.
  • Writing scripts for backup and recovery, Import and export procedure.

Title

Sr. ORACLE DBA

Client

Confidential

Work Location

Reston , VA

Duration

March 2007 - Mar 2008

Environment

Windows NT/2000, HP-UX, AIX and Linux, Oracle 9i and 10g, Toad Database Tools/Utilities, Enterprise Manager, Aqua Data Studio 3.7,Query Analyzer, Oracle Fail Safe

Project Scope: Confidential, is one of the world\'s leading wealth management, capital markets and advisory Companies. There were many development projects which were going on, as a result of ever growing demand of new databases in the organization, the development projects were more client based, which included all the client related information as well as investment data, other tasks also included supporting production databases.

Responsibilities:

  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Administration, optimization, and maintenance of the Data Warehouse and Data Marts databases.
  • Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
  • Worked on Automatic Storage Management (ASM) for managing data in SAN.
  • Configured Oracle data guard and Streams.
  • Oracle streams configuration and performance tuning.
  • Data Modeling, Database Design and Creation.
  • Design, review and maintenance of database structures.
  • Query optimization for reporting and ETL.
  • Performance assessment, SQL scripts, stored procedures, functions and transactions analysis
  • Oracle Grid Control Management Server Installation
  • Database backup and Database tuning for real time and batch systems
  • Assisting customer setup, tune and maintain Oracle database.
  • Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
  • Data extraction from various sources, transformation and loading into the target Oracle database using Informatica PowerMart.
  • Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same. Oracle replication ( advanced replication, materialized views etc )
  • Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements.
  • Implemented Backup-using RMAN (Recovery Manager) as a media management layer.
  • Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
  • Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
  • Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
  • Developed UNIX shell scripts to perform the above tasks efficiently.
  • Worked as a member of production DBA team in perfect coordination with seniors and team members.

Title

Sr. ORACLE DBA

Client

Confidential

Work Location

Mclean, VA

Duration

Sep 2005 - Jan 2007

Environment

Solaris 8.0/9.0/10.0, OAS 10g, Linux Red Hat, Windows 2000/2003 Oracle 8i (8.1.6/8.1.7), Oracle 9i/10gR1, Oracle Enterprise Manager, Oracle Partitioning, Oracle Replication, Hot Standby, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2000, Toad

Project Scope: The Third Party Engine is a batch processing application designed to facilitate the sales, service, termination, and refunds of "Cross-Sell" products added to the Cardholder's Credit Card account. It has several processes like the, sales and enrollments process, Cancellation and refund process, Claims and Deferrals Process, Account attribute change process and Preference Change Process.
Responsibilities:

  • Review of Database logical and Physical design.
  • Install, upgrade and maintain Oracle software products/versions for on Linux, Sun Solaris and HP-UX.
  • Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
  • Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
  • Administration, optimization, and maintenance of the Data Warehouse and Data Marts databases.
  • Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
  • Data Modeling, Database Design and Creation.
  • Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
  • Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
  • Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle
  • Corporation and installation of patches.
  • Write and modify UNIX shell scripts to manage Oracle environment.
  • Problem analysis involving interactions/dependencies between UNIX and Oracle.
  • Production support for Oracle running on UNIX.
  • On-Call 24x7 DBA support for production databases.
  • OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator (RAM),
  • Data Migration as part of enterprise data warehouse project.
  • Extensive Performance Tuning, Memory (SGA) Tuning, RAC tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
  • Cloning databases using scripts as well as RMAN. Installation, setup and configuration of DATA guard.
  • Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
  • Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Title

ORACLE DBA

Client

Confidential

Work Location

Dallas, TX

Duration

APR 2004 - Aug 2005

Environment

Oracle 10g/9i, HP-UX, AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TKPROF, Explain plan, STATSPACK, SQL*loader, Windows NT/2000

Responsibilities:

  • Performed day-to-day DBA jobs for managing Production/Development databases.
  • Logical and Physical Modeling using ERWIN Data Modeler.
  • Management of tablespaces for different users by granting quota on Default & Temporary tablespaces.
  • Estimated Storage capacity for database objects.
  • Monitored the growth of the database objects UNIX Shell scripting. Implemented for capacity planning.
  • Created UNIX shell scripts to automate batch jobs through Cron.
  • Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication using materialized views.
  • In-depth experience in Data Warehousing using Informatica and Oracle.
  • Utilized SQL*loader and data pump import to load data into tables.
  • Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
  • Database Administration and Planning including logical design, physical design, backup & recovery.
  • Took a logical backup of the entire database using import/export utility.
  • Created and implemented Oracle database backup and recovery strategies using RMAN.
  • Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
  • Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
  • Tuning test and production database by altering the parameters.
  • Export and Import of database objects to copy from one database to another database.
  • Investigating suspicious database activity using Auditing.

Title

ORACLE Developer

Client

Confidential

Work Location

India

Duration

Jan 2003 - Feb 2004

Environment

Windows 98/NT/2000, HP-UX, Oracle 8i/7,TOAD,Database Tools/Utilities

Project Scope: Project's included building; maintaining and testing databases, involved in the entire development life cycle right from development to production, other tasks included were supporting and tuning oracle applications.

Responsibilities:

  • Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT
  • Analyzed the structures using Analyze command.
  • Used Triggers for database activities, like delete, update triggers.
  • Involvement in all phases of the project life cycle
  • Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system
  • Assuring appropriate backup and recovery procedures to be in place to meet the Company's requirements.
  • Used SQL* Loader for data import from remote databases
  • Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code
  • Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Hire Now