SUMMARY:

• Over 5+ years of experience as an Oracle Database Administrator having hands and experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Experience in translating business requirements into conceptual, logical, and physical data models.
• Experience in configuring Oracle network, RMAN, Recovery Catalog, and Performance Tuning of database by optimizing SQL and PL/SQL scripts and instance. Used statspack report, AWR report, ADDM advisors, autotrace and execution plan.
• Excellent experience in installation, setup and configuration of Oracle 10g and 11g in HP - UX, Sun Solaris, Windows and UNIX/Linux environment.
• Proficient at performing major Database Release Upgrade (manually as well as using DBUA) along with applying various PSU patches using OPatch for 10g|11g|12c databases.
• Adept at routine Database Administration tasks including automated installation, creation and replication of databases, management of tablespaces, logs, grants, roles, users, indices.
• Working experience in database cloning, database backup, recovery procedures and security.
• Experience in application Support, SQL Loader, Data pump, Data Guard, Fine Grain Auditing (FGA), performing Flashback, transportable tablespaces.
• Experience in TDE(Transparent Data Encryption) 12C Keystore on Tablespace Master Encryption.
• Experience in designing and configuring high-availability systems using DATAGUARD with physical standby. Effectively used DATAGUARD BROKER utility.
• Experience in Tables Partitioning
• Hands on experience in installation and maintenance of enterprise manager 12c and Grid Control 11g and addition of targets for database Monitoring/Performance/Diagnostics purposes.
• Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases.
• Experience in Performance Tuning, Tuned various large critical OLTP and OLAP databases using various tools like AWR, STATSPACK, ASH, SQL-TRACE, TKPROF, ADDM, and Explain Plan Utilities.
• Experience in the management and implementation of database models, data flow diagrams, database schemas, database scripts, to support a robust data management infrastructure.
• Qualified at writing SHELL Scripts and using CRONTAB for automatic backups.
• Adept at installation of OEM Database Control, OEM grid control and Deploying Agents.
• In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security.
• Experienced in Designing, Installing, Configuring and Maintaining Real Application Cluster (RAC) using raw devices, OCFS, Automatic Storage Management (ASM) and SRVCTL utility.

TECHNICAL SKILLS:

Databases: Oracle 9i,10g, 11g, 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DBA Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Statspack/AWR, Top, DBCA, DBUA, ADDM,SERVICENOW,SRVCTLCRSTL.

Operating Systems: UNIX (Solaris /9/10, AIX, HP-UX), LINUX

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers Red Hat Linux 6.5X

Middleware: BEA Weblogic 10.2.3,ODI

Tuning Tools: TKPROF, EXPLAIN PLAN,AWR/ADDM/ASH

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Oracle Database Administrator

• DBA supporting a 4 Node Exadata on X4s from Development, Test, UAT to Production environments, involving daily configuration, administration, all running on Red Hat Linux 6.5. Database sizes range from 500GB to 7TB (in MANHATTAN,ODS & FIN,OC11,SCI & EDW environments).
• Table refreshes and schema refreshes using Datapump, expdp and impdp .
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning .
• Experienced in cloning the databases using HOT and COLD backups.
• Used RMAN Duplicate and EXPORT/IMPORT data from 9i to 11.2.0.4.
• Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Installation of oracle enterprise manager 12c, oracle management repository and deployed agents.
• Manage agents using emctl utility and creating incident rules in enterprise manager 12c
• Configuring administration groups, and creating template collections in oem 12c.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in Applications, in writing the Packages, Triggers and Indexes on the tables.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Responsible for setup and implementation of 2 Node RAC on Linux in 11g R2.
• Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
• Create database Objects, Tablespaces, Schemas as needed.
• Schema migrations from Development to Production via Tech Test environments.
• Database refresh from Production to Tech Test as needed.

Tools: Used: Linux, HP-UX, SQL, PLSQL, SQL Developer, Toad, Oracle 10g/11g, RMAN, Oracle RAC, DATAPUMP, DATAGUARD, ASM

Confidential, Indianpolis, IN

Oracle Database Administrator

• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Applied patches 11.2.0.3 and 11.2.0.4 DATA GUARD running on a 4 Node RAC
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 supports for all the production and development databases.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, Indianapols, IN

Oracle Junior DBA

• Configure. Implement & Deploy Oracle 11g (11.2.0.4) & Oracle 12C, single instances on
• The work involved overall Maintenance of Oracle Database, Backup, Recovery and other database related activities.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviors.
• Day to day Performance Monitoring and tuning of database.
• Diagnose and Troubleshoot Database Problems and failures
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery Plan.
• Involved in the installation of Oracle 11g(11.2.0.4) on both Solaris and LINUX platforms.
• Creation and maintenance of database.
• Handling day-to-day activities.
• Monitoring of database for growth and performance.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Storage and space management including table spaces and data files.
• Creating Databases and all database objects. Database Designing, Designing Tablespaces and Rollback Segments.
• Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Tools: Used: Oracle 10.2.0.1, Oracle 10g (9.2.0.8), RMAN, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN