SUMMARY:

• Over 7+ years of experience as an Oracle Database Administrator having hands on experience in database creation, administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, trouble shooting and shell scripting.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g & 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Expertise in different environments like HP - UX, Linux and Windows.
• Excellent experience in migrating the Databases.
• Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management (table space, rollback segment), and monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
• Experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).
• Hands on experience in 11g R2 grid infrastructure.
• Experienced at using Oracle Enterprise Manager OEM to manage databases and diagnosing database problems using OEM-Diagnostic pack.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 TRACE and OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Strong Exposure on High Availability Concepts (RAC, Standby), Database Cloning, and Oracle Streams.
• Successfully implemented physical Standby database using Oracle Data Guard feature for High availability configuration.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, capacity planning and documentation.
• Experience in using Flash-Back Recovery, Data Pump, AWR, ASM, ASH and ADDM, Recycle Bin and 10g Grid Monitoring.
• Strong knowledge and experience of managing Oracle 8i,9i, 10g and 11g RAC environments using the OEM Grid Control tools.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Knowledge on Oracle Support processes for technical requests through Meta link.
• Planning and scheduling for the backup of database information using UNIX shell script and Crontab jobs.
• Experienced in using Oracle's Transportable Table space (TTS) feature allows users to quickly move a user Table space across Oracle databases.
• Strong knowledge and experience of managing Oracle8i, 9i,10g and 11g environments using the OEM Grid Control tools.
• Experience in Database Patching, predicting growth trends and Capacity Planning.
• Data transferring with Export, Import, Data Pump and SQL* Loader utilities.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks and used DBMS STATS to gather the statistics.
• Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
• Skilled in database upgrades 8i to 9i, 9i to 10g R2 and 10g to 11g.
• Refresh/Cloning of Database and applications for development and testing purpose.
• On call 24x7 Production Support Worked beyond regular hours.
• Dealing with database security and auditing.
• Excellent communication, interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment. Willing to relocate: Anywhere

TECHNICAL SKILLS:

Operating Systems: MS-DOS, MS Windows … HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6,5, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux 2.1, 3.x, 4.x, 5.x

Programming Languages: SQL, PL/SQL, Unix Shell Scripting. RDBMS Oracle …

Software's, Applications and Tools: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, Golden Gate, ASM, Cluster ware, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, DB Artisan, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR and ADDM, SQL Developer.

Web Related and Other Tools: HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential - -Broomfield, CO

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Sun Solaris 9,10, Scent OS
• 24x7 remote support and on call Database support for Database developers & end-users.
• Successfully upgraded Production and Test databases from Oracle 9i (9.2.0.8) to Oracle 10g …
• Successfully upgraded Oracle 10g … to Oracle 11g … on Sun Solaris
• Implemented and maintained Oracle … Data Guard/standby databases for fail-over purposes.
• Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities. Implemented 11g RAC on a test basis.
• Expertise in recovering the database. Performed complete database recovery using control files.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Configured and maintained Grid Control Repository and Deployed OMS Agents on different database servers.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab.
• Experience in configuring Golden Gate director for alerts monitoring.
• Installed a new Rman catalog database and successfully registered more than 100 databases.
• Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• Involved in the Monitor of Backup and Recovery Strategies using RMAN, and Configuring Oracle Data Guard.
• Developed SQL*PLUS & PL/SQL scripts for Extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
• Using the 11g Grid control, OEM for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc.
• Experience in taking backups with RMAN in both Catalog/ No catalog modes.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Cloning & duplicating databases using scripts as well as RMAN.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Applying security patches both Server side and Client side and Performed testing.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Enabled the audit on all the dev/test databases, analyzed and reported the audit records about the suspicious activity in the database.
• Responsible for quarterly patching and bug fixes
• Configured Oracle Streams and exchanged data between two databases in remote locations.
• Performed all aspects of database administration including installs, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Performing SQL*Loader jobs for loading data from text files

Environment: Oracle 10g, 11g R2 on ASM, Sun Solaris 9 & 10, Golden gate Shell Scripts, TOAD, SQL*Loader, Data Guard, RMAN, RAC, OEM, Grid Control.

Oracle DBA

Confidential -Chicago, IL

Responsibilities:

• Worked in Oracle 10g, 11g R2 Sun SOLARIS 5.8, HP UX 11.23
• Worked on 11g R2 grid infrastructure in 2 node RAC environment.
• Implemented Data Guard for Disaster recovery system using Oracle 10g
• Setup and configure Standby database for high availability by using Data Guard.
• Migrated & upgraded databases from Oracle 10g to oracle 11g R2
• Installation of Oracle … … and … binaries.
• Installed and implemented Golden gate to replicate data between two databases.
• Created new 10g Database and performed regular RMAN backups for all the databases.
• Patch Analysis, Patch Installation.
• Documented instructions for migrating & upgrading databases.
• Refreshed schemas from Production environment to Dev/Test environment using exp/imp and expdp/impdp utilities.
• Upgrade and character set conversion of RAC databases with the aid of Oracle Golden Gate utility.
• Installed EM10g Agent on HP-UX.
• Maintained checklist for monitoring Production and Test systems.
• Wrote various shell scripts to automate tasks.
• Created tablespaces and managed tablespaces by adding/deleting/resizing data files.
• Created schema (tables, Indexes, views, sequences, synonyms, packages).
• Setup database auditing, granted privileges to users through system/object roles.
• Worked as part of a team and provide 24x7 supports when required.
• Created and configured Data guard.
• Implement and maintain database security.
• Took remote export of a database residing on a remote server using tns entry (same oracle version) due to non availability of space in legacy server.
• Created db link for inserting large tables directly without taking export.
• Managed databases of various sizes ranging from 1 GB to 50 GB.
• Online index rebuilds and storage recovery.
• Applied regular Security Patching on Oracle products and interim patches for various bug fixes on database products.
• Deleting data and arch file systems on legacy server after Database Migration to new server.
• Created Procedure, Function, Triggers.
• Installed STATSPACK in 9i environment.
• Taking Hot and cold backups.
• Strong expertise in RMAN.
• Creating and managing partitioned tables and indexes.
• Monitor and tune database performance using STATSPACK and AWR.
• Increased performance of sql queries by creating materialized views and by enabling query re-write.

Environment: Oracle 10g, 11g R2 HP-UX 11.11, 11.23, Sun Solaris 5.8/5.9, data guard, Golden gate oracle streams, RAC, OEM grid control 10g, Sql developer.

Oracle DBA

Confidential, Greensboro, NC

Responsibilities:

• Organizing Oracle Database operations, installation, creation, configuration of Databases, laying out database tables and database schema design, startup and shutdown of Databases.
• Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Creating users and roles for database and give the privileges to suitable user.
• 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.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported a large number of Development Databases
• Using the ADDM to analyze performance problem and with help of AWR reports for individual SQL statements. Analyzing recent session activity with an ASH report.
• Prepared Installation Procedures for current Patch, Documentation for Adding a node to Existing RAC environment and Data Guard.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low disk spaces and Performance issues.
• Cloning of production database to the test environment using Recovery Manager (RMAN)
• Created Standby databases for Disaster Recovery, using Data Guard.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated Database auditing and managing user groups, Database security, OS space monitoring etc.
• Database Administration and Planning including physical design, backup & recovery.
• Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing.
• With help of Database links provided connectivity to other databases.
• Created database objects like tables, views, indexes, partitions.
• Develop, document and enforce database standards and procedures.
• Setting Oracle Streams for replication between two databases.
• Implementation of RAC, ASM, DATAPUMP, FLASH BACK Recovery
• Clear communication and documentation of technical specifications..
• Experience in developing Oracle Alerts, SQL Tuning and Optimization.
• General database administration including the management of instances, redo logs, temp space, rollback/ undo segments and schema management.

Environment: Oracle 10g RAC, HP-UX 10.x, TOAD, OEM, AWR, Data Guard, RMAN, Golden gate TKPROF, oracle streams

Oracle DBA

Confidential - Plantation, FL

Responsibilities:

• Designed, configured and installed Oracle Real Application Clusters on a 2 node Cluster.
• Implementation of RAC Technology.
• Experience in taking backup of OCR.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export.
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Performed backup and recovery activities on the RAC databases
• Designed the database schema and created any necessary database objects.
• Monitor production and non-production database through Grid Control, Optimize queries, startup, shutdown and configure agents to communicate with grid control for various different maintenance tasks.
• Applied patches or upgrades to the database as needed.
• Created number of LINUX shell scripts for various tasks.
• Worked on Oracle Metalink in case of problems.
• Experience in using Veritas volume manager on UNIX.
• Worked on all phases of the project lifecycle including mapping data requirements, data definitions and construction of logical data models.
• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan, AWR and ADDM.
• Tuned memory structures such as the database buffer cache, shared pool and library cache.
• Configured ASM for RAC setup and non RAC databases.
• Assist application developers to meet their day to day requirements related to performance.
• Handled databases with size more than 1 TB.

Environment: Oracle 9i/10g, RHEL 4, IBM-AIX 5L, Veritas volume Manager, OEM (Grid Control), RMAN, RAC, ASM, PL/SQL, TOAD and SQL *PLUS.

Oracle DBA

Confidential

Responsibilities:

• Responsible for maintenance and improvement of production, archive Oracle databases.
• Participated in design and implementation of Oracle data Streams, Single-Source replication.
• Replicated tables, views and triggers using SNAPSHOT and MATERIALIZED VIEWS.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Database administration tasks included performing regular Hot & Cold Backups, Job Scheduling.
• Managing Database Structure, Storage Allocation, Table/Index segments and Rollback segments.
• Monitored Alert Log Report and system Error Logs.
• Cloned database from PRODUCTION to create TEST, DEVELOPMENT and UAT instances.
• Configured and managed OEM to stabilized oracle database into healthy environment.
• Installed and Upgrade database with help of patches to maintain environment.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Rebuilt, reorganized and simplified databases, enhancing development, maintenance and performance.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA
• Worked with Data Guard to protect a standby database from corruptions that attempt to propagate from a primary database.
• Maintenance & modification of Shell Scripts.
• Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes and Loaded bulk data with SQL*Loader.
• Develop, document and enforce database standards and procedures.
• Generating Statspack report by using statistics for the optimizer.
• Extensively worked on Full/Incremental backup with the Block Change Tracking utilities.
• Drastically reduced unscheduled downtime and improved performance.
• Monitoring and tuning database performance using STATSPACK, TKPROF and DBMS STATS.
• Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth.
• Troubleshooting and fixing database listener issues.
• Worked in a 24/7 supporting environment with ON-CALL rotation

Environment: SUN SOLARIS 8, Oracle 9i, PL/SQL, Windows NT, shell scripting.