PROFESSIONAL SUMMARY

• Highly accomplishment & deeply driven oracle database administrator with 8 years of progressive experience in Oracle DB Administrator, primarily in Production and Development environment, played different roles like Production /Development and Data Warehouse DBA. Experience in Build, Upgrades, Patches, Performance Tuning, Backup and Recovery, Space Management, Database Security, Cloning, Migration, Shell Scripting.
• Oracle implementation, planning, designing, installing and maintaining grid and database (12c/11gR2, 11gR1, 10g, 9i, 8i) on multiple nodes (RAC) on Sun Solaris 5.10, HP - Unix, Red Hat Linux, AIX 6.1 and Windows with ASM.
• Oracle 10g/11g/11gR2 RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM).
• Strong Oracle RAC Installation, Configuration and Tuning Skills on Red-Hat Linux and Sun Solaris.
• Expert in RAC related tools.
• Experienced in Backup and Recovery using RMAN, Veritas Net Backup.
• Expert in building and configuring DR sites.
• Expert in working with Dataguard, Snapshot Standby, Switch over and Fail over of DR sites during Stress test and Data center power down.
• Created Clone databases in Dev and Test environments using RMAN cloning procedure as well as User manual cloning.
• Experience in backups and recovery using shell scripting, RMAN and media managers using Tivoli and Legato
• Performance Tuning of the database (I/O Tuning, Tuning Contentions) using AWR, ADDM, Advisories, TKPROF, EXPLAIN PLAN for the Better performance.
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Good experience in resolving the issues related to installation, upgrades and patches.
• Experience in Implementing Streams (Oracle Golden Gate), Data Pump, Export and Import utilities.
• Expertise in creating and scheduling jobs through OEM.
• Experience in database RMAN full and incremental backups (hot and cold), DataPump, Export/Import, backup and Restore procedures.
• Worked with 12c Grid OEM and Installed GRID agent clients on target databases.
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes from PROD to UAT/QA/SIT and development databases using RMAN and Datapump.
• Excellent Troubleshooting skills in OS level and Database level.
• Written shell scripts in UNIX and scheduled the job using CRON and Tivoli scheduling.
• Good experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in SQL, PL/SQL, and developing various Data Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.
• Proficient in SQL,PL/SQL, Perl Scripting, Shell Scripting, ERwin Data modeling, Oracle Data Dictionary - meta data, Logical and Physical Database Design.
• Worked with Oracle Streams for Replication of data from source to target databases.
• Experience in maintenance of Production, Testing,Development,RAC, Standby databases/ DataguardforOLTP, Decision Support Systems (DSS) Data Warehouseenvironments.
• Back-end programming, databaseTriggers, stored procedures and functions usingPL/SQL.
• Job scheduling using Shell scripts/AUTOSYS/Control-Mfor automatingDBAtasks.
• Good team player and supported 24/7 on-call support.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11gR2/11g/10g/9i/8.

APPLICATIONS, & TOOLS: DBCA, DBUA, Oracle Data Guard, Oracle Golden Gate, Oracle Audit Vault, ASMCMD, OEM, RMAN, ASM, clusterware, Shareplex, EXADATA, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, ERwin, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR and ADDM.

Application Servers: Oracle Application Server (9i, 10g & 11g), Apache

High Availability: (RAC) Clusterware 11g and 10g

LANGUAGES: SQL, PL/SQL, C, C++, UNIX Shell Scripting, bash Scripting.

OPERATING SYSTEMS: Sun Solaris 5.8, 9, 10, Linux RHEL 2.1, 3.x, 4.x, 5.x and WindowsNT/2000/2003/XP.

PROFESSIONAL EXPERIENCE

Confidential, Sterling, VA

Sr. Oracle Database Administrator

Responsibilities:

• Providing Installation, Configuration and Administration of Oracle 10g/11g/12c on different platforms like Linux and HP-UX.
• Performing Cross platform upgrade of Oracle 10g/11g from AIX to Linux.
• Ensuring the high availability and integrity of databases.
• Writing UNIX shell scripting for automating the jobs.
• Configuring standby databases for all the existing production systems.
• Performing Installation of RAC with ASM and Configuration with Custom Applications and Oracle Applications.
• Providing Database administration support on 11g Database with RAC.
• Performing support for 1TB 3 Node production RAC database.
• Performing Backup and recovery utilizing RMAN.
• Troubleshooting and resolving performance issues with OLTP and Data Warehouses Databases.
• Applying the Oracle security patches and application patches using the OPATCH and AD PATCH utilities.
• Performing advanced portioning on VLDB (8TB) databases.
• Performing Configuration and building Golden Gate Extracts/replicate for multiple databases.
• Configuring error handling for restart, logging, production support and status reporting in Golden Gate
• Performing Troubleshooting and Performance Tuning Golden Gate replications
• Implementing necessary monitoring scripts for Golden Gate in UNIX/Perl scripting.
• Performing Installation and configuration of logical standby database and Data Guard for high available production instances.
• Implementing Oracle Enterprise Manager (OEM) and configuring all the databases
• Utilizing Automatic Storage Management (ASM) for managing data in SAN.
• Creating logical and physical models using ERWIN which includes forward engineering the DDL from the MODEL.
• Creating and maintaining DBMS objects tables, indexes, views, sequences, triggers, packages, partitioning, compression and data encryption
• Assisting ETL, Report developers with performance tuning ETL jobs & report execution.
• Creating database maintenance scripts using SQL, PL/SQLand Shell scripts.
• Performing SQL tuning to improve the database performance.
• Performing Replication of the Production database for setting up instances for the QA and Testing teams.
• Provided 24x7 production support and On-Call rotation

Environment: Linux4, HP-UX, Windows 2003, Oracle 11g/12c, Oracle10/11RAC, Golden Gate, Oracle Audit Vault, ASM, Grid Control, OEM, Shell Scripting, Data pumps, Exports/Imports, SQL*Plus, PL/SQL.

Confidential, CA

Sr. Oracle Database Administrator

Responsibilities

• Installation, Configuration and Administration of Oracle 11gR1/11gR2 (RAC) on different operating systems HP-UX, Linux, and AIX with ASM to support Custom applications.
• Ensuring the high availability and integrity of databases.
• Performed up-gradation of grid infrastructure and Oracle databases from 11.2.0.3 to 11.2.0.4.
• Writing UNIX shell scripting for automating the jobs.
• Configuring data guard for all the existing production systems and implemented data guard broker for switchover and failover.
• Support for RAC database and standalone databases ranging from 100 GB to 12 TB.
• Good knowledge in RAC related utilities.
• Performed Database refresh from Production environment to UAT/QA/SIT/DEV environments using RMAN and Datapump.
• Experience in monitoring and managing of Oracle instances usingEnterprise Manager Grid Control(OEM grid) 10g /11g/12c.
• InstalledGolden Gatefor replication of database on 11gR2 RAC environment.
• Planned and developed scripts to perform incremental level 0 and level 1 and archive log backups using RMAN.
• Troubleshooting and resolving performance issues with OLTP and Data Warehouses Databases.
• Optimized SQL, PL/SQL code and performance tuning issues using AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN & TUNING ADVISOR.
• Applying the Oracle security patches and application patches using the OPATCH and AD PATCH utilities.
• Creation of Oracle databases using Database configuration Assistant (DBCA).
• Implementing necessary monitoring scripts for Golden Gate in UNIX/Perl scripting.
• Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.
• Automation of database space, resource and utilization stats scripts using perl scripting.
• Creating and maintaining DBMS objects tables, indexes, views, sequences, triggers, packages, partitioning, compression and data encryption.
• Responsible for analyzing, testing and applying Quarterly PSU patching for grid home and database home.
• Assisting ETL, Report developers with performance tuning ETL jobs & report execution.
• Provided 24x7 production support and On-Call rotation

Environment: Oracle 11gR1, 11gR2,11.2.0.3,12c RHEL 5.8, HP-Unix 7, Solaris 10, AIX, OEM, DBUA,RMAN, Oracle Enterprise Manager Grid Control, RAC, ASM, Data guard, SQL*LOADER, AWR, ADDM, ASH, VPD, Oracle Wallet, Data pumps, Exports/Imports, shell scripting.

Confidential, Wilmington, DE

Sr. Oracle Database Administrator

Responsibilities

• Installation and configuration of Oracle server software 11g, 10g on SunSolaris/AIX/LINUX and UNIX platforms.
• Implemented DataGuard in oracle 11g.
• Migrated databases from 9i, 10g to 11g.
• Maintained Oracle 11g, 10g RAC nodes using ASM.
• Created and managed ASM disk groups.
• Experience with MySQL on both Linux and Windows.
• Created Oracle 11g databases allocated system storage and planned future storage requirements for the database.
• Database Backups & Recovery using RMAN.
• Implemented Load balancing for clustered databases (RAC).
• 24 X 7 Production Support.
• Backup strategy planning, online backups, cold backup, archive log backups and hot backups.
• Creation of Users and Roles and profiles and assigning particular roles to the users and for good performance assigned CPU time, idle time using profiles.
• Performing regular backups of the database.
• Applying database software fixes/patches.
• Administering Oracle networking by configuring listener.ora and tnsnames.ora.
• Responsible for the management, maintenance and security of the databases.
• Tuning of database and SQL statements for application developers using SQL tuning advisor.
• Generated and analyzed AWR reports and monitoring statistics for performance tuning of the database.
• Providing on-site support for our Business application.
• Interacted with the users and troubleshooting the problems involved with the development of stored procedures, triggers and problems related to the privileges & resources.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Managing of Tablespaces for different user by granting quota on Default & Temporary Table spaces.
• Taking Backup & Recovery of Database Using Logical (Expdp & Impdp) & Physical (Online & Offline) Backup.
• Responsible for UNIX Shell Scripts for Housekeeping.
• Reorganization of tables and rebuilding of indexes.

Environment: Oracle 11g/10g/9i, AIX, Solaris, LINUX, Windows 2008/2000 server, PL/SQL, My Sql OEM, Oracle Universal Installer, Oracle Fail Safe Manager, Oracle Designer, QUEST tools.

Confidential

Oracle Database Administrator

Responsibilities

• Installation and creation of 10g databases for Testing, Development and Production on IBM-AIX and Sun Solaris environment for OLTP and DSS systems.
• Refresh/Cloning of Database and applications to setup development, test environments.
• Migrating databases in production and development environments across different platforms.
• Performing periodic backups, recoveries using RMAN, conventional hot and cold backups.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options includingRMAN, Hot and Cold backups.
• Optimization and Tuning SQL queries using SQL Trace, TKPROF, EXPLAINPLAN.
• Experience with SQL, PL/SQL coding, stored procedures, functions, packages, triggers.
• Partitioning strategies for very large tables.
• Generated Statistics using DBMS.STATS Pack at Schema level, Table Level and for Indexes.
• Created UNIX Shell scripts for different database tasks and export/import for data transfer.
• Management of schema objects, partitioning of tables & indexes.
• Performing SQL*Loader jobs for loading data from flat files (ETL).
• Oracle Database monitoring, troubleshoot and resolve the issues, monitoring alert log, trace files.
• Participated in Disaster Recovery (Physical Standby), documented database and application validation steps.
• Performed Oracle Database Cloning from Production to Test and Development databases as per client requirements.
• Implemented RMAN Backups, Creation of catalog database, Developed RMAN scripts and tuned various parameters.
• Monitoring growth of tables and undertaking necessary re-organization of database.
• Conducting sizing & capacity planning for Oracle databases.
• Involved in Logical and Physical data modeling.
• Designing the security and database access strategies and Scheduling jobs using crontab.
• Providing support to developers to enhance their SQL, PL/SQL code.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Performing all daily maintenance tasks.
• Writing scripts for the system and database for effective functionality and report generation.
• Scheduling jobs on UNIX servers using crontab.
• Implemented DBDiff V3.0 tool to compare the structural differences between Production, Staging and Development environments.
• Performance tuning involving Memory, Disk I/O tuning and SQL tuning.
• Extensively worked on OEM (Oracle Enterprise Manager).
• Provided 24/7 support for production, development, and test database.

Environment: Oracle 10g, 9i, 8i, RMAN, ASM, OEM, SQL, PL/SQL, UNIX Shell scripting, SQL *Loader, TOAD, Datapump, Erwin, IBM AIX, Sun Solaris.

Confidential

Oracle Database Administrator

Responsibilities

• Installed and configured Oracle RDBMS on UNIX/Linux and Windows environments for PROD/UAT/QA/DEV environments.
• Developed scripts for database backup (hot and cold backups).
• Upgraded the database from 9.2.0.4 to 10.2.0.3 and applied patches when required.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using Tkprof, Stats pack, Explain plan and SQL*Trace.
• Created database objects, users, roles and profiles.
• Performed cloning using RMAN to refresh UAT/QA/DEV from PROD.
• Involved in re-org of database objects.
• Partitioned large tables to increase performance
• Responsible for configuring and taking level 0 and level1 incremental RMAN backups.
• Performed daily health check of the databases by implementing custom scripts.
• Involved in Data refresh from production to UAT/QA/SIT/DEV.
• Objects/schema level data refresh done by export and import..
• Responsible for all database activities such as space management, database security management, rollback segments & creation of DB links.
• Responsible for administering, supporting production/UAT/DEV Databases.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Loaded data from flat file to Oracle database using SQL*Loader. Created indexes on tables for performance tuning. Performance monitoring, tuning and space management.
• Involved in user creation and user access control. Involved in Schema creation and management. And Developed stored procedures, functions and PL/SQL packages to comply with the requirements.
• In depth knowledge of setting up RMAN backups. Proficient duplicate database using RMAN.
• Develop, implement and test Backup and recovery strategies for development databases.
• Performed Database Reorganization to remove row migrations and fragmentation using exp/imp utilities.

Environment: Oracle 10g/9i/8, HP-UNIX, Toad, Spotlight, SQL*Plus, SQL*Loader, PL/SQL Developer, RMAN, Import/Export, Forms/Reports, MS-SQL, Erwin, Windows, UNIX Shell Scripting, export/import utilities