SUMMARY

• 9 years of Experience as Oracle 8i/9i/10g/11g/12c DBA in Production, Test and Development Instance environment
• Administered databases on Linux, Solaris, AIX and Windows
• Strong Trouble - shooting, Problem solving, Analytical & Design Skills.
• Experience in Installation, Configuration and Re-Configuration of Oracle Database on Solaris OS, Red hat Linux 5/6/7, AIX 5,6,7, Suse Linux 9/10/11 and Windows advanced servers.
• Experience in Configuring, managing and monitoring both Physical standby and Logical standby databases using Data Guard
• Have worked on Oracle Streams and Golden gate for 10g and 11g databases
• Involved with installation and maintenance of Oracle 10g, 11g 2 node/4 node RAC clusters for high availability
• Experience with Point of Sale application support
• Maintained Mission critical and Business critical application databases
• Experience in configuring, managing and monitoring ASM for standalone and RAC databases
• Administrated database of various sizes from 40GB to 5TB
• Experience in Capacity Planning and Space Management.
• Experience in Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Tuning advisor, SQLT, LTOM and AWR
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage
• Experience in Online and Offline backups and recovery
• Experience in backups and recovery using RMAN
• Worked on RMAN backups with Catalog database
• Experience in Creating Duplicate databases/refreshing databases using RMAN cloning, User managed cloning and SRDF
• Experience in Cumulative and differential incremental backup using RMAN
• Experience in Point in time and disaster recovery
• Expertise in applying Patch sets and Interim patches
• Plan for contingency, disaster management that includes standby databases, data guard and cloning
• Planning Backup/Restoration Strategy for 24x7 operation support
• Planning and Scheduling Backups.
• Experience in Logical backups using Data Pump utility
• Installed and maintained Audit vault for SOX,HIPPA auditing
• Experience in Oracle Enterprise Manager (10g,11g and 12c)
• Experience in Shell scripting
• Experience in Flashback
• Expertise in Alert Monitoring and Ticketing
• Provided support for implementing and upgrading various new and third party application at client site
• Worked on encrypting customer data using Data Masking
• Application deployments
• Experience in working with a Team size of 2 to 5 DBAs
• Expertise in PL/SQL programming
• Experience in Data Center Migration
• Participated in resolving Sev1 and Sev2 issues
• Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g/12c

Platforms: Windows, Sun Solaris 10/9/8, RHEL ES/AS/4/5/6, IBM-AIX 7.x/6.x/5.x, Suse 9/10/11

Programming Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting

Tools/Utilities: TOAD, PL/SQL Developer, SQLPLUS, SQL Developer,, RMAN, Data Pump,OEM

PROFESSIONAL EXPERIENCE

Confidential, Mason, Ohio

Oracle DBA

Responsibilities

• Installation, Maintenance and Administration of Oracle databases ranging from 9i to 12c.
• Responsible for setting up 11g Grid control and 11g OEM agents
• Installed, configured and maintained 12c Cloud control.
• Physical standby set up and maintenance for 10g and 11g databases.
• Logical standby setup and maintenance for POS 10g database.
• Database upgrades from 9i to 11g and 10g to 11g.
• Involved in the development of backup scripts, maintenance scripts.
• Adding, modifying, and removing of Users and tablespaces.
• Database refreshes.
• Point in time recoveries
• Schema Imports/Exports
• Applying Patchsets, PSUs and CPUs.
• Migration of tables, schema, tablespaces using Datapump.
• Database performace enhancements.
• Backup and Recovery with RMAN.
• Installed, configured and managed Audit vault
• Application deployments
• Administration of 2 node and 4 node RAC clusters
• Creation of users and granting the users required privileges and roles.
• Involved in Data Center Migration
• Implemented Data masking for encrypting customer/associate data
• Responsible for managing databases on both filesystems and ASM
• Configured Oracle streams for Client’s lab environments ( Data from 5 databases streaming into a common repository)
• Implemented golden gate replication for a test environment.
• Involvement in space management, rectification of lock problems, managed quotas.
• Peformance tuning for application databases
• Worked with both TSM and HPDP tape backups
• Resolving issues within SLA
• 24x7 On call support on a rotation policy

Environment: Oracle 9i/10g/11g/12c, Suse Linux 9/10/11, RHEL 4/5/6, AIX 5.x/6.x/7.x, Grid control 11g, Grid Control 10g, Cloud Control 12c,Streams, Dataguard, ASM,RAC, TSM, HPDP,BMC Remedy, HPSM

Confidential, Cincinnati, Ohio

Oracle DBA

Responsibilities

• Installation, configuration, and maintenance of Oracle 10g on RHEL 4, AIX 5 and 11g on RHEL 5.
• Shell Scripting to schedule backups and space management on AIX and RHEL
• Responsible for setup and implementation of two node RAC on Oracle 10g
• Configured ASM with external redundancy for high availability
• Implemented and managed Oracle Data Guard on Oracle 10g
• Upgrading the Oracle 10g to Oracle 11g Release 2 by applying patches. Worked with both patch sets and interim patches
• Upgrading databases using DBUA
• Monitoring of Oracle Instances, Users, Tables, Tablespaces, Memory Structures, Rollback Segments, Redo Logs, Archive Logs and Alerts
• Creating and maintaining Databases using DBCA
• Replication of databases using Oracle streams
• Encryption of tables and columns using Data masking
• Creation of users and granting the users required privileges and roles.
• Involvement in space management, rectification of lock problems, managed quotas.
• Configuration of Listener and Net Service names using NETCA and NETMGR.
• Managing backup strategy for all production databases (at least triple redundancy).
• Provide at least double redundancy for all development databases.
• Database backup & Recovery for non archive and archive database with RMAN commands.
• Used Data pump for exporting and importing tables, schemas and table spaces.
• Implemented Data Guard on production database.
• Migrated databases from MS SQL server 2000 and 2005 to Oracle 10g and 11g using SQL Developer.
• Archive weekly all production database exports to CD (in encrypted form), stored both onsite and offsite.
• Develop and enforce both database and OS-level security policies for data protection.
• Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Managed more than 4 databases using OEM Grid Control.
• Undo table space management.
• Rollback segment creation and assignment for transaction as per departmental requirement for process.
• Hands on experience working on High Availability Environments.
• Responsible for auditing tables using Triggers
• Active Alert monitoring.
• Post installation process, kernel upgrade, applying support packs and add-ons.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, Data Pump, FLASHBACK and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Cloning databases with RMAN and also with user managed.
• Creation, managing and monitoring of database objects like Tables, Indexes, Views, Cursors, Triggers, Procedures, Functions, Materialized views etc.
• Loading of external tables into Oracle using SQL loader.
• Scheduling the databases backup using Cron tab and Veritas netbackup.
• Managing databases on multiple servers.
• Disk Space Monitoring.
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.
• Managing and providing 24X7 supports for various versions of databases.

Environment: Oracle 10.1.0.4/10.2.0.4/11g R1 and R2, RHEL 4 and 5, AIX, Oracle Enterprise Manager Grid Control, OEM Database control, PL/SQL, Shell Scripting, Stored Procedures, TOAD, Shareplex and all Oracle Tools.

Confidential, Roseland, NJ

Oracle DBA

Responsibilities

• Configuration and maintenance of a two node RAC on Oracle 10g.
• Configuration of ASM with normal and external redundancy.
• Restoration of databases from Critical failures.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Responsible for scheduling backups.
• Taking Incremental backup using RMAN.
• Alert monitoring and Ticketing.
• Creation and maintenance of databases.
• Creation of tables, table spaces, users, views and related objects.
• Performing analysis and diagnosis of database performance statistics.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Performing Online and Offline backups with RMAN as well as User managed.
• Schema and Table level replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Implementing backup procedures using Cron Tab.
• Performed activities such as Query Optimization, Database Consistency Monitoring.
• Installation of Oracle 10g on RHEL 4 and AIX.
• Used Shell Scripting to backup database.
• Physical and logical data modeling using Erwin tool.
• Responsible for granting required privileges and roles to users.
• Tuning SQL queries when the performance is poor.
• Migration of databases from MS SQL server 2000 and Sybase to Oracle 10g.
• Creation and maintenance of database objects.
• Duplicating production databases.
• Renaming and resizing databases.
• Restoration of purged tables using Flashback.
• Implementation of logical backups using Log Miner.
• Upgrading databases from 10.0.1.0 to 10.0.4.0 using Patch sets.
• Scheduling Oracle Jobs in the database.
• Implemented Point in time recovery using RMAN.
• Configuration of Multiple Listeners in the server and Net Service Names for the target databases using NETCA and NETMGR.
• Responsible for Space management and resolving dead lock issues.
• Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, Data Pump, Flashback, Data Guard, ASM and RMAN.
• Managing table spaces, user profiles, indexes, storage parameters.
• Involved in developing and implementing PL/SQL stored procedures and triggers.
• Responsible to provide 24 x 7 database administrative activities over different database servers.

Environment: Oracle 10.2.0.3/11.1.0.6/.7, Linux, AIX, Solaris 10,Window 2003, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, Shell Scripting, Stored Procedures, ASM, Data guard.

Confidential, Indianapolis, Indiana

Oracle DBA/Developer

Responsibilities

• Configuration and Maintenance of Physical Standby databases.
• Supported different Databases like Production, Testing, Staging and Training.
• Online and Offline Database backup and Recovery.
• Upgrading databases from 9i to 10g.
• Creating databases manually or with DBCA.
• Backing up databases using catalog database with the help of RMAN.
• Monitoring Oracle instances with Oracle Enterprise Manager.
• Loading and Unloading of tables to and from Oracle respectively.
• Monitoring and managing Alert notifications.
• Configured databases with filesystems and ASM.
• Used performance views to tune the performance of the databases.
• Table level replication using Oracle Streams.
• Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, and IMPORT/EXPORT.
• Month end job monitoring and checklist preparation and co-ordination.
• Adding and resizing table spaces based on threshold metrics.
• Granting and revoking required privileges and roles to users.
• Implementation of table level snapshots on target databases.
• Hands on experience working on High Availability Environments.
• Implementation of almost all Oracle tools.
• Responsible to provide 24 x 7 database administrative activities over different database servers, representing various RDBMS on Linux OS.

Environment: Oracle 9.2.0, Linux 4, Window 2003, Oracle Enterprise Manager, RDBMS, Oracle 10g, SQLDBA, PL/SQL, TOAD7.5

Confidential, Fishers, IN

Oracle Developer/DBA

Responsibilities:

• Installation and maintenance of Oracle 9i on Linux OS.
• Installed, upgraded and patched Oracle installations.
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Performed hot and cold backup and recovery using RMAN and UNIX Scripts
• Monitored database and SQL performance using Statspack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Loading of tables into oracle.
• Created Users for the Applications, giving them different level of permissions.
• Monitored database and system performance.
• Configured the Event Manager to notify support personnel.
• Worked on application and database security (data access, passwords, network, etc).
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.

Environment: Oracle 9.2.0.7, Window NT/2000/2003, Oracle Enterprise Manager, MS SQL Server 7/2000,RDBMS, VERITAS Netback up, SQLDBA, PL/SQL, TOAD7.5, Shell Scripting, HTML, Stored Procedures, Triggers.