SUMMARY

Over 8+ years of IT experience as an Oracle DBA. Expertise in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, troubleshooting database design, Unix shell scripting and documentation.

• Experience with working on various UNIX platforms (Solaris, HP-UX, AIX,Linux), Windows NT 4.0/2000/2003 with Oracle (9i, 10g, 11g), 10G RAC, 11gRAC, Streams, Data Guard and RMAN
• Involved in Installation, Configuration and deployment of Oracle database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM) and experience in adding and removing nodes.
• Expert in Installation, Configuration, Cloning, Trouble shooting and Performance tuning of oracle 8i/9i/10g/11g databases on Unix and Windows environments.
• Performed Backup and Recovery procedures in 24x7, Windows/Linux/Solaris environments using the incremental and full backup strategies.
• Hands on experience of database Backups and Recovery strategies using RMAN, Export Import Utility (Classical & Data Pump) and Transportable Tablespaces
• 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.
• Experience 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)andRMAN.
• Experienced in Database cloning and relocation activities.
• Experienced in automating routine backup and monitoring tasks using Scheduler, Unixshell scripting, RMAN local/global stored scripts.
• Experienced in creating, configuring, and utilizing Recovery Manager Catalog.
• Adept in performing all sorts of recoverylike recovering from missing or corrupted data files, redo log group, control files, and recovery from block corruptionetc.
• Proficient in utilizing, managing, and monitoring hot standby databases (Data Guard).
• Adept in Database Maintenance. DatabaseMonitoringand the use of advanced tools like Automatic Workload Repository (AWR), and Automatic Database Diagnostic Monitor (ADDM), andwellacquainted withAutomatic Segment Space Management(ASSM), and automatically shared memory management (ASMM).
• Experienced in Performance Tuning, alert log monitoring, and solving problems related to storage, indexing, SQL queries, DML operations, and other anomalies or errors.
• 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.
• Sound working knowledge about various Logical Volume Managers (LVMs), RAID technology, etc.
• Experienced working on OLTP, Data Warehousing, and ERP environment in various areas like Banking, telecommunication, etc.

TECHNICAL SKILLS

Hardware Platforms : Sun SPARC (E10000, E3500, E250, SUN Ultra and R Class), IBM AIX, IBM compatibles (IBM AIX 5L/4.3), Dell poweredge
Operating Systems : Sun Solaris 10/9, Red Hat Enterprise Linux 3,4,5, Windows 2003/2000/NT, HP-UX 11.23/11.11, IBM AIX 5.3,6.1
HA Clusters : Veritas Cluster Server, Sun Cluster, Veritas SFRAC, HPService Guard, NetAppCluster
RDBMS : ORACLE 11g(11.2.0.3),10G(10.2.0.4), 9i(9.2.x)
Languages : Java, C/ C++, SQL, PL/SQL
Tools and Utilities : Oracle Enterprise Manager, RMAN, SQL*Loader, SQL*NET, TKPROF, STATSPACK, PL/SQL Developer, Data Vault, Quest software’s like TOAD for DBA etc.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville FL April 2010 –Till Date
Role: Oracle DBA
Responsibilities:

• Installed and configured oracle 11gR2 RAC on AIX 6.1
• Upgraded 10g CRS and ASM to 11g Grid.
• Performed database migrations from 10g RAC (10.2.0.4) to 11gR2 RAC (11.2.0.2).
• Installed and Configured Oracle 10g and 11g Real Application Cluster (RAC) Instances with stand by database (data-guard) using CRS and ASM.
• Added nodes to the RAC cluster for the increased load and removed it when not necessary.
• Maintain and Support Oracle Databases in 10g/11g running on AIX/Solaris platforms that includes backup and recovery, performance tuning etc.
• Data Refresh from Production to SIT/UAT/LT and Development environments using RMAN Duplicate Database.
• Setup, Configured and supported Physical Standby (Data Guard) databases for high availability and disaster recovery.
• Took Hot and Cold backups, Performed Full and Point in Time Recoveries using RMAN, investigated causes for failures and resolved them.
• Generated Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM)reports for the health check of the databases.
• Created users, roles and granted privileges according to the business requirements.
• Migration of code from development to production instances, database space and file system space monitoring, purging of unwanted data and files.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low disk spacesandPerformance issues.
• Applied CPU and quarterly patches in the development and production environments using Opatch utility.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Creating and refreshing materialized views, views, synonyms, and indexes.
• Developed UNIX Shell scripts for daily database logical backups, data retention, purging and other scheduled database procedures
• Installed foglight and OSWatcher on various database servers.
• Worked with Oracle support to resolve database critical issues.

Environment:Sun Solaris 10/9, HP-UX, AIX5.3/6.1, RHEL,Oracle 11g/10g,RAC, Data Guard.

Confidential, Nashville TNSept 2009 –April 2010
Role:Oracle Database Administrator
Project Description: TFACTS Tennessee Family and Child Tracking System, is a Web Services based technical architecture case management system that will support county and state program practice. The system will be easy to use enabling DCS (Department of Children Services) workers to electronically record, retrieve, and present child welfare information consistent with the Federal SACWIS requirements as determined by the administration for children and families. The project has tracks comprising of Intake, Case Management, Finance Management, Resource Management, and Common Functions.

Responsibilities:

• Responsible for administration and supporting Oracle 9i, 10g and 11g databases.
• Installation, Upgrade and Configuration of Oracle (10g and 11g).
• Involved in designing of disaster recovery using Data Guard, High Availability using RAC.
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins.
• Configuration, maintenance and tuning of Oracle 10gRAC.
• Installing and configuring Recovery Manager (RMAN) and Flash Recovery.
• Taking Backups on scheduled time and monitoring scheduled Backups through RMAN.
• Cloning databases using scripts as well as RMAN.
• Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Responsible for creating the training databases used for training the users over the entire state.
• Periodically refreshing the SIT/UAT databases from Production database.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Involved in the process of data extract coming from various data sources (DB2, FoxPro, Oracle 8i) and loading into staging area.
• Performed database tuning using Explain Plan, TOAD, and Enterprise Manager.
• Establish standby/cloned databases via Data Guard for Database Disaster Recovery. Created, procured, and maintained various database-related documents such as manuals and spreadsheets
• Extensive UNIX Shell scripting in csh, ksh.
• Involved in Data Migration / Conversion Process.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team. Daily Health Check Up of the Database using STATSPACK, AWR, ADDM.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Developed scripts to duplicate the golden data to 2000 users to enable the statewide training of the application.

Environment:RHEL 5, Oracle 10g/11g, 10gRAC, OEM grid control, TOAD 9.6,DBF viewer2000, Apache/TomKat Web server.

Confidential, Richmond VA Feb 2008 –Aug 2009
Role: Oracle DBA

Responsibilities:

• Provided 24x7 production support Managing Oracle 10gRACwith oracle clusterwareand non-RAC databases using Oracle Enterprise Manager (OEM) Grid Control.
• Used Automatic Storage Management (ASM) for multiple instances of Oracle 10g
• Frequently tested and updated development databases to production as well as useddatabase cloning.
• Monitored and managed redo log, archive log, and control filemultiplexed destinations.
• Implemented privacy, security, and auditing.
• Managing schemas, users, resource plans, logical/physical storage structures, memory, partitioning, replication, upgrades, patches etc.
• Monitored the databases using Automatic Workload Repository (AWR), and Automatic Database Diagnostic Monitor (ADDM).
• Solved storage-related problems on many occasions.
• Performed and maintained database backups using Enterprise Manager andRMANas well as OS utilities.
• Deleted obsolete/outdated backups for easy management and efficient storage utilization.
• Implemented test to switch any standby database / Oracle Data Guard to the production role for minimizing the downtime associated with outage and preventing any data loss.
• Configured and utilized Recovery ManagerCatalog.
• Used Oracle Scheduler, UNIX shell scripting/CRON jobs for automating various tasks.
• Created Oracle Streams for high replication topology among multiple databases using Oracle AQ. Proactively researched application of RAC along with Oracle Streams for different production databases for High Availability and Load Sharing.
• 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 thedatabases for minimal/no data loss and speedy recovery in case of critical failures.
• Consulted frequently and participated with the database design team and adhered to the business rules and maintained documentations and standards.
• Monitored and managed databases to maintain high level of performance and availability as well as performed other routine DBA tasks.

Environment:Sun SPARC, Sun Solaris 10/9, HP-UX 11.23/11.11, Oracle 10g/9i, Oracle 10g Application Server, Oracle Data Vault.

Confidential, Cherry Hill NJ Jan 2007 – Dec 2007
Role:Oracle DBA

Responsibilities:

• Provided 24x7 production support Managing Oracle 10g instances on Real Application Cluster (RAC) environment with oracle clusterwareusing Enterprise Manager Grid Control as well as database control.
• Monitor and performance tuning Oracle databases for optimal performance.
• Developed RMAN scripts for database backups.
• Assisted developers with various aspects of database and in SQL/PLSQL tuning.
• 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.
• Configured services and listeners using oracle Net Manager.
• Wrote Oracle database triggers, functions, procedures, and packages.
• Optimized database performance by analyzing objects, generating statistics, creating indexes and views.
• Responsible for loading data into Data Marts (data warehouse) using Oracle Streams by capture, staging and consumption mechanism.
• Used Data Pump Import/Export to move large amounts of data. Performed database cloning whenever necessary.
• Monitored 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,WebLogic 8.1/7.0, Hitachi SAN.

Confidential, Denver, CO April 2006 – Jan 2007
Role: Oracle Database Administrator

Responsibilities:

• Planned and implemented Oracle software installations, upgrades, and patches.
• Formulated backup strategy (RMAN backup) and performedrestore, and recovery.
• Managed Oracle 10g/9i instances and performed Oracle 10g Real Application Clusters (RAC) installation.
• Developed RMAN scripts for database backups for both RAC and single-instance databases.
• Used information from various dynamic performanceand 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.
• 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 Data Pump Import/Export to move data.
• Managed Schemas, Users, Privileges, Roles, Profiles, Resources, Listeners, etc.
• Monitored various logical and physical storage structures.
• Maintained a STANDBY database 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, Parsippany NJ Nov 2004 – March 2006
Role: Oracle Database Administrator

Responsibilities:

• Provided support for Oracle 10g/9i on Sun Solaris in a 24x7 production environment.
• Monitored and supported geographically distributed databases in close association with senior DBAs, system and Network administrators.
• Conformed to business rules.
• Performed regular backups and recovery.
• Setup and managed Oracle Streamsreplication environment.
• Performed data backups using RMAN on disks as well as on tapes.
• Upgraded databases from 9i to 10g and applied the requiredpatches.
• Participated in consultation with the Application development teams and provided DBA supportto the developers.
• Evaluated, recommended and installed various softwares on a regular basis.
• Upgraded and applied patches.
• Wrote UNIX scripts to automate periodic tasks.
• Participated in cloning, creating and maintaining schemas, and performance tuning and monitoring.
• Performed other core database administration activities.

Environment:HP-UX,AIX, Oracle Database 10g/9i, Sun Solaris 9/8, windows 2003/2000, TOAD 7.5

Confidential, Bangalore India June 2003 – Oct 2004
Role: Oracle DBA/Oracle AppsDBA

Responsibilities:

• Worked as a member of a database design and data analysis team for both the above mentioned projects accompanied by data architects and produced data models closely following all the business rules and requirements i.e.Participated in Physical and Logical Modeling of databases.
• Installed oracle software and associated applications.
• Assisted in the formulation of backup, recovery and storage strategies.
• Managed rollback segments.
• Used SQL*Loader and External tables to load external data into the database.
• Configured Oracle Networking and monitored database listeners.
• Proactively isolated or provided recommendations to potential performance issues like database performance, and I/O different kinds of performance problems.
• Performed DBA roles like performance tuning, managing database security, managing users, privileges, roles, windows batch scripts etc.
• Wrote functions, procedures, triggers and assisted the application development team.

Environment: Windows 2000, Oracle 9i/8i, Oracle Parallel Server, TOAD 7.0

B E in Computer Engineering

Relocation:Willing to relocate to any place in USA