SUMMARY

• 7+years of experience as a Certified Oracle Database Administration having hands on experience in database administration, production, support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, migration, shell scripting and documentation.
• Extensive knowledge on database administration for Oracle 9i, 10g and 11g within very large scale environments.
• Excellent experience in installation, setup and configuration of Oracle 9i, 10g and 11g in HP - UX, Sun Solaris, IBM AIX, Windows and UNIX/LinuxEnvironment.
• Installed Oracle 10g/11g RAC using ASM file system for database files and ocfs2 file system for binaries.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone database to RAC environment.
• Experience in configuration and maintainingOracle Physical Standby Database usingOracle Data Guard 10g and 11g.
• Knowledge in configuring ASM (Automatic Storage Management) for both the standalone database and RAC database environments.
• Plan, Implement and test disaster recovery system, using RMAN and custom written shell scripts.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery. Incomplete recover and disaster recovery using Standby database.
• Implemented Oracle10g Streams unidirectional on table level for replication between homogeneous environments.
• Experience inLogminertechnology used for data replication (PREPARER, BUILDER, and APPLIER).
• Experience in upgrading the database from Oracle 9i to Oracle 10g and Oracle 10g to Oracle11g.
• Experience in complete range of Oracle DBA activities including day-to-day production database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshoot production issues, Physical Database Design.
• Installed and applied various patches which includeCritical Patch Update (CPU), Patch Set Update (PSU) andOne-off patchesusing OPatch and runinstaller, also involved in upgradeoracle database 9i to 10g and 10g to 11g.
• Experience with data movement using Oracle utilities like Export/Import, Data pump and SQL *Loader.
• Involved in Monitoring, Optimizing Oracle database for Performance Tuning & system/modules for Application Tuning using tools like AWR, ADDM, ASH, STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, and UTLBSTAT.
• Experience in database Security and Auditing.
• Experience in Database Links, Materialized Views, Flashback Technology, Partitioning Tables to improve Performance and Manageability.
• Experience in writing Procedures, Functions, Triggers and Packages in Oracle Server using PL/SQL.
• Experience in using Oracle’s Transportable Tablespace (TTS) feature allows users to quickly move a user tablespace across the Oracle databases.
• Database replication using snapshots, materialized views and advanced replication methods.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Listener, TNSNames, Dynamic Performance Views (v$) and Dictionary Views.
• Knowledge in Oracle Support Process for Technical requests using Metalink/Oracle support.
• Provided 24X7 support to resolve the production issues and application support.
• Excellent interpersonal and strong analytical skills, Documentation and Problem-solving skills with customers’ service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 3.x, 4.x, 5.x and Windows 95/98/NT/2000/XP.

RDBMS: ORACLE 11g, 10g, 9i, Oracle 10g (RAC, Data Guard & Streams), SQL Server 2005 and My SQL.

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting, Ksh, bash and Perl Scripting

Tools: /Utilities: RMAN, OEM, Grid Control, Oracle Management Service (OMS), ASM, Export/Import, Data pump, SQL*PLUS, SQL*LOADER, TOAD, Patch Management, ODBC, DBUA, DBCA, putty, Oracle Data guard, VERITAS Net Backup.

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

WEB TOOLS: HTML, XML, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Sr. Oracle DBA

Responsibilities:

• Involved in Installation and configuration of Oracle 10g and 11g RAC using OracleClusterware and ASM.
• Implemented Data Guard, Physical Standby database in 10g and 11g RAC environment for the Production databases for Active and Passive cluster.
• Experienced in Design, implementation and generating documentation of Oracle 10g and 11gData Guard on both physical/logical standby databases in high availability mode.
• Installed Oracle Streams as an enhancement for the Client's DW method and monitored Streams Issues using Grid Control and Implemented Oracle Streams unidirectional on table level.
• Experienced in the installation of Oracle Grid Control in Server (OMS Oracle management Server) and installing the Agents in all the production, test and development databases and configuring them.
• Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0, IBM-AIX 5.3.
• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g(11.1.0.7) andOracle 11g(11.1.0.7) to Oracle 11g(11.2.0.2 ) on IBM-AIX.
• Writing and modifying UNIX Shell Scripts to manage Oracle environments for BackendProcesses.
• Developed SQL*PLUS&PL/SQL scripts for extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
• 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 and Data pump utilities).
• Creating&ManagingDatabase Structures, Storage Allocation, Table/Index 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.
• Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
• 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 (ASH).
• Automated the nightlyRMAN backups for the Production and Test Databases using Crontab.
• Creating and Scheduling Oracle Backend Process jobs in Crontab.
• Cloning & duplicating database using scripts as well as RMAN.
• Expertise in recovering the database, Performed complete recovery, data file recovery, incomplete recovery.
• Experienced in Database Security user Management, Privileges, Roles, Auditing, Profiling, and Authentication.
• Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.
• Applying security patches both Server Side and Client side.
• Worked closely with the developers for the better performance in Applications in writing the Packages, Triggers, Materialized Views and Indexes on the tables.
• Used Secure SCP &SFTP extensively for the File transfers from machines to remote server.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.
• Resolved TAR (Technical Assistance Request) issues 24X7 while assisting the functional team and oracle support (Metalink) and managing database/data security.

Environment: HP -UX, Linux, Windows 2003, Oracle 10g and 11g, Oracle Enterprise Manager, RMAN, RAC, Streams, DataGuard, ASM, TOAD, SCP/SFTP, AWR, ADDM, TKPROF, Explain plan, DBVerify, SQL* Plus, PL/SQL,Shell Scripting, SQL* Loader.

Confidential

Sr. Oracle DBA

Responsibilities:

• Installation, maintenance and tuning of RAC and standby database, OLTP, DSS and Data Warehousing using customized shell scripts.
• 24X7 Database Administrations, support and monitoring to ensure proactive problem recognition and resolved the database issues.
• Involved in Designand Implementationof disaster recovery using Data Guard, High Availability using 10gRAC.
• Responsible for managing Data guard, staging databases and involved in database installation,maintenance and administration for disaster recovery.
• Implemented Oracle Streams for the data replication unidirectional on table level.
• Applied patches to Oracle Databases and Oracle Applications.
• Upgraded development and production databases from Oracle 10g (10.1.0.4) to Oracle 10g (10.2.0.4).
• Appling security patches both Server and client side.
• Proactive database monitoring using 10g grid monitoring tool.
• SQL tuning and Database PerformanceTuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan and monitor the database performance on daily basis.
• Responsible for optimizing the queriesforapplication tuning.
• Provided support to Application Database Administrators in designing the database.
• Implemented RMAN backups (Hot, Cold, full and incremental) as per backup policy.
• Automated the nightly RMAN backups for the Production, Development and Test Databases using Crontab.
• Recoveredfull and point-in-time of Databases as needed fromRMAN backups.
• Cloning the database using scripts as well as RMAN.
• Management of schemasobjects, partitioning oftables & indexes.
• Automation of data load using Korn shellscripting and SQL*Loader.
• Used Secure SCP & SFTP extensively for the File transfers between servers.
• Responsible for Database Security user Management, Privileges, Roles, Auditing, Profiling, and Authentication.
• Performed other DBA activities including space management and performance monitoring.
• Experienced in Oracle Database monitoring troubleshooting and resolve the issues.

Environment: Windows 2000/2003/XP, Oracle 10g, 9i, DataGuard, RMAN, Red Hat Linux, Sun Solaris, UNIX Scripting, PL/SQL, TKPROF, Explain Plan, AWR, ADDM Partitioning, Grid Control/OEM.

Confidential

Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle 9i and 10g databases.
• 24X7 Production database administrations, support and monitoring to ensure proactive problem recognition and resolving the database issues.
• Installation, Upgrade and Configuration of Oracle 9i and 10g Databases.
• Involved in designing of disaster recovery plan using Data Guard, and High availability using RAC.
• Schemas refresh using export/import, data pump, creating the database table spaces, tables, indexes, setting privileges and user logins.
• Configuration, Administration and tuning of Oracle 10g and 9i RAC.
• Used cross platform transportable table space to transport tablespace across platforms.
• Data Refresh in Test and integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC environment.
• Implemented Oracle Streams unidirectional on Table level.
• Implemented backup strategies hot, cold and exports as per business requirement.
• Cloning databases using scripts as well as RMAN and performed tablespace point in time recovery (TSPITR) using RMAN and user managed backups.
• Implemented Streams replication between RAC and non-RAC database environments.
• Installed Oracle 10g Enterprise Manager (Grid control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Assisted a team of DBA's in upgrade of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle Cost Based Optimizer (CBO) SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager and Statspack.
• Performed conversion single instance to Real Application Cluster (RAC) Database instances.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.

Environment: s:Windows 2000/2003/XP, Oracle 10g, 9i, DataGuard, RMAN, Red Hat Linux, Sun Solaris, UNIX Scripting, PL/SQL, TKPROF, Explain Plan

Confidential

Oracle DBA

Responsibilities:

• Installation of Oracle Database and Oracle products.
• Implementing Backup/Recovery Strategies.
• Using Enterprise Backup utilities for backup.
• System tuning for better performance.
• Creating users, roles and maintaining database security.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Designing and enforcing standards and naming conventions.
• Co-coordinated, and delivered Oracle courses such as Database Administration, database security, enterprise backup and recovery solutions, PL/SQL concepts.
• Writing UNIX shell scripts for backup and recovery.
• Involved in installation and configuration of Oracle databases on Linux and Windows NT.
• Writing SQL scripts to monitor database performance.
• Writing SQL*Loader control files for data loading.
• Problem trouble shooting and resolution.
• Database installation and instance creation.
• Database tuning, backup and recovery and general day-to-day activities.
• Systems analysis and design.
• Creating project plans and implementation schedules.

Environment: Oracle9i, RMAN, DBCA, TOAD, Erwin, UNIX, Sun Solaris, Red Hat Linux, AIX.