SUMMARY

• 7 Years of experience as ORACLE DBA with 8i,9i,10g,11g on different Unix environments like HP - UX (Hp PA RISC), IBM AIX, Sun Solaris, Linux and Windows 2000/NT.
• Supported Oracle 9i/10g/11g databases in different environments like HP-UNIX, Red Hat Linux, Sun Solaris and Windows.
• Designed and developed plans to achieve high availability, scalability, performance of the Oracle RDBMS servers.
• Migrated databases using Golden Gate, Transportable tablespace and Datapump from 9i, 10g to 11g.
• Experienced in setting up 10g Data Guard Physical/Logical standby, 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 and 11g RAC clusterware and instances.
• Administered databases using OEM (Oracle Enterprise Manager) and Grid Control.
• Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, SQL-Backtrack, VERITAS Net Backup.
• Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.
• Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.
• Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
• Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
• Used TKPROF utility and Explain Plan for tuning SQL queries.
• Experience in regular DBA activities such asUpgrades, Patches,TAR support,Cloning,Backups and Recovery Manager, Performance Tuning,Capacity Planningand documentation
• Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.
• Rebuilding of Indexes for better performance, User Management, Tablespace management, maintenance of Oracle Database..
• Installing Oracle patches, Migration of database across releases.
• Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Expertise in loading data from flat files using external tables, SQL* Loader.
• Experience with SQL, PL/SQL, UNIX Scripting.
• Hands onexperiencein tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Excellent analytical, problem solving, communication and interpersonal skills.
• Analytical and Systematic thinking ability with a goal and solution oriented approach.
• 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.
• Creating the Private and Public database link.
• Good Programming Skills in SQL, PL/SQL, UNIX Shell Scripting.
• Providing 24/7 production support for critical production databases.

TECHNICAL SKILLS

Operating Systems: HP-UX, IBM AIX 4.3/5.0, 5.1,WINDOWS NT, LINUX (Red Hat Enterprise Manager), Sun Solaris 2.7

Languages: SQL, PL/SQL, T-SQL, C, C++, Java, HTML, COBOL, XML,.NET 1.1, UNIX, Shell, PERL.

RDBMS: Oracle 11g/10g/9i/ 8i, SQL Server and Ms-Access.

Administration: SQL*Loader, Export, Import, SSIS

Tools: Oracle Migration Workbench, SQL-Backtrack, Platinum - Performance Monitor, Veritas Volume Manager, Power Designer, Sybase Central, Erwin and DBArtisan, SQL* Loader, Informatica (PowerMart 7/6.2/5.1, PowerCenter .7/6.2/5.1,, Crystal Reports, BMC Patrol.

Source Control Tools: Microsoft Visual Source Safe, PVCS Version Manager.

Reporting Tools: Crystal Reports, SQR, MS Access Reports, Oracle Reports & Cognos 8, Business objects.

Office Tools: MS Word, Excel, Power Point, Visio, UML, Erwin, MS Project.

PROFESSIONAL EXPERIENCE

Confidential, Bartlesville, OK

Sr. Oracle DBA

Responsibilities:

• Part of the Data Architecture team which supports development, test and production databases.
• Performed Database migration from Oracle 10g to Oracle 11.2.0.3 using Golden Gate 10.4.0.
• Worked on RMAN duplication, Cross-platform Transportable Tablespace.
• Implementation and support of 10g and 11g migrations and upgrades from Oracle 10g to Oracle 11g databases, including RAC (Real Application Clusters) databases on HP-UX and Linux.
• Implemented 10G Data Guard Physical and Logical standby using DG Broker, and experienced with 11G Data Guard new features Active Data Guard and Snapshot Standby.
• Migrated applications to the HDS (Hosted Database Services) environment using Golden Gate 10.4.0.
• Performed oracle Software’s Installations, Creation of new standalone and clustered databases.
• Administering and setting up of 11G RAC and 10G RAC clusterware and instances.
• Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Also worked on Network data encryption to improve the security and also implemented SSL wallet to secure the connections.
• Database Services creation for distributing the applications across multiple nodes, Extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,
• Setting up the IDM Read Only (RO) and Break Fix (BF) roles for the application users as per the clients security compliance.
• Redefinition of tables using DBMS REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace
• Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Implemented 11g Interval Partitioning for monthly partitioning of large tables..
• Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
• Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab and $UNIVERSE.
• Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
• Handled Chained Rows and Row migration, and solved the database performance issues.
• Experienced with ASM, adding,deletingdisks to the disk group.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
• Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
• Supported development teams for moving changes to different development, test levels and prepared documentations to move changes to the live production environment.
• Responsible for all activities related to the development, implementation, administration and support ofETLprocesses for large-scale data warehouses using Power Center and Power Exchange.
• 24/7 support for the production environment.

Environment: HP-UX 11.31,Linux, Oracle 11G/10G/9i,CAD2.4(Oracle:10.2.0.4, RHEL 5.3)CAD 3.1(Oracle 11.2.0.2,RHEL 5.4), Oracle Golden Gate 10.4, Data Guard 10g Physical/Logical, Data Guard 11G Active Data Guard, ABINITIO 8.7.4,Power Designer 15, Oracle Enterprise Manager(OEM), SQL*Loader, OEM Grid Control 11.x, RMAN, Sybase 12.5, Windows XP/2000.

Confidential, Des Moines, IA

Sr. Oracle DBA

Responsibilities:

• Supported development and test environments and production environments.
• Worked on partitioning of AUDIT tables and implemented 11G interval partitioning and partitioned tables in the production using DBMS REDEFINITION.
• Implemented Partitioning maintenance procedures for regular maintenance of partitioned tables.
• Migrated databases using RMAN cross plat form transportable tablespace.
• Duplicated databases using RMAN 11G Active duplication.
• Administered 10G RAC, 11G RAC databases and experienced with ASM (Automatic storage management).
• Performed oracle software installations and created standalone and cluster instances as required.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams.
• Implemented Data guard for faster Disaster Recovery and implemented Golden Gate for database replication.
• Involved in developing LOGICAL and PHYSICAL model of the database using Erwin.
• Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files.
• Implemented security triggers for tracking changes and developed stored procedures for moving data between the two environments.
• Implemented logical backup plans for faster recovery of database objects in the testing environments.
• Developed procedures for doing regular jobs like truncating schemas and for moving day to day data to the Production environments.
• Migrated & upgradeddatabases from Oracle10gto oracle11g and also documentedinstructionsfor migrating & upgrading databases.
• Trained in GoldenGate replication software with GoldenGate Software, Inc
• Installed and Configured the GoldenGate software and created manager, extract, replicate trail files.
• Tested data is flowing from AMDOCS source to target database and switch over from Shareplex to GoldenGate.
• Extensively worked on SQL Performance tuning using Explain plan and AWR report.
• Experience with OEM, TOAD, and Oracle SQL Developer for database administration.
• Involved in business analysis and technical design sessionswithbusiness and technical staff to develop requirements document, andETLspecifications.
• Worked with Data modelers in desiging and implementing performance improvement changes to ETL processes using Informatica.
• Designed Physical data models, capacity planning for the new application using Power Designer.
• Administered environment with mixed Data Domain Boost, virtual tape and physical tape storage environments across multiple data centers.
• Involved in a team where we had to migrate Oracle databases for the SAP application from either TSM/Tape or TSM/Data Domain to RMAN/Data Domain.
• Prepared the documentation for production loads and prepared the test cases.
• Preparing Documentation for Data Migration from Legacy systems to Oracle.
• 24/7 support for the production environment.

Environment: HP-UX 11.31, Oracle 11g R2, Oracle SQL Developer 2.1,Golden Gate, Data Guard, Oracle Enterprise Manager(OEM), SQL*Loader, OEM Grid Control 11.x, RMAN, Sybase 12.5, PowerBuilder 9.0, Micro Focus COBOL, C, NETTERM, Windows XP/2000. Erwin 4.0

Confidential, Morristown, NJ

Sr. Oracle DBA

Responsibilities:

• Installed oracle RAC database software. Creation of Databases for Testing, Development and Production on TERADATA databases.
• Implemented Backup & Recovery procedures and took Periodic Backup of the database and the software. Solid experience in Oracle Recovery Manager (RMAN), and standbydatabase using Data Guard 9i/10g with ASM.
• Oracle Databases and MySQL Databases installation, creating and managing instances, schemas, users, profiles.
• Monitoring the health of the databases using Oracle Enterprise Manager 10G Grid control.
• Implemented Hot, Cold and Logical backup plans.
• Used Export and Import of databases for Logical backups.
• Developed SQL Loader scripts to migrate large amount of data for capacity planning.
• Create and Refresh materialized views.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Provided support to SAP/ERP database implementation and database Troubleshooting with SAP and Oracle tools.
• Experience using modeling tools, logical and physical database design and SAN storage and Proficient in Enterprise Database Operations.
• Experienced in maintaining high availability of databases for global operation using Oracle RAC and Data Guard/Standby databases.
• Configuring a single setup Golden Gate on a centralized server to do replication for different database
• Competent in the use of Oracle Database server tools and utilities. These tools include SQL Loader, Export, Import, Data Pump and OEM grid control.
• Create and Manage Standby databases at remote data center as Disaster Recovery.
• Implemented DRP (Disaster recovery plan) for critical databases using Streams.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Scheduling jobs through job scheduler and Oracle scheduler.
• 24/7 support for the production environment.

Environment: Oracle 10g/9i, Oracle RAC 9.2.0, LINUX, AIX,HPUX, SQL Server, ASM, OEM Standby Database with Data Guard, TOAD, PERL.

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Worked extensively on providing support to oracle high availability RAC databases.
• Performed migration of database from 10gR2 to 11g using golden gate and oracle provided data load tools like exp and imp.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
• Involved in Oracle 10g RAC installation on new and existing systems.
• Designed database models for enhancements to existing databases.
• Performed SQL and Application tuning using OEM tuning advisor, explain plan and TKprof.
• Worked on Database replication (golden gate), Migration of databases.
• Responsible for supporting and migrating huge volume (1TB) of data between different servers and versions.
• Supported 7 database out of 35+ databases deployed at FedEx currently.
• Responsible for developing design documents for new database designs and enhancements.
• Coordinated DBA team of 3 for new application implementation on database migration from Sybase.
• Installed and configured Data Guard oracle 10g Databases.
• Worked with developer in tuning multiple PL/SQL stored procedures and SQL queries.
• Performed multiple data migrations using oracle Data Pump and regular exp and imp.
• Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pool like Recycle pool, Keep pool.
• Implemented 10g features like Undo retention Guarantee, Flashback table, Flashback version query, Flashback Transaction query, Recycle bin.
• Implemented Oracle Advanced Indexes
• Creating the Private and Public database link.
• Creating Materialized View and Using Query Rewrite for Performance.
• Expertise in configuring Network using Net Manager.
• Configured listener.ora and tnsnames.ora as on when required for clients.
• Creation of database with the complete understanding of hardware configuration to provide maximum performance and high availability.
• Hands on practice on ASM (Automatic Storage Management).

Environment: Oracle 8.1.6 /9i, HP-UX 10.2/11.0, HP 9000, Windows NT 4.0, Erwin, Power Mart, Oracle Replication Manager, RDBMS, Export/Import, Unix Shell Scripts, TOAD, Tkprof and SQL*Net/Net8

Confidential

Oracle DBA

Responsibilities:

• Installed oracle RAC database software. Creation of Databases for Testing, Development and Production on TERADATA databases.
• Implemented Backup & Recovery procedures and took Periodic Backup of the database and the software.
• Solid experience in Oracle Recovery Manager (RMAN), and standbydatabase using Data Guard 9i/10g with ASM.
• Oracle Databases and MySQL Databases installation, creating and managing instances, schemas, users, profiles.
• Monitoring the health of the databases using Oracle Enterprise Manager 10G Grid control.
• Implemented Hot, Cold and Logical backup plans.
• Used Export and Import of databases for Logical backups.
• Developed SQL Loader scripts to migrate large amount of data for capacity planning.
• Create and Refresh materialized views.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Experience using modeling tools, logical and physical database design and SAN storage and Proficient in Enterprise Database Operations.
• Experienced in maintaining high availability of databases for global operation using Oracle RAC and Data Guard/Standby databases.
• Competent in the use of Oracle Database server tools and utilities. These tools include SQL Loader, Export, Import, Data Pump and OEM grid control.
• Create and Manage Standby databases at remote data center as Disaster Recovery.
• Implemented DRP (Disaster recovery plan) for critical databases using Streams.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Scheduling jobs through job scheduler and Oracle scheduler.

Environment: Oracle 10g/9i, Oracle RAC 9.2.0, LINUX, AIX,HPUX, SQL Server, ASM, OEM Standby Database with Data Guard, TOAD, PERL.

Confidential

Oracle Developer/Oracle DBA

Responsibilities:

• Installation of Oracle 8i/8.x/7.x and other Oracle tools.
• Participated in testing the compatibility and portability of Application on Oracle.05 by migrating whole application and database from 7.3.2 to 8.05.
• Creating primary database storage structures (tablespaces, datafiles, tables, indexes etc).
• Team member of Backup and Recovery Group (consist of 3 DBAs) responsible for EXP and IMP in the server across Standby Databases.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Actively worked on SQL and Physical database tuning resolving fragmentation and disk contention. Use Partitioning feature of Oracle 8 to improve performance.
• Used VLDB for very large databases such as Temporary Table spaces.
• As member of CCB, responsible for maintaining Application schema and Schema versions.
• Tuning the database for optimal performance.
• Troubleshooting through examining Oracle alert logs, system logs and trace files
• Setup and Tune a Testing Server with RAID technology on HP Server running HP 11.0/ Oracle 7.3.3.
• Tested load of 1000 concurrent users. For Load testing used Mercury Tool Load Runner.
• Performing all daily maintenance tasks. Interacting with oracle customer service as and when required.
• Database sizing for various deployments to clients.
• Actively participated in Database replication (golden gate), Application Tuning, which includes SQL Tuning, Database design tuning and tuning at Instance level.
• Written and troubleshoot database triggers/Stored Procedures using PL/SQL.
• Have written shell scripts for automation of various database-monitoring activities

Environment: Oracle 8i/7.x running under HP-UX 11.0/10.20,Sun Solaris, SQL* Loader, ERWIN, RDBMS, OEM, Platinum SQL Station, Precise, BMC Patrol.