PROFESSIONAL SUMMARY:

• 7+ years of experience as Oracle Database Administrator, providing 24x7 production support as well as for Development databases on 11g/10g/9i databases on different OS Platforms.
• Good Experience in Installation and Configuration of Oracle 9i, 10g, 11g and 11gR2 RAC in UNIX/LINUX and Windows environment.
• Hands on Experience in installing, configuring and managing Oracle 11gR2 RAC with ASM.
• Excellent experience in OLTP/DSS database administration, implementing and managing Very Large Oracle Databases (VLDB).
• Implemented High Availability/Disaster recovery using RAC, Physical & Logical standby databases (Oracle Data Guard).
• Good experience in Golden Gate with replication of data in databases.
• Delivering Oracle Database performance - tuning services for customers with Explain Plan, TKPROF, AWR, ADDM, ASH, SQL Trace, ORADEBUG, 10g OEM Grid Monitoring, Oracle Diagnostics pack, Oracle Tuning Pack.
• Experience in regular Database Administration activities such as Upgrades, Migration and Patches.
• Cloned and refreshed databases using Data pump and RMAN with Commvault, VERITAS Net Backup & TSM.
• Performed Backup and Recovery activities using Recovery Manager for lot of databases.
• Performance tuning the database server at Instance, SQL, Memory, Disk I/O and at OS level.
• Experience in Benchmarking and capacity planning, scripts development, and documentation.
• Planned and implemented DR & high availability solutions using Oracle 11g Standby Database using Oracle Data guard.
• Experience in taking backups using COLD, HOT and writing scripts for these backups.
• Skilled in using tools such as SQL Developer and TOAD and loading data from flat files using SQL Loader and External Tables.
• Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
• Strong RDBMS, SQL & PL/SQL experience. Written Packages, Procedures, Functions, Triggers to incorporate complex business logic and also written shell scripts to automate day to day tasks.
• Replication of data using multi master replication environment.
• Writing shell scripts for automating various database activities like backup and recovery, performance tuning and managing archive data and dump and trace files.
• Excellent problem solving skills along with ability to work in dual Environment, team as well as individual.

TECHNICAL SKILLS:

Database: Oracle 11g/10g/9i/8i, RAC 11g/10g

Languages: SQL, PLSQL, Java, C, C++, XML, HTML, UNIX shell scripting

Operating Systems: Red Hat Linux 8/7/6/5, HP-Unix , Sun Solaris, AIX , DOS

Windows 2000/2003/XP/7/8:

Tools/Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, TOAD, Import/Export, SQL Developer, FTP, Data pump, MS Access, Data Guard

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle DBA

Responsibilities:

• 24x7 Production on call Database support.
• Installed and configured Oracle 11g with RAC and ASM on three nodes on Linux.
• Applied patches and patch sets on Oracle database and cluster ware.
• Upgrading of oracle database from Oracle 10g to Oracle 11gR2.
• Configured RMAN to backup for RAC database.
• Good experience of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities.
• Performed converting single node instance to RAC and Adding instance to the existing 2 node RAC.
• Applied patches for enhancement and fixing bugs using Opatch, Adpatch.
• Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR, Stats pack, ADDM, ASH reports, OEM Grid Control.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed Data pump operations for 10g and 11g Databases thru command line and involved database refreshes using data pump.
• Data loading from flat files and external files activities through SQL loader.
• Partitioned large tables to get the better performance and manageability.
• Performed Cloning of databases to setup Test and Development databases.
• Preparing, Configuring and Maintenance of Standby database using Data guard.
• Implemented Backup & Recovery procedures using level 0/level 1 using RMAN, Hot/Cold Backups using conventional method.
• Written and modified UNIX shell scripts and updated crontab for automating the database activities to manage Oracle environments.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager.
• Working knowledge in Oracle Grid control. Maintaining the grid control alerts, configuring the rules, notifications, setting up metric settings, blackouts, advisors (Segment Advisor, SQL Tuning Advisor, Memory Advisor, SQL Access Advisor), and administration and performance tuning of databases and servers.
• Implemented Oracle Streams 10g to capture, propagate, and apply the transfer of data, transactions, and events within managed databases. Replicated in OLTP as well as data warehouse environments.
• Working with Oracle support to resolve like ORA errors issues.

Environment: Oracle 11g RAC, 10g, Grid Control 10gR5, ASM, CommVault, Linux SuSE, RHEL 4,5, Shell Scripting, RMAN, Data Guard, Toad, SQL Developer.

Confidential, Redwood City CA

Oracle DBA

Responsibilities:

• Installed configured, maintained and tuned around 5 Oracle 10g and 11g databases.
• Installed and configured Oracle 10g RAC, Oracle 11g RAC with ASM.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Involved in Migration of Non RAC single instance to Real Application Cluster (RAC) database instances.
• Involved in Design, implementation and generating documentation of Oracle 10g, 11g Data Guard on both physical/logical standby databases in high availability mode.
• Performed capacity planning and bench marking.
• Implemented Data guard, creating both Logical and Physical Standby databases in 10g RAC, 11g Troubleshooting errors that occurs one daily basis and resolving problems quickly and efficiently and giving suggestions to developers when they are required for tuning the code to maximize performance of the database.
• Implemented Cumulative, Differential, Incremental backups using RMAN.
• Written and modified UNIX shell scripts, to manage Oracle environments.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Creating & Managing Database Structures, Storage Allocations, 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.
• Organized various migration review meetings with the application team to discuss the migration strategy based on business requirements.
• Cloning & duplicating databases using scripts as well as RMAN for QA and developers.
• Experience in Database Security User Management, Privileges, Roles, Auditing.
• Applied security patches, Patch Set Unit PSU and Performed testing.
• Written monitoring scripts and scheduled them using the Crontab.
• Worked closely with the Oracle developers for the better performance in Applications in writing the efficient SQL and PL/SQL Packages, Procedures, Functions and Triggers.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Working with Oracle support to resolve critical issues like ORA-600 errors.

Environment: Red Hat Linux, AIX, Oracle 10g RAC and 11g RAC, Oracle Enterprise Manager/Grid Control, RMAN, Data Guard, ASM, SCP/SFTP, Net App, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, Crontab, PL/SQL, SQL* Loader.

Confidential, Houston TX

Oracle DBA

Responsibilities:

• Involved in 24x7 supports for Production database and applications with on-call pager.
• Installed, configured and maintained Oracle 11g R2 on Linux also upgraded from Oracle 10g to 11g.
• Installation and creation of 10g RAC and 9i databases for Testing, Development and Production.
• Installed RAC on Oracle 10g and using OCFS2 feature of Oracle.
• Supported upgrades from oracle 9i to 10g, 9i/10g.
• Performed migration from 9i to 10g from AIX to Linux.
• Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Involved in Dimensional   Data   Modeling, Relational   Data   Modeling , Dimension Tables, Conceptual, Logical and Physical   Data   Modeling using ER Studio, E r win and Power Designer.
• Creating tablespaces, sizing the system tablespace, allocating default tablespaces for users.
• Creating tables and indexes, sizing their extent, partitioning and so on.
• Creating users with restricted access, with default and temporary tablespaces.
• Creating roles and granting to users based on their group requirements.
• Resolving SQL tuning issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Experience in SQL*Loader, loading data from text files.
• Experience in writing shell scripts for automating various database related tasks as well as for backups and restoration.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard. Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Performed scheduling of Change Control-activities and scheduling jobs.
• Tuning SQL queries using TKPROF, EXPLAIN PLAN, and SQL TRACE.
• Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities. Write UNIX Shell Scripts to schedule these activities.
• Contact oracle metalink to resolve database issues and to raise SR’s.

Environment: Oracle 11g/10g/9i, ASM, HP-UX, Red Hat Enterprise Linux 4.2, OEM, Explain Plan, SQL, PL/SQL, Tkprof, Erwin Power Designer, SQL*LOADER.

Confidential, NJ

Oracle DBA

Responsibilities:

• Install and Setup of 10g Grid Control, upgrade to 10.2.0.3 for HA i.e., on Veritas Cluster Server (VCS) on Production and 10.2.0.4 on Development.
• Installed 10.2.0.1 Agents on many hosts, patched them to 10.2.0.3 on Production and to 10.2.0.4 on Development.
• Applied patches, upgraded databases to 10.2.0.3.
• Performed Backup and Recovery Activities using RMAN.
• Created the catalogue and registered the databases for RMAN.
• Worked with application teams, collected relevant information and provided DBA support to resolve the performance issues.
• Involved in application releases on Production.
• Involved in reorganizing the tables and rebuilding the indexes that are highly fragmented to improve the performance.
• Table fragmentation tuning, partitioning the existing large table by range.
• Managed tablespaces such as creation, reorganization and modification of storage parameters for optimization of disk space and defragmentation.
• Created and maintained user accounts, roles, system & user level database objects.
• Copying schemas from one database to another through Transportable tablespaces.
• Responsible for performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, STATSPACK etc.
• Implementing Automatic Shared Memory Management for optimum utilization of memory.
• Used data pump to move the data for 10g databases.
• Applied DST/CPU patches to production and lower environment databases.
• Involved in the process of Conversion of the data through stored procedures.
• Written PL/SQL stored procedures, shell scripts for back populating tables as a part of release.
• Grouping the Procedures and Functions that were already written into respective Packages to increase the system performance.
• Performed various dev activities like schema changes etc.,
• Communicated with management and other branch offices regarding technical issues.
• Refreshed Test / Development / UAT databases from the production environment.
• Configured Physical standby environment for disaster recovery.

Environment: Oracle 11g/10g/9i, UNIX Shell Scripting, RHEL, WINDOWS, RMAN, PL/SQL, OEM, SQL*Loader.

Confidential

Oracle DBA

Responsibilities:

• Installation, Implementation and Maintenance of the Oracle database.
• Created and managed the database objects such as tables, indexes and views.
• Handled Space management activities as part of 24X7 Production support in the environment of large database.
• Administrating different Databases using Grid control, Configuring and testing Grid Software.
• Managed tablespaces such as creation, reorganization and modification of storage parameters for optimization of disk space and defragmentation.
• Created and maintained user accounts, roles, system & user level database objects.
• Created and managing the database storage structures which include data table spaces, index table spaces, rollback table spaces and rollback segments.
• Loading the database with SQL*Loader.
• To improve the performance by Using the Hints, Indexes, Explain Plan, SQL Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data.
• Performing the logical and physical structure of tables, indexes, modeling normalization and foreign key constraints
• Database maintaining including backups, recovery, imports/exports
• Monitoring the database daily activities.
• Worked with application teams, collected relevant information and provided DBA support to resolve the performance issues.

Environment: Oracle 10g/9i, SQL, PL/SQL, TOAD, Oracle Enterprise Manager, SQL*Loader, Sun Solaris, Red Hat Linux, Windows 2003.