SUMMARY:

• An Oracle DBA professional with 7+ years of experience in Development and Production environments involving Oracle 9i/10g/11g/11gr2 and RAC and Sql Server.
• Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases.
• Installation, configuration maintenance of Oracle 10g, 11g, Standby Databases (Data Guard).
• Extensively performed database administration tasks: installation, configuration, upgrades, patches, migration, backup and recovery, Space management, database security, Golden Gate, performance tuning and cloning on Oracle 8i, 9i, 10gand 11gR2 on large scale database environments and mission critical large OLTP and OLAP systems.
• Hands - on experience with RAC Cluster ware configuration, administration and patching, RAC Backup and recovery.
• More than 5 years of experience in migrating and upgrading databases of different versions of Oracle (8i, 9i, 10g, 11g) and in different environments.
• Very good experience in doing cross platform migrations using RMAN and Transportable table spaces.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Stats pack, AWR, ADDM and OEM Grid Monitoring.
• Experience in using OEM, TOAD, Database Migrations using transportable table spaces, transportable database, benchmarking using load testing tools.
• Extensive performance tuning activities like Operating System Tuning, SQL Tuning, and Database/Instance Tuning.
• Experience in a variety of hardware and software platforms including Unix/Linux, Sun Solaris, HP-UX & AIX, MS-Windows 2000,2003 and RHEL
• Outstanding knowledge and hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid installation).
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and SQL TRACE.
• Expert in Installing OEM Grid Control, Configuring and Maintaining.
• Extensive experience in Data guard configuration, implementing and maintaining standby databases.
• Setup, Configured and Maintained Oracle Data Guards to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
• Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM
• Co-ordinate with UNIX administrators for space managements on various servers.
• Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Experience in writing Shell scripts to backup, restore database and automate daily activities.
• Complete range of Oracle DBA activities including day-to-day production database monitoring includes alert log, trace file, and achieve files, Troubleshooting production issues and Performance Tuning issues.
• Troubleshooting production issues, Performance Tuning, Physical Database design, Table Space Administration and managing Data Dictionary objects. Extensive SQL and PL/SQL skills
• Skilled in reducing the SQL query time by monitoring queries on TOAD and removing deadlocks.
• Created and modified Database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Experienced in providing 24/7 support for database systems including performance monitoring, performance tuning, troubleshooting and client support.

TECHNICAL SKILLS:

Databases: Oracle 11g R2 RAC, 10gR2RAC, 9i

Operating Systems: HP-UX, Sun Solaris, AIX, Linux and Windows, IBM DB2, Informix on IBM.

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

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

ETL Tools: Informatics 5.1, Data pump, Share Plex.

Data Modeling: Erwin, DB Artisan, Rational Rose, SOX

Other: EMC, Net App, VERITAS, Golden Gate, Oracle Wallet Manager.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Sr Oracle DBA

Responsibilities:

• Responsible for performing all Database Administration activities i.e. schema management, checking alert log of databases, space management in database, user and roles administration.
• Involved in performing cross platform migrations from Oracle 9i, 10g to Oracle 11g.
• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Created Databases on SUSE 10 and SUSE 11 servers.
• Installation and maintenance of Oracle 11g Data Guard (Active).
• Data Guard using physical standby database, Implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Upgrading databases to Oracle 11g and 11gR2 from Oracle 10g.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
• Oracle 10g, 11g (R1 and R2) installation on all major UNIX flavored operating system like RHEL, Oracle Unbreakable Linux (OUL), and WINDOWS server 2000, and 2003.
• Installed Oracle 10g, 11g RAC database on Red Hat Linux.
• Creating and maintaining the Oracle databases.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Installation, configuration and management of Golden Gate 11g.
• Experience in applying critical patches and patch sets whenever required.
• Applying patches both Server side and Client side.
• Coordinate with UNIX administrators for space management on various servers.
• Setting up new environments (Development, Production etc.).
• Database backup and recoveries using RMAN.
• Cloned database from production to Test using RMAN.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Setup backup and recovery procedures using RMAN.
• Experience inOracleGolden Gate installation, configuration, troubleshooting GG issues.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Explain Plan analysis for Query Optimization and SQL tuning with OEM.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.

Environment: Oracle 12c/11gR2 databases, Data pump, Export/Import, Physical Backups, Oracle Streams, Solaris 9.0, AIX Windows 2000/XP, RHEL, HTTP, Golden Gate, F-Secure SSH, F-Secure FTP, Oracle Enterprise Manager 12c, TOAD, ASM, Data Guard other Oracle tools.

Confidential, Cleveland, OH

Sr Oracle DBA

Responsibilities:

• Installation, configuration, maintenance, patching and upgrade of Oracle 10g and 11g RAC databases.
• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation
• Map new business requirements to enhancements existing database models and applications.
• Create logical data models from system requirements.
• Provided production support for the 24x7 Oracle database availability.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Supported and Worked on CURAM for Oracle Databases.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Also migrated data from Oracle to SQL SERVER, Sybase, etc., for testing, reporting and analysis requirements.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Experienced in performing Point in time recovery using RMAN.

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM.

Confidential, Richmond, VA

Sr Oracle DBA

Responsibilities:

• Configured and installed Oracle 9i/10g Databases; handled migration/upgrades of databases from 8i to 9i and 10g manually and with DBUA.
• Data modeling / Logical database design and implementation (including index design)
• Performed Backup/Recovery using RMAN and established testing standards utilizing the advantages of 10g Flashback.
• Performance tuned application/table design, data access methods, memory allocation, disk I/O, CPU usage and resource contention.
• Supported Oracle 11g, 10g and 9i databases
• Performed upgrades from Oracle 10g (10.2.0.3) to 11g (11.1.0.1) on Intel and HP boxes
• Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) running Oracle 10g over to HP Itanium boxes running Oracle 11g.
• Installed Oracle 10g RAC software with ASM & OCFS2 file systems
• Configuration, maintenance and tuning of 10g RAC
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
• Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints
• Experienced in migrating databases to higher releases including incremental migrations
• Migrated database from 9i to 10g and 11g supporting various incremental releases
• Setup of Disaster Recovery databases (Data Guard)
• Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Installing and Configuring Recovery Manager (RMAN)
• Created & Managed Jobs using AutoSys Job Scheduler
• Good knowledge in UNIX Shell scripting in csh, Pro*C
• Planned version control of production source code using Clear case
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle Corporation and installation of patches
• Data Modeling, Database Design and Creation using ERwin

Environment: Oracle 9i, 10g, and 11g, Oracle RAC (11g, 10g), Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, Autosys, Clear case, SQL*Plus, PL/SQL, PostGre SQL, SQL*Loader, HP-UX, Windows 2000/2003, and Linux.

Confidential, Dayton, OH

Sr Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 9i & 10gRAC database and Performed DBA tasks
• Supporting large mission critical databases in a 24x7 environment.
• Migration of database from Oracle 9i to Oracle 10g.
• Working with database Monitoring and Tuning. Lead efforts to develop and improve procedures for automating monitoring.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and kern shells, Unix shell Scripting.
• Cloning of databases from production to development and test databases
• Used RMAN for Backup & Recovery.
• Performance Tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components
• Reviewing performance stats and recommended changes for tuning SQL queries, database, server, and storage configurations.
• Responsible for Upgrading the Database from 9i to 10g, 9i, 10g to 11g.
• Responsible for SQL query tuning, optimization. Performance tuning using tools such as SQLTRACE, TKPROOF, STATSPACK, Explain Plan, AWR and ADDM.
• Automatic Health Monitoring, security, SQL Performance Analyzer.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Refresh/Cloning of Database from production environment to test environment and application of patches and security patches downloaded from Oracle Meta link.
• Working and good experience in diamond relational tables of SQL server 2005 management studio.
• Participating in periodic backup audits, including test restores ensuring all databases and associated logs are being backed-up
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance.
• Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• Coordinate interaction with vendors in critical database problem situations.
• Submitting Tickets using remedy communicating with other groups like UNIX, Configuration Team.
• Oracle utilities i.e. export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance.

Environment: Oracle 10g RAC/9i, Sun Solaris, AIX, PL/SQL, Oracle Stream, DATAGUARD, Import Export, TOAD, OLTP, LDAP, RMAN, Remedy, Shell Script.

Confidential

Oracle DBA

Responsibilities:

• Oracle Database 11gR2 Real Application Clusters (RAC) Installation and Configuration on Linux Server release 5
• Upgrading databases from 10.2.0.4 to 10.2.0.5 and Migration of databases between the RHEL AS4 update 8 to SOLARIS 5.10
• Patching, upgrading the database to 10g, 11g
• Creating databases as per client Standard
• Duplicating Database with RMAN from RAC to Single Node
• Duplicating Database with RMAN from RAC to RAC
• Data Guard Rebuild
• 11gR2 DR drill for Data Guard
• Migrated database from non ASM to ASM
• Check the performance of the database and tune as and when requires using tools AWR, EXPLAIN PLAN
• Understanding execution plan of top SQL statements by using Explain plan, Auto trace and TKPROF
• Refreshing Test Databases with EXPDP/IMPDP
• Handling database management and change requests in form of import and export.
• Oracle Server and client software installation

Environment: Oracle 10g, 11g, RAC, LINUX, RMAN, RAC, Data Guard, ASM, AWR, EXPLAIN PLAN, Auto trace, TKPROF, EXPDP/IMPDP.

Confidential

PL/Sql Developer

Responsibilities:

• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Responsible for installing, upgrading and configuring the Oracle server.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Designed backup and recovery procedures for OLTP system
• Use TOAD tool to access the database.
• Used PL/SQL developer to create PL/SQL Procedures.
• Refresh/Cloning of Database for development, testing.
• Monitoring and Management of database users.
• Testing PL/SQL procedures against the test cases.
• Involved in creating use cases and test cases.

Environment: Oracle 9i, TOAD, Database Tools/Utilities, Windows 98/NT / 2000