Oracle Data

Pavan Anam

ORACLE DBA – JPMORGAN CHASE, NY

Senior Oracle DBA with 14 years of diversified experience in IT services and Infrastructure Management, Providing production and development support 11g/10g/9i/8i databases on different platforms like HP-UX, SUN SOLARIS, AIX, Red Hat Linux and Windows. Experience in Installing, Administering, Upgrading and Maintaining Oracle 9i/10g/11g Databases.

Worked in a 24X7 Production support environment.

Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, capacity planning, space management, database security, auditing, troubleshooting, database reorganizations and documentation.

Sound knowledge of Oracle RAC (10g, 11gR2, 12c) administrations, installation, migrations and upgradations.

Knowledge on 12c PDB and Non PDB databases administration.

Configured golden gate unidirectional and bi-directional.

Oracle RAC Administration with ASM, Data guard and Golden gate setups.

Oracle CPU, PSU installation on RAC databases and non RAC databases which has Data guard and Golden gate setup.

Implementation of High Availability solutions with Oracle 10g RAC, 11g RAC, Data Guard.

Sound understanding of Oracle Database Architecture, Configuration.

Migrated Terabyte size databases in cross platforms from Solaris to Windows and Solaris to Linux using Transportable tablespace.

Tuning – Inefficient SQL statement, waits event, buffer cache diagnostic and sizing.

Sound knowledge on 10g,11g and 12c OEM configuration and administration

Backup and Recovery – Taking Hot Backup, Cold Backup, Data pump, Export, Import, Incremental backups and recovery scenarios.

Knowledge in shell scripting.

Implemented Bi-directional replication between Oracle-Oracle Golden Gate setup.

Built grid infrastructure, create databases on Oracle Exadata Machines.

Exceptionally self-motivated, teamwork oriented, well-organized, efficient work habits and strong interpersonal skills.

Installation and Configuration of ORACLE 9i/10g/11g/12c databases.

Implementation and maintaining database security (create, maintain users and assign privileges).

Usage of Oracle utilities like Export, Import and Data pump

Planning and scheduling of hot, cold Backups, Logical Backups, RMAN and database Recovery.

Work Experience

Sr.Oracle DBA

Scubel LLC, NJ: Jun 2016 to Present

Client: JP Morgan Chase

Role: As a SME in Oracle database, providing database design/administration for production, development and testing environments

Implemented uni directional and Bi-directional replication using various versions of Golden gate.

Configured different levels of replication such as DDL replication, DML replication for table/schema level using Golden Gate.

Migrating non-RAC databases to RAC databases.

Maintaining and Installations of Grid Infrastructure software.

Performed numerous Installations of various versions 11g and 12c.

Performing release level and version level upgrades

Very much acquainted to the change management process for production changes.

Performed numerous version and release upgradations.

Setting up OEM and installing agents on servers.

Expertise in applying PSU Patches to all releases of Oracle on UNIX environment.

Worked on 2-node, 3-node and 6-node RAC environment.

Implementing Recovery Strategies and recovering the database in case of crash to minimize downtime of the databases.

Worked with application development team to resolve app related issues

Extensive experience in supporting Production and Development environments.

Working under the environment of 24X7 DBA support.

Interaction with client/users on various issues.

Extensive experience on support databases utilizing PeopleSoft applications.

Troubleshooting performance issues reported by the Application Team.

Experience in opening, managing, and resolving Oracle TAR's to resolve prod issues.

Physical and logical Data guard implementation and maintenance.

Several load tests on databases in coordination with testing/dev teams.

Schema, Table, Database refreshes on demand for dev teams.

Generic .profile scripts setup for databases & env setup on brand new servers.

Backup of the Production & Development Databases, based on business requirements.

Resolving complex backup and recovery issues.

Configured physical standby database and tested for switchover.

Monitoring and performing daily incremental backups, weekly backups using RMAN.

Performing Table, Schema, Tablespace, and Database refreshes.

Excellent in troubleshooting Oracle Network issues.

Sr. Oracle DBA

Bank of America: Aug 2014 to Jun 2016

Role: Sr.Analyst (Sr.Oracle DBA)

As part of active team member in Oracle DB team, supported to the critical applications like ecommerce, channels, products and SOT.

Maintaining and Designing Gigabyte to terabyte sized databases

Implemented High availability using Golden Gate Replication

Strong in database architecture, Upgrades, Patching, RMAN, database cloning, installations and configurations.

Maintaining strong working relationships with other DBA’s and application teams

Going through the day-to-day user requests and troubleshooting the database related problems.

Identify, prioritize, resolve and/or escalate issues as they arise for delivering solution on time

Proactive monitoring of databases through alerts/monitors

Troubleshoot performance issues & root cause analysis

Ensure databases are compliant with Global Information Security (GIS) guidelines

RAC setup from the scratch using OCFS and ASM technologies on 3 node Linux machines.

Building new databases and physical standby’s from the scratch [oracle 10g and 11g versions]

Performed database migrations from 9i to 10g and 10g to 11g.

Cross Platform Database Migrations using Transportable table space

Upgraded RAC database versions [10.2.0.2 to 10.2.0.3, 10.2.0.2 to 10.2.0.4, 10.2.0.4 to 11.2.0.2, 11,2.0.2 to 11.2.0.3 and 11.2.0.3 to 11.2.0.4]

Setup and configured Oracle 10g/11g RAC high availability systems with Oracle ASM and oracle ACFS (11g).

Upgraded oracle cluster ware version from 10.2.0.4 to 11.2.0.2, 11.2.0.2 to 11.2.0.3 and 11.2.0.2 to 11.2.0.4.

Installing 10g and 11g standalone and RAC databases on SOLARIS, IBM-AIX and Red hat Linux

Migrated and restored OCR and Voting disks

Setup disaster recovery and High Availability Architecture with Data Guard (having physical Standby) in Standalone and Oracle RAC environments using manual approach and Data Guard broker.

Oracle 10g and 11g RAC switchover and failover configuration, implementation, and testing

Setup Data guard (physical standby databases) for RAC one databases.

Setup cascading physical standby databases in Data Guard.

Expertise in troubleshooting Data guard scenarios.

Setup, Configure and manage Oracle golden gate 11g.

Implemented golden gate replication between oracle-oracle bi-directional.

Good knowledge in troubleshooting oracle golden gate environments.

Created RAC databases on Oracle Exadata Machines.

Applied PSU patches to grid and RAC RDBMS homes.

Managed 1.2 TB cluster database with 3 cluster nodes.

Created and maintained RAC one databases.

Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Performance tuning, troubleshooting & monitoring using ADDM and Automatic Workload Repository Advisor in Oracle and SQL Profile

Monitoring indexes and rebuild the indexes

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

Exposure to flashback technologies.

CPU/PSU patches installation on every quarter and maintaining current patch levels as per GIS risk ratings.

Applied PSU, CPUs, golden gate patches, one off and bug fixes in Oracle RAC, Data Guard and Oracle Exadata machines.

Applied patches using “opatch auto” and “opatch apply online”.

DB cloning using RMAN duplicate and from active database (11g)

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

Involved in and successfully performed a number of RMAN & TSM restore and recovery operations.

Used RMAN duplicate and RMAN from active standby for setting up Standby databases.

Good Knowledge in troubleshooting RMAN operations like backups to disk and tape, in golden gate systems and in RAC.

Schema refreshes using export, import, expdp and impdp.

Decommissioning database as per the requirement

Proactively monitoring databases, database servers, golden gate.

Capacity planning of the servers with respect to storage, memory, CPUs and making suggestions to management for acquiring new hardware to meet the business demands.

Coordinating with different departments like Applications, TSM, UNIX, Change Management, Problem Management, Capacity Management, Sys admin, SAN.

While on-call support, resolved successfully priority incidents and received appreciation from service management.

Interacted with Oracle Support for resolving various critical database issues like ORA-600,ORA-7445

Job scheduling using crontab

Wrote many wiki documents for new activities/troubleshooting

Designed and implemented solutions for Data migrations

Ability to work flexibly as a team member.

Dedicated with an inner drive to succeed and accomplish goals.

Ability to perfectly plan and execute the given job to perfection.

Received appreciation from the manager for dedication towards work on many occasions.

Oracle Database Administrator

Gemalto: Oct 2013 to Aug 2014

Role: As Oracle Database Administrator, supported day to day monitoring for multiple client databases. Worked on upgrades and performance tuning.

Environment: Oracle 9i, 10g, 11g on UNIX/Linux, AIX, and Solaris environment.

Experience in handling the databases on production, dev and testing Environments.

The production and DR databases are always kept synchronized, by deploying the real time apply feature of Oracle Data Guard. This has considerably reduced the manual archive shipping/applying tasks. The DR restoration drill has also been successfully tested by switching over the databases (switch over).

Implemented advanced RMAN concepts as the backup strategy for the production databases (Hot and Cold backups). Have scheduled these backups in the CRON to run at scheduled timings.

Managing OEM agents, configuring/deleting targets from portal

Setting blackouts in OEM, Tivoli netcool tools for activities needed downtime.

Applying CPU patches and required one off patches during weekend outages.

Working in coordination with backup teams for net app filer level backups for databases.

Refreshing data from production to staging instances

Creating users and managing roles and privileges.

Routine DBA activities like refreshing schemas on demand, scheduling cronjobs, taking care of alerts pertaining to production systems etc.

Working in coordination with support team (Oracle) and applying the patches provided for the bugs identified. Working with server consolidation project that includes migrations from servers to others and also to newer versions of databases.

Working with 24X7 database support.

Monitoring native tools for tickets and Ensuring quality of the deliverables as per the SLA and maintenance standards agreed upon.

Maintaining and Installations of oracle software on brand new servers and migrating them from client servers to IBM servers in IBM data center.

Performing release level and version level upgrades

Applying Patches (CPU, DST etc.) to all releases of Oracle on UNIX environment

Implementing Recovery Strategies and recovering the database in case of crash to minimize downtime of the databases.

Worked with application development team to resolve app related issues

Scheduling and managing Cronjobs.

Performing SAN migrations of databases from old to new SAN.

Weekly index rebuilding activities on all the production databases. This also includes statistics gathering.

Use EXPLAIN PLAN to know if the execution plan for critical jobs has changed.

Enable session level tracing and send the trace file to the application team.

Coordinating with the data center team in moving backup to tapes and then deleting the old/moved backups from disk as part of cleaning policy.

Upgraded the UAT database from 10g to 11g and applied recent CPU Patch.

Performed Oracle switch over operation successfully during a Power failure disaster. Auto mail triggering has been enabled to the customer mail id for the daily database related reports.

Restoration drill has been handled successfully as part of sanity check on the current backup strategy.

Automated the mundane jobs and enabled mail triggering for automated database reports.

Oracle Database Administrator

IBM: Feb 2009 to Jun 2013

Role: Oracle DBA

Checking the status of backups and sending report to onsite; if failed, finding the root causes for the failure and provide a RCA report to the customer for the same.

Setup, Configure and manage Oracle golden gate 11g.

Setup Data guard (physical standby databases) for RAC one databases.

Building new databases and physical standby’s from the scratch [oracle 10g and 11g versions]

Coordinating with the onsite DBA, application team for any emergency releases/refreshes

Database refreshes on UAT and Production using Data pump (IMPDP/EXPDP). Also when there are space constraints due to file utilization, refresh activity is performed using database link and the NETWORK_LINK parameter of IMPDP.

UAT environments are refreshed with the Production database in very short time span by taking Cold backup replication from the DR database.

Upgraded RAC database versions

Installing 10g and 11g standalone and RAC databases on SOLARIS, IBM-AIX and Red hat Linux

Setup disaster recovery and High Availability Architecture with Data Guard (having physical Standby) in Standalone and Oracle RAC environments using manual approach and Data Guard broker.

Contacting Oracle Metalink support in case of major technical assistance.

On-call Support

Setup cascading physical standby databases in Data Guard.

Expertise in troubleshooting Data guard scenarios.

Implement backups, perform recovery, and refresh databases with Data Pump, RMAN, and user-managed methods and ensure high availability with Flashback Database, Flashback Drop, Flashback Query, and Flashback Table

Upgrade Database and Grid Infrastructure, apply CPU, PSU, and one-off patches using rolling upgrades and offline methods, and bug fixing with Oracle Support through Service Requests

Resolving DB related performance issues.

Oracle Database Administrator

IT CAN PVT Ltd: Aug 2006 – Feb 2009

Clients : Credit Suisse, HP

Configured services and listeners using oracle Net Manager.

Configured Oracle Networking and monitored database listeners.

Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues.

Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.

Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.

Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN.

Recovering Databases when there is any Physical or Logical Corruption.

Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.

Tuned database servers by using new 10g features ADDM, AWR, Keep/pin objects, tune recovery time, ran SQL trace and generated TKPROF reports.

Providing support to clients/developers regarding SQL queries, applications errors, database errors Prepared and managed system for Data replication. Loading flat file data into tables using SQL Loader.

Configured Automatic Storage Management (ASM) for 10g RAC databases for reducing disk.

Performing Database Refreshes using Exp,Imp,Data pump, SQL*Loader and RMAN

Strong knowledge of Oracle internals, tools including DBMS jobs, RMAN, SQLPlus, export/import, Toad, Oracle Enterprise Manager (OEM).

In-depth knowledge of Oracle internals and architecture.

Experience with testing and debugging Oracle Internals, Architecture and Performance issues.

Oracle Database Administrator

Sigmax Solutions Pvt Ltd: Feb 2003 - Aug 2006

Role: As Oracle Database Administration supported day to day monitoring for multiple client databases. Worked on upgrades and performance tuning

Patched (CPU/PSU PATCHES) all of our production databases. Some of the production databases are in OS cluster. So patching was initially done on the passive node, then package switching is done, and later the active node is also patched. The same patching activity was performed on all of the UAT databases too.

Checking the status of backups and sending report to onsite; if failed, finding the root causes for the failure and provide a RCA report to the customer for the same.

Coordinating with the onsite DBA, application team for any emergency releases/refreshes

Database refreshes on UAT and Production using Data pump (IMPDP/EXPDP). Also when there are space constraints due to file utilization, refresh activity is performed using database link and the NETWORK_LINK parameter of IMPDP.

Installation and Configuration of Oracle 10g R2 RAC databases on Linux.

Administering RAC databases using SRVCTL.

Installation and Configuration of Oracle 11g and 10g and Creating Databases based on specifications.

Applied CRS # bundle patch to resolve node eviction issues and for bug fixes.

Configured high availability services in RAC and tested for failover and load balancing.

Patched and upgraded databases from 10.2.0.1 to 10.2.0.4.

Performed database backup using RMAN.

Decommissioning of Schema’s as per approved requests.

Implemented ASMM feature in Memory Tuning.

Performance tuning of Query by taking Execution plan with tkprof and explain plan utilities.

Job scheduling using crontab.

Participating in Disaster recovery testing with senior DBAs and preparing documents to client for future reference.

Education

Master of Business Administration in I.T.

Bachelors in Computer Science

Skills

Additional Skills

Oracle 12c/11gR2 RAC, Golden Gate, RHEL 6/5, RAC, AIX, OEM grid control(11g/12c), TOAD, Data Pump, RMAN, AWR, ASM, Exadata, Linux, 24*7 support Upgrade, Upgrade/Patching/Migration/Backup Recovery/Mirroring 24*7 support

Software Name and Version

Oracle Database 12c, 11g,10g and 9i

Backup Technology RMAN, Exports/Data Pump, Traditional Hot/Cold backup

Replication Technology Oracle 11g/12c Standby/Data Guard, Oracle 11g/12cGolden Gate.

Database Tools SQL*Plus,Toad and OEM 12c Grid control

Languages SQL, PL/SQL,Shell scripting (KSH,C & Bash), HTML

Contact this candidate