SUMMARY

• Over 8 years of experience as an Oracle Database Administrator providing 24 x 7 support on development, test Installation, Configuration, Maintenance and production environments of Oracle 11g/10g/9i on Red Hat Linux, Windows, Solaris, HP - UX.
• Experience with Oracle 11g/10gRAC/9i/8i in Installation, Administration, Monitoring, Database Backup and Recovery.
• Expertise in Designing, creating, operating, maintaining, troubleshooting & Administration of Oracle Application & databases.
• Proficient with Database Cloning, Migration, Standby Database, Data Guard and Patching of Oracle Databases and Oracle Applications.
• Experience in design and implementation of Backup and Recovery strategies (both hot and cold backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental).
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Good knowledge in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
• Experience in maintaining database security regulations, standards, procedures and auditing.
• Experience in implementing active data guard in Oracle 9i/10g/11g for disaster recovery.
• Experience in using various Oracle Utilities like Export/Import, Data Pump and SQL*loader, flash-back technology and ASM.
• Expertise in Setup and configuration of Oracle9i Real Application Clusters (RAC) and Oracle 10g RAC.
• Experience with large databases with high transaction volume in a RAC configuration.
• Experience in implementing various database solutions such as 10g RAC, 9i RAC, Data guard, Oracle Grid and Oracle Streams.
• Expert in using tools such as explain plan, TKPROF, statspack, SQL TRACE, ASH, AWR, ADDM and troubleshooting oracle databases using SQL trace utilities.
• Experience in writing Perl Scripts in performing various processes like sending reports, fetching data from remote servers etc.
• Proficient in automating several jobs using CRON and experience using Enterprise manager.
• Extensive experience in Data Warehousing, ETL (Extraction, Transformation, Loading) using Informatica 6.x/7.x/8.x.
• Experience in Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues.
• Expert in Patch Management. Includes monitoring the current system patch level, identifying and installing new patches, testing and promoting patches to other instances as identified in the instance management document per the patching strategy.
• Experience in reviewing test cases, test scripts, conducting regular meetings in order to review the project status.
• Proficient in writing SQL, PL/SQL stored procedures, constraints, packages and triggers.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.

TECHNICAL SKILLS

Operating Systems: UNIX (Sun Solaris/HP-UX/IBM AIX), Red Hat Linux, Oracle Enterprise Linux, SLES and Windows

Relational Databases: Oracle 11g/10g/9i, SQL Server 2000/2005/2008 , MySQL, Teradata, Knowledge of 10g & 11g RAC

Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPAK, AWR, ASH, ADDM

Tools: and Utilities: RMAN, ASM, Import / Export, DataPump(Expdp, Impdp), TOAD

Querying/Reporting: PL/SQL, SQL

Languages: SQL, PL/SQL, Shell Scripting

Administration Tool: Oracle Enterprise Manager, Toad, Service Now, Manage Now, Service Center, Control-Putty, Citrix, Sql*Plus

PROFESSIONAL EXPERIENCE

Confidential, TX

Oracle Database Administrator

Responsibilities:

• Responsible for installing, configuring, managing and supporting all Production, Development environments of Oracle Version 10g and 11g databases on Linux and HP-UX.
• Configured RMAN Catalog database and registered target databases with catalog.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Configured and maintained RMAN hot and cold backups.
• Responsible for database sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration.
• Configured ASM (Automatic Storage Management) which includes creating disks, diskgroups for the RAC environment.
• Responsible for creating roles, assign system /object level privileges to the roles and assign users to these roles.
• Performed Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Worked on designing, installing & maintaining RAC and Dataguard components of Oracle.
• Extensively involved in upgrading database to Oracle 11g from Oracle 10g.
• Applied regular Security Patching on Oracle products and interim patches for various bug fixes on database products.
• Monitored the table growth, database growth, current users, and system resource usage and so on.
• Gathered statistics, rebuilt indexes and updated statistics on tables to improve performance.
• Installed and Implemented Backup & Recovery procedures. Implemented hot, cold and Logical backup plans.
• Analyzed explain plans, stat packs, monitored alert logs and system performance.
• Created and troubleshoot DB Links’ issues in Oracle for communicating with external databases.
• Implemented Oracle data guard on 11g in maximum performance mode.
• Used Oracle Enterprise Manager (OEM) and Grid control for performance, administration and maintenance of databases.
• Monitored database usage and reported on database performance and system availability.
• Performed databases and SQL tuning using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Manager (ADDM), Statspack, explain plan.
• Deployed database code changes into production environment from SVN source control repository.
• Diagnosed Oracle bugs and coordinated with oracle support to resolve them in timely manner.
• Performed database cloning to setup test and development databases.

Environment: Oracle Enterprise Manager (OEM), Grid control,Oracle10g/11g, DBCA,PL/SQL Developer, RMAN, GoldenGate, Data Pump, TOAD, UNIX, Linux, HP-UX, Putty.

Confidential, WI

Oracle Database Administrator

Responsibilities:

• Created database design according to the requirement of Application Software, monitored and configured databases on Linux and Solaris.
• Built DEV, TEST, QA and PATCH environments from Production database.
• Implemented Oracle 10.2.0.3 physical Data Guard in maximum performance mode for disaster recovery.
• Installed and Configured RAC with 3 nodes server side load balancing using Automatic Storage Management (ASM).
• Performance Monitoring and analysis of RAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
• Involved in upgradation and Migration of Database from 9i to 10g and applying patches whenever required.
• Worked on RMAN backups and recoveries and database cloning using RMAN Duplicate.
• Responsible for troubleshooting and maintenance of RMAN backups and user managed backups.
• Applied Patch with rolling patch method for maximum availability of the system on Oracle RAC, Oracle Clusterware and ASM.
• Implemented ASM on stand-alone databases.
• Managed disks and disk groups with ASM.
• Used Data pump for faster export/import of data in various DEV/TEST environments.
• Implemented Grid Control for managing databases.
• Monitored database usage and reported on database performance and system availability.
• Involved in capacity and resource planning.
• Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
• Provided 24*7 on-call Production database Support and Maintenance, including remote database support.
• Applied patches and worked closely with Oracle to make database environment up to date.
• Responsible for data integrity, user security, daily monitoring for production and non-production systems.
• Scheduled db maintenance tasks such as tables/indexes analysis, index rebuild, materialized views refresh and db exports.
• Wrote Shell scripts for Alerts for ORA-errors, backup and recovery, Import and export procedures.

Environment: Oracle 10g, OEM, DBCA, RMAN, RAC, ASM, Net Manager, Dataguard, Unix Shell Scripts, Data pump, TOAD, Linux, Solaris.

Confidential, NC

Oracle Database Administrator

Responsibilities:

• Installed & upgraded Oracle database server 10g on Linux.
• Migrated databases from Solaris to Linux.
• Responsible for profile creation to control user resource and security.
• Implemented security administration by creating roles, views and granting necessary object/system level privileges for users.
• Monitoring and optimizing the performance of the database.
• Installed, configured, implemented and supportedOracledatabase environments with RAC configurations.
• Taking Backup & Recovery of Database Using Logical (Export & Import) & RMAN Backup.
• Cloned the Oracle Home and Oracle enterprise management agent.
• Configured fast refresh for Materialized Views.
• Configured Standby database for high availability.
• Performance tuning of Oracle Database Objects by fixing row chaining and row migrations.
• Monitored CPU usage, IO statistics, and CPU time to identify any OS level bottlenecks.
• Responsible for Index management, table partitioning, SQL tuning, RAC interconnect tuning.
• Generated and analyzed statspack reports and monitoring statistics for performance tuning of the database.
• Developed UNIX scripts for the system and databases for effective functionality and report generations.
• Responsible for Load and Performance testing of the database servers and application servers, analysis and documentation of results.

Environment: Oracle 10g, Export/Import, Data Pump, RAC, TOAD, SQL*Plus, SQL, PL/SQL, SQL*LOADER, UNIX Shell Scripting, Cron Scripts, Oracle Enterprise Manager (OEM).

Confidential

Oracle Database Administrator

Responsibilities:

• Monitoring Space and Report Generation.
• Monitoring Rollback Segment usage.
• Backup/Restore procedures.
• Performance checks of different SGA components.
• Interacted with developers and the business managers for get purge and archiving requirements for database.
• User Management.
• Hot and Cold Backup using RMAN.
• Performed troubleshooting of the various database servers.
• Performed troubleshooting of the various company database servers.
• Regularly backup and tune Oracle databases.
• Applied business rules with the use of database triggers and stored procedures.
• Controlled and monitoring user access to the database.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, passwords (security).
• Involved in creating different databases as per the requirements.
• Monitored Database activities using Oracle Enterprise Manager.
• Created different databases as per the requirements for Development and Testing.
• Performed SQL tuning and troubleshooting.

Environment: Oracle 10,Apache, /Linux, RMAN, Oracle 10g Streams, Oracle Clusterware, Oracle ASM, 10gEM, Oracle Data guard, Windows NT, SQL*Plus, Perl and shell Scripting.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed, configured and maintained of Oracle 9i on HP-UX and Windows.
• Implemented Database export/import, hot backup and cold backup setup for all the clients.
• Used Export and Import ofdatabases for Logical backups and restores.
• Used Oracle utilities like SQL Trace, TK Prof and Explain Plan for performance tuning.
• Used Partitioning Strategies for very large tables implementing range, list partitions and hash sub partitions.
• Performance tuning and Monitoring using Grid Control database & managing instances.
• Responsible for managing development and test databases.
• Implemented Database export/import, hot backup and cold backup setup for all the clients.
• Setup backup and recovery procedures using RMAN.
• Installed database, version upgrades and applying patches.
• Cloned databases in development and testing environments.
• Transferred data from different database to oracle database using SQL*Loader.
• Responsible for using Oracle Data Pump Utility for exporting and importing bulk volumes of data.
• Involved in Dataguard (Standby) setup for high availability and disaster recovery purpose.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Developed UNIX Shell Scripts (KORN Shell) for automating the loading procedures.
• Perform daily administration support for database backups, performance tuning and monitoring.

Environment: Oracle Enterprise Manager (OEM), Oracle 9i, HP-UX, Windows, RMAN, Data Pump, Dataguard, SQL*LOADER, TOAD, UNIX Shell Scripting.