PROFESSIONAL SUMMARY:

• 7 Years of experience as an Oracle DBA, working with 24X7 production and development databases of versions 11g/10g/9i/8i on various platforms including SOLARIS, HP - UX, AIX, UNIX/LINUX and Windows.
• Proficient with Oracle 10g RAC, Standby Database, Data Guard, Replication, Oracle 10g Grid control and Oracle Enterprise Manager.
• Experience in OLTP/DSS database systems and managing large Oracle databases (VLDB).
• Experience in Data Migrations, Benchmarking
• Experience in upgrading oracle database from 10g to 11g.
• Extensive experience with database performance and tuning techniques to enhance database optimization plans.
• Prepared the installation documents and operational procedures documents for RAC and Logical standby databases.
• Experienced in Database Cloning, Upgrades/Migration, and Patching of Oracle Databases.
• Proficient with Performance Tuning using EXPLAIN PLAN, AWR, TKPROF, and STATSPACK.
• Extensive experience with RMAN Backups, Hot Backups and Logical Backups.
• Experienced in using 10g features like Data pump, Flash-Back Recovery, Streams, and ASM, ADDM, SQL Tuning Advisor, Flashback and SQL Profiling.
• Hands on experience using the Oracle Enterprise Manager (OEM) for database monitoring and maintenance.
• Experience in working with ETL tool like ODI (Oracle Data Integrator) and other data ware housing transactions.
• Knowledgeable on database recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Experience in using STATSPACK and kintana used from change track management, migration tracking system.
• Expertise in maintaining Database Security using auditing.
• Worked closely with the architect, supported in the data modeling and various other SDLC activities.
• Proficient in UNIX shell scripting, PL/SQL, DBMS * and UTL * packages, VPD.
• Experienced in Disaster Recovery setup.
• Experienced in UNIX shell scripting and CRON jobs.
• Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors and Packages.
• SQL Query optimization expertise, including data integrity analysis for application customization testing, and creating analytical metrics.
• Ability to perfectly plan and execute the given job to perfection.
• Result oriented, self-motivated, Team player, with ability to work independently accepting new challenges.

TECHNICAL SKILLS:

HP: UX, Sun Solaris 2.6/8/9/10,Unix/ Red Hat Linux and IBM AIX 4.x, 5L, Windows NT/00/03.

RDBMS: Oracle 8i, 9i, 10g, 11g, 9i RAC and 10g RAC

Database Servers: HP 700 Series, HP Superdome, Sun 3500, 3800, 6800, Sun Enterprise 450, Oracle Application Server 10g, Sun Fire V1280, Dell PowerEdge T100, Sun fire 4800

Languages: SQL, PL/SQL, Java, C, C++, UNIX Shell Scripting

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Shareplex, STAT, KINTANA

Tuning tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQL*TRACE, AWR, ADDM

Others: EMC, NetApp, VERITAS Netback up, SQL BackTrack

WORK EXPERIENCE:

Confidential

Data Base Administrator

Responsibilities:

• Performed Database Administration activities like space management in database, user and roles administration, schema management, checking alert log of the databases.
• Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Configured, created and Managed Oracle Data Guard in a real Applications Clusters (RAC) Environment
• Installation, Configuration and Administration of Oracle 10g RAC.
• Performed Database clone.
• Converted a single instance database to Oracle RAC 10g.
• Created users in OEM and assigned privileges to the users
• Management of schemas, objects partitioning the tables & indexes.
• Created DB links between Oracle servers.
• Documented procedures for standby setup, alert log monitoring, tablespace alerts, and archive log directory usage.
• Documented procedures for standby setup, alert log monitoring, tablespace alerts, and archive log directory usage.
• Changed table column datatypes.
• Intensively used latest 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Created and managed indexes, index organized tables, and clustered tables to improve query performance.
• Involved in database administration including 10g RAC Database cloning, tuning, patching and monitoring concurrent manager processing etc

Confidential

Data Base Administrator

Responsibilities:

• Responsible for testing the behavior of 11gR2 RAC database using Veritas cluster file system.
• Scheduling daily hot backups and weekly cold backups.
• Building Clone instances for Development and Test teams.
• Set and document standards for use of databases to use Data guard in Maximum availability mode
• Using TKPROF, AWR, ADDM, STATSPACK, and EXPLAINPLAN for monitoring database performance.
• Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN
• Restoration and recovery from backup.
• Involved in both Logical and Physical design of Databases
• Worked with various Oracle Streams, 10g Grid Control and Automatic Storage Management (ASM).
• Used Data Pump Import/Export to move large amounts of data and performed database cloning whenever necessary.
• Performed patching using opatch utility.
• Wrote scripts for analyzing the tables and rebuilding the indexes
• Created DB links between Oracle servers.
• Participated in cloning, creating and maintaining schemas, and performance tuning and monitoring.
• Reorganizing IOT tables.
• Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose.
• Database sizing & tuning.
• Installation of Oracle Enterprise Manager Grid Control

Confidential

Data Base Administrator

Responsibilities:

• Installation and maintenance of Oracle 11g database
• GRID (10.2.0.5.0 ) installation and configuration for monitoring and performance tuning.
• Installed and Upgraded SQL BACKTRACK (backup utility) to backup online and archive logs into TSM or AVAMAR.
• Using Data pump in importing and exporting the data between the databases.
• Performed database migration from windows to AIX.
• Performed patching using opatch utility.
• Installation and deinstall of ORACLE WORKSPACE MANAGER
• Oracle Database and Oracle Applications cloning/refresh.
• Involved in the administration of various activities like creation of schemas,
• Involved in the implementation of High Availability solutions with Oracle 10g RAC.
• Performed cross platform migration using export import from windows to AIX.
• Storage and space management including table spaces and data files.
• Assisted users by installing oracle clients and in connectivity issues.
• Writing UNIX shell scripts for backup and recovery.
• Scheduled jobs through Oracle job Scheduler, cron jobs.
• Experience in UNIX Shell scripting in csh, ksh.
• Monitored and managed redo log, archive log, and control file multiplexed destinations.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Tuned the databases for better performance using Explain plan, Statspack and AWR monitoring for Database fragmentation and correcting them
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Implemented DATA GUARD (Standby) for high availability/disaster recovery purpose.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Confidential, NY

Data Base Administrator

Responsibilities:

• Successfully Upgraded database from Oracle 10g to 11g.
• Involved in administration of over 50 Oracle 11g/10g instances.
• Involved in the process of tuning and refining queries of various applications.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Implementing 10g Data guard with one physical database
• Converted a single instance database to Oracle RAC 10g.
• Expertise in data warehousing design and ETL.
• Monitored database events as part of a Level 1 support staff.
• Configured the Public Network/Private Interconnect for Oracle 10g RAC.
• Cloning databases using scripts as well as RMAN.
• Knowledge of Erwin for data modelling and Dimensional Data Modelling
• Moving data from development to production through transportable tablespace exports.
• Monitoring the table growth, database growth, current users, and system resource usage.
• Installation, Configuration and Administration of Oracle 10g RAC.
• Implementing standby database and database replication to provide high availability of database.
• Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.
• Experience in SQL*Loader, loading data from text files.
• Involved in team management, team building exercises for the DBA team.
• SQL issues and Tuning Considerations for Different Applications.
• Creating and refreshing materialized views, views, synonyms, and indexes.

Confidential

Oracle Database Administrator

Responsibilities:

• 24x7 Production Database Administration and support.
• The work involves overall maintenance of ORACLE database, performance tuning, backup, recoveries and other database related activities.
• Upgraded the oracle Database from 9i to 10g.
• Implemented DATA GUARD to provide high availability of the database.
• Installing version upgrades and patches.
• Performing database export & imports for porting tables across databases.
• Day to day performance monitoring and tuning of database.
• Performed DATABASE MIGRATION from Oracle to SQL Server.
• Developed UNIX Shell scripts and SQL queries.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session
• Using the Oracle 10g Grid for monitoring of databases.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK
• Performing transportable tablespace exports.
• Performing backup validations using RMAN using TSM and NetBackup.
• Preparing Backup and Recovery plan.
• Automation of data load and data parsing using PL/SQL procedures, ksh scripting and SQL*loader.
• Usage of Partitions to improve the query performance and manageability.
• Implementing range, list partitions, hash sub partitions and Indexing strategies.
• Involved in Performance Tuning of Informatica ETL mappings and database.
• Monitoring and Troubleshooting of Database Replication issues using Shareplex Tool.
• Scheduled jobs using Oracle Job Scheduler.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Involved in upgrading the development and production databases to Oracle 10g.
• Performed database cloning for various environments.

Confidential

Oracle Database Administrator

Responsibilities:

• Database administration of the Oracle database System.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Performing all the Database Administration activities like space management in database, user and roles administration, schema management, checking alert log of all the databases for errors and resolving them.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Involved in the process of tuning and refining queries of various applications.
• Performed patching using opatch utility.
• Performed application tuning and query optimization
• Actively involved in Shell Scripting for various CRON jobs to be run for monitoring the database health, checking for events such as running out of disk space and extents.
• Involved in the process of exploring new areas of Oracle and its products.
• Installed Oracle 9i Database software in Linux, created database according to the requirement of Application Software, monitored and configured databases.
• Wrote Scripts for startup/shutdown of the database, cold backups, health check of databases, to check oracle errors in alert log file and send mails.
• Wrote scripts for analyzing the tables and rebuilding the indexes.
• Daily database backup, tablespace administration, SQL net configuration and basic database tuning as part of maintenance activities.
• Created DB links between Oracle servers.
• OEM installation and configuration for monitoring and performance tuning.
• Maintenance of existing system and provided advanced level support.
• Involved in System study, Analysis, Design and Development.
• Developed back-end Stored Procedures, triggers, functions.
• Worked on import/export and SQL loader.

Confidential

 Jr. Oracle Database Administrator / Developer

Responsibilities:

• Managed in-house Oracle Databases running on various operating systems like Windows NT and Linux.
• Installation of Oracle Database and Oracle products.
• Implementing Backup/Recovery Strategies.
• Using Enterprise Backup utilities for backup.
• Writing scripts for backup and recovery.
• System tuning for better performance.
• Creating stored procedures, packages and database triggers.
• Creating users and maintaining database security.
• Worked with application developers to debug PL/SQL procedures, tuning queries and database sizing.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Supervised the installation and configuration of Oracle databases on Linux and Windows NT.
• Supported the implementation of a web based human resources/ Payroll and asset management system for the bank.
• Writing SQL scripts to monitor database performance.
• Writing SQL Loader control files for data loading to the payroll system.
• Creating PL/SQL packages, procedures and database triggers.
• Database installation and instance creation.
• Creating database triggers, Procedures and packages for the payroll system.