Devang Patel

Oracle DBA

732-***-****

aczn4g@r.postjobfree.com

PROFESSIONAL SUMMARY:

8+ years of experience in Oracle Database Administration, tuning, development, analysis, design, all phases of SDLC, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning, auditing, SQL, PL/SQL, troubleshooting and documentation.

Experience in Installation, Configuration and Maintenance of Oracle 11g/10gRAC with ASM and single instance database.

Oracle Database Administration in a variety of environments like Oracle Linux, HP-UX, IBM-AIX, Sun Solaris, RHEL and EXADATA.

Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).

Experience with Toad Data modeler and Generate detailed reports on existing database structure.

Build complex entity relationship models – both logical and physical Database Design.

RMAN procedure for backup and recovery and also cloned database using RMAN Duplicate.

Managed Oracle server in high availability environments using Failover, Clustering, Mirroring, Dataguard and Cloning technologies.

Experienced with cross site (active-active) data replication using Golden gate.

Preparing cluster, configuring and Installation of Clusterware and Oracle RAC on RHEL.

Migrated database from 9i, 10g to 11g by using Scripts and applied patches by Opatch utility.

Experiencein database full Backup (hot and cold), Incomplete Backup, DataPumpExport/Import, SQL Backtrack and Restore procedures.

Implementation and administration of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database (Data Guard), Materialized views, Streams Replication, Golden Gate.

Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.

Experience in Database creation with RMAN jobs and security implementations in Oracle.

Load Balancing, Startup, Shutdown of Individual instances on RAC database.

Installed 12c Grid agent on servers and configure 12c OEM Grid control.

Data Loading using SQL*Loader and DBVERIFY for corruption checking.

Experiencein PeopleSoft application and PeopleSoft Peopletools

Used parameters to configure, install and manage ASM instance in 10g RAC.

Experience in maintenance of Production, Testing, Development, RAC, Standby databases/ Dataguard for OLTP, Decision Support Systems (DSS) Data Warehouse environments.

Back-end programming, database Triggers, stored procedures and functions using PL/SQL.

Experience in using oracle Streams for replication of database.

Job scheduling using cron, at and batch utility at the OS level and Shell Scripting for automating DBA tasks.

Experience with new features like Flash-Back Recovery, ASSM, AMM, ASMM, Recycle Bin.

Good experience in Database Creation, Partitions, Setting-up parameters,Tablespaces, Indexes, User Setup, Roles, Security, Storage and hands on experience in network management.

Experience in ERWIN Data modeling and MS Visio for E-R diagrams and Logical, Physical layout designs.

Experience of Auditing, Oracle Security, OEM, SQL Navigator and TOAD.

Experience in Very Large Multi-Terabyte Database (VLDB) and also performed migrations in this environment.

Experienced in Oracle Support processes for technical requests throughMetalink and other support procedures.

Documented all Oracle database installations and database operations

24*7 Production Database Support to ensure availability, efficiency and recoverability.

SKILL SET:

Databases: Oracle 12c/11g/10g/9i, MySQL 5.5/5.6/5.7

Languages: SQL and PL/SQL

Application Servers: Oracle Application Server (9i, 10g&11g), Apache,

High Availability: (RAC) Clusterware 11g and 10g

Operating Systems: Sun Solaris, Linux (Red Hat, centos, Windows)

DB Tools: TOAD,SQL*Plus, i*SQL Plus, SQL*Loader, Export & Import utility (regular and data pump), OEM, ASMCMD, Net8, Database Configuration Assistant, Oracle Data Integrator(ODI) 10g, 11g, Explain plan, Goldengate Manager, Goldengate v 11.1, 11.2, SQL Trace, Tkprof, HCM, CRM, Peopletools, Tuxedo,

Data Protection Tools: Flash BackQuery, DataGuard

Programming Languages: SQL, PL/SQL, UNIX Shell Scripts and batch scripting

PROFESSIONAL EXPERIENCE:

Client: Optum Insight, Plymouth, MN.

Duration: June 2015 – Present

Role: Oracle DBA

Responsibilities:

Project involves for migrating databases as part of the core reduction project:

oMigrated method: SCP, Restore, Data guard, and Export/Import.

oStorage system: file system to file system with remapping of disk space, file system to ASM

oMigrated database from non-exadata to exadata using TDE encryption and compression.

oMigrated over 100 databases prod and non-prod.

oMigrated database from 10GB to 5TB.

Performed health checks in RAC instances using crsctl and srvctl utility.

Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM.

Planned and Implemented Disaster Recovery (DR) and High Availability using RAC, and Data Guard.

Installed and configured RAC 3 node and Performed up-gradation of grid infrastructure and Oracle databases from 12.1.0.1 to 12.1.0.2.

Performed Database refresh from Production RAC environment to TEST/DEV/STAGE RAC/non-RAC environment.

Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.

Interacting with the users and troubleshooting the problems related to the privileges and queries.

Monitoring disk space usage, performing cleanup of invalid objects.

Upgraded CRS-ASM to 12c

Resolve Incident and Service Requests in the tickets queue and proactively resolve database related problems.

Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN. And legato TAPE backup management.

Implemented and configured Goldengate in 2-node RAC cluster for flow into EDW

Implemented flatfile load into HBase using Goldengate and Flume

Resolved replication issues in Goldengate.

Installed GoldenGate software in Test and dev instances

Configured Goldengate on production servers

Upgraded Oracle goldengate v10 to v11. Setup classic capture replication mechanism using goldengate.

Configured GoldenGate to achieve unidirectional and bidirectional replication. Performed DDL and DML replication from test and dev instances into EDW

Successfully tested initial Data load during environment build

Setup GoldenGate User with necessary privileges

Cross-Train DBAs on Goldengate configuration and replication

Creating shell database using OEM Grid

Perform resize after encrypting and compression tablespace.

Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.

Implementing physical and logical standby setups data guard configurations.

Involved in production Support for critical application databases when needed.

Scheduling jobs through oracle JOB SCHEDULAR, CRONTAB (UNIX).

Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues helping to transform business requirements into environment specific databases.

Closely Worked with Oracle support in identifying some long-standing issues. Also extensively used oracle Metalink.

Client: Bank of America, Dallas, TX.

Duration: Oct 2013 – May 2015

Role: Oracle DBA

Responsibilities:

Supported 100+ databases ranging in size between 30GB to 50TB.

Planned and Implemented Disaster Recovery (DR) and High Availability using RAC, and Data Guard.

Installed and configured RAC (2 node) and Performed up-gradation of grid infrastructure and Oracle databases from 11.2.0.1 to 11.2.0.3.

Performed health checks in RAC instances using Crsctl and Srvctl utility.

Performed Database refresh from Production RAC environment to TEST RAC environment.

Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.

Starting and stopping the agents to clear metric alerts and collecting ADDM reports in OEM.

Performed backup/recovery and tuning on MS SQL Server.

Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM.

Installed Golden Gate for replication of database on 11gR2 RAC environment.

Installation and configuration of Tuxedo,HCM 9, CRM 9, Peopletools.

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

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

Involved in Tuning the RAC interconnect Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.

Performed various tasks on ASM, creating a disk group, adding a disk-to-disk group, making disk online and offline and troubleshooting issues in ASM environment.

Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.

Experienced in Spatial Programming, Spatial Models and Algorithms.

Create thorough documentation of installation procedures and administrative tasks in the clustered environment.

Generated and automated Statspack/AWR reports from Oracle 11g/10g/9i database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth.

Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.

Used Explain Plan, Oracle hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.

Addressed developers/testers requests to clone production databases for the purposes of testing using RMAN.

Client: DEUTSCHE Bank, Parsippany, NJ.

Duration: March 2012-Sep 2013

Role: Oracle DBA

Responsibilities:

At PNC I was part of Oracle Support team so primary focus was to provide 24*7 production support.

Maintain and Support Oracle databases 12C,11g R1/11g R2/10gR2/10gR1/9iR1/9iR2 and MS SQL Server 2008 r2, 2012 in Solaris, AIX, Oracle Linux platform.

Patched and upgraded the oracle databases.

Using the Cloud Control Agent to manage Oracle Database 12c Release 1

Responsible for support of 1000+ Production databasesof Terabytes in size, 2500+ UAT, DEV & TEST databases sizing 100G to Terabytes.

Active member of Conversion team; PNC acquired National City Corp(NCC) almost 2+ yrs ago. As a part of this team, I have migrated Legacy NCC databases to PNC standards. This includes setting up backup strategy, oracle database environment, disaster recovery setup, monitoring setup etc.

Complete range of Oracle DBA activities including day-to-day production database monitoring, Backup and recovery using RMAN, Trouble Shooting production issues, Physical Database design.

Managed the databasesin Sun Virtual Environment. Also maintained the database which had O/S cluster for failure scenario.

Worked with Grid Control for various day-to-day oracle DBA tasks.

Resolve Incident and Service Requests in the tickets queue and proactively resolve database related problems, based on alerts triggered by OEM or BMC Patrol Monitoring Tool.

Support and monitor databases to ensure Service Level Agreements on uptime, capacity, health and functionality.

Used Oracle Apex for various tasks like managing database inventory etc.

Actively maintained Oracle Database Project, this has 4 production RAC databases (sizes 20+ TB) with each 8 nodes, 15+ DEV/TEST/QA/Break FIX 8 node RAC environment.

Collaborate with Oracle Support for bugs & issues resolutions and personal research.

Provided valuable inputs forvarious performance tuning issues.

Worked with crontab and Oracle Jobs to manage, schedule various database jobs for backup, maintenance, password change etc.

Refreshed non-production environments from production database backup for developers.

Followed change control, Information Security and IT audit standards and procedures for any DBA activity.

Analyzed, planned, managed and evaluated processes that determine databasequality, design and functionality per SAS standards

Worked collaboratively with developers and management to establish Oracle development and production standards.

Developed task definition and execution strategies.

Client: Citi Group, Irving, TX.

Duration: Nov 2009- Feb 2012

Role: Oracle DBA

Responsibilities:

Responsible for administration and supporting oracle 11g, 10g and 9i databases

Worked on DR project.

Worked on cloning databases.

Trouble shouted node hand issues.

Worked closely with different team during migrations.

Managed Materialize Views servers.

Applied CPU/PSU patches.

Worked on Windows database servers.

Performed various tasks using grid control.

Worked on writing scripts to automate various tasks.

Worked on offshore team.

Performance tuning of applications and the databases Oracle 11g/10g/9i

Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance.

Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.

Intensively used 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.

Remove unnecessary histograms in highly volatile schemas.

Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.

Database dot release upgrades using oracle universal installer and cat patchSQl.

Applied various recovery scenarios for complete and incomplete recovery in case of failure

Performed Security administration tasks, setup users accounts, passwords, roles, profiles and quota.

Client: AZZ, Fort Worth, TX.

Duration: Sep 2008 – Oct 2009

Role: Oracle DBA

Responsibilities:

Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases

Monitoring database events as part of a Production support and level 1 staff.

Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR)of databases,.

Performed cross platform migrations from Oracle 10g to Oracle 11g (Solaris-Linux)

Experienced with cross site (active-active) data replication using Golden gate.

Hands on experience working with Golden Gate Director and configured ODI to use Oracle Golden Gate for Change Data Capture.

Did SQL and PL/SQL programming for ODI and oracle.

Created PL/SQL stored procedures, functions and triggers. Developed interfaces for loading the lookup and transactional data.

Installed and configured TOAD for Oracle and MS SQL Server. Created ODI packages, scenarios using interfaces, variables, procedure.

Used ODI commands like ODIFile_Move, odiFileAppend, odiFilecopy etc

Implemented logic to archive the source files with date stamp affixed after the successful load. Performance tuned the ODI interfaces.

Proficient in migrating database from 9i/10g to 11g by applying latest patch sets.

Implemented zero downtime migration and upgrade of 10g to 11g database using Oracle Golden Gate.

Replicated certain columns from a table and also certain values from columns by usingOracle Golden Gate.

Used Oracle streams for data migration and data distribution.

Configured RAC on oracle 11g RAC.

Involved in administration of over 150 Oracle 11g/10g R2 instances.

Implemented Oracle advanced security across various database levels.

Developed Oracle Forms and Reports for the user interface; a data load using PL/SQL andSQL*Loader; and Unix scripts to download and manipulate files

Development of PL/SQL and Web PL/SQL stored procedures.

Developed and performed the quality assurance activities and unit testing.

Installed Sybase ASE (15.0.x), REP 12.6 in AIX, Loading FACETS, HIPAA

Proficient in Oracle Materialized view replications.

Used Data guard for data migration from various database’s.

Installation and maintenance of Oracle 11g database.

Extensively used Erwin for data modeling and Dimensional Data Modeling.

Involved in the process of tuning and refining queries of various applications.

Implementing 10g Data guard with one physical database

Converted a single instance database to Oracle RAC 10g.

Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.

Extensive usage of ADDM, AWR, ASSM, features of 10g.

Developing Hot, cold and logical backup scripts to automate the backup procedures.

Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.

Restoration and recovery from backup.

Cloning of application from production environment to test environment and application ofpatches.

Moving data from development to production through transportable table space exports.

Monitoring the table growth, database growth, current users, and system resource usage.

Implementing standby database and database replication to provide high availability of database.

Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.

Continuous monitoring of database performance during peak and non-peak loads usingSTATSPACK

Involved in team management, team-building exercises for the DBA team.

Education: Bachelor Degree inComputer Information System – Database Management from DeVry University

Contact this candidate