SUMMARY

• Over 7+ 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 R2 (10.2.03) RAC, 11g R2 (11.2.04) RAC, 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 r2/11g r2, 12c databases on UNIX and Windows environments.
• Strong expertise in OEM 11g/12c, Performance Tuning, Data Guard, Golden Gate, Backup, Restore/Recovery using RMAN and experience in managing large scale database environments and mission critical OLTP/OLAP systems.
• Performed Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup and IBM Tivoli Storage Manager (TSM).
• Migrated databases using Golden Gate, Transportable Table space (TTS) and Data pump from 9i, 10g to 11g.
• Hands on experience of database Backups and Recovery strategies using RMAN, Export Import Utility (Classical & Data Pump) and Transportable Table spaces
• Experienced in Installing patches and upgrades of Oracle database software as well as in migrating and relocating from one OS platform to other.
• Experience in working with Oracle 11G R2 Data guard using Fast Start Failover (FSFO) and Observer.
• 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.
• Good experience and Working knowledge on SQL Tuning and Query Optimization. Also worked on referential integrity, triggers and stored procedures.
• Adept in Planning and scheduling database backups using Oracle Enterprise Manager (OEM) and RMAN.
• Experienced in automating routine backup and monitoring tasks using Scheduler, UNIX shell scripting, RMAN local/global stored scripts.
• 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.
• Experienced in Installation and Configuration of One node RAC. Configured instances on one node RAC to OEM.
• Proficient in utilizing, managing, and monitoring hot standby databases (Data Guard).
• Adept in Database Maintenance, Database Monitoring and the use of advanced tools like Automatic Workload Repository (AWR), and Automatic Database Diagnostic Monitor (ADDM), and well acquainted with Automatic 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.
• Proficient in Installation, Cloning, Patching, space management issues and user management issues related to Oracle Applications, registration of forms and reports, which were developed as part of customization process with Oracle Applications.
• Experience in converting Database into Oracle Application Table space model (OATM).
• Backup and Recovery, Optimal Flexible Architecture (OFA).
• Experienced in storage management of the database for installing future applications.
• Experience in interacting with Data Modeling team and knowledge in using Data Modeling tool ERwin.
• Good knowledge and understanding on EXADATA concepts like Hybrid Columnar Comparison (HCC), Storage Loader and Smart Scan.
• Knowledge of Data warehouse Application Console (DAC) Architecture
• Experience in developing Oracle PL/SQL based applications using Oracle Stored Procedures, Functions Packages, Triggers, Materialized views.
• 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: Log Miner, 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.
• Have strong analytical, administration and problem-solving skills dedicated to maintain the high quality standards.

TECHNICAL SKILLS

Hardware Platforms: Sun SPARC (E10000, E3500, E250, SUN Ultra and R Class), IBM AIX, IBM compatibles (IBM AIX 5L/4.3), Dell power edge

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, HP Service Guard, Net App Cluster

RDBMS: ORACLE 11g(11.2.0.3),10G(10.2.0.4), 9i(9.2.x)

Languages: Java, C/ C++, SQL, PL/SQL, Perl, UNIX Shell scripting.

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

Oracle DBA

Responsibilities:

• Involved in administrating 10+ production databases of size ranging from 300GB to 1.2TB
• Performed Installation, configuration, and upgrade of Oracle database 11.2.0.2 and upgraded to 11.2.0.4 on RHEL 5U3 and 6.1.
• Worked on multiple RAC environments having 2 to 5 modes per cluster.
• Installed Agents on database servers and configured enterprise manager 12c (OEM).
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up production databases.
• Refreshed non-prod environments frequently from production using RMAN script.
• Proficient in troubleshooting node reboots in Oracle RAC Environment and also worked on WebLogic environments.
• Created Users, Roles and Profiles, Privilege management with role-based security.
• Monitored Table spaces, data maintenance, and User management.
• Experience in migrating the database between servers using DATAPUMP.
• Experience in Patch Analysis and applying the patches as needed to upgrade the oracle database server.
• Experience in ASM file system, cloned the RAC environments with ASM as database storage system.
• Involved in installation of 11g (11.2.0.2) Grid control on RHEL 5U3.
• Worked on shell scripts to automate the backups and mail alerts for scanning the disk size utilization for every fixed time and refresh of instance in Crontab.
• Implemented materialized views for Oracle 10g and 11g Databases.
• Worked 24x7 with on call support.
• Monitored the alert log for all the production databases for issue and provided the solution as required.
• Performed the auditing tasks by running the SQL and shell scripts provided by the oracle support.
• Created and Implemented PL/SQL packages for specific functioning of oracle database for retrieving data, creating flat files and XML files to transfer data to manufacturing end client location.
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Migrated database from ASM to Non-ASM using RMAN, Recovered data files from block corruption using RMAN.
• Golden Gate (10.x and 11.x) replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments, performed DDL replication using Golden Gate.
• Maintained Unidirectional and Bi-directional Oracle-to-Oracle replicated environments utilizing Golden Gate.
• Created Partition’s, estimated stats on one partition and copied the stats to remaining partitions using DBMS STATS.
• Supported ORACLE FORMS in resolving the gaps between the FORMS functioning and the database level issues.
• Implemented triggers to monitor the end to end OLTP transactions and create logging if any errors from ORACLE FORMS to SAP via Oracle database.
• Worked on resolving the startup defect of WebLogic server.
• DBA activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, table spaces, indexing, data maintenance, user management, and maintenance and solving critical errors like ORA-600, ORA-7445.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as TKPROF, STATSPACK, Explain plan and SQL*Trace.
• Experience with SQL, DDL, DML, DCL, PL/SQL coding, stored procedures, functions, packages, triggers and Periodically uploading data from flat files using SQL*Loader.

Environment: Oracle 10g, 11gR2, RHEL 5U8, RHEL 6.1 OEM, SQL loader, SQL*PLUS, RMAN, Data Pump, RAC, ASM, TOAD, EXPLAIN PLAN, TKPROF.

Confidential, Cleveland

Oracle DBA

Responsibilities:

• Installed and configured oracle 11.2.0.2 RAC on AIX 6.1 and upgraded to 11.2.0.3
• Upgraded 10g CRS and ASM to 11g Grid.
• Performed database migrations from 10g RAC (10.2.0.3) 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.
• Installed and configured 12c grid Infrastructure
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Installed 11g Oracle Database/ASM binaries on Linux and AIX Environment both Standalone and RAC
• Installed and configured single Instance, 2-node, 4-node 11G Grid Infrastructure binaries on 16+ servers.
• ASM Disk Configuration, mounting and re balancing tasks.
• Database migration through ASM.
• Have done tuning of Oracle Applications, Concurrent managers, Apache Server, Forms Servers, Reports servers.
• Expertise in RMAN duplicate from active database.
• Day to day performance monitoring and tuning of database.
• Diagnose and troubleshoot Database problems and failures.
• The work involves overall maintenance of ORACLE database, performance, tuning, backup, recoveries and other database related activities
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in the Design (Logical & Physical) of Databases.
• Involved in installation and configuration of RAC on one node.
• Configured OEM for VERITAS cluster.
• Experience in using Grid control to monitor target databases.
• Preparing Backup and Recovery plan.
• Involved in administering Oracle database running on UNIX and Windows Machines to support Oracle database.
• Management of table space growth, monitoring data files additions, extent growth.
• Written stored procedures using PL/SQL in UNIX platform.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Creating logical standby database from hot backup of primary database
• Resolving gaps between primary and standby databases (Gap Resolution mechanism FAL )
• Building a Logical standby for Reports purposes.
• Installed and Configured Oracle Data guard for Oracle 11g & 10g for the maintenance of Stand by database.
• Implemented DATA GUARD (Standby) for high availability/disaster recovery purpose.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Setting up Data guard using switchover and failover with RMAN backup, Monitoring Database for fragmentation and correcting them.
• Setting up and maintaining user accounts and profiles.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Creating Databases and all database objects. Database Designing (Designing Table spaces and Undo Table spaces).

Environment: Oracle 11g with RAC, Oracle 10g, Solaris, Linux.

Confidential, San Jose CA

Oracle Database Administrator

Responsibilities:

• Maintain and Support Oracle Databases in 10g/11g running on AIX/Solaris platforms that includes backup and recovery, performance tuning etc.
• Migrated data on different Oracle versions of 10g and 11g and on different operating systems of AIX/Sun Solaris/Linux.
• 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 spaces and Performance 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 RMAN duplicate database from Active database
• Creating and refreshing materialized views, views, synonyms, and indexes.
• Debugged and Created new Oracle Reports and Oracle Forms programs based on user specifications.
• Developed UNIX Shell scripts for daily database logical backups, data retention, purging and other scheduled database procedures
• Installed fog light and OS Watcher 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, NY

Oracle Database Administrator

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.
• Knowledge and Experience in working with Oracle APEX.
• 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/Tomcat Web server.

Confidential, San Diego, CA

Oracle Database Administrator

Responsibilities:

• Provided 24x 7 productions support Managing Oracle 10g RAC with oracle cluster ware and 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 used database cloning.
• Monitored and managed redo log, archive log, and control file multiplexed 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.
• Involved in working with SOX and PCI security Issues.
• Performed and maintained database backups using Enterprise Manager and RMAN as 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 Manager Catalog.
• 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 the databases for minimal/no data loss and speedy recovery in case of critical failures.
• Participated in Golden gate configuration and maintenance on a large scale database.
• 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, MN

Oracle DBA

Responsibilities:

• Provided 24x7 production support Managing Oracle 10g instances on Real Application Cluster (RAC) environment with oracle cluster ware using 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, Web Logic 8.1/7.0, Hitachi SAN.

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

• Planned and implemented Oracle software installations, upgrades, and patches.
• Formulated backup strategy (RMAN backup) and performed restore, 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 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.
• Migrated data from SQL Server to Oracle database.
• Responsible for resolving all database issues through experience and using oracle support using Meta link 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, Web Logic 8.1/7.0.

Confidential

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 Streams replication environment.
• Performed data backups using RMAN on disks as well as on tapes.
• Upgraded databases from 9i to 10g and applied the required patches.
• Participated in consultation with the Application development teams and provided DBA support to the developers.
• Upgraded and applied patches.
• Wrote UNIX scripts to automate periodic tasks.
• Performed tuning and optimization on SQL queries using Explain Plan and TKPROF.
• Performed code reviews and developed test plans for all backend database modules.
• 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

Oracle Database Administrator

Responsibilities:

• Responsible for, both manage and support all Production, Development and Test instances of Oracle Applications 11.5.2, 11.0.3.
• Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH and ADCTRL.
• Created Shell script for daily refreshing an instance from Oracle Apps 11i Production instance.
• Creating the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords.
• Reorganization of the Database using export import.
• Database upgrade from Oracle Release 7.3.4 to Oracle Release 8.1.7.4
• Installing RHEL and Solaris for Oracle 8i testing and development purpose.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Design and development of major processing at the back-end through DB-Triggers, Stored Packages and Procedures using SQL and PL/SQL and SQL.
• Daily activities include monitoring batch application for performance and space requirements and tuning the system to optimize space and performance.
• Query optimization and tuning using tools like TOAD and SQL Loader.
• Provide technical assistance to developers in all matters concerning performance related issues.
• Assists in design tasks such as debugging, specifications development and system integration testing.

Environment: Linux 2.4, Oracle database 7i&8i, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader