Oracle Manager

Venkata Raj

Sr. Oracle DBA

Email: **********@*****.*** Phone: 732-***-****

Experience Summary:

* ***** ** ********** ** Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software 12c/11g/10g/9i on Sun Solaris, Red Hat Linux, HP-UX, and Windows Platform.

Experience in Installation, Configuration, physical and logical backups, upgrade/migration, Cloning, Data pump, Data guard, Performance Tuning, RAC, ASM, Golden Gate, on different HP-UX, Sun Solaris, Linux, UNIX AIX, and Windows servers.

Experience in installation, configuration and administering 2/3/4 node Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM) including active monitoring of ASM disk groups for their load balancing and redundancy.

Experience in upgrading the database from Oracle 9i to Oracle 10g, oracle 10g to oracle 11g & oracle 11g to oracle 12c and migration of the databases using transportable database, tablespaces export/import, data pump utilities.

Experience with Building RAC, Data Guard, Golden gate, and RMAN.

Migrating databases to Exadata.

Planned and implemented Oracle 10g RAC, 11gR2 RAC and Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).

Experience in installing and patching ASM with Oracle (RAC) on AIX, Solaris and Linux platforms.

Experienced in configuring resource allocation, information sharing, and high availability with (RAC)

Designed and implemented centralized backups and recovery strategies using recovery manager (RMAN).

Experienced in installation, configuring and managing Golden Gate V10x, V11x on Oracle 10g and 11gR2 with Linux, HP-UX and Windows platforms.

Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.

Expertise on performing cold backups, hot backups, advanced recovery methods like flash back recovery using (RMAN) recovery manager.

Software and firmware maintenance of the Exadata storage servers in the Database machine including upgrades and patching.

Replicate schemas using Golden Gate schema replication which includes online change synchronization and ddl synchronization.

Experience in using SQL, PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance.

Performance Tuning: Experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, (OEM) Grid Monitoring.

Implemented strategy for partitioning and management of historical data tables in RAC

Experience in proprietary change management processes to prevent production disruptions and outages.

24*7 production database support with support to developers & end-users.

Good communication and coordination with different departments (IT & Non-IT) for efficient problem escalation and deciding on optimal solution.

Technical Skills:

Operating Systems:

Sun Solaris 9/10, HP-UX 11i v1.5, AIX 5.3/6.1/7.1, RHEL 4/5/6, Windows all Versions.

Databases:

Oracle 12c, 11g, 10g, 9i, 8i, Sybase 15,16, Microsoft Sql Server 2008,2012, Real Application Cluster (RAC), ASM, Goldengate.

DB Utilities:

SQL*LOADER, Data Pump, RMAN, Opatch, TKPROF, Statspack, AWR, ADDM, SRVCTL, CRSCTL, ASMCMD, ASMCA, DBCA, ADRCI and DBUA.

Tools:

Oracle Enterprise Manager 10g/11g/12c, TOAD 8.5, SQL Developer, Logminer.

Languages:

SQL, PL/SQL for Oracle, C, Java, Php, .NET

Professional Experience:

Project: UBS, Weehawken, NJ Dec 2016 – Present

Role: Sr. Oracle DBA

Responsibilities:

24*7 on call rotation supporting over 500+ production database.

Worked on Oracle 11g and upgraded to 12c.

Successfully maintained RAC environments of 3Nodes with ASM file system using cluster ware Responsible for applying quarterly PSU security patches.

Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.

Installed and configured extended 11g RAC on Linux.

Created oracle database tables, materialized views, objects with storage parameters based on quarterly growth requirements of the system.

Assisted in integration of Exadata applications into current IT actionable events and solutions.

Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control.

Responsible for RMAN backups and improvement to backup with incremental back by adding block change tracking feature of Oracle 11gR2.

Install and configure Oracle Golden Gate.

Created Users, Roles and Profiles, Privilege management with role-based security.

Configuring and using Oracle Log miner and Oracle Flash Back for recovery of the objects.

Performed database tuning using Explain Plan, TKPROF, Statspack, AWR, ADDM, ASH, SQL Trace and other custom utilities.

Integration of Exadata monitoring and escalation.

Experienced in using 11g features like Database Replay, Partitioning, Logminer, and Schema Management.

Configured and implemented Oracle 11g ACTIVE DATA GUARD for Database Disaster Recovery by using DATA GUARD broker (DGMDRL).

Performed logical backups of schemas and database using Data Pump (expdp/impdp) as per requirement.

Installation of Oracle 11g Grid and respective agents on databases, application servers, predefine templates with group option to monitor Prod, UAT and Dev Databases.

Performed Cross platform migration using transportable, tablespaces and RMAN.

Done migration of non ASM database to ASM database.

Monitored backups, space usage, and user activity on daily basis and Performed daily hot backups and weekly Cold backups using RMAN.

Altered, modified, Partitioned, dropped, created Database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM.

Trouble shooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.

Used Export/Import, DataPump Utilities to move the data between different databases and for backups.

Involved in deployment process from dev to production environments.

Implemented and supported Golden Gate replication in production databases.

Installed and configured Golden Gate on 11g RAC database running on ASM for replication.

Configured unidirectional Golden gate replications at table and schema level.

Troubleshooting Golden Gate issues such as process abending and lag on replication environments.

Environment: AIX 6.3,7.1, Sun Solaris 2.6/7/8, RHEL, Red Hat Linux 6.0, Oracle 10g/11g/12c, Oracle 12c GRID, Oracle RAC, Data guard, TOAD 8.6, SQL server.

Project: DTE ENERGY, Detroit, MI Aug 2014 – Nov 2016

Role: Sr. Oracle DBA

Responsibilities:

Implemented Oracle 11g active standby database and worked on building and rolling out new 11g databases for test, dev and production database environment.

Worked on upgrading of oracle databases from 10.2.0.4 to 11.2.0.4 and successfully Installed and Configured Oracle 11g Golden Gate on Oracle 11g Database.

Maintained load balancing and disaster recovery actions and resolved conflicts with triggers data looping lag through Golden Gate bi-directional replication.

Involved in 24x7 support for 4 Node production RAC database and maintained through CRSCTL and SRVCTL.

Documented the necessary procedures as per the industry requirements for data guard, RAC installation and DataPump setup processes.

Configured Active Data Guard (physical Standby) to ensure high availability, data protection and Disaster recovery (DR) for enterprise data.

Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

Involved in setting up Grid Control for Monitoring Exadata X3 and upgrading exadata database machine from half rack to full rack.

Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.

Configured unidirectional Golden gate replications at table and schema level.

Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.

SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and STATSPACK.

Performed Cross platform migration using transportable tablespaces and RMAN.

Performed full and incremental backups using RMAN and created catalog database.

Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN incremental backups.

Extensively used Oracle Application Server 10g, in deploying and integrating enterprise’s applications.

Migrating and upgrading the Oracle 10.2.0.5 database to Oracle 11.2.0.4 also performed version upgrades and patch installs.

Loading bulk data from flat files using SQL*loader and external tables.

Installation of Oracle Fail Safe on Microsoft Cluster server.

Environment: Oracle 11g/10g, SQL, TOAD (10.1), RMAN, OEM, SQL*Loader, TKPROF, Data Guard, Shell Scripts, Golden Gate, AWR, ADDM, Windows 2008, RHEL 4.0, AIX-5.3

Project: CAPTIAL GROUP, LA, CA Jan 2014 – Aug 2014

Role: Oracle DBA

Responsibilities:

24x7 production database support

Installed and maintained 10g/11gR2 databases for testing, development and production

Database Monitoring and administration of database using Enterprise Manager Grid control (OEM).

Upgraded Oracle Database from 9i to 10g, 10g to 11gR2.

Cloning of the database from Production to the Test and Development environments using RMAN and conventional methods.

Installed and configured oracle grid control.

Performed logical backups of schemas and database using DataPump as per requirement.

Performed Cold backup, hot backup using conventional backups and RMAN, recovered various and critical Production databases.

Assisted in management and database administration of Oracle database applications on Exadata platforms.

Prepared backup schedule which include offline, online and logical backups.

Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.

Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.

Generated performance reports and Daily health checkup of the database using utilities like AWR, Statspack and ADDM to gather performance statistics.

Partition of tables to improve performance.

Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases.

Worked on SQL* Loader to load data from flat files, checking for Row Migration and Chaining on Highly used transaction tables.

Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

Created DB links across databases and Solved Database connectivity issues by continuously monitoring the status of the listeners and instances.

Checked alert logs and background trace files on daily basis and resolved problems.

Automated shell scripts and scheduled batch jobs.

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Data Guard, Shell Scripts, AWR, ADDM, RHEL 4.0.

Project: BSNL, Hyderabad, India Jun 2012 – Dec 2013

Role: Jr. Oracle DBA

Responsibilities:

Provided 24x7 Support of Critical Databases and worked on enhancing the Database Monitoring process.

Upgrading database from 8i to 9i and troubleshooting issues during upgrade, applying patches to fix issues.

Responsible for refreshing/cloning test instances with Production Instance periodically.

Administration of databases- Physical and logical structures.

Creating and Managing users, Granting and Revoking privileges for the users in order to ensure the Database security.

Automated jobs to run backups, disk cleanup for logs and archive logs, gather statistics.

Identify and troubleshoot long running queries, locked sessions to improve overall performance.

Established and wrote the Database Administrators Procedures document for the IT department.

This document highlights all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, policies, practices and procedures.

Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self-tuning purposes.

Monitored the databases and added the data files to the tablespaces or resizing the tablespaces and monitored the sessions running on the databases.

Managed and supported users by creating roles and privileges for database access and data manipulation.

Reported the database storage capacities to Project Management and organized the capacity planning of the production database.

Environment: Oracle 9i/8i, Solaris, Linux, RHEL 4.0, HP-UX

Project: Kotak Mahindra Bank, Chennai, India Jan 2011 - May 2012

Role: Database Administrator

Responsibilities:

Proficient in installation and creation of Oracle 9i, 10g databases in development, Production and QA environments including configuration, backup & performance tuning.

Designing, documenting and deploying through the various development and production environments.

Refresh/Cloning of the databases from Production to the Test and Development environments.

Upgraded database from Oracle 9i to Oracle 10g.

Installation and Configuration of Oracle 10gRAC and Standby Databases for high availability and disaster recovery.

Database Migration

Worked with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.

Configured Active Data Guard (physical Standby) to ensure high availability,

Planned and implemented Backup & Recovery using RMAN.

Implemented Cold Backup and Hot Backup depending on the requirement.

Refreshed development and test databases from production using Logical Backups (Export and Import).

Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, AWR, STATSPACK.

Daily Health Check Up of the Database using ADDM with the help of AWR report.

Written SQL, PL/SQL scripts and Shell scripting to monitor table space and extent growth. Space Management, which includes table space creation, adding new data files.

Maintaining Database Security by Creating Roles, Privileges, Quotas, and Passwords.

Troubleshooting and Technical Support on Oracle Database & Oracle Applications and Network Administration using SR, SAR, IOSTAT and RDA.

Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption).

Environment: Oracle 9i/8i, Solaris, Linux, RHEL 3.0, HP-UX.

Contact this candidate