SUMMARY:

• 8+ years of experience in Information Technology in various roles, as an Oracle Database Administrator having hands on experience in database administration and performed different tasks like installation, configuration, upgrades, patches, performance tuning, Golden Gate, backup and recovery, production support, cloning, space management, database security, monitoring the database using OEM Grid Control, shell scripting using ORACLE 12c/11g/10g/9i.
• Install and configure Container and Non - Container 12c databases, Pluggable databases - Architecture, Installation and the concepts associated with 12C database.
• 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 Golden gate installation.
• Installation, Configuration and Maintenance of Physical/Active standby databases in Data guard.
• Configured Replication between Active-Active Database's with golden gate replication .
• Implemented High availability using Golden Gate Replication.
• Configured Replication between different structured Target and source with DEFGEN and COLMAP.
• Performed Data Transformations in PUMP and Replicate .
• Handled CDR's (conflict Data Resolution's), wrote exceptions to catch issues .
• Tuned golden gate replication using parameters like BATCH-SQL, PARALLEL and MAX PARALLESIM. configured lag monitoring and heart beat table in Golden Gate .
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases.
• Configured cascade standby databases using active duplication.
• Resolving the different sync issues in DR by identifying the root cause and resolving the same, restore logs and applying manually if necessary.
• Golden Gate Install, Configuration, Maintenance, Trouble Shooting and Upgrade.
• Experience in Uni-directional, By-directional and Integrated Capture data replication using Golden Gate.
• Resolving the issues in conflicts between the target and source database in Golden gate.
• Cross platform Migrated from AIX to Linux and Upgraded database from 11g to 12c Using Golden Gate.
• 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 data centers, 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.
• Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities.
• Strong knowledge and experience of managing Oracle 9i and 10g RAC environments using the OEM Grid Control tools.
• Worked on Performance optimization of large objects (LOB, BLOB, CLOB) by monitoring redoes generation, increasing log buffer size, blocksize and changing archiving procedures and Query tuning using Statspack, TKprof and OEM.
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, ADDM, Advisories, TKPROF, EXPLAIN PLAN for the Better performance.
• Expertise in creating and scheduling jobs through OEM.
• Performed Export/Import through Data Pump.
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Implemented basic replication through Materialized Views.
• Expertise in cross platform data migrations using Transportable Table spaces.
• Excellent Troubleshooting skills in OS level and Database level.
• Experienced in using 10g features like Flash-Back Recovery Area (FRA).
• Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows Environments.
• Install and configure Cloud Control 12c, deploy 12c agents on the target servers and monitor databases.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM Grid) 10g/11g/12c
• Installed Oracle 12c database and OEM 12c Cloud control on Linux server.
• Worked on building and rolling out new 12c databases for test/dev/SIT/UAT environments.
• Setup and configured Oracle enterprise Manager Cloud control 12c and use it as a tool of
• Administration, monitoring and performance tuning.
• Implemented OEM 12c Repository database, Backup strategies using OEM12C, OEM 12c
• Agent and golden gate plug-in Installations.
• 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.
• Involved in moving databases in Exadata RAC environment and also Implemented DBFS on Exadata.
• 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. Daily backups using RMAN.
• 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, ADRCI for Oracle Database diagnostic data, 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.

TECHNICAL SKILLS:

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

Oracle Products: Oracle 10g (Grid Control), OEM (Oracle Enterprise Manager), RMAN, OEM 12C, SQL*Loader, Import and Export (EXPDP/IMPDP), ASM, SRVCTL, EXADATA V2(X2-2),SQL*Loader And SQL * Net, RAC, OUD, Golden gate Replication.

Operating System: RHEL 4, RHEL 5,RHEL 6, Linux 9/8/7.2/7.1/6.2 , 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.

Web technologies: HTML 5, Java Script, CSS, HTTP, TCP/IP

WORK EXPERIENCE:

Confidential

Sr. ORACLE DBA

Responsibilities:

• Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) 4 node RAC on EXADATA X2-2 HALF RACK.
• Installed, configured and maintained Oracle Database 12c
• Deploy the 12c agents on the target servers and add the target Configuration Items to monitor.
• Plug-in installations on the target servers to extend the functionality of OEM
• Configure Oracle Advanced Security to implement Transparent Data Encryption at table space, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Setup physical standby’s (DATAGUARD) for several Databases (via OEM as well).
• Implemented DBFS on EXADATA.
• Implemented PARTITIONING using EXCHANGE PARTITION method to improve the performance of the database
• Configure Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status
• Upgrade existing 10g/11g databases to 12.1.0.1 on HP database machine using transportable table space method. Upgraded supported versions using DBUA (direct path upgrade)
• Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate
• Performing the initial load using (expdp and impdp) from source to target.
• Golden Gate performance issues were resolved by splitting the process into subsets, so that performance is improved.
• Troubleshooting Golden Gate process abends, analyzing report files, error log file and discard files.
• Worked on Log dump utility of Golden Gate .
• Performed skipping the transactions which are not necessary using log dump utility.
• Good at altering the Rba for replica during the troubleshoot of Golden Gate based on the transaction type and not missing any transactions.
• Maintenance of Golden Gate process during the batch loads.
• Golden Gate monitoring was done using the cron jobs, where it does report a mail in case of a process abend or Lag more than threshold and any Checkpoint.
• Worked on Shell Scripts for the Golden Gate monitoring and Trail file system size alerts.
• Worked on huge no of database decommissions and also server level decommissions.
• Worked on Adding and removing targets to OEM 12c.
• Implement Oracle Multimedia and Text options.
• Backup/Restore & Recover of the databases using RMAN and FLASHBACK database procedures.
• Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using data pump.
• Good experience with OVD and resolving connection Issues, registering and removing databases from OVD.
• Database Installation, Upgrades and Patching. Upgrade the binaries by applying patch set and interim patches using opatch and opatch Auto.
• Capacity planning for the projects owned in the environment.
• Configuring the disks and slices for ASM
• Effective Production Support and off hour support, support handover.
• Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.
• Storage Migrations: Solely responsible for migrating the Prod/Test/Dev/Sit/UAT Databases from Net App to HNAS and also to block level storage. (Migrating the databases from Non-ASM to ASM)
• User management, Table space management, file system space management, backups management
• Create, Track and work and tickets (Change Requests, Work Orders and incidents) generated from PAC2000 (BMC Remedy) Tool.
• Generate reports needed to provide details with number of tickets closed, current status, average age on tickets to client from Remedy’s Business Analytics tool.
• Execute changes to database based on preapproved change requests
• Installs necessary tools on infrastructure (deploying agents, RMAN FRAMEWORK, control M, RMAN framework, 12c agents)
• Deliver the reports on time as agreed. Follow-up all actions items and provide status.
• Training the new team members on Security Baselines and Installation Qualifications.
• Monitor and educate team with new processes and standards.
• Effective Production Support and off hour support, support handover, off-shore co-ordination.

Environment: Oracle 12c/11g/10gon Unix/Windows, Oracle EXADATA X2-2 HALF RACK 4,7/Oracle 11g, Red Hat Linux 5.8, RHEL 6,AIX 6, OEM 12c, RAC, Oracle Advanced Security, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, OVD, Performance tuning, opatch Auto, TOAD for oracle 12.1/11.6, SQL developer, Golden gate, Storage Migrations.

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.
• Worked on OEM 12C grid for monitoring the Listeners present in the oracle environment.
• 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.
• Installation and configuration of Golden gate on 11g database for the Bi-directional replication.
• Resolving the issues in conflicts between the target and source database in Golden gate.
• Performed Data Transformations in PUMP and Replicate .
• Handled CDR's (conflict Data Resolution's), wrote exceptions to catch issues .
• Tuned golden gate replication using parameters like BATCH-SQL, PARALLEL and MAX PARALLESIM. configured lag monitoring and heart beat table in Golden Gate
• Involved in deploying new application and setting up replication between the databases using Golden gate.
• 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, EXADATA X2-2,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 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.
• Handy in utilizing Data pump tool for exporting and importing the data between databases.
• Used Data pump 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, ASM, AIX, Database Control, Data guard,RAC,TOAD, OEM 12c, ASM.

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