SUMMARY

• 16 plus Years of experience focusing on Database Administration, database modeling, designing and development in Oracle 11g/10g/9i/8i/8/7.3.
• Experienced in Installing patches and upgrades of Oracle database software as well as in migrating and relocating from one OS platform to other.
• Versed in managing and supporting Oracle production/development databases 24x7 in order to ensure maximum availability.
• Proficient in managing objects, users, privileges, and roles.
• Experienced in implementing and managing Oracle 11g/10g RAC (Real Application Clusters) with Automatic Storage Management (ASM) and DataGuard.
• Experienced in setting up and using Oracle streams.
• Versed in Loading external data into the database using SQL*Loader, External Tables, etc. and moving data from one database to other using Data Pump Export/Import.
• Adept in Planning and scheduling database backups using Oracle Enterprise Manager (OEM), RMAN scripts or user managed.
• Familiar with moving data using Cross - Platform Transportable Tablespaces (TTS) and in Oracle Database Heterogeneous Connectivity for transparent access to data in non-Oracle systems.
• Experienced in Database cloning and relocation activities.
• Proficient in Implementing privacy, security, and auditing using advanced features.
• Well versed in configuring SQL*Net and security for the listeners.
• Experienced in automating routine backup and monitoring tasks using Scheduler, unix shell scripting, RMAN scripts.
• Proficient in Performing backup and recovery using Oracle 10g's user managed backup, using RMAN or Enterprise Manager (cold backup/hot backup procedures).
• Experienced in creating, configuring, and utilizing Recovery Manager Catalog.
• Adept in performing all sorts of recovery like recovering from missing or corrupted data files, redo log group, control files, and recovery from block corruption etc.
• Well versed in using Flashback Query (FBQ) and Automatic Undo Management.
• Proficient in utilizing, managing, and monitoring hot standby databases (Data Guard).
• Adept in Database Maintenance. DatabaseMonitoring and the use of advanced tools like Automatic Workload Repository (AWR), and Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH) andwellacquainted with Automatic Segment Space Management (ASSM), and automatically shared memory management (ASMM).
• Experienced in Performance Tuning, alert monitoring, alert log monitoring, and solving problems related to storage, indexing, SQL queries, DML operations, and other anomalies or errors.
• Proficient in performing interrogation of system events, wait states, and lock activities and take corrective action.
• Experienced in setting up and using Oracle's optimizer such as AUTOTRACE facility, Oracle's Cost Based Optimizer (CBO) and using hints to change execution plans.
• Adept in using tools like: LogMiner, DBVERIFY, STATSPACK, TKPROF, EXPLAIN PLAN, etc.
• Experienced in Moneta Installation and administration.
• Sound working knowledge about various Logical Volume Managers (LVMs), RAID technology, etc.
• Sound working knowledge about code migration, database change management, and data management through the various stages of the development life cycle as well as business object reporting platforms.
• Experienced working on OLTP, Data Warehousing, and ERP environment in various areas like Financial, HRM, etc.
• Focused, hardworking, deadline and goal oriented with a problem-solver's attitude.
• Flexible to adapt to new environment, willing to learn new technologies, and travel.
• Effective team player with good interpersonal and communication skills.
• Good Knowledge and understanding of Oracle 11i Application DBA, FLEXCUBE (oracle) Banking Application.

Hardware Platforms: Sun SPARC, Sun Fire, HP ProLiant, IBM X Series, Sun StorageTek, Sun StoreEdge, Dell R 900/710/6850/2950

Operating Systems: Sun Solaris 10/9, Red Hat Enterprise Linux 5, 4 & 3, Windows 2003/2000/NT, HP-UX 11.23/11.11 , IBM AIX 4.3.3/4.3.2

HA Clusters: Veritas Cluster Server, Sun Cluster, Veritas SFRAC, HP Service Guard, NetApp Cluster

RDBMS: Oracle 11g/10g/9i/8i/8, SQL Server 2005, MySQL, MS-Access 2007/2003

Languages: Java, C/ C++, PL/SQL

Tools and Utilities: Oracle Enterprise Manager, RMAN, SQL*Loader, SQL*NET, TKPROF, STATSPACK, PL/SQL Developer, Data Vault, Quest softwares like TOAD for DBA, shareplex etc., NetBackup, ErWin, and DBArtisan

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Tx

Role: Sr. Oracle DBA / Sr. Oracle Developer DBA

Description: Confidential, is a leading Telecom Service Provider, I am supporting work for Revenue Assurance Team which has production databases with various applications as well as multiple database instances that support development and testing.

Responsibilities:

• Designed Logical and Physical database and Installed Oracle 11g R2 5 node Real Application Cluster(RAC ), Automatic Storage Management (ASM) in Linux 5.3
• Provided 24x7 production support Managing Oracle 10g/11g RAC with oracle clusterware and non-RAC databases using Oracle Enterprise Manager (OEM) and Grid Control.
• Written stored procedure and shell script to Migrated SQL server to Oracle database.
• Successfully Migrated 6 SQL Server 2005 (Windows) database to Oracle (Linux 5.3) database, approximately Migrated 10 TB of Data.
• Installed, configured and administered Moneta Application and Configured scan IP in hibernate properties.
• Migrated Production Data center from Dallas to Fairland with minimal down Time
• Migrated HDS storage to VSU storage without downtime.
• Written Stored procedures and script to generate Moneta Performance statistics, Moneta data load timings, Moneta audit timings and to find unused control points.
• Written Stored procedures to Perform Advanced compression and saved storage.
• Created range, list and hash partition table and written procedure to add new partition and archive old partition and automated the same.
• Created synonyms and partition synonyms to avoid data duplicate in multiple schemas .
• Written procedures to monitor storage growth and send reports to managers for storage growth trend.
• Frequently tested and updated development databases to production as well as used database cloning.
• Monitored and managed redo log, archive log, and control filemultiplexed destinations.
• Actively involved in security administration adopting the principle of least privilege, managing default user accounts, implemented standard password security features, auditing database activity, and registering & applying security updates.
• Managed schemas, users, resource plans, logical/physical storage structures, memory, partitioning, replication, upgrades, migrations, patches etc.
• Monitored the databases using Automatic Workload Repository (AWR), and Automatic Database Diagnostic Monitor (ADDM).
• Solved storage-related problems on many occasions and used Flash Recovery Area, Automatic Memory Management, and Automatic Segment Space Management.
• Performed and maintained database backups using Enterprise Manager or RMAN as well as OS utilities.
• Deleted obsolete/outdated backups for easy management and efficient storage utilization.
• Configured and utilized Recovery ManagerCatalog.
• Used Oracle Scheduler, UNIX shell scripting /CRON jobs for automating various tasks.
• Extensively used dynamic performance views, data dictionary, as well as Enterprise Manager to monitor the database and perform tuning activities.
• Proactively monitored alert log and various trace files to look for potential as well as intervened in order to resolve problems.
• Participated in the configuration of the databases for minimal/no data loss and speedy recovery in case of critical failures.
• Assisted developers with embedded oracle scripts with various aspects of database like writing and tuning queries, writing triggers, functions, procedures, dynamic SQL scripting etc in .NET and JAVA environments.
• Monitored and managed databases to maintain high level of performance and availability as well as performed other routine DBA tasks.

Environment: Dell R900 / R 50 / 2950, Solaris 10/9, RHEL 5.3, Oracle 11g/10g/9i, Oracle APEX, JAVA, JDBC, NetApp Storage (VSU) and Hitachi Storage.

Confidential, Bangalore, India

Role:Sr. Oracle DBA / Flexcube Implementation Consultant

Responsibilities:

• Designed Logical and Physical database and Installed Oracle 10g 2 node Real Application Cluster(RAC), Automatic Storage Management (ASM) in IBA Aix 4.3.2
• Provided 24x7 production support Managing Oracle 10g instances on Real Application Cluster (RAC) environment with oracle clusterware using Enterprise Manager Grid Control as well as database control.
• Installed and supported Flexcube software core banking application
• Configured and administered Standby database (DataGuard), Automatic Storage Management (ASM), and oracle Streams in order to ensure maximum availability.
• Monitor and performance tuning Oracle databases for optimal performance.
• Experienced in embedded oracle scripts.
• Developed RMAN scripts and for database backups.
• Used Shell Scripting, and DBMS SCHEDULER for scheduling various tasks.
• Assisted developers with various aspects of database and in SQL/PLSQL tuning in C / C++, J2EE, and .NET environments.
• Used information from various dynamic performance and data dictionary views to monitor database performance and carry out performance tuning tasks.
• Managed Users, Privileges, Roles, and Resources.
• Migrated data from SQL Server, Cobol & Access to Oracle database
• Actively involved in security administration adopting the principle of least privilege, managing default user accounts, implemented standard password security features, auditing database activity, and registering & applying security updates etc.
• Configured services and listeners using oracle Net Manager.
• Wrote Oracle database triggers, functions, procedures, and packages.
• Optimized database performance by analyzing objects, ensuring current statistics, creating indexes and views.
• Used Data Pump Import/Export to move large amounts of data. Performed database cloning whenever necessary.
• Monitored Flash Recovery Area and various logical and physical storage structures and prevented space-related problems.
• Maintained a STANDBY database for the production system.
• Responsible for other routine DBA activities.

Environment: Sun Fire, IBM X Server, Sun Solaris 10, Oracle 10g/9i, Oracle Developer 2000, AIX 4.3.2, Weblogic 8.1/7.0, Hitachi SAN.

Confidential, Muscat, Oman

Role: Sr. Oracle DBA / Sr. Application Developer

Responsibilities:

• Planned and implemented Oracle software installations, upgrades, and patches.
• Formulated backup strategy (RMAN backup) and performed restore, and recovery.
• Managed Oracle 10g/9i/8i instances and performed Oracle 10g RAC (Real Application Clusters) installation with ASM.
• Developed RMAN scripts for database backups for both RAC and single-instance databases.
• Used information from various dynamic performance and data dictionary views to monitor database performance and carry out performance tuning tasks.
• Administered Oracle database triggers, procedures, functions and packages and other database objects.
• Created and managed indexes, index organized tables, and clustered tables to improve query performance.
• Monitored Flash Recovery Area and used Automatic Segment Space Management, and Automatic Memory Management for 10g databases.
• Actively involved in security administration adopting the principle of least privilege, managing default user accounts, implemented standard password security features, auditing database activity, and registering & applying security updates
• Migrated data from SQL Server to Oracle database.
• Responsible for resolving all database issues through experience and using oracle support using MetaLink to log TARs / SRs whenever required.
• Used Unix Shell scripts and DBMS Scheduler to automatic administrative tasks.
• Used Data Pump Import/Export to move data.
• Managed Schemas, Users, Privileges, Roles, Profiles, Resources, Listeners, etc.
• Performed database cloning, and used Shareplex 4.5/5.0 and Oracle Streams for the replication environment.
• Monitored various logical and physical storage structures.
• Maintained a STANDBY database (DataGuard) for the production system.
• Provided DBA support for developer requests as well as assisted developers.
• Performed other routine DBA activities.

Environment: Sun SPARC, Solaris 10/9, Oracle 10g/9i, Veritas Cluster server, Dell Power Vault, Windows 2003, SQL Server 2000, WebLogic 8.1/7.0

Confidential, Coimbatore, India

Role: Application Developer

Description: Confidential, is one of the Readymade Garment Exporting Company.

Responsibilities:

I was involved in development of PL/SQL, Forms & Reports and various database administration activities which include Oracle software install, patching, database creation/maintenance, and performance tuning.

Environment: Oracle 7.x, Sun-Solaris, Forms 4.5, Reports 2.5, Pro * C 2.0.6.0