SUMMARY

• Around 9 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
• Extensive knowledge on database administration for Postgre SQL 9.4/9.3/8.4/8.3/8.2/8.1, with experience in very large scale database environment.
• Extensive knowledge on database administration for Oracle 9i,10g and 11g, with experience in very large scale database environment and mission critical large OLTP and OLAP system
• Involved with installation and maintenance of Oracle 10g RAC/Oracle 11g RAC and standby database for High Availabitlity and Disaster Recovery purpose.
• Experience in managing Oracle databases running on MS - Windows, NT Server, Unix/Linux, Sun Solaris, HP-UX, AIX and RHEL.
• Hands on experience in Oracle 10g/11g RAC implementation and administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).
• Good experience in RAC Clusterware administration, Configuration and Patching.
• Extensive experience in Dataguard configuration (Physical Standby /Logical Standby), implementing and maintaining standby databases.
• Hands on experience in Grid Control, Streams and Golden Gate replication.
• Expertise in Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Performs Golden Gate replication monitoring, tuning, and capacity planning.
• Configured Oracle Golden Gate and parameter files in an active-active architecture.
• Experience in setting up Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) for database monitoring/performance/diagnostics.
• Extensive experience in RMAN database backups ( Full/Incremental ) and in traditional hot/cold backups.
• Good experience in writing/editing UNIX Shell Scripts.
• Worked on applying quaterly patches (PSUs) and One Off patches.
• Experience in upgrading databases from 9i to 10g & 11g, 10g to 11g.
• Performed logical and physical modeling using Erwin.
• Experience in Database Refresh and in Database Cloning with RMAN and third party tools like Timefinder.
• Experience in Flashback technology ( Flashback database/table ).
• Worked extensively on Data loading using SQL*Loader, logical backups using conventional export/import and Data Pump.
• 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 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.
• Worked on Data Modeling, Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.

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, Netezaa

ORDBMS: Postgre SQL

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

Tools: TOAD, SQL Tools, Exadata,InformaticaPowerCenter, 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

PROFESSIONAL EXPERIENCE

Confidential, Chorlette, NC

Sr. DBA

Responsibilities:

• Installing, configuring and maintaining Postgre SQL 8.4/8.3 databases on Linux, UNIX and Windows Platforms.
• Installing, configuring, maintaining and troubleshooting Postgre SQL 8.4/8.3.
• Migration of databases across Heterogeneous platforms.
• Perform POC for testing DDL and DML replication across Databases.
• Installing, configuring Postgre SQL Datagaurd with Active/Active setup.
• Upgraded Databases from 8.4 to 9.3 and applying patches whenever required.
• Implemented Standby Databases (Active Data guard) for faster Disaster Recovery and HA.
• Experience inOracleGolde Gate installation, configuration, troubleshooting GG issues
• 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.
• Experience in User Management, Tablespace management, maintenance of Database.
• Experience in applying patches and upgrading databases.
• Investigate Replications failures using LogDump utility.
• Worked extensively with Netezza scripts to load the data from flatfiles to Netezza database.
• Worked with NetezzaSQL scripts, Netezza,LOAD commands to load the data to Netezza target Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Monitoring Smart Flash Cache Activity on Oracle Exadata.
• Configured various Oracle Exadata Database Machine
• Implemented DR Drill test from Primary to standby database.
• Setup GoldenGate Database User with necessary privileges
• Plan and Implement Data Replication between Heterogeneous Databases.
• Database creation of RAC databases in 4 Node cluster
• Performed Hot, Cold 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.
• Expertise in usingGolden Gateto support data replication in the Oracle database environment.
• Rebuilding Standby database using SRDF technology
• ASM Storage migrations with Disk rebalance activity.
• Troubleshooting metric collection errors in GRID CONTROL.
• Extensive experience in configuring and implementing Flashback Technology for databases in Postgre SQL 8.4
• Design and support complex DISTRIBUTED database architecture.
• Continuous Performance monitoring and tuning of the databases and application using OEM TuningPack,Diagnostics Pack, STATSPACK.

Environment: Postgre SQL 8.3/8.4/9.3, HP-UX, IBM AIX, Sun Solaris, RedHat Linux,Netezaa,Exadata,SQL, PL/SQL, SQL Developer, GoldenGate, ERWIN, DataPump, OEM/Grid Control, RMAN, ASM, TOAD.

Confidential, Chorltee, NC

Sr. Oracle DBA

Responsibilities:

• Planning, installation, configuration, management, troubleshooting and administering of 10g & 11g Oracle databases on Window OS
• 24x7 production testing and development support for several mission critical systems which utilize multiple Oracle databases.
• Performed CDC (Change Data Capture) along with data replication and MDM (Master Data Management) capabilities ofGoldenGate.
• Restored and recovered successfully production databases in Dataguard, RAC and ASM environment using RMAN. Converted successfully oracle databases from ASM to Non-ASM and Non-ASM to ASM database using RMAN.
• Expert in Advanced features in Oracle 11g in RMAN,RAC etc.
• Installation and configuration of GOLDENGATE CrossPlatforms.
• Tablespaces encrypted using Advance Security features.
• Set up & manage database security by creating new users, roles, profiles, and provide required user privileges using OEM and SQL PLUS
• Managed schema objects like tables, views, indexes using OEM and SQL PLUS
• Load and transfer data into the database by using data pump & SQL Loader utilities
• Applying ORACLE PSUpatches on both RAC and single machines.
• Upgrading the database from 10.2.0.4 to 11.2.0.2.
• Storage and space management including tablespaces and datafiles.
• Developed scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Experience in monitoring blocking sessions and killing them on the requirement basis.
• Experience with new features like Flash-Back Recovery like Flashback Transaction and Query.
• DBA activities including creation, management, startup and shutdown of Oracle databases, management of data files, redo log files, control files, table spaces, segments, extents and data blocks & physical storage, creation, monitoring.
• Golden Gate trouble shooting in production databases.
• Creation of DB console (OEM) for databases.
• Configuring databases and listeners in GRID CONTROL.
• Defined backup procedures using daily hot backups and weekly cold backups.
• Monitor and report on daily, weekly Backup and Recovery procedures for production, non-production databases using RMAN backups taking periodic complete, cumulative and differential incremental backups
• Use data pump utility to export and import data from the database
• Implemented database monitoring and tuning, application, and queries using ADDM, ASH, AWR, Explain Plan and OEM.
• Scheduling jobs in crontab by configuration in TSM, Networker.
• Performed database tuning using Explain Plan, Toad, and Enterprise Manager.
• Performed Database tuning using StatspackAWR and ADDM.
• Performed SQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor.

Environment: Oracle 9i/10g/11g, OEM,Sun Solaris, and TOAD, Data Guard, RAC, Networker TSM, HPOV.

Confidential, Stamford, CT

Sr. DBA

Responsibilities:

• Installed and configured Postgre SQL 8.1/8.2 Databases for Production, Development and Testing.
• Expertise in handling various security aspects of the database including VPD (virtual private Database).
• 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.
• Data modeling with extensive normalization activity.
• Managing of Tablespace for different users by granting quota on Tablespaces.
• Backup and Recovery set up through RMAN and Export / Import utility.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.
• User administration, define roles & profiles and partitioning tables.
• Replicated tables to different database locations by Snapshots on master tables at master site.
• Used parallel query options and SQL hints for partitioned tables.
• 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 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.
• Load balancing, Databases/Schema/TableRe-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.

Environment: Postgre SQL 8.1/8.2, 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, Columbus, OH

Sr.Oracle DBA

Responsibilities:

• Installed and created Oracle10g 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 OracleData 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 likeExport/Import and Data Pump. Performed Hot/Cold Backups.
• Design and developed scripts to monitor instance locks, long running queries, free space, extent growth.
• REFRESH/CLONING of Database using RMAN Duplicate for development, testing.
• Analyzing Alert Log and User Trace Files and diagnosing the problem.
• Daily incremental backup and weekly full backup of databases using RMAN.
• Involved in migration of applications of the clients.
• Implemented Materialized views, database linksin Regular database management on 10g and 11g OEM.
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement.
• Creating batch files and automating the tasks.
• Daily health checkup of the database using TKPROF, AWR, ADDM.
• Monitoring alert log/system log and managing Database Locks and blocking sessions.
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 9i,10g,11g,OEM,RMAN, Dataguard, AIX 5.3, Windows 2003, Power6 microprocessor, Toad, Remedy, EMC SAN/HBA, NFS, DB on file system and RAW devices.

Confidential

Oracle DBA/Developer

Responsibilities:

• 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.
• Taking Cold and Hot Backups RMAN 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 Oracle10g, 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.
• Responsible for creating tables, views, synonyms.
• Writing PL/SQL Programs Functions, Procedures, Packages and Triggers
• Creating and modifying Stored Procedures and Database Triggers
• Written Shell scripts for backups and monitoring
• Creating Roles and Users and granting required privileges.

Environment: Oracle 10g /9i/8i, IBM AIX, RedHat Linux, SQL, PL/SQL, SQL Developer, ERWIN, DataPump, OEM/Grid Control, RMAN, ASM, TOAD