Oracle Manager

Location:

Alpharetta, GA

Salary:

Negotiable

Posted:

July 13, 2016

Contact this candidate

Resume:

Yatindra Agrawal

Over ** years of experience in the area of Oracle Database Administration, Database Performance, Enterprise System Design and Exadata Administration.

Expertise Highlights

Database Architect/Oracle DBA Expertise

Exadata Database Machine X3-2,X4-2,X5-2

Real Application Clusters (RAC)

Performance Tuning

AWR and ADDM

Replication

Distributed Databases

Disaster Recovery Solutions

Database Design

System Design

ASM

DataPump,Exp,Imp

Statspack, Tkprof, Explain plan, Sql Tuning Advisor,DBMS_STATS

Large Online Transaction Processing

Installation and Configuration

Application Maintenance and Production Support

Recovery Manager (RMAN)

Standby Database Solutions and Data Guard Implementation

Data warehousing

Enterprise Backup and Recovery Solutions

Toad, OEM

Shell Script

Oracle Internal Process Management

Database cloning, refresh and patch management

Management Expertise

Client Relationship Management

Pre-Sales and Business Development

People/Team Management

Project Management

Software Service Delivery Management

Technical SKILLS

Operating System

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, 6.x and Windows 95/98/NT/2000/XP.

RDBMS

Oracle 12c/11g/10g/9i, Oracle 10g, 11g/12c Real Application Clusters (RAC)

SOFTWARE / APPLICATIONS/ TOOLS

Recovery Manager (RMAN), Real Applications Cluster (RAC), STATSPACK, ASM, AWR, ADDM, DATAPUMP, TOAD, Oracle Enterprise Manager, Oracle GoldenGate 11g/12c

Engineered System

Exadata X-3, X-4, X-5 (Quarter and Half Racks)

Qualification

Diploma in Computer Applications from Macro Computers & Technology Institute, Gwalior, INDIA, 1994

Bachelor of Arts from University of Rajasthan, INDIA, 2000

Certificate in Computing from Indira Gandhi National Open University, New Delhi, INDIA, 2000.

Certifications

Oracle Certified Associate (OCA) (Oracle 9i), Dec 2004

Oracle Certified Professional (OCP) (Oracle 9i), Jan 2005

Oracle Certified Professional (OCP) (Oracle 10g), Nov 2009

Oracle Certified Expert, Oracle Exadata X3 & X4 Administrator, May 2014

Oracle Certified Associate, Oracle Solaris 11 System Administrator, Aug 2014

Oracle Certified Professional (OCP) (Oracle 11g), June 2015

Oracle Linux 6 Certified Implementation Specialist, Nov 2015

EXPERIENCE SUMMARY

Continuserve LLC

Client- Rheem Manufacturing Company Nov 2015 till date

Role: Delivery Lead/Exadata Architecht/Database Architecht

Location: Atlanta, GA (United States)

Responsibilities:

Leading the team of DBAs.

Managing project and project deliveries.

Co-ordination with client/business team for project requirements.

Co-ordinating with development team, Application support team, System administration, network team, security team and DBAs for creating delivery plan, defining path for the project and delivery.

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

Performed database management functions such as maintenance, access issues and security.

Conducted designing, assembly and tuning of databases in coordination with development teams.

Expertise database migration using Oracle Golden Gate 12c.

Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate

Expertise in replication technologies including GoldenGate, Streams, AQ and Materialized Views

Executed processes for evaluation of system space, database allocation and storage metrics.

Maintained all existing databases and new installations at current and stable production levels.

OneCommand configuration on Exadata

Upgrading Exadata environment

Maintaining Exadata hardware

Configure, Maintaining and troubleshooting Exadata Cell disk/Grid Disks

Troubleshooting Exadata smart scan/offloading issues

Bare metal restores of Exadata DB node and CELL node

Monitoring the Infiniband Switches/ports, HCA ports on DB/CELL nodes and IB topology

Troubleshooting Infiniband/RDS performance issues

Configuring IORM/DBRM and Implementing Oracle Exadata best Practices

Migrating databases to Exadata

Applied QFSDP for whole Exadata Database Machine X4-2 & X5-2

Setting and Monitoring Exadata using EM12c

Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues

RCA for Node evictions and Instance evictions

24x7 production support for several mission critical systems which utilize multiple Oracle databases up to 45 TB in size.

Well versed in process documentation.

Environment: Exadata Database Machine X3-2, Oracle 9i/10g/11g, SQL, PL/SQL, Oracle Grid Control, Oracle RAC 10g/11g, DataGuard, ASM, AWR, ADDM, DataPump, Oracle Golden Gate, TOAD, Precise, Oracle Enterprise Manager, SQL*Loader, Sun Solaris, Red Hat Linux.

Continuserve LLC

Client- Rheem Manufacturing Company Nov 2015 till date

Role: Delivery Lead/Exadata Architecht/Database Architecht

Location: Atlanta, GA (United States)

Responsibilities:

Leading the team of DBAs.

Managing project and project deliveries.

Co-ordination with client/business team for project requirements.

Co-coordinating with development team, Application support team, System administration, network team, security team and DBAs for creating delivery plan, defining path for the project and delivery.

Exadata Certified Administrator for Exadata Database Machine X3 & X4

Exadata Database Machine Administration

Good Knowledge of Oracle Exadata architecture

OneCommand configuration on Exadata

Maintaining Exadata Storage Server Software

Maintaining Exadata Infiniband Network

Responsible for increasing Filesystems on Exadata

Administering Oracle ASM Diskgroup on Exadata Storage Servers

Administering Exadata Software Patching when required that includes OS Kernel, Firmware, Grid Infrastructure and Database.

Applied QFSDP for whole Exadata Database Machine X3-2 and X4-2.

Provided technical assistance for development of physical and logical architecture models on all Oracle server platforms.

Coordinated with project teams for designing and implementation of database infrastructure designs by documentation and system testing.

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

Suggested procedures for database performance and tuning of all database machines and related components.

Created certified processes and procedures for maintenance and upgrading of all database machines.

Conducted analysis and feasibility studies for development of Oracle Exadata solutions.

Developed strategies for disaster recovery services of all database machines along with advisory services.

24x7 production support for several mission critical systems which utilize multiple Oracle databases up to 30 TB in size.

Oracle RAC implementation Planning & feasibility analysis to provide high available enterprise solution for mission critical applications

Installed and Configured Oracle 11g RAC solution on Red Hat Linux and Solaris

System Study & Analysis, Design & Development.

Installation, Configuration and Maintenance of Oracle RDBMS Software.

Upgrading databases to Oracle 11g from Oracle 10g.

Implemented and maintained Data Guard (Standby) to provide local transaction recovery and Disaster recovery solution for mission critical systems

Setting up Performance Benchmark using different tools and environments for each application release.

UNIX Shell scripting in (cshell) csh, (korn shell) ksh for automating startup/shutdown of databases, getting system alerts.

Applying patches both Server side and Client side.

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).

Using Data Pump and Export/Import for transferring data from one database to another.

Setup backup and recovery procedures using RMAN.

Using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for monitoring database performance.

Database Growth and Space management, capacity planning, table partitioning; distributing the tables, redo logs, archived redo logs and rollback segments on different disks to optimize data retrieval.

Migrated the large databases more than 2.5 TB from Non-Exadata to Exadata DB Machine using Golden Gate 11g replication process.

Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate

Expertise in replication technologies including GoldenGate, Streams, AQ and Materialized Views

Manage Oracle RAC database configurations utilizing Veritas Cluster Server (VCS), GoldenGate and Data Guard to ensure maximum availability and data protection.

Well versed in process documentation, creating presentations and presenting them in front of the client management.

Tech Mahindra America Inc

Client- AT&T Oct 2012 to Dec 2013

Role: Lead DBA

Location: Alpharetta, GA (United States)

Responsibilities:

Leading the team of DBAs, java developer and application support.

Managing project and project deliveries.

Co-ordination with client/business team for project requirements.

Co-ordinating with teams to handle the deliveries.

Implemented Enterprise database solutions to provide optimized resource utilization and best in class application performance

24x7 production support for several mission critical systems which utilize multiple Oracle databases.

Implementation of Large Online transaction system using Oracle Partition and Materialized Views.

Table reorg for very large table ( 500 GB)

Oracle RAC implementation Planning & feasibility analysis to provide high available enterprise solution for mission critical applications

Database and System design Using Toad Data Modular.

Installed and Configured Oracle 11g RAC solution on Red Hat Linux and Solaris

System Study & Analysis, Design &Development.

Database Design and Data modeling using Erwin for End to End Business Monitoring System.

Installation, Configuration and Maintenance of Oracle RDBMS Software.

Upgrading databases to Oracle 11g from Oracle 10g.

Implemented and maintained Data Guard (Standby) to provide local transaction recovery and Disaster recovery solution for mission critical systems

Object Analysis to do proactive performance improvement action.

Setting up Performance Benchmark using different tools and environments for each application release.

Database Objects redesign (Materialized Views, IOT,Indexes,Cluster) basis of business availability requirements

UNIX Shell scripting in (cshell) csh, (korn shell) ksh for automating startup/shutdown of databases, getting system alerts.

Applying patches both Server side and Client side.

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).

Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.

Using Data Pump and Export/Import for transferring data from one database to another.

Setup backup and recovery procedures using RMAN.

Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for monitoring database performance.

Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.

Responsible for all database activities such as space management, database security management, rollback segments & creation of DB links between two oracle servers.

Working on data migration from Solaris to Linux for the large databases more than 2.5 TB using Golden Gate 11g replication process.

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, Oracle Grid Control, Oracle RAC 10g/11g, DataGuard, ASM, AWR, ADDM, DataPump, TOAD, Precise, Oracle Enterprise Manager, SQL*Loader, Sun Solaris, Red Hat Linux.

Tech Mahindra Ltd.

Client- AT&T March 2010 to Sept. 2012

Role: Lead DBA

Location: Noida, Pune (India)

Responsibilities:

Implemented Enterprise database solutions to provide optimized resource utilization and best in class application performance

24x7 production support for several mission critical systems which utilize multiple Oracle databases.

Implementation of Large Online transaction system using Oracle Partition and Materialized Views.

Table reorg for very large table ( 500 GB)

Oracle RAC implementation Planning & feasibility analysis to provide high available enterprise solution for mission critical applications

Database and System design Using Toad Data Modular.

Installed and Configured Oracle 11g RAC solution on Red Hat Linux and Solaris

System Study & Analysis, Design &Development.

Database Design and Data modeling using Erwin for End to End Business Monitoring System.

Implemented Oracle E-Business Suite Rel 12 for Financial and Inventory.

Installation, Configuration and Maintenance of Oracle RDBMS Software.

Upgrading databases to Oracle 11g from Oracle 10g.

Implemented and maintained Data Guard (Standby) to provide local transaction recovery and Disaster recovery solution for mission critical systems

Object Analysis to do proactive performance improvement action.

Setting up Performance Benchmark using different tools and environments for each application release.

Database Objects redesign (Materialized Views, IOT,Indexes,Cluster) basis of business availability requirements

UNIX Shell scripting in (cshell) csh, (korn shell) ksh for automating startup/shutdown of databases, getting system alerts.

Applying patches both Server side and Client side.

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).

Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.

Configured STREAMS for better Transaction Management.

Using Data Pump and Export/Import for transferring data from one database to another.

Setup backup and recovery procedures using RMAN.

Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for monitoring database performance.

Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.

Responsible for all database activities such as space management, database security management, rollback segments & creation of DB links between two oracle servers.

Hewlett Packard

Client- Agilent Technologies US October 2006 to March 2010

Role: Sr. Oracle DBA

Location: Bangalore (India)

Responsibilities:

24x7 production support for several mission critical systems which utilize above 800 Oracle databases.

Managed admin users and granted the role to the users with high level security to protect the database from unauthorized access.

Installation and configuration of Oracle RAC 10g on HP Unix environment

Implemented Index organized tables to improve the performance.

Designed Performance Tuning methodology using custom script, AWR and ADDM Reports.

On-going SQL tuning using Explain Plan and SQL Trace.

Synchronize Databases with production for data and testing purpose.

Involved in Database Security monitoring, Database Logging & Auditing.

Development of backup and recovery procedures and Import and Export of Data (Logical Backup) and RMAN and Database cloning.

Creation of the Test database, Table spaces, Tables and Indexes, Index rebuilding.

Interacted with Business Analysts and client representatives in doing research and solving client specific data issues.

Involved in Logical and Physical Database design Star Schema design. Identified Fact tables, Transaction tables.

Application tuning using Explain Plan, Tkprof and SQL trace facilities.

Tuning the Oracle instance for optimal performance.

Tuning of I/O to reduce disk contention by distributing I/O

Performed troubleshooting of the database.

Co-ordinate with UNIX Administrators for space management on various servers and help in Oracle insatallation, upgrading according to the standards & Quality assurance.

Environment: Oracle 9i/10g SQL, Oracle Grid Control, Oracle 10g RAC,ASM,AWR,ADDM,DataPump, TOAD, Oracle Enterprise Manager, HP-Unix, Red Hat Linux, Window Server Family.

Harjai Computers Pvt Ltd.

Client- Reliance Communications November 2005 to October 2006

Role: DBA

Location: Mumbai (India)

Responsibilities:

Handling above 30 databases as a DBA

Installation and Configuration of Oracle Database and components.

Supporting end users.

Backup and Restoration.

Administrating Databases.

Resolving Basic Tuning Problems

Schema Management

Uploading data in Test Databases from the production databases and vice versa.

Monitoring Backup, Space requirement.

Housekeeping Activities

Also involve in creating SQL scripts and Shell scripts related to DBA tasks.

Environment: Oracle 9i/10g SQL, Oracle Grid Control, Oracle 10g TOAD, Oracle Enterprise Manager, HP-Unix, Red Hat Linux, Window Server Family.

TRAININGS

Oracle Certified Professional Certification Training (Oracle 9i), from Pune, in 2004.

Oracle Certified Professional Certification Training program (Oracle 10g), from ORACLE organized by HP corporate training, in Sept 2007

MSSQL Training program (MSSQL 2005), organized by HP corporate training, in May 2007

PERSONAL DETAILS:

Date of Birth: 8th July 1976.

Passport No: J3210753

Expiry Date: 22-12-2020

Current Visa Status: H1B

Visa Expiry: Sept 2018

Linkedin address:-

https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile

Contact this candidate