EXPERIENCE SUMMARY:

• Having 8+ years of experience as an Oracle Database Administrator with exposure on Production Systems Analysis, Design, Development, Implementation and Testing of Relational Database Management Systems for Business Solutions.
• Experience in Administration activities such as Installation, Configuration, Client/server connectivity, Creating and Managing Repositories, Users, User Groups, Folders, User Roles, Profiles and Privileges.
• Experience on creation and implementation of Backup and Recovery methods and disaster recovery methods using RMAN, logical, hot backups, Flashback Recovery and performed full, incremental and Cumulative backups using RMAN.
• Extensive experience in Application Development, Database development and 24x7 production system support handling large databases using Oracle 12c, 11g, 10g, 9i on various platforms like AIX, Solaris, Red hat EL, UNIX and Windows.
• Experience in Configuring Single Instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM).
• Strong skills in Data Guard management, ASM and Oracle RAC for providing critical solutions.
• Experience in upgrading RAC and standalone databases from 10gR2 to 11gR1 and from 11gR1 to 11gR2 and from 11gR2 to 12c in prod and non - prod environments.
• Effective volume management using Oracle Automatic Storage Management (ASM).
• Experience in providing Level-1, Level-2 support for the database issues.
• Experience in configuring and managing GoldenGate on multi-node RAC environment.
• Experience in capacity planning, space management, Rollback segments and Undo segments.
• Experience in using 11g advanced features like Active Database Duplication in instantiating the standby database from Primary.
• Experience in using Flashback feature of Guaranteed Restore point for application to perform testing or to perform large schema exports without impacting Mission Critical Primary databases.
• Experience in implementing Oracle TDE to protect data at the operating system level.
• Experience on Performance Tuning - proactive and reactive for optimal performance to meet Business SLA*s. Database performance tuning (Oracle 9i, 10g, 11g), SQL tuning (using AWR report, SQL Turning Advisor, v$ tables, ASH, ADDM report, OEM).
• Export and Import of database objects using Data pump utilities EXPDP and IMPDP.
• Experience in partitioning the tables to improve the performance.
• Experience in configuring and performing Switchover using Active Data-guard.
• Experience in shell scripting and scheduling jobs using crontab utility.
• Configuration of TNSNAMES.ora, LISTENER.ora for SQL*NET connectivity and resolving connection problems.
• Strong skills in Database Management tools like Grid and OEM.
• Experience in cloning the databases on various platforms.
• Experience in creating the database using DBCA for Oracle 9i, Oracle 10g and Oracle 11g.
• Possess technical ability and self-initiative to learn and implement new concepts in short duration.
• A very good team player, self motivated, dedicated in any work environment with 24x7 support.
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.
• Excellent communication, documentation and coordination skills.

SKILLS:

Databases: Oracle 12c/11g/10g/9i/8i, SQL Server 2008 R2/2012

Oracle High Availability: Data Guard, ASM, 10G/11G RAC

Oracle Tools: SQL* Plus

Oracle Utilities: RMAN, Expdp/Impdp, SQL* Loader, Crontab

Operating Systems: RHEL/OEL/Solaris/AIX/HP-UX/Windows

Languages: SQL, PL/SQL & Visual basic

Scripting Languages: Shell/Perl Scripting

Other Tools: MS-Office, ER Studio, Erwin, TOAD

WORK EXPERIENCE:

Confidential, Cleveland, OH

Oracle DBA

Responsibilities:

• Responsible in providing 24*7 On call support for Production Databases.
• Responsible in creating 2-node RAC and creating 2-node Physical standby database.
• Responsible in upgrading RAC and standalone databases from 11.1.0.7 to 11.2.0.3 in production and non-production environments and also from 11.2.0.3 to 12c in non-production environments.
• Responsible for managing Oracle databases on UNIX, Linux and Windows platforms.
• Handled all standard database administrative tasks such as: installations, up gradations, configurations, back up and recovery, proactive performance tuning and monitoring, trouble-shooting.
• Coordinates strategies to move data between databases; Monitors database space requirements and adjusts for future needs.
• Responsible in performing rolling-over upgrades by applying one-off patches and PSU’s provided by Oracle support during maintenance window for 2-node RAC database.
• Experience in Administrating RAC Databases using SRVCTL, CRSCTL.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Done migration of non ASM database to ASM database.
• Responsible for administering ASM by adding Disks to the Disk Groups when needed.
• Responsible in restoring Tablespace on ASM in the event of data failure by creating duplicate instance on same production host by skipping unwanted tablespaces.
• Responsible for configuring high availability solutions like Active Dataguard.
• Granting Roles and Privileges for users.
• Created PL/SQL and shell scripts to automate batch jobs through crontab.
• Instantiated Physical standby database from Primary using Active Database Duplication for 11gR2 database.
• Responsible in performing Dataguard Switch-over and Switch-back exercises during the maintenance window.
• Responsible in performing cross-platform migration of databases from HP UX to Linux using Transportable Tablespace and Oracle’s EXPDP/IMPDP utilities.
• Responsible in implementing Oracle’s Transparent Data Encryption (TDE) Security in production/lab instances.
• Responsible in configuring and maintenance of Golden Gate replication between source and target.
• Performed FLASHBACK features to handle efficient database recovery.
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN.
• Responsible for monitoring and acting upon the alerts from Oracle Grid Control 11g.
• Performed scheduling of Change Control-activities and scheduling jobs.
• Worked on Datapump (Expdp/Impdp),Import/Export for logical database maintenance.
• Experience in using SQL*Loader by loading data from text files.
• Responsible in installing and setting-up GoldenGate from source to target to provide active data replication.
• Daily Health Check Up of the Databases and applications.
• Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
• SQL tuning and Application Performance monitoring.
• Done the documentation of various database activities like up gradations, migrations, change control activities, partitioning of tables, performance-tuning activities and provided on-site production support.
• Contact oracle meta link to resolve database issues and to raise SR’s.

Environment: ORACLE 11g/12c, UNIX/SOLARIS/Windows, RAC, ASM, DATAGUARD, RMAN, EMPDP/IMPDP, PL/SQL, FLASH BACK, SQL*Loader, TDE, GoldenGate, AWR, ADDM

Confidential, Boston, MA

Oracle DBA

Responsibilities:

• Responsible in providing 24*7 On call support for Production Databases.
• Experience in patching/upgrading standalone and 5-node RAC clusters from 11gr1 to 11gr2.
• Performed Rolling-over upgrades on RAC.
• Instantiated Physical Standby database for 3-node RAC.
• Refreshing Test/QA RAC databases from Production.
• Installation, configuration and upgrading of Oracle server software and related products.
• Good hands on experience in using GoldenGate.
• Responsible in taking Incremental level 0 & level 1 backups using RMAN.
• Cross platform migration using export/import from windows to Linux.
• Refreshed/instantiated Physical standby database using advanced 11gR2 features like Active Database Duplication (ADD).
• Responsible in setting up Active Data-guard for Mission Critical databases.
• Monitor Archive log/ Database backups, perform recovery for Lab/ Standby database instantiations.
• Responsible for creating SQL profiles for the problematic SQL’s to improve the performance.
• Responsible for finding the root cause of performance problems with ASH, AWR and ADDM reports.
• Experience in PL/SQL development, Shell scripting.
• Performed fine grain auditing and reporting on all databases which are required.
• Responsible for instantiating and maintaining high availability solutions using Active Dataguard.
• Responsible in switching over to Physical standby database during an disaster event.
• Responsible in instantiating Physical standby databases sizing about 30TB.
• Configuring Archive log and database backups from Standby databases and writing the shell scripts to do the cleanup of Archive logs on Primary instance.
• Monitored and maintained Standby Database and Database Replication to realize database high availability.
• Responsible in Managing and optimizing transactional replication in OLTP environments.
• Reviewing Space reports for the Databases, and participating in Capacity planning projects.
• Experience in troubleshooting alerts and logging service requests with oracle to solve the problems.

Environment: ORACLE 11g, RHEL, RAC, ASM, DATAGUARD, PL/SQL, RMAN, Performance Tuning (ASH, AWR, ADDM), GoldenGate

Confidential, Carlsbad, CA

Oracle DBA/SQL DBA

Responsibilities:

• Responsible in providing 24*7 On call support for Production Databases.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Used to do HOT backup every day and COLD backup once in two weeks on the application database techniques using RMAN and conducted disaster recovery drills.
• Designed database using DBCA and Database creation scripts.
• Backup and recovery using RMAN. Cloning development databases using RMAN.
• Designed and implemented data load process that is running two or more SQL* LDR together to improve oracle database loading capacity.
• Responsible for installing OEM agents and configuring database Target’s.
• Creating tablespaces, sizing the system table space, allocating default tablespaces for users.
• Responsible for monitoring and acting upon the alerts from Oracle Grid Control 10g.
• Responsible in switching over/switching back to Physical standby database and vice-versa and starting GoldenGate processes accordingly.
• Responsible in instantiating Physical standby databases sizing about 20TB using RMAN Image copy.
• Experience in using GoldenGate to support data replication in the Oracle database environment.
• Experience in installing and configuring GoldenGate 10.4 and setting up Uni-directional between source and Target.
• Used AWR, ADDM, ASH reports and SQL Trace for database performance statistics.
• Utilized TKPROF to read the execution plan.
• Managed performance tuning and find the root cause of performance problems with STATSPACK, and developed scripts to automate process and monitored database usage.
• Reviewed Space reports for the Databases, and participated in Capacity planning projects.
• Responsible for the creation of database and application objects (tables, views, indexes, packages, triggers, etc.).

Environment: ORACLE 10g, LINUX/UNIX, Oracle Enterprise Manager (OEM), Recovery Manager(RMAN), SQL Loader, GoldenGate, Data Pump(EXPDP/IMPDP), STATSPACK, AWR, ADDM, ASH, TKPROF

Confidential

Junior Oracle Database Administrator

Responsibilities:

• Installing, configuring and administering ORACLE 9i/8i on LINUX and Solaris.
• Create oracle databases (single instance) on configured servers using both the DBCA & Database creation scripts.
• Upgraded databases from Oracle 8i to Oracle 9i.
• Used Database export/import using EXP and IMP utilities to take logical backups.
• Performed Data loads using SQL loader utilities.
• Planning Backup and Recovery Strategies for various database environments using Recovery manager (RMAN).
• Developing hot, cold and logical backup scripts to automate the backup procedures.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Experienced with Space Management and Security.
• Developed Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.
• Writing scripts for the system and database for the effective functionality and report generation.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Perform capacity planning required to create and maintain database environments.
• Monitoring Database for fragmentation and correcting them.
• Management of table space growth, monitoring data files additions, extent growth
• Performed Database, OS and application tuning.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Contact to the development team to solve the issues with the new enhancement releases.

Environment: ORACLE 9i/8i, Linux, Sun Solaris 10.0,RMAN, DBCA, EXP/IMP, SQLTRACE, TKPROF, EXPLAIN PLAN.