SUMMARY

• Experience in Oracle Installations, Oracle Version Upgrade and Migration(from 10g to 11g and 11g to 12c)
• Extensive experience on Database Security, Transparent Data Encryption (TDE),Data Redaction and Auditing ( fine - grained Auditing , value based, Mandatory and standard auditing)
• Good understanding of data transfer protocols including ETL, FTP, SFTP, and AS2.
• Experience in implementing User Managed and RMAN backups including full and incremental as well as logical backups using DATAPUMP.
• Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR), Flashback Recovery, Cloning and Refresh (at database, schema & table level) using RMAN utility.
• Installation, configuration and Maintaining Oracle Data Guard for high availability/disaster recovery purpose and ensuring that the physical standby is always in sync with primary database.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning, instance, application etc) using tools like SQLT, STATSPACK, EXPLAIN PLAN, AUTOTRACE, SQL TRACE, TKPROF, AWR, ADDM, ASH, Top, v$ performance views.
• Experience in the configuration and administration of Oracle Golden Gate for Real-Time data replication and troubleshooting Oracle Golden Gate issues.
• Extensive Knowledge in applying quarterly Patches (Patching), Critical Patch Update (CPU) and Patch Set Update (PSU) using the Opatch and runinstaller Utilities.
• Knowledge in Oracle 10g/11g RAC configuration and installation using ASM, Grid Installation).
• Implemented of H/A solutions with Oracle 10g & 11g RAC with experience in Troubleshooting in a RAC environment.
• Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 11g, 10g) for the purpose of monitoring multiple databases and application servers.
• Heavy UNIX shell scripting, Scheduled maintenance jobs using DBMS SCHEDULER/CRONTAB.
• Hands-on experience working as Production DBA, working knowledge on S-L-A metrics, Remedy system and worked with Oracle Support, co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS

• RDBMS: Oracle 12c, 11g, 10g
• 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, Exadata, MS SQL server, My Sql
• Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL
• Tools: Oracle Enterprise Manager, TKPROF,ASH,EXPLAIN PLAN, Sql Tuning Advisor, OEM Grid, STATSPACK/AWR, SQL TRACE, Top, DBCA, DBUA and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Microsoft, LogMeIn and Cisco VPN Client
• Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Opatch, DataPump, Export, Import, Dataguard, Golden gate

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Oracle Database Administrator

Responsibilities:

• DBA involved in production support and major projects from Development to Production environments, involving daily configuration and administration of databases.
• Supported RAC production database and a lot of Development and Test databases 10g and 11g.
• Maintained DATA GUARD to provide high availability by implementing physical stand-by database and snapshot-standby.
• Experience in configuration and administration of Data Guard (Physical/Logical standby Databases) and trouble shouting Dataguard issues.
• Implementing 10g, 11g Data guard with physical database.
• Delivering Oracle Database performance-tuning services for customers using Tools like EXPLAIN PLAN, TKPROF, AWR, ADDM, SQL TRACE and SQLT as well as Partitioning and re-organization of table and indexes to optimize database performance.
• Identified Top SQL that are consuming heavy resources and provided support to the development team in identifying SQL queries that are consuming high resources and interaction with the development team to see if these queries can be fine-tuned further to optimize performance.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Full, Incremental backups), LOGICAL BACKUPS and Database migration using DATA PUMP, Export/Import and Transportable Tablespaces.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Manager).
• Setting up and testing the backup and recovery strategies.
• Worked closely with the system operations team on database deployment processes.
• Experience in Upgrade from oracle 10g to 11g and Migration of oracle database from red hat Linux, Window platform to Linux on development, integration and production environment using Oracle Data Migration Assistant and Transportable tablespaces.
• Participated in Space and User Management, Capacity planning, Backup & recovery (Import/Export, Datapump, RMAN).
• Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
• Scheduled database maintenance tasks such as tables/indexes analysis, gathering statistics, partitioned tables, index maintenance, refreshing materialized views refresh and db exports.
• Troubleshooting Space Management & User accounts and privilege issues while coordinating with UNIX and application teams.
• 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.
• 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 and performing health checks in Oracle RAC.
• Monitoring Health checks of OCR, VOTING DISKS and Private Interconnect for H/A, optimizing performance and troubleshooting in a RAC environment (11GR2).
• Applied Oracle patches in RAC rolling fashion and experience with 11g cluster maintenance using CRSCTL command and using SRVCTL command for Oracle 11g RAC database
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfil the storage needs.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
• Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases, cloned and backup CDB and pluggables.
• Building Clone instances for Development and Test teams.
• 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 db Objects like Custom tables, Procedures, functions, Alerts, Views, Indexes.
• Implemented shell scripts for automation of day to day activities such as growing table sizes, extent allocation, free space, used space, fragmentation and backups result etc.

Confidential, Charleston, IL

Oracle Production Support Database Administrator

Responsibilities:

• Refreshing DEV and TEST environment with data from Production on a regular basis.
• Database reorganizations Cloned/refreshes/Migrated databases using RMAN , Transportable Tablespace and Data Pump export/import utilities in Oracle 11gR2.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Provided Production & test environment support while coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle Databases.
• Installed, configured and maintained Physical, Active standby databases supported by Data guard on Oracle 11g.
• Regularly involved in oracle version upgrade, applying patches (PSU) using Opatch on all the databases.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
• Good hands on performance tuning related issues with experience in query analysing and Performance Tuning for the SQL queries which are running slow, resources consuming SQLs, Wait events, Locks and Alert log file.
• Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate issues like abended, stopped process, errors, alerts and lag alert.
• Monitored Goldengate using 12c Goldengate Plugin, Goldengate Director and shell scripts for alerting GG process down alerts.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Developed compliance reports and performed Database auditing at higher levels.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Database monitoring/maintenance and performance tuning using OEM (Oracle Enterprise Manager) such as setting thresholds on tablespaces and managed users, privileges, profiles, schemas.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recycle Bin for a faster recovery of the databases and database objects.
• Knowledge in Oracle Data warehouse, skills relating to administration and management of VLDB environments, Oracle OLTP.
• Expertise in implementing partitioning methodologies on tables and indexes for high performance.
• Implementing various Backup strategies and Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption) in 11g.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Used TOAD, Scripts and OEM for database management.
• Knowledge in promoting application code through the full lifecycle, including development, test, and quality assurance (QA) and production.
• Maintained the data integrity and security using integrity constraints and database triggers.
• 24 X 7 Production & Development database support and administration.

Confidential, Peapack, NJ

Junior, Oracle Database Administrator

Responsibilities:

• Created User accounts, Roles and granting required access permissions and privileges to the users. Maintained Security through auditing.
• Performed DBA activities including space management and performance monitoring and automated processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing.
• Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups, refreshes and migration of databases.
• Worked on cloning of databases using RMAN Utility.
• Excessively worked on performing database backup and recovery using RMAN. Key player taking RMAN backups and in troubleshooting backup issues.
• Perform database code deployments, Backup and replication monitoring.
• Extensively involved in query optimization and application tuning.
• Raised SRs with MOS to resolve the bottlenecks in the database environments.
• Proactive monitoring of Oracle Databases, close alerts triggered by proactive monitoring using OEM and Scripts, Documentation and status reports.