PROFILE SUMMARY:

• Over 3+ years of experience in Oracle Database Administration, Worked extensively on Installations of Oracle Database Software 12c,11gR2, 10g, 9i, 8i on OEL, RHEL, UNIX, AIX, Sun Solaris and Windows environments. Experienced in Oracle Database's High Availability solution set like, configuration and monitoring of Oracle Real Application Cluster (RAC), Data Guard and GoldenGate. Experienced in Upgradation, applying oracle PSU and CPU Patches, Migration, Backup and Recovery, cloning oracle database from production to development Replication, Database Security, RMAN, User Management Performance tuning and monitoring the database using OEM Grid Control.
• Experience in installation and configuration of Oracle 8i, 9i, 10gRAC, 11gR2 (RAC),12c databases in LINUX, HP - UX, SOLARIS, IBM AIX and Windows environments.
• Experience in upgrading the database from Oracle 9i to Oracle 10g & oracle 10g to oracle 11gR2 & oracle 11gR2 to oracle 12c and migration of the databases using transportable database, tablespaces export/import, data pump utilities.
• Planned and implemented Oracle 10g RAC, 11gR2 RAC,12c RAC and Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).
• Experience in installing and patching ASM with Oracle (RAC) on AIX, Solaris and Linux platforms.
• Installed and configured oracle Grid control and deployed agent on managed targets.
• Experienced in configuring resource allocation, information sharing, and high availability with (RAC)
• Designed and implemented centralized backups and recovery strategies using recovery manager (RMAN).
• Experienced in installation, configuring and managing Golden Gate V10x, V11x on Oracle 10g 11gR2 and 12c with Linux, HP-UX and Windows platforms.
• Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.
• Experience in implementing cross platform Migration from HP-UX to AIX, Solaris to Linux and Windows to Linux
• Expertise on performing cold backups, hot backups, advanced recovery methods like flash back recovery using (RMAN) recovery manager.
• Experience in Implementing and maintaining Database security.
• Experience in using SQL, PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance.
• Responsible for sql 2008 backup and recovery
• Good experience with Oracle grid control, Oracle enterprise manager (OEM), ASM, AWR, ADDM, Flashback Technology, SQL tuning advisor, SQL access advisor, and SQL server undo advisor.
• Expertise in maintaining Database Roles, Users using Security Compliance Auditing, expertise in loading data from Flat Files using SQL*LOADER and External Table.
• Performance Tuning: Experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, (OEM) Grid Monitoring.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Worked on shared environment with sql and oracle on a single application with linked server setup
• Experience in proprietary change management processes to prevent production disruptions and outages. Cloned Database from Production to Test and Development and from Development to Production.
• 24*7 production database support with support to developers & end-users.
• Good communication and coordination with different departments (IT & Non-IT) for efficient problem escalation and deciding on optimal solution.

TECHNICAL SKILLS

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 8,9,10 IBM AIX 5.x, 6.x, Red Hat Linux 4 .x, 5.x, 6.x, and Windows.

RDBMS: Oracle 8i, 9i, 10gRAC, 11gR2RAC,12c SQL Server 2005,2008R2,2012 And 2014, Real Application Cluster(RAC), ASM

LANGUAGES: SQL, PL/SQL, Java, C, XML, Pearl, Shell Scripting.

UTILITIES: RMAN, Oracle Enterprise Manager/Grid Control, Data Guard, SQL*Loader, EXP, IMP, Data pump, SQL developer, VeritasNetBackup and Golden Gate.

TOOLS: TKPROF, TOAD, EXPLAIN PLAN, AWR, STATSPACK, ADDM, Putty and AUTO Trace, Winscp3, ERWIN.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• 24*7 production database supported with support to developers & end-users.
• Oracle 10g,11gR2,12c installation and administration.
• Involved in Oracle Database upgrades from 11gR2R2 to Oracle 12c.
• Installed and configured multi node Oracle 11gR2R2 (RAC) for High Availability.
• Installed and configured Oracle Physical Standby Databases (DATA GUARD) for Disaster Recovery
• Identified and performed SQL tuning using EXPLAIN PLAN, SQL TRACE and TKPROF, Analyzed tables, indexes for improving the performance of the Query
• Constantly Performed monitoring and tuning using STATSPACK, TKPROF, EXPLAIN PLAN, AWR, and ADDM.
• Implemented Automatic Shared Memory Management (ASMM) and Automatic Segment Space Management (ASSM).
• Involved in Data modeling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back-up and recovery, installations and configurations on an as needed basis.
• Refresh/Cloning of the databases from Production to the Test and Development environments.
• Installation configured and Supported database replication using Golden Gate V10x 11gR2 with Linux.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Implemented and maintained Database security.
• Involved in designing and implementing Oracle backup and recovery methods using recovery manager (RMAN).
• Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.
• Worked on ATG repository, ATG Dynamo and created ATG form handler.
• Created and managing user, roles, privileges, profile, schemas in oracle 11gR2R2.
• Implementation and monitoring of all databases using OEM/Grid Control.
• Implemented Database Logical and physical models of databases and Migration & conversion of existing data.
• Loading data from flat files using SQL*Loader and Developed UNIX Shell scripts to automate backups using recovery manager (RMAN).
• Implementing the changes in the database design and modifying stored procedures in PL/SQL if necessary.
• Entensively worked on installation and configuration of sql server 2008,2012,2014 on standalone and clusterd environment
• Worked on migrations on sql server 2012 from sql 2008
• Managed and resolved design issues during development and suggested standards to ensure that all design was produced with proper integrity, security and performance.
• Manipulated tables to manage the data and data types. Modified tables to change the data types and added new columns (according to requirement).
• Partitioned large tables for better performance and manageability
• Involved in Conceptual Database Design, Logical and Physical Database Design.
• Involved in implementation of 10g GRID and GRID CONTROL agent.
• Developed scripts to refresh of databases in stage and development environments
• Provided support to Application Database Administrators in designing the database.

Environment: Oracle 9i/10g/11gR2,12c, Linux, Solaris, PLSQL, Shell Scripting, RMAN, Grid control, Data Guard, EXP, IMP, Data Pump, Exadata TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.

Confidential

Oracle DBA

Responsibilities:

• Proficient in installation and creation of Oracle 9i, 10g databases in development, Production and QA environments including configuration, backup & performance tuning.
• Designing, documenting and deploying through the various development and production environments.
• Refresh/Cloning of the databases from Production to the Test and Development environments.
• Upgraded database from Oracle 9i to Oracle 10g.
• Installation and Configuration of Oracle 10gRAC and Standby Databases for high availability and disaster recovery. Database Migration
• Worked with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Planned and implemented Backup & Recovery using RMAN.
• Implemented Cold Backup and Hot Backup depending on the requirement.
• Refreshed development and test databases from production using Logical Backups (Export and Import).
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, AWR, STATSPACK.
• Daily Health Check Up of the Database using ADDM with the help of AWR report.
• Written SQL, PL/SQL scripts and Shell scripting to monitor table space and extent growth. Space Management, which includes table space creation, adding new data files.
• Maintaining Database Security by Creating Roles, Privileges, Quotas, and Passwords.
• Troubleshooting and Technical Support on Oracle Database & Oracle Applications and Network Administration using SR, SAR, IOSTAT and RDA.
• Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption).

Environment: IBM AIX, Oracle 10g/9i enterprise edition 9.2.0.4, Windows servers, Oracle Enterprise Manager.