OVERVIEW:

• I have over 5 years of hands - on experience in the daily administration of production and project Oracle 11g, 12c databases as well as installation and configuration of both standalone and Oracle Real Application Cluster (RAC) databases, backup and recovery using Oracle Recovery Manager (RMAN), database migration and refresh using Oracle Data Pump, Oracle database replication using Oracle Data Guard, and Oracle 12c Cloud Control configuration and monitor. Also responsible for patching, upgrade, database trouble shooting and supporting development effort with regard to production deployment releases, database schema, role, user, and objects, database hardening and baseline per security policy to improve database security

PROFESSIONAL SUMMARY:

• Responsible for Datacenter Migration from old Datacenter to new datacenter and Migrated and upgraded single instance database to multiple instance databases using export/import, data pump.
• Configure Data Guard on both standby and primary for numerous production databases.
• Fail over and switch over between standby and primary databases.
• Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Experience in multi-node and RAC environments including configuration of PCP.
• Highly experienced in Cloning of Oracle databases from multi-node to single-node and single node to multinode
• Troubleshoot Database performance issues with use of PROCWATCHER, Cluster health monitor and Other Oracle support suggested utilities and also used OS related utilities like NMON, SAR, OSWATCHER, top, topas, vmstat, iostat, prstat, strace etc
• Import/Export and Expdp/ Impdp utilities. Excellent experience in Installation, configuration, Maintenance of Oracle 12C, 11g, 10g on Operating Systems Solaris, Linux, AIX and Windows platforms.
• Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Upgraded the Databases from Oracle 10g/11g to 11g and 12c and applied patches according to the client requirement in RAC and NON RAC environments with ASM and Non ASM storage
• Experience in Auditing and Capacity Planning, Configuring & Managing Hot Standby Databases (Data Guard)
• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability
• Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Experienced with SRVCTL, OCR and Voting Disk of 11g RAC
• Handled RAC Node hangs and node eviction issues.
• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations.
• Performed database recovery using User-Managed, RMAN-Managed Recovery and performed FLASHBACK features to handle efficient database recovery.
• Experience in automating backup strategy using the UNIX shell script Cron Utility, Control-M & Autosys.
• Experience in schema and table designing, stored procedures, Triggers, Views, and Indexes.
• Experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN.
• Hands on experience in performance tuning using EXPLAIN PLAN, TKPROF, STATSPACK, DBMS STATS, Automatic workload Repository (AWR), ASH and Automatic database diagnostic monitor (ADDM)
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Implemented various backup strategies for Large / Medium sized databases using RMAN
• Worked extensively on Cloning /Duplicate of databases using RMAN.
• Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
• Migrated databases from Non-ASM file system to ASM file system using RMAN.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL, Shell Scripting

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

PROFESSIONAL EXPERIENCE

Confidential - Peapack, NJ

Oracle Database Administrator

• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.2 & 5.3. Database sizes range from 40GB to 1.5TB (in ODS & EDW environments).
• Supported 50+ databases including RAC production database, a Data warehouse database and a lot of Development and Test databases and upgraded from 10g to 11g.
• Provided Production & test environment support while coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle Databases.
• Worked on setting up/installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g CRS on IBM AIX 6.1.
• Installed and configured 2 node oracle 11gR2 RAC for production environment.
• Installed 12c Databases and responsible for upgrading Oracle 10g RAC to 11g RAC.
• Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICATE issues.
• Implemented and administered Oracle Golden Gate (v10) for Database Replication between production and reporting node, by using Oracle Streams in parallel to secure data and having the availability of the database during the regular upgrade or maintenance operation.
• Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
• Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
• Monitoring database performance and database operation to prevent downtime and slowness of the services.
• Worked closely with the system operations team on database deployment processes and database capacity planning.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Cloning RAC to RAC and RAC to NON RAC using hot backup and RMAN.
• Expertise in configuring and managing the Concurrent Managers, Workflow Notification Mailers and monitoring their operation
• Strong experience in Space and User Management, Capacity planning, standby setup, Backup & recovery (Import/Export, Datapump, RMAN)
• Delivering Oracle Database performance-tuning services using EXPLAIN PLAN, TKPROF, AWR, ADDM, SQL TRACE
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Manager).
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata servers.
• Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild, materialized views refresh and db exports.
• Maintained DATA GUARD to provide high availability by implementing physical stand-by database and snapshot-standby and worked with Oracle 11g features 11g Grid Control and Automatic Storage Management (ASM).
• Troubleshooting Space Management & User accounts and privilege issues while coordinating with Unix and application teams.
• Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shell scripts for automation of day to day activities.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.
• Regular Security Patching and Critical patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bug fixes on database products.
• Production support for Oracle database 10g/11g RAC.
• Implemented and configured of Oracle Enterprise manager OEM 12C and Oracle Management Server for maintenance and monitoring of production databases.
• Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL tuning and Metrics, using Grid Control of Oracle Enterprise Manager (OEM) 12C.
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations.
• Expert in monitoring database using Oracle Enterprise Manager (OEM).

Confidential, Austin, TX

Oracle Database Administrator

• The work involved overall Maintenance of Oracle Database, Backup, Recovery and other database related activities.
• Installed, configured and maintained Oracle 11g Real Application Cluster (RAC) / ASM on Redhat Enterprise Linux 5.x boxes.
• Implemented 11g DataGuard Physical using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.
• Worked on Golden Gate 12c Replication configuration like unidirectional as well as bidirectional as per the requirement and addition of tables for the existing Golden Gate configuration.
• Performed Data Guard switchover/failover as per the requirements.
• SQL Queries/Application and Database performance monitoring and tuning using various tools like ADDM, AWR, Explain Plan and Statspack reports.
• Database Growth and Space management, capacity planning; distributing the tables, redo logs, archived redo logs and rollback segments on different disks to optimize data retrieval.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Modified database structures including tablespace, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• General DBA daily jobs such as disk usage monitoring, table/index rebuild and reorganization as needed. Used import/export utilities for cloning/migration of small sized databases and Datapump
• Monitoring of database for growth and performance.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• Worked with latest 10g/11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• 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.