PROFESSIONAL SUMMARY:

• Over Eight and Half years of experience as an IT professional as an Oracle DBA. Have experience of various projects in 12.1.0.2/11.2.0.4/10.2.0.3, 10.2.0.5/9.2.0.8 using RAC for HA and RMAN for Backup and recovery, Data guard for Disaster recovery, Installation, Configuration, Migration, upgrade, Capacity planning, cloning, patching, Performance tuning and Golden Gate for Unidirectional and Bidirectional database replication
• Experience in DSS database systems, managing large Oracle databases (VLDB) and data warehouse systems.
• Experience in the Oracle RDBMS including installation, configuration & administration of OLAP & OLTP systems
• Strong experience with Oracle Databases (11g/10g), RAC on different flavours of UNIX.
• Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA).
• Managing Oracle ASM File Access Control for Disk Groups.
• Proficient in implementation of Oracle Streams in unidirectional table level (local capture).
• Managed streams for data replication, data protection.
• Knowledge on Golden Gate Installation and Migration.
• Configured database 10g, 11g for ORACLE FLASHBACK TECHNOLOGY.
• Managed Materialized Views for data replication purpose.
• Strong Knowledge in Hot/Cold Backup and Recovery.
• Strong Experience in Cloning of databases using RMAN, User - Managed Backup.
• Worked with Oracle12c OEM.
• Very good experience in applying Patches (Patching), Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and runinstaller, also involved in Upgrading and Migration of a Oracle server to higher version available.
• Created and maintained immediate failover with up to the minute data to minimize the recovery time mission critical systems using oracle GOLDEN GATE (Testing Purpose).
• Experience in Implementing Data Pump, Export and Import using transportable tablespace.
• Involved in Monitoring, Optimizing Oracle database for Performance Tuning& system/modules for Application Tuning using tools like AWR, ADDM, ASH, SQL TRACE, and UTLBSTAT.
• Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 12c, 11g, 10g) for the purpose of monitoring multiple databases and application servers.
• Experience in implementing Authentication, Authorization and role based access control using OIM.
• Experience in product installation, configuration and upgrades for Identity and Access Management.
• Installed, configured, administered Oracle Golden Gate 11g application for real time transactions.
• Excellent Knowledge on Oracle Support processes with Embedded Empress RDBMS.
• Experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Korn Shell Scripting, Partitioning, Data modeling, oracle Data Dictionary - Meta data, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in maintaining Database Security using auditing.
• Expertise in loading data from flat files using external tables, SQL*Loader.
• Proven ability to adapt to demanding schedules and changing priorities.
• Very good experience in solving ORA-600, ORA-1555, ORA-7445 errors.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Linux RHEL 2.1, 3.x, 4.x, MS SQL Server 2000 & 2005,Windows NT,XP,V

RDBMS: Oracle 11g/10g/9i/8i, Oracle 10g/11g (RAC, Data Guard and Golden Gate)

Languages: SQL, PL/SQL, C, C++, Perl, Korn, UNIX Shell Scripting, VB, Advanced VB

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD

Tuning Tools: AWR, ADDM, ASH

Database Modeling: Erwin 4.0, Rational rose, UML 2.0

Other: EMC, NetApp, Veritas NetBackup

PROFESSIONAL EXPERIENCE:

Confidential, Henrico, VA

Senior Oracle DBA

Responsibilities:

• Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Installation, Cloning, Configuration and Administration of Oracle 11gR2 RAC.
• Installed RAC on Oracle 11gR2 and worked on ASM feature of Oracle.
• Created and maintained immediate failover with up to the minute data to minimize the recovery time mission systems using oracle GOLDEN GATE (Testing Purpose).
• I worked in managing multi-terabyte databases like more than 10 terabytes in this project.
• Upgraded Oracle Database from 10.2.0.4 to 11.2.0.3.
• Performance Tuning of test and production database, monitoring system. Tuning and diagnosing of database performance by query Optimization and trace facility Monitoring users, free spaces, table spaces and indexes.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).
• Involved in Datacenter Migrations, SAN Migrations and NAS Migrations.
• Installed, configured, administered Oracle Golden Gate 11g application for real time transactional change data capture as a part of POC.
• Installed, configured and supported Golden Gate (11g)replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments.
• Develop custom utilities to automate manually intensive tasks including mass schema changes, recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.
• Performed DDL replication and director tracing using Golden Gate.
• Set up backup and recovery procedure using RMAN and setup Autosys jobs.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Optimize and performance tune Vertica DB queries across multiple databases.
• Experience in designingVertica to run 24/7 enterprise multi-data center environment, including installation, configuration, backup, recovery and node failures.
• Created duplicate databases using RMAN duplicate.
• Created and Configured Physical Schemas, Logical Schemas, Models, Interfaces and Packages.
• Troubleshooting the issues on Oracle Data Integrator establishment and replication setup.
• Utilized SQL*loader and data pump import to load data into tables.
• Refresh schema using Export/Import. Creating the database, tablespaces, tables, indexes, settings privileges and user logins.
• Created different points of views and solved issues and identify and maximize the issues.
• Supported in oracle Identity and Access Management.
• Used Oracle Enterprise Manager (OEM) 12c, 11g, 10g Grid Control for monitoring multiple database and notification of database alert.
• Performance Tuning use of SQL diagnostic (ADDM, SQL Adviser) and Oracle utilities like AWR.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespaces.
• I know how to solve these errors ORA-600, ORA-1555, ORA-7445.
• 24x7 production database support.
• A self-motivated, responsible and reliable team player with a set of strong technical skills.
• Excellent analytical, interpersonal and communication skills.
• Enthusiasm in learning new technologies.

Environment: ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, Toad, AWR, ADDM, ASH, SQL, PL/SQL, DataPump, OEM, RMAN, SQL*Loader, NETBACKUP, Korn Shell Scripting, SQL Server, OLTP, Datacenter, SAN and NAS Migrations.

Confidential, LA, CA

Oracle DBA

Responsibilities:

• Involved in 24x7 supports for production RAC databases with on-call pager.
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installing 9i, 10g and 11g databases on Solaris and Linux.
• Skilled with AWR, ADDM to check health of database & hardware.
• Using the tools such as tkprof, explain plans, and trace files to tune SQL Queries.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Migration of Databases from Windows to Linux.
• Upgrade of Databases from 10g to 11g applying patches whenever required.
• Developed PL/SQL Packages from the scratch which are used for Extract Transform and Load purpose.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC and RAC Troubleshooting.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as PL/SQL, Oracle Hints, SQL Trace, Explain plans.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configure and manage tablespaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with Space Management and Security.
• Tuning high resource queries introducing hints and creating indexes/partitions, changing the query if necessary.
• Experienced with Data guard Implementation.
• Implemented oracle high availability solution using oracle 10g Physical Standby.
• Importing data from flat files into database using SQL loader and External Tables.
• Experienced in Volume management, Disk Management using volume manager.
• Written shell scripts to automate the tasks.
• Physical and Logical database design.
• Mapping of old data fields to new model data fields for data migration.
• Worked very closely with development team.

Environment: Oracle 9i, 10g, 11g RAC, ASM, Linux, Solaris, HP UX.

Confidential

Oracle DBA

Responsibilities:

• Troubleshooting RAC ASM and Oracle Cluster ware related issues.
• Involved and Implemented Disaster Recovery Plan (Oracle 10g Data Guard).
• Installed and used Oracle 10g OEM Grid control and TOAD in monitoring and accomplishing Database Administration issues.
• Monitoring infrastructure tier and middle tier processes using OEM 10g Application Control Consoles and database with OEM db console.
• Replicating schema/table level database using Streams. Performed unidirectional table level replication using Streams.
• Performed Backup/Recovery of the Oracle databases using RMAN Incremental & Hot Backup.
• Configured Recovery Manager (RMAN) like Advice on data recovery, parallel backup of the same file, and virtual catalogs for security.
• Restore and Recover, Cloning and Duplicating databases using scripts as well as with RMAN.
• Migration: Duplicated database using RMAN and upgraded it to oracle 10g/11g and applied latest patch set.
• Applied the bundle and CPU patches to all test, development and production databases.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Installed and Upgraded Oracle 9i(9.2.0.8) database to Oracle 10g(10.2.0.4) database.
• Migrated Database schemas and full Database using export and import utilities.
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases.
• Export and Import of Portal Schema using Transport Set utility and Oracle Internet Directory Users with LDIF utility.
• Database performance tuning using STATSPACK, TKPROF, SQL Trace and Explain Plan.
• Performed Database Administration activities such as Upgrades, Patches, TAR-Support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Developed Korn, Perl, shell scripts for automating the Database job processes.
• Involved in 24x7 Production Database Administration and support.
• Excellent Written and verbal Communication skills with a customer service oriented attitude.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges. Strong listening, interpersonal and analytical skills.

Environment: Oracle Server 11g/10g /9i, RAC, SQL, PL/SQL, Sun Solaris 9, HP-UX11, Red Hat Linux 4.x

Confidential

Oracle DBA

Responsibilities:

• Implemented 2 node RAC Database on Linux Operatin System.
• Proficient with Standby Database, Data Guard and Replication.
• Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
• Installed and supported OEM on Linux.
• Create table spaces, tables, and users for custom applications.
• Implemented and worked Streams, Data Pump, Export and Import utilities.
• Implemented and Involved in local and downward streams.
• Implement Hot, Cold and RMAN backup plans.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Performed database cloning to setup test and development database on different operating systems.
• Refresh/Cloning of Database and applications for development, testing.
• Database patching using opatch.pl perl script.
• Upgrading development and production databases to Oracle 9i to 10g.
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions).
• Experience in SQL tunning using STATSPACK, EXPLAIN PLAN and TKPROF.
• Data refresh from production to test and development.
• Installed and Configured Grid monitoring tool for Oracle 10g Database.
• Good knowlede of Developer Environment Setup, Support, Cloning and Refreshes.
• Used External Tables to Load data from flat files to database.
• Implemented different Partition methodologies to improve performance and manageability.
• Diagnose and troubleshoot Database problems and failures.
• Conducting sizing & capacity planning for Oracle databases.
• Perform SQL tuning and assist developers with coding PL/SQL
• Performed PL/SQL querying and troubleshooting errors in queries using TOAD tool.
• Write Korn shell scripts to monitor and maintain the Oracle database.
• Write SQL scripts to monitor tablespaces and extent growth.
• I know how to solve these errors ORA-600, ORA-1555, ORA-7445.
• Resolve various application failures due to data entry errors or system errors.
• Involves identifying problems and implementing corrective actions.
• Providing Solutions to the Problem Faced by end Users Or Programmers
• Automation of Startup Shutdown on all Production and Development Database.
• Worked with team to support 24x7 production environments.

Environment: HP-UX 11, Sun Solaris 2.8/2.9 RHEL 4.x, PL/SQL, Oracle 11g/10g Sql*Plus, UNIX Shell Scripts.