Please Contact:

Name: Jag

Email: acx7ag@r.postjobfree.com

Phone: 248-***-****

RAHUL

(Senior Oracle DBA)

Current Location: Irving, TX

Availability: Immediately

SUMMARY:

7+ years of Experience in IT industry and as Oracle DBA with Real Application Clusters.

Expertise in Oracle Database Adminstration.

Expertise in Oracle High Availabitly and Replication Soultions including Oracle

RAC,Dataguard,Goldengate

Experienced in SUN Sloaris,Redhat Linux Administration.

Strong experience in Performance Tuning and Troubleshooting of Single Instance and RAC

Databases.

Expertise in Installing,Configuring and Upgradation of Oralce Databases from 9i to 10g and 10g to

11g across cross platform

Perfromed Databased Cross Platform migration from HP-Unix/Solaris to AIX.

Experience in SAN,NAS and Virtual Storage iSCSI.

Expertise in implementing new database features, and proactive monitoring of the databases using

various shell scripts.

Handson experience in Volume managers including Veritas Cluster Filesystem,Veritas Volum

Manager VxVM, Oracle ASM, Linux LVM.

Performance Tuning using ADDM,AWR,ASH,Oracle 10g/11g and 12c OEM,

STATSPACK,UTLE,UTLB,TKPROF,EXPLAIN PLAIN.

Experince in Configuring Backup and Recovery Solutions using RMAN,IBM Tivoli TSM,Commvalut,

Veritas NetBackup.

Experince in Configuring Databases on Virtual Environments ( Vmware ESxi) and Cloud (vCloud

Director,vCloud Air).

Knowledge in Linux Kernel Programming and Device drivers.

Wrote various scripts in PERL and SHELL for database health and space checks.

Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and

Data Warehousing using customized shell scripts and stepwise.

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.

Knowledge on Oracle Support Process for Technical requests using Metalink and other support

procedures.

Expertise in Patching including Interim,CPU,Upgarde patches.

Administrated database of various sizes ranging from 5Tb to 25TB.

Excellent Interpersonal and strong analytical skills, Documentation & Problem-solving skills with

customer service oriented attitude. A very good team player, self motivated, dedicated in any work

environment.

Experienced in automating jobs using shell, pl-sql scripting.

Deep understanding of technology with focus on delivering business solutions.

Posse Strong Communication skills and Analytical Skills that consistently resolves ongoing issues

or defects.

Ability to learn and adapt to new Technologies quickly.

Proven ability in providing internal Trainings and participated Career Development programs

EDUCATION:

Masters in Computer science Silicon Valley University, CA

Bachelors in Technology & computer science: Osmania Unvieristy, India

TECHINCAL SKILLS:

Databases Oracle 9i/10g,11g,12c, MS-SQL Server 2008

Operating Systems SUN Solaris 9/10, HP-UNIX, IBM AIX 6/7, Redhat 7/8/9, RHEL 5/6, Oracle OEL 5/6

Hypervisors VMware ESXi, IBM LPAR

Programming Languages Java, C, Unix Shell Scripting, Perl and Python.

Hardware SUN V440 SUN Fire Servers, IBM Power 5 eServer, HP DL-380,Intel Xenon.

PROFESSIONAL EXPERIENCE:

ADP Inc,Rose Land,New Jersey May 15 Till Date

Senior Oracle DBA

Roles & Responsibility:

Gather client Projects and requirements and adminster to complete the projects in time.

Install/Uprade Oracle 11g Database from 9i and 10g to 11g.

Migrate Databases running on HP-Unix and Solaris to AIX .

Work with Business leads/Managers and provide Database solutions according to their

requirements.

Performance Monitoring and Tuning of Oracle 9i through 11g Databases.

Performance tuning using Oracle tools STATSPACK,EXPLAIN

PLAN,TKPROF,AWR,ADDM,ASH,10g/11g OEM and 12c OEM,OSWatcher

Use vmstat,iostat,sar,topas,top tools for performance monitoring and tuning at O/S level.

Experience in configuring OEM 12c cloud control load balancing by adding additional OMS using

F5 Service Load Balancer(SLB).

As a cloud service engineer provided DBaaS support for client using AWS.

Provide customer onboarding and help customer to understand AWS offering and troubleshoot

database issues.

Provide end to end Oracle DBA support and consulting services to customer running Oracle

database on AWS.

Experience in using Oracle Access Manager (OAM) Single Sign-On authentication for user logging

in Oracle 12c Cloud control.

Implemented active Data Guard for reporting databases and other critical databases.

Configure and Troubleshoot Shareplex Database Multisite Bi-Directional Replication.

Configure and manintain Goldengate Bi-directional Replication

Migrated 11g databases to different server using Goldengate with minimal down time.

Troubleshoot Physical Standby databases running on 9i and Dataguard for Oracle databases

running on 10g and 11g.

Wrote Shell and Perl scripts for monitoring and automating tasks of various Databases.

Perform Database refresh from Production to QA and Dev environments

Create Procedures, Packages,Function and refresh Materialized views..

Enforce adherence to IT Processes including SDLC, Change management, and other fundamental

processes.

Work with Development team on designing standardized data models, and standard and optimal

PL/SQL code.

Oversee the Development and implementation of Database security policies and procedures, in line

with corporate objectives.

Environment: Oracle 9i/10g/11g, Shell, Data Guard, Perl, Oracle 10g/11g RAC, Dataguard, Shareplex,HP-

UNIX,SUN Solaris,AIX, RMAN, IBM Tivoli TSM, IBM Power 6/7 eseris servers, SAN Storage,TOAD, Oracle

SQL Developer, Autosys.

AT&T,Dallas,TX Oct 14 April 15

Oracle DBA

Roles and Responsibilities:

Responsible to Maintained 500+ Production Databases

Provided 24/7/365 on call Support for Database and System Admin issues.

Patching, Cloning, Installing and Upgrading databases

Performance Tuning and Troubleshooting Single Instance and RAC Databases, Dataguard.

Growth projections and Capacity planning.

24x7 Production database and applications support.

Upgraded databases from Oracle 9i to 10g and 10g to 11g.

Writing UNIX shell Scripts and Scheduling through crontab.

Worked on Data Guard builds, active Data Guard, switchover and failover activities

Restoration and Recovery of databases at the times of occurrence of critical failures.

Responsible for installing, upgrading and configuring the Oracle environment by creating

databases, storage structures and objects, database backup and recovery, monitoring and

optimizing database performance.

Created and reorganizing Table Partitions, Materialized Views, Indexes, Parallel Execution

Performed large batch jobs, and tuning of SQL queries and database systems.

Partitioned large tables for better performance and manageability.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and

Logical backups.

Written PL/SQL Stored Procedures, Packages, Functions and Triggers using TOAD.

Worked with Data Pump EXPORT and IMPORT to take the logical backups of databases.

Experienced in performing Point-in-Time Recovery (PITR).

Load and Transform data using SQL*Loader and External Tables.

Implemented and followed Data security standards and Security User Management

Logical and Physical Database Design

Wrote Knowledge Based Articles

Environment: Oracle 10g, Data Guard, 11g,Shell, OEM,AWR,ASH,ADDM,

Daimler Financials,Dallas,TX Feb 13-Sep 14

Oracle DBA

Client: Newyork Life Isurance

Roles and Responsibilities:

Installing & configuring Multisite 3-Node Oracle 10g/11g RAC Databases on AIX,SUN Solaris.

Provided 24/7/365 on call Support for Database and System Admin issues.

Responsible to Maintained 5000+ Production Databases

Team member of Project Development and Deployment team.

Apply Patches and Upgrading Oracle RAC and Single Instance Databases.

Performance Tuning of RAC databases.

Configuring RMAN for LTO Tapes through Tivoli Storage Manager.

Worked on data guard environment and performs quarterly switchover test for High availability

testing activities.

Wrote RMAN scripts for Backups.

Configuring and Troubleshooting Oracle Cluster / Dataguard (Standby) problems.

Follow the Process as per the standards Patch Management, Change management.

Interacting with Development team, Architects and System Admins and for solving problems and

Deployment.

Developed Shell Scripts and SQL scripts to carry out routine checks on databases and perform

various tasks on the database.

Integrating of application using WebSphere with RAC Databases.

Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback

segments, buffer cache, redo mechanisms

Oracle Grid Control Management Server Installation.

Handling large database environments using Oracle Enterprise Manager (OEM) on daily basis

observing the performance of the production database and constantly active regarding

performance and space management issues and accordingly providing on-fly solutions to make

database healthy and running.

Monitoring and tuning using tools like Enterprise Manager 11G GRID, Oracle Cost Based optimizer

(CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and

Statspack.

Performance analysis using AWR/ASH/ADDM reports and wait event analysis.

Made performance improvements to the database by building Partitioned tables, Index Organized

Tables, Materialized Views and Bitmap Indexes.

Supported development effort by providing SQL statement tuning and optimizing ETL procedures

and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace,

TKPROF, TOAD and Oracle Enterprise Manager.

Environment: Oracle Database 10g,Data Guard, Shell, Oracle 10g Clusterware, IBM Tivoli TSM, IBM Power

5 Servers, IBM Websphere Application Server, IBM TSM SAN storage

New York Life Insurance

Fresno,CA Feb 12 Jan 13

Oracle DBA

Part fo 15 DBA team support Oracle databases both Single Instance and RAC databases.

Install and Configur 130+ Oracle 10g RAC Databases on Redhat Linux 5.

Configure RAC on ASM,

Troubleshoot RAC Node Evictions and Clusterware issues.

Patching and Cloning of RAC and Single Instance Databases.

Troubleshoot Single Instance and RAC databases.

Perfromance mointoring of RAC databases using Oracle OEM, AWR, ADDM.

Database Cloning hot backups to refresh data on to Test, QA, DEV Environments.

Tune RAC instances for better perfomance, using RAC Services and Load Balancing using TAF and

FAN.

Troubleshoot RAC network Private and VIP issues.

Support and work closly with Application,Oracle develpment team and End Clients and reslove

any Production isssues.

Restoration and Recovery of databases at the times of occurrence of critical failures.

Responsible for installing, upgrading and configuring the Oracle environment by creating

databases, storage structures and objects, database backup and recovery, monitoring and

optimizing database performance.

Created and reorganizing Table Partitions, Materialized Views, Indexes, Parallel Execution

Performed large batch jobs, and tuning of SQL queries and database systems.

Partitioned large tables for better performance and manageability.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and

Logical backups using Veritas NetBackup.

Written PL/SQL Stored Procedures, Packages, Functions and Triggers using TOAD.

Worked with Data Pump to take the logical backups of databases.

Experienced in performing Point-in-Time Recovery (PITR).

Load and Transform data using SQL*Loader and External Tables

Environment: Orace 10g, Oracle 10g RAC, RedHat Linux 5, Microsft Windows 2003, HP DL-380, HP EVA

SAN Storage, Microsoft,.Net, RMAN, Veritas Netbackup.

Lawrel InfoTech Jan 09-Jan 12

Hyderabad, INDIA .

Oracle DBA

Responsibilities:

Worked with a team of 2 DBA s, and coordinating with UNIX system administrators for the setup,

installations, upgrades of Oracle 9i and 8i databases for test, development, and QA.

Reconfigured the existing physical database layout, increasing the performance of the complete

system by 20%, including better use of the hard disk space.

Installed, created and maintained new oracle 9i and 8i instances. Upgraded several Oracle 9i

instances from 8i.

Connectivity with different client programs using ODBC.

Writing scripts to move data files, for monitoring system activities (I/O CPU), memory usage at

process level, file growth, user login, and user s setup.

Maintained backups for recovery using RMAN in tapes and disks.

Planning and implementing Backup strategy for the databases using RMAN, Scripting backups,

once in two weeks on the application database.

Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances.

Periodically fine-tuned and optimized the database performance for data integrity and maintained

the databases for the day-to-day DBA activities.

Redesigned the database backup/recovery scripts to log errors, and to be consistent/ robust.

Modified and maintained database structures and views for the core system.

Performed work related to importing and exporting data using IMP and EXP tools in Oracle, file

structures.

Reduced DBA off-hours support needs by 60% through planning and proactive monitoring.

Implemented automated backup strategy using the UNIX shell script and CRON Utility.

Cloned database for development needs.

Worked as Production Support for Oracle based systems and UNIX based Server environments.

Creating users and database links, snap shots on production and development servers.

Solving problems related to extent allocation and database connectivity. Established and

maintained sound backup recovery and procedures.

Applied database patches using Opatch utility & building Clone instances for Development and

Test teams.

Performed Backup and Recovery using RMAN.

Involved in coding of data extraction scripts as per technical specifications.

Analyzed the table structures using Analyze command.

Involvement in all phases of the project life cycle.

Designed database tables as per technical specifications.

Translated business requirements into creation and alteration of database objects: tables, indexes,

constraints, triggers and stored procedures.

Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: Oracle 8.1.7/9i, HP-UX, Windows NT/2000, PL/SQL, SQL Server 2000, T-SQL, Database

Tools/Utilities, OPS, Shell Scripting.

Contact this candidate