PROFESSIONAL SUMMARY:

• 8+ years of experience as an Oracle Database Administrator in the Database Installation, Development and Production System Support leading global teams in a wide variety of cutting edge environments.
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, streams, partitioning, database security, troubleshooting, database design, UNIX shell scripting, Korn shell scripting and documentation.
• Experience in OLTP/DSS database systems, managing large Oracle databases (VLDB) and data warehouse 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.
• I have strong experience in MySQL.
• Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 12c, 11g, 10g) for the purpose of monitoring multiple databases and application servers.
• Installed, configured, administered Oracle Golden Gate 11g application for real time transactions.
• Excellent Knowledge on Oracle Support processes for technical requests with Metalink.
• 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 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, VeritasNetBackup

PROFESSIONAL EXPERIENCE:

Confidential, Menomonee Falls, WI

Sr.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.
• Extensive knowledge of electronic medical records EMR system and web-based applications.
• 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.
• 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.
• 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.
• 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.
• 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, Richmond, VA

Sr. Oracle DBA

Responsibilities:

• Configured Data Guard to provide high availability by implementing 11g R2 Physical Standby database.
• Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Installation, Configure, setup of 11g RAC on Linux.
• Add new nodes to RAC 11g Cluster to distribute the load.
• Installed and implemented 10g RAC with 4 nodes with ASM.
• Upgraded Databases from 10g to 11g and applied patches as per requirement.
• Worked extensively on data center migrations on multiple database versions. i.e., 9i, 10g and 11g.
• Responsible for installing and configuring Golden Gate for Oracle using 11g R2
• Database migration from 10g to 11g.
• 24x7x365 production support.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
• Recovered databases and clone applications Using RMAN.
• Responsible for resolving several complex recovery scenarios (including RMAN) with critical production database.
• Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Performed Import and Export using Oracle Data pump utilities
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Used external tables and SQL*Loader to import data from flat files.
• Monitored database space requirements and adjusted for future needs.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administration.
• Create and maintain users, roles and privileges
• Generated ASH, AWR, ADDM reports from Grid Control and command line.
• Part of On-call rotation to support 24/7 every few weeks.

Environment: Oracle 10g / 11g Databases, 11g (Active) Data Guard, 10g/11g RAC

Confidential, Jacksonville, FL

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 veritas 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, Bothell, WA

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.
• I know how to solve these errors ORA-600, ORA-1555, ORA-7445.
• 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, Westchester, PA

Oracle DBA

Responsibilities:

• Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
• Performing Hot/Cold backups of the database through RMAN or User Managed method.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Perform database cloning/exp/imp to setupidentical databases in the production and development environments.
• Create and maintain users, roles and privileges.
• Upgrade/Migrated the production and development databases from 9i to 10.2.0.1 to 10.2.0.2
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Involved in Database sizing, Capacity Planning.
• Perform Space Management & Troubleshooting the database issues.
• Upgrading OEMRepository and InstallingOEM 10Grid Control to monitor all the databases.
• Configured and managed agents to work efficiently with Grid Control.
• Lead coordinator between technical operations team (DBA) and applications users/information systems/ processing specialists
• Generated ASH, AWR, ADDM reports from Grid Control and command line.

Environment: Oracle 9i, 10g, 11g RAC, ASM, Linux, Solaris, Data Guard.