SUMMARY

• 8+ years of professional experience as an Oracle Database Administrator (DBA) having an immense experience in Production, Development and Test environments in Installation, Administration, Monitoring, Trouble Shooting, Data Guard setup, Migration, Performance Tuning, Patching, Backup and Recovery, Cloning.
• Experienced in working with a team to provide 24/7 on - call support for Production and development and tests environments.
• Proficient in configuring, installing and maintaining Oracle on different environments like Red Hat Enterprise Linux, IBM AIX, Sun Solaris, HP - Unix.
• Extensive experience in configuring and migrating single instance to multimode, Real Application Cluster (RAC) setup using Grid Infrastructure including setup of Automatic Storage Management (ASM).
• Experience in upgrading databases from 9i to 10g and 10g to 11g, 11g to 12c.
• Experience in cross platform migrations using transportable tablespaces, RMAN convert and expdp/impdp utilities.
• Experience in installing and configuring OEM (Oracle Enterprise Manager) and OEM agents for Managing and Maintaining databases in large environments.
• Experience in configuring and maintenance of Oracle Data Guard Physical standby (11g and 10g) for both RAC and standalone databases.
• Experience in implementing FSFO (Fast Start Failover) on database and disaster recovery site using Data Guard.
• Experience in configuring, automating and implementing physical RMAN full and incremental backups (differential and cumulative) for all databases to recover from failures.
• Excellent knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).
• Expertise in performance tuning, specialized in Operating system tuning, SQL tuning, Database/Instance tuning.
• Expertise in Performance Tuning of Oracle database using AWR, ADDM, TKPROF, STATSPACK, SQL Tuning Advisor, Segment Advisor and tuning of SQL Scripts using SQL Trace, Explain Plan and Hints.
• Experience in configuring unidirectional and bidirectional replication using Oracle streams by configuring capture, propagate and apply processes.
• Experience in database cloning (10g and 11g active cloning) using RMAN duplicate and changing of both DBID and database names using NID.
• Excellent knowledge of tools like OEM, TOAD, DB Artisan and SQL Developer, SQL*loader.
• Experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM.
• Worked extensively with Oracle RDBMS, proficient in SQL, PL/SQL, Shell Scripting, ERWIN Data Modeling, Stored Procedures, Functions, Packages, Oracle Data Dictionary - Meta data, logical and Physical Database Design.
• Experience in maintaining and supporting Meter Data Management utility for application team.
• Experience in applying patches using Opatch to update the databases or to fix some of the bugs.
• Knowledge on Tablespace Reorganization (renaming controlfiles, datafiles, all systemfiles).
• Implemented automated daily backups using crontab and Tivoli by writing RMAN scripts and Korn shell scripts.
• Experience in modeling using Erwin tools.
• Demonstrated ability to quickly adapt to new environments and to continuously learn and apply new technologies. Ability to work independently with minimum supervision in a team environment.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 9/10, HP-UX 11i v1.5, AIX 5.3/6.1/7.1, RHEL 3/4/5, Windows 2003Windows 2000/NT, Windows XP.

Databases: Oracle 12c,11g, 10g, 9i, 8i, Microsoft SQL Server 2005, Oracle 12c/11g/10g Real Application Cluster (RAC), ASM.

DB Utilities: SQL*LOADER, exp, imp, EXPDP, IMPDP, RMAN, Opatch,TKProf, Utlbstat, Utlestat, StatspackAWR, ADDM, QOPATCH, NID, DBVERIFY, SRVCTL, CRSCTL.

Scripting: Shell Scripting Korn & Bourne, C Shell

Tools: Oracle Enterprise Manager 10g/11g/12c, TOAD, SQL Developer, Putty, SQL*PLUSSQL*Plus, ERWIN, SQL- Navigator, ERWIN.

Languages: SQL, PL/SQL for Oracle, MYSQL, C, C++, XML.

PROFESSIONAL EXPERIENCE

Confidential - San Francisco, CA

Senior Oracle DBA

Responsibilities:

• Upgraded/Migrated the production and development databases from 11.2.0.2 to 11.2.0.4
• Setup and configured 2 node Oracle 11g RAC with ASM.
• Performed Hot/Cold backups of the database using RMAN.
• Setup and configured Oracle Physical Standby database (Data Guard), where the standby database was used for disaster recovery.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Provided the database refreshes from production to staging, development and test environments.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Used Oracle 11g AWR & ADDM to monitor database activities and performance tuning.
• Involved in Database sizing, Capacity Planning.
• Initiated cron jobs to review alert logs and dump files to check for any ORA- errors.
• Performed Database Administration using OEM Grid and SQL scripts.
• Installed, migrated, configured and tested Oracle 11g databases in various environments.
• Performed Space Management & Troubleshooting the database issues.
• Upgrading OEM Repository and Installing OEM 11 Grid Control to monitor all the databases.
• Configured and managed agents to work efficiently with Grid Control.
• Setting up privileges to create local and remote objects.
• Configuring Oracle databases to effectively use the DISM (Dynamic Intimate Shared Memory) to dynamically shrink grow the SGA.
• Installing of quarterly security patches on all non-production and production servers.
• Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.
• Created 12c Standards document for installing and upgrading 12c and initially test and identify the issues in the release 1 and created SRs with oracle and identified work arounds and solutions.
• Identified the plan changes during peak hours and found the good SQL plans and created SPM.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Applied database patches using Opatch utility for Development and Production environments.
• Setup and monitored multi node RAC to RAC Data guard with real time apply for DR and offload backups.
• 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 regular the upgrade or maintenance operation.
• Wrote shell scripts for automation of tasks.
• Used shell scripts with crontab for job scheduling.
• On call Production Support on Shift Basis.

Environment: Oracle 10g/11g RAC/12C, 11g Oracle Enterprise Manager, Redhat Linux, IBM-AIX, Oracle Partitioning, Oracle Replication, Oracle Streams, Grid Control, Oracle Express, Goldengate, RMAN, Opatch, expdp, impdp, AWR, ADDM, Statspack,, SQL*Plus, PL/SQL, SQL*Loader, Toad and SQL Navigator.

Confidential - Milford, OH

Senior Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g/11gR1/11R2 enterprise edition databases on Red Hat Linux 6.2, Solaris and AIX platforms.
• Involved in Creation of standard document for installing binaries, patches and pre/post upgrade steps.
• Migrated oracle databases from 10g to 11g version and applied patches.
• Implemented and maintained RAC, Data guard and Streams on RHEL and Solaris.
• Installed and configured Oracle OEM Grid control and intensively used Diagnostic & tuning packs.
• Certified and applied CPU patches on Solaris, AIX and Red Hat Linux platforms in RAC and Non-RAC Environment.
• Provided Support to users in resolving Issues, Tickets, in a RAC Environment in Retail Services.
• Expertise in Administrating RAC Databases using SRVCTL, CRSCTL.
• Performed Database Refresh in RAC Environment using transportable tablespaces, expdp, impdp on Solaris, Red Hat Linux and AIX Platforms.
• Interacted with the users and troubleshooting the problems involved with the development of stored procedures, triggers.
• Extensively used Explain Plan, SQL Trace, AWR, ADDM and ASH reports to Monitor database performance and tune the expensive SQLs.
• Implemented backup and recovery procedures using RMAN with Oracle Import/Export & Datapump utilities (impdp/expdp).
• Build Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Performed performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE and TKPROF.
• Created and maintained databases: Creating tablespaces, tables, indexes, views and materialized views.
• Monitored table space size, resizing table space, relocating data files for better disk I/O.
• Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging Databases.
• Performed data loads using SQL*Loader, Export, Import for backing certain tables.
• Installed, configured and administered Goldengate 10.4.0.19, 11.1.1.1. on Oracle Servers.
• Actively involved in designing/Testing of Disaster Crash recovery scenarios during Dataguard switchover/failover including Golden gate extracts and trail file generation.
• Provided 24x7 production support and on call rotation.

Environment: Oracle 11g, 10g, RedHat Linux, IBM AIX, Sun Solaris, OEM grid, Data guard, RAC, Goldengate, RMAN, STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, SRVCTL, CRSCTL, SQL Trace, AWR, ADDM,, SQL*Plus, PL/SQL, SQL*Loader, Toad.

Confidential - Sunnyvale, CA

Oracle DBA

Responsibilities:

• Supported multiple databases including development/production sizes up to 5 TB for 24/7.
• Installed and configured the Oracle server software and related products. Upgraded databases from 10.2.0.3 to 11gR1 on RHEL and AIX.
• Completely build RAC from scratch including OS and RAID configuration.
• Attended meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Attended DBA meetings and provided input to Develop, revise and implement policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Monitored and maintained 2/3 node RAC database on Red Hat Linux. Provided DBA support needed for the development and test teams.
• Maintained sound backup and recovery policies and procedures using RMAN, Monitored the scheduled backup procedures for daily basis using crontab.
• Used RDA, ADDM and AWR reports to monitor the database performance.
• Implemented SQL outline to get the better execution plan for the offending queries.
• Developed stats gathering scripts and scheduled cron jobs to gather stats daily.
• Performed Database Tuning & Performance, Storage Management, Database Monitoring, Security Management and Tuning SQL queries.
• Day-to-Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.
• Performed various tasks like administering RAC using SRVCTL, adding nodes and instances, administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Served as part of a 7 member DBA team which was involved in the maintenance of the Oracle 10g/11g databases for the Production as well as the development environments.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g.
• Performed database cloning, export and import datapumps to setup identical databases in the production and development environments.
• Created and maintain users, roles and privileges.
• Involved in configuring and setup of Dataguard( primary and standby databases)
• Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.
• Performed Database Administration using Oracle Enterprise Manager and SQL scripts.

Environment: Oracle 10g, 11g; RHEL, AIX, Windows NT/2000, TOAD,RAC, Grid Control, OEM, RDA, ADDM, AWR, RMAN, SQL Developer, SQL, SQL*Plus, PL/SQL.

Confidential

Oracle DBA

Responsibilities:

• Involved in migration of 9i to 10g.
• Installed 10g oracle binaries and configured the parameters required and Upgraded Oracle 9i(9.2.0.8) database to Oracle 10g(10.2.0.4) database.
• Created Oracle SR's for oracle support.
• Involved and Implemented Disaster Recovery Plan (Oracle 10g Data Guard).
• Installed and used Oracle 10g OEM Grid control for monitoring and accomplishing Database Administration tasks.
• Took the cold backups before and after upgrade of the database.
• Provided scripts for replicating tables between databases using streams ( capture, propagate and apply scripts).
• Performed Backup/Recovery of the Oracle databases using RMAN Incremental & Hot Backup.
• Wrote scripts for Cloning and Duplicating databases.
• Used export/import datapump utilities for backups and restore.
• Applied the Oracle and CPU patches to all test, development and production databases.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases.
• Monitored infrastructure tier and middle tier processes using OEM 10g.
• Performed database tuning using STATSPACK, TKPROF, SQL Trace and Explain Plan.
• Developed Korn, Perl, shell scripts for automating the routine Database jobs.
• Created database links to retrieve data from multiple servers.
• Used EXPORT/IMPORT to do table level and full database de-fragmentation.
• Performed query tuning and performance monitoring.
• Performed off site on call 24x7 production support for Oracle 10g database administration activities.

Environment: Oracle Database 10g/9i, SQL, PL/SQL, Sun Solaris, HP-UX11, Red Hat Linux 4.5, RMAN, STATSPACK, TKPROF, expdp, impdp.

Confidential

Oracle Developer / DBA

Responsibilities:

• Involved in writing technical specifications based on the Requirement documents and refining application data model.
• Created database objects - Tables, Indexes, Synonyms, Views and Sequences.
• Wrote complex SQL queries, Views for Generating Reports.
• Wrote PL/SQL procedures, functions, triggers and Packages.
• Involved in Design and development of the new application.
• Analyzing, Designing, Development, Unit Testing and Deployment of the Oracle apps forms enhancements.
• Involved in all stages of project lifecycle, from business requirements and technical definitions to development, migrations, Staging, testing, user acceptance testing (UAT), production support, and completion.
• Responsible for fixing any production support EBF (Emergency Bug Fix) related to PL/SQL and UNIX.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc.
• Wrote scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain tablespaces and other database objects.
• Performed day-to-day database administration tasks like tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs.
• Written UNIX shell scripting to automate tasks and crontab and dbms scheduler for scheduling jobs.

Environment: Oracle 9i, Sun Solaris 9.0, RedHat Linux 4.0, HP-UX, Windows 2003, ASM, OEM, SQLPlus, SQL, PL/SQL and TOAD.