SUMMARY:

• Experienced Oracle DBA with 6 years of experience in Oracle Database Administration in large - scale production environments across multiple platforms.
• Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Real Application Clusters (RAC) and Data Guard.
• Ability to work both as an individual contributor and as a member of a team.
• Experience in Performance tuning of Oracle GoldenGate Processes to achieve zero lag times.
• Hands on experience on using of macros, conflict resolution, filtering and transformation, exception handlers and Security.
• Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.
• Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.
• Experience in SQL Tuning using tools like Explain Plan, SQL*Trace, TKPROF and OEM.
• Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM.
• Experience in Database capacity planning, monitoring object growth and Storage Management.
• Performed data migration from flat files into an Oracle database using SQL*Loader.
• Experience in performing Cloning and Refresh using RMAN and Datapump.
• Experience in Oracle Advanced Compression techniques.
• Experience in Online/Offline Re-Organization of database objects.
• Experience in Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
• Demonstrated proficiency in managing Oracle Instance, database storage structure, schema objects, managing tablespaces, Rollback and undo segments, creation of database objects, Data Modeling.
• Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.
• Experience working with database security tools TDE, DB Vault / VPD.
• Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.
• Experience in upgrading Oracle Binaries and databases from 10g to 11g and 11g to 12c.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations.
• Performed Upgrade and Migration of Oracle databases from oracle 10g to 11g & 12c.
• Support Installation of databases of various versions including 11g and 12c.
• Support on day-to-day DBA activities.
• Applying Critical Security Patches, PSU patches and One off patches to environment as on need and as per oracle recommendations.
• Upgrading grid infrastructure from 10g to 11g/12c versions along with database upgrades.
• Knowledge in configuring ASM (Automatic Storage Management)
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Datapump, conventionalExport/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Planning and Implementation of Security, Backup and Recovery Strategies using RMAN
• Applying GI PSU and Database PSU quarterly patches as per oracle support recommendations.
• Working experience on Enterprise Manager Cloud Control 12c to monitor database performance and availability of various targets in database servers.
• Managing users and resources, controlling user privileges, roles and auditing.
• Working closely with application teams and supporting on various performance and configuration issues on day to day basis.
• Working on Data guard, switchover, and failover activities as part of disaster recovery management.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using DatapumpExport/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Clusters (RAC) and Automatic Storage Management (ASM) and Data guard and Streams.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

TECHNICAL SKILLS:

Operating Systems: Windows NT /2010/, RHEL (RedHat Linux), UNIX, Solaris

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, 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 - Conshohocken, PA

Oracle Database Administrator

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g on Linux platform using ASM.
• RMAN point in time recovery and Instance recovery done on 11g.
• Developed compliance reports and performed auditing at higher levels.
• Implemented 12c RAC Clusters and created POC for failures and performance in the environment and troubleshooting using clusterware Alert Log Monitoring every day in the production environment
• Perform health checks using crsctl and managing services using srvctl
• Performance Tuning for the SQL queries which are running slow and taking more CPU cost
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Query optimizing using CBO (Cost Based Optimization) and Scheduled Oracle Jobs and Backups using CRONTAB.
• Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases
• Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Creating OEM alerts that provides notifications through emails.
• Monitoring rollback segment and temporary table space use.
• Table partitioning to improve I/O access
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump
• Implemented 12c RAC Clusters and created POC for failures and performance in the environment and troubleshooting using clusterware Alert Log Monitoring every day in the production environment
• Performing housekeeping tasks like checking log and trace files.
• Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• Performing monthly and annual performance reports for trend analysis and capacity planning.
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
• Worked on both VMS and UNIX environments.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Experience in writing UNIX/SHELL scripts for providing the reports.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Confidential - Cleveland, OH

Oracle Database Administrator

• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Installed Oracle 10g and 11gR1,11gR2 database on HP-UX 11.0, Redhat 6, IBM AIX 5.1,5.2,6.1
• Applied Bug fixes patches and Quarterly Security Patches for the stand-alone databases and 2-node RAC databases with in the maintenance window.
• Installed RAC/GRID Infrastructure on Oracle 10g,11g and worked on ASM feature of Oracle on HP-UNIX/LINUX. Worked on the ACFS file system and scheduled backup using RMAN on ACFS file system sharing between the nodes
• Maintained a 2-node RAC environment on LINUX AS 4.0(RHEL) for the staging purpose to support the business requirements and provide High Availability.
• Upgraded DEV/Qa/performace databases from 11.2.0.3 to 12.1.0.2
• Upgraded the databases from 10gR2 to 11gR2 and upgrade from 11.2.0.3 to 11.2.0.4.
• Installed and configured golden gate for replication.
• Managed DSS (Decision Support System) and OLTP (On Line Transaction Processing system) full life cycle projects with multiple databases at one time, biggest database around 10 TBytes
• Responsible for Database Backup and Recovery, daily monitoring of database & network issues
• Deployed Grid Control to monitor and manage all the databases on clients
• Worked on the Load Balancing issues on the Server side by creating the services.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing recommendations to make database healthy and running.
• Experience in Data Modelling concepts like Data Vault and also in Advance security like DB Auditing, Labeling.
• Data loads using SQL*Loader and refresh the test environments using Data Pump export/import
• Ministering the databases using Grid Control including but not limited to Space Management, Performance Tuning, and Workload Analysis (AWR, ADDM)
• Involved in setting up disaster recovery sites using Data Guard technology. Configuring the Physical Standby, active data guard and snapshot standby database
• Used Shell Scripts to automate database operation and schedule jobs using CRONTAB
• Created and managed the RAC clustered databases on Solaris and HP-UX used ASM
• Upgraded Grid Infrastructure and Databases from 11.2.0.2 to 11.2.0.3. by creating a new home of 11.2.0.3 and relinking the binaries.
• Working with Oracle Support to fix the production issues and also to get the merge patches.
• Involved in capacity planning
• Providing application support to create database objects and apply database changes.
• Worked on Database Wallet and TDE (Transparent Data Encryption) for Encrypting the Sensitive data using column encryption and tablespace encryption.
• Setting up physical Standby/Data Guard for disaster and recovery.
• Involved in DR testing.