We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

CA

SUMMARY

  • 8+ years of IT experience as an Oracle Database Administrator having hands on experience in Installation, Management, Administration, Backup and Recovery, Performance monitoring and Tuning of Oracle RDBMS.
  • Supported Oracle 9i/10g/11g & Oracle 10g RAC, 11g RAC databases in different environments like Sun Solaris, IBM AIX, HP-UX, Red Hat Linux, Oracle Enterprise Linux and Windows.
  • Designed and developed plans to achieve high availability, scalability, performance
  • Experience in cross platform migration using Golden Gate, Transportable tablespaces and Datapump.
  • Experienced in setting up standby databases, and hands on experience with 11g Data Guard new features like Active Data Guard and Snap shot standby.
  • Experienced in Setting up and administering both Oracle 10g RAC and 11g RAC clusterware and instances.
  • Experience in monitoring using OEM (Oracle Enterprise Manager) and Grid Control.
  • Hands on experience with logical backups, Hot/Cold backups, RMAN incremental backups. Recovery and cloning of databases using (RMAN) Recovery Manager.
  • Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.
  • Plugging the tablespaces between different platforms using Cross platform transportable tablespace Utility.
  • Collecting performance statistics using ASH, Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
  • Used TKPROF utility and Explain Plan for tuning SQL queries.
  • Extensive Experience in Oracle Architecture, Optimization, Memory Tuning, Performance Tuning and troubleshooting.
  • Memory tuning by using ASMM (Automatic shared Memory Management).
  • Experience in Rebuilding of Indexes for better performance
  • Experience in User Management, Tablespace management, maintenance of Oracle Database.
  • Experience in applying patches and upgrading databases.
  • Experience in Monitoring and Tuning system resources associated with the database performance
  • Expertise in maintenance, upgradation, administration, backup and recovery of Oracle Exadata systems.
  • Experience with SQL, PL/SQL Programming, UNIX Scripting.
  • Extracting, transforming and Loading (ETL) of data from source systems in the Data Warehouse.
  • Installation, Configuration and administration of GoldenGate
  • Replication using GoldenGate, Oracle Streams and Materialized views.
  • Worked on Data Modeling, Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
  • Expertise in loading data from flat files using external tables, SQL* Loader.
  • Experience in providing 24/7 production support for critical production databases.
  • Excellent analytical, problem solving, communication and interpersonal skills.
  • Analytical and Systematic thinking ability with a goal and solution oriented approach.
  • Strong Problem analysis and resolution skills.

Technical Skills

Operating Systems

HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.x,6.x,7.x, Red Hat Linux RHEL 4.x, 5.x,6.x and Windows NT/2000//XP.

RDBMS

Oracle 11g RAC/10g RAC/9i/8i, MySQL, MS SQL Server 2008

Languages

SQL, PL/SQL, XML ,UNIX Shell Scripting, C,C++

Tools

TOAD, SQL Tools, Informatica PowerCenter, Cognos 8

Oracle Tools

RAC, RMAN, ASM, OEM, SQL*Loader, exp/imp, DataPump(expdp/impdp), GoldenGate, Oracle Streams.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK,ASH, AWR, ADDM

Database Modeling

Erwin 4.0, Toad Data Modeler.

Other

VERITAS Netbackup, TSM

Education: Bachelors in Engineering.

Work Experience

Confidential,San Francisco, CA June 11 – Aug 12
Sr. Oracle DBA
RESPONSIBILITIES:

  • Involved in 24x7 on call production support.
  • Installed and configured Oracle 11g, 10g databases
  • Installed, configured and tested oracle 10g RAC and 11g RAC environment for High Availability.
  • Upgraded Databases from 10g to 11g and applying patches whenever required.
  • Implemented Standby Databases (Active Data guard) for faster Disaster Recovery and HA.
  • Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
  • Performed Hot, Cols Backups, RMAN incremental backups.
  • Migrated databases from Sun Solaris to IBM AIX, HP-UX to IBM AIX, Windows to Linux
  • Creating and Managing Tablespaces with different block-sizes to prevent row chaining and row migration.
  • Wrote UNIX Shell Scripts, SQL, PL/SQL, stored procedures, functions, packages and triggers.
  • Worked with Automatic Storage Management (ASM) Oracle utility which provides a simple storage management interface that is consistent across all server and storage platforms.
  • Clone/Refresh of Production databases to Testing and Development environments to test & simulate few technical challenges.
  • Performed data transfer between one database to other by using Oracle data pump which are expdp (Data Pump Export) and impdp (Data pump Import).
  • Installation, Configuration and administration of GoldenGate
  • Replication using GoldenGate and Materialized views.
  • Load balancing, Databases/Schema/Table Re-organization for faster performance using export/import & Move procedures.
  • Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace TKPROF, STATSPACK, ASH, AWR, ADDM
  • Used SQL*Loader (sqlldr) utility which is used for high data loads from any text file, to inserted into database.
  • Performed Capacity Planning and Bench Marking.
  • Partitioned tables for better performance and manageability.
  • Logical and Physical Database design.
  • Responsible for allocating system storage and develop plans for future storage, implementing policies and procedures to ensure the integrity, security, availability, and accessibility databases like capacity planning.
  • Analyzing Alert Log, User trace files, SQL statements, reorganize database objects and design indexes to improve response of queries and to diagnosing the problem.

ENVIRONMENT: Oracle 11g RAC/10g/9i RAC, HP-UX, IBM AIX, Sun Solaris, RedHat Linux, SQL, PL/SQL, SQL Developer, GoldenGate, ERWIN, DataPump, OEM/Grid Control, RMAN, ASM, TOAD
Confidential,Schaumburg, IL Feb 09 – June 11
Oracle DBA
RESPONSIBILITIES:

  • Involved in 24x7 on call production support.
  • Installed and configured Oracle 10g and 11g Databases for Production, Development and Testing.
  • Installed, configured and tested oracle 10g RAC and 11g RAC Databases.
  • Expertise in handling various security aspects of the database including VPD (virtual private Database).
  • Implemented Migration of Databases from 10g to 11g and applying patches whenever required.
  • Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
  • Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
  • Creating and Managing Tablespaces with different block-sizes to prevent row chaining and row migration.
  • Wrote UNIX Shell, SQL, PL/SQL, stored procedures, packages, functions and triggers
  • Worked with Automatic Storage Management (ASM) Oracle utility which provides a simple storage management interface that is consistent across all server and storage platforms.
  • Clone/Refresh of Production databases to Testing and Development environments to test & simulate few technical challenges.
  • Implemented Oracle Streams which enable the propagation of data from one database to another
  • High speed data transfer between one database to other by using two utilities of oracle data pump which are expdp (Data Pump Export) and impdp (Data pump Import).
  • Load balancing, Databases/Schema/Table Re-organization for faster performance using export/import & Move procedures.
  • Monitoring databases using OEM Grid Control.
  • Performance monitoring tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace ,TKPROF, STATSPACK, AWR, ASH, ADDM
  • Used SQL*Loader (sqlldr) utility which is used for high data loads from any text file, to inserted into database.
  • Scheduled Jobs through Job Scheduler
  • Performed data modeling using Erwin data modeler.
  • Responsible for allocating system storage and develop plans for future storage, implementing policies and procedures to ensure the integrity, security, availability, and accessibility databases like capacity planning.
  • Analyzing Alert Log, User trace files, SQL statements, reorganize database objects and design indexes to improve response of queries and to diagnosing the problem.

ENVIRONMENT: Oracle 11g RAC/10g RAC/9i, HP-UX, Sun Solaris, RedHat Linux, Oracle Enterprise Linux, SQL, PL/SQL, SQL Developer, GoldenGate, Oracle Streams, ERWIN, DataPump, OEM/Grid Control, RMAN, ASM, TOAD
Confidential,Irving, TX Dec 07 – Jan 09
Oracle DBA
RESPONSIBILITIES:

  • Involved in 24x7 on call production support.
  • Installation and configuration of Oracle 10g RAC for High Availability
  • Installed and created Oracle 10g databases in development, Production and QA environment including configuration, backup & performance tuning.
  • Implemented Oracle RAC (Real Application Cluster) with four nodes for Scalability and high availability.
  • Loading data into a normalizedOracledatabase using SQL*Loader and External tables.
  • Coding and preparation of Test plans.
  • Upgraded databases from 8i, 9i to 10g, 10g to 11g and applied patches.
  • Extensively worked on deployment/migration process, data flow control between production, development and reporting.
  • Created and monitored the Standby database Configuration for the Disaster recovery scenarios.
  • Worked with Oracle Data Pump (expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
  • Implemented Replication using Oracle streams
  • Design and implemented backup strategies, like, incremental, complete and cumulative Backup of the database using Recovery manager (RMAN). Used utilities like Export/Import and Data Pump. Performed Hot/Cold Backups.
  • Design and developed scripts to monitor instance locks, long running queries, free space, and extent growth.
  • REFRESH/CLONING of Database using RMAN Duplicate for development, testing.
  • Analyzing Alert Log and User Trace Files and diagnosing the problem.
  • Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
  • Performance monitoring tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace,TKPROF, STATSPACK, AWR, ASH, ADDM
  • Performance tuning which includes creating indexes, analyze tables and optimizer hints.

ENVIRONMENT: Oracle 11g/10g RAC/9i/8i, IBM AIX, Sun Solaris, RedHat Linux, Oracle Enterprise Linux, SQL, PL/SQL, SQL Developer, Oracle Streams, ERWIN, DataPump, OEM/Grid Control, RMAN, ASM, TOAD

Confidential,Parsippany, NJ Jun 06 - Nov 07

Oracle DBA
RESPONSIBILITIES:

  • Installed and created Oracle 9i and 10g databases for Production, Testing, and Development.
  • CLONING /REFRESH of Database for development, testing using RMAN, Export/Import, and Data pump.
  • Created and Managed Physical Stand by database for failover and switch over operations.
  • Conducting sizing & capacity planning for Oracle databases.
  • Responsible for setting and managing user accounts, granting privileges to users.
  • Designing the security policies and database access strategies, Logical and Physical database structure.
  • Logical and physical modeling using Erwin Tool.
  • Implemented backup and recovery strategies, taking Backups on scheduled time and monitoring those.
  • Establish and Document Backup and Recovery strategies and procedures after evaluating various options includingRMAN (Recovery Manager).
  • Partitioning Strategies for very large tables. Implemented Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
  • Wrote monitoring/health check scripts, to send alerts like, database uptime/downtime status, sizing issues.
  • Data refresh from production to test and development, maintain Database Security.
  • Performed block recovery using RMAN. Performed backup validations using RMAN.
  • Identifying the expensive SQL statements and assist the developers during modification.
  • Wrote Stored Procedures according to specs and control files for input to SQL*Loader for loading data from external files into the Oracle database.
  • Management of schemas, objects partitioning the tables & indexes.
  • Automation of data load using shell scripting with SQL*Loader.
  • Performance monitoring tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace,TKPROF, STATSPACK, AWR, ASH, ADDM

ENVIRONMENT: Oracle 10g RAC/9i/8i, HP-UX, IBM AIX, RedHat Linux, SQL, PL/SQL, SQL Developer, ERWIN, DataPump, OEM/Grid Control, RMAN, ASM, TOAD
Confidential,Hyderabad, India Oct 04 – May 06

Oracle DBA
ENVIRONMENT: Oracle 8i, SQL, PL/SQL, RHEL, Windows 2000 Server.
RESPONSIBILITIES:

  • Taking Cold and Hot Backups Backups on scheduled time and Monitoring Scheduled Backups.
  • Creating and dropping of users, granting and revoking permissions as and when required.
  • Involved in the Design (Logical & Physical) of Databases.
  • Involved in the installation of Oracle 10g, 9i Databases.
  • Handling day-to-day activities and monitoring performance.
  • Creating Databases and database objects, Tablespaces.
  • Monitoring Tablespaces, Indexes, extents & performance tuning.
  • Constantly monitor the Alert log files & Trace files.
  • Perform database and SQL tuning using in-house scripts and database tools
  • Enrolling the users and providing required privileges, and maintaining the system security.
  • Ensuring proper Online and Offline backup, Periodical reading and checking of backups taken.
  • Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.

ENVIRONMENT: Oracle 10g /9i/8i, IBM AIX, RedHat Linux, SQL, PL/SQL, SQL Developer, ERWIN, DataPump, OEM/Grid Control, RMAN, ASM, TOAD
Confidential,India Apr 04 – Sep 04

Junior Oracle DBA/Developer
RESPONSIBILITIES:

  • Responsible for creating tables, views, synonyms.
  • Writing PL/SQL Programs Functions, Procedures, Packages and Triggers
  • Written Shell scripts for backups and monitoring
  • Creating Roles and Users and granting required privileges.
  • Created Indexes wherever required to improve the performance.
  • Implemented Security management through grants and triggers. User account creation, group creation and setting up of privileges and accesses.
  • Tuning the databases for optimal performance.
  • Creating and modifying Stored Procedures and Database Triggers
  • Design, developed, test, debug, PL/SQL Package, Procedures.
  • Implement scripts to automate Oracle backups utilizing different approaches such as hot and cold backups and export and import utilities.

ENVIRONMENT: Oracle 10g /9i/8i, Sun Solaris, RedHat Linux, SQL, PL/SQL

Hire Now