SUMMARY:

• 8 years of experience as an Oracle Database Administrator having hands on experience in database administration and performed different tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security.
• Experience in Installation of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Configured multiple database instances using ASM instance.
• Troubleshoot performance issues for the RAC instances.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files
• Providing DBA support to multiple Cluster, Non Cluster and ASM Database in production, development and Testing Servers in UNIX, AIX & Windows Environments.
• Resolved/Diagnose Node Eviction.
• Add or Remove Node from RAC.
• Implemented &configuring replication technology using Dataguard & Oracle Goldengate installation.
• Installation, Configuration and Maintenance of Physical/Active standby databases in Data guard.
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases.
• Resolving the different sync issues in DR by identifying the root cause and resolving the same, restore logs and applying manually if necessary.
• GoldenGate Install, Configuration, Maintenance, Trouble Shooting and Upgrade.
• Experience in Uni - directional, By-directional and Integrated Capture data replication using GoldenGate.
• Resolving the issues in conflicts between the target and source database in Goldengate.
• Cross platform Migrated from Solaris to Linux and Upgraded database from 11g to 12c Using Golden Gate with Zero downtime.
• Upgrade of Grid and Oracle Infrastructure on multi node RAC cluster from 11.2.0.3 to 11.2.0.4.
• Performed Migration between different datacenters, Non ASM to ASM, Single instance to RAC.
• Extensively worked on identifying bugs and installing necessary/latest CPU/PSU patches in a rolling fashion for both the Clusterware home and Database home.
• Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows Environments.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM Grid) 10g/11g/12c
• Performed Migration and Up gradation of databases to 10g and 11g.
• Experience in Tuning oracle database on EXADATA V2(X2-2) machine that is only manufactured by oracle.
• Experience in Construction of Catalog Databases and developed scripts to perform Backups using RMAN.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery and disaster recovery.
• Well Experienced in taking Cold Backup for a very huge 15-Tb Database.
• Installation and configuration of Recovery Catalog for multiple Databases.
• Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).
• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network Attached Storage (NAS).
• Experience in configuring, managing and monitoring ASM for standalone and RAC databases
• Administrated database of various sizes from 40GB to 5TB
• Experience in Oracle Patching for 9i, 10G and 11G.
• Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.
• Experience in SQL tuning using Explain Plans and Hints.
• Experience in Performance Tuning for better performance. Identifying bottlenecks with memory and disk contentions.
• In-depth study of Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Experience in UNIX Bash Shell Scripting.
• International experience and exposure in three different countries: India, Australia and USA

TECHNICAL SKILLS:

Databases: Oracle 11gR2, 10g, 9i, SQL Server 2005 and 2008

Oracle Products: Oracle 10g (Grid Control), OEM (Oracle EnterpriseManager), RMAN, OEM 12C, SQL*Loader, Import and Export(EXPdp/IMPdp), ASM, SRVCTL, EXADATA V2(X2-2),SQL* LoaderAnd SQL * Net.

Operating System: RHEL 4, RHEL 5, OEL 4, WIN NT/2003/2008, Solaris 10,HP-UX Itanium, IBM AIX

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

Other Tools: TOAD, Putty, SQL Developer, Erwin.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• 24 hrs production support.
• Provide DBA support with a high degree of customer service, technical expertise, and timeliness. Provide adequate and creative solutions to user problems of reasonable nature to ensure user productivity and assuring data is protected and recoverable as required.
• Analyze load and capacity allocation and participate in performance debugging exercises when required. Plan for backup and recovery of the database, and allocate system storage and plan future storage needs.
• Study relevant business processes, understanding application design/behavior and the data flow, criticality and dependencies.
• Responsible for configuring, administering, and maintaining the database environments in a RAC configuration.
• Upgraded database from 11g to 12c.
• Upgrade of Grid and Oracle Infrastructure on multi node RAC cluster from 11.2.0.3 to 11.2.0.4.
• Performed Migration between different datacenters, Non ASM to ASM, Single instance to RAC.
• Extensively worked on identifying bugs and installing necessary/latest CPU/PSU patches in a rolling fashion for both the Cluster ware home and Database home.
• Responsibilities include database upgrades, patching, security, troubleshooting and issue resolution and backup procedures using RMAN and data pump.
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases by configuring Physical/Active standby databases.
• Create automated scheduled jobs for integrity checks, index defragmentation and update statistics.
• Good in Database and Transaction log Backups and Restoration, backup strategies, scheduling the backups.
• Resolving the different sync issues between primary and standby by identifying the root cause and resolving the same, restore logs and applying manually if require.
• Performing and prepare maintenance for adding new luns, changing IP’s and kernels for Production environment.
• Configure, monitor and trouble shoot Nimbus monitoring tool.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML

Confidential, COLUMBUS, OH

Oracle Database Administrator

Responsibilities:

• Installed and Configured 2node RAC on Linux.
• Installed and Configured and maintained oracle 10g and 11g.
• Oracle Grid Control 11g Installation and Configuration.
• Refreshing the Database from one version to another version.
• Configuration of Physical Standby database for maximum performance mode - Oracle Data Guard
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM
• Working Knowledge of installation and configuration of GOLDENGATE in Unix environment
• Done Installation and configuration of golden gate on 11g database for the replication.
• Implemented Bi-Directional replication in golden gate from target to source and source to target.
• Resolving the conflicts between the target and source database.
• Configuring parameters for DDL support in golden gate replication
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health checkup of the database using TKPROF, AWR, ADDM.
• Monitoring alert log/system log and managing Database Locks and blocking sessions
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML

Confidential, Denver, CO

Oracle DBA

Responsibilities:

• Installed Oracle DB 10g, 11g RDBMS, RAC on ASM, Applying Oracle Critical patch updates, Implementing and Manage Data Guard, Replication, Backup and Recovery support and performance tuning etc.
• Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments and Oracle Grid Control11g Installation.
• Migrated Non-ASM databases to ASM environment for high availability using RCONFIG.
• Worked on OEM 12C grid for monitoring the Listeners present in the oracle environment.
• Worked in troubleshooting RAC and implemented ASM features.
• Applied necessary Patches during installation and also in up-gradation of databases.
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and disaster recovery databases.
• Involved and Upgraded Analytical Databases from 10g to 11g.
• Installation and configuration of Goldengate on 11g database for the Bi-directional replication.
• Resolving the issues in conflicts between the target and source database in Goldengate.
• Involved in deploying new application and setting up replication between the databases using Goldengate
• Handy in utilizing Datapump tool for exporting and importing the data between databases.
• Used Datapump for schema refresh, and RMAN for database refresh and used RMAN for backing up databases
• Well Experienced in taking Cold Backup for a very huge 15-Tb Database.
• Daily backups using RMAN.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• Having good exposure in user management, Table space Management, Session Management, undo Management issues.
• Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
• Generated AWR, ADDM and ASH reports for database issues
• Installed 12c agents on hosts and discovered targets.
• Created new Groups, Templates, and Incident Rule sets in OEM 12C.
• Designed and tested patching through OEM 12C.

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, EXADATA X2-2, ASM, AIX, Golden Gate, Database Control, TOAD, OEM 12c, ASM, AIX, Golden gate, Tivoli

Confidential

Oracle Database Administrator

Responsibilities:

• Installation and configuration of Oracle software 10g version.
• Created databases, allocated system storage and planned future storage requirements for the database.
• Installed Oracle and related tools, upgraded the database and applied patches as and when required.
• Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Configured the Data guard for switchover and failover and thereby providing high availability.
• Coordinated operating system setup/upgrades and infrastructure troubleshooting in partnership with system administrators.
• Implemented Recovery Manager (RMAN) Recovery Catalog performed Complete and Incomplete recovery.
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Implemented Cloning to migrate data from PROD to Test and Dev databases.
• Performed Capacity planning and storage management.
• Estimation of database growth and analysis.
• Reorganization of tables and rebuilding of indexes.
• Maintained a disaster recovery site and planned and instituted disaster recovery process.
• Coordination with the team and ORACLE Support for troubleshooting the database issues.
• Developed UNIX Shell scripts to backup and recover the Oracle databases.
• Modified shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
• Worked as a team member to provide 24x7 on-call production database support.

Environment: Oracle 9i/10g, LINUX, Windows 2003 server, OEM, Shell Scripting, PL/SQL

Confidential

Junior Oracle Database Administrator

Responsibilities:

• Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Involved in optimizing SQL statements using Indexes and Hints.
• Made use of the REF CURSORS in stored procedures for report generation.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.
• Involved in writing complex SQL statements.
• Developed backup and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions wherever possible.
• Co-ordinate with System administrators, application developers for various activities.
• Maintained database security by managing users roles, privileges. Implemented new security rules via roles as per the company policies.
• Tuned the performance of the SQL’s using TkProf and Statspack reports.
• Performed security management and accessibility control by managing OS and Password file authentication, creating profiles, privileges and roles.

Environment: PL/SQL, Oracle 10g, TOAD, SQL PLUS, PL/SQL Developer, HP-UX 11.0