Oracle Sql

Dheeraj K

Email: *******.*******@*****.***

Phone: 318-***-****

_____________________________________________________________________________

_

Professional Summary

Over 8+ years of experience as Oracle Data Base Administrator, providing 24/7

support of both development and production 10g/9i/8i databases on Various Platforms.

Extensive experience in Installation and configuration of Oracle 8i, 9i, 10g, 11g and 11i,

R12 in UNIX/LINUX and Windows environment.

Proficient in Database Administration activities such as Upgrades, Patches, TAR

support, Cloning, Backup and Recovery, Performance Tuning, capacity planning,

script development, and documentation.

Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ADDM,

Grid Monitoring, Recycle Bin

Experience in Installation, configuration and administration of Oracle 10g RAC.

Experience in Standby / Data Guard

Effective in troubleshooting of database and performance problems.

Good experience in SQL, PL/SQL/JAVA.

Experience with Data Modeling, Logical and Physical database design.

Experienced in using 10g features like Datapump, Flash-Back Recovery and ASM.

Worked with development teams and data administration staff to enhance Database and

application performance.

Management of schemas, objects & Partitioning the tables & indexes.

Experience in different environments like HP-UX, SUN SOLARIS, Linux and

Windows.

Knowledge on Oracle Support processes for technical requests through Metalink and

other Support Procedures

Proactive Monitoring, identifying areas that need to be improved in the application and

database using Statspack, AWR, ADDM, and 10g OEM Grid Monitoring

Experience in Database Security and Auditing.

Extensive experience in system architecture of 11i, R12 Applications implementation of various

Financials modules like GL, AP, AR and FA.

Worked directly with Engineers on data modeling, logical/physical schema design, SQL

query tuning; and the application of data related business rules while assisting in

troubleshooting, debugging, and issue resolution

Performed backups and tested crash recoveries using conventional cold, hot & RMAN backups.

Proficient in performance tuning using Explain Plan, STATSPACK, SQL_TRACE,

TKPROF.

Experience in basic and advanced replication using Oracle Streams and experience in

using OEM, TOAD, Data Migrations using export/import, benchmarking using load

testing tools

Proficient in using OEM and RMAN.

Technical Skills

Oracle E-Business Suite R12, 11.5.10, 11.5.9, 11.5.8, 11.5.7

ERP

Oracle 7/8i/9i/10g/11g, 9i/10g,11g RAC, Dataguard, Teradata 12, DB2, SQL Server, MS

Databases

Access

Database Tools PL/SQL Developer, TOAD, OEM, OAM, SQL*Plus, SQL*Net, SQL*Loader

Languages PL/SQL, JAVA, C, XML, HTML, VB 6.0 and JCL.

Tools, Utilities TOAD 8, 9, MS Visual Studio Team System, Lotus Notes, Share Point 2.0, MS VSTS, IBM

& Others MQ Series, TSO, Team Track 5.8, LDAP Browser, Web services..

BI Tools Informatica PC RT 7.1, Business Objects 6.5, Crystal reports XII, Cognos DS & SAP BIW

2.0.

Operating Linux Itanium 4.7 tikanga, Redhat Linux 2.1,3,4,5, Windows (XP, Vista, Windows 7),

Systems Redhat Linux, IBM AIX 5.1, 5.2, 5.3, Sun Solaris, MAC OS X Snow leopard.

Protocols Http, https, TCP/IP, FTP, SOAP, FIX.

Others MS-Project, MS-Visio and MS-Office, NetApp, Veritas Net Backup

Educational Qualification

Bachelor’s Electronics & Communication Engineering from JNT University, India.

Professional Experience:

Client: Cisco Systems, San Jose, CA

Duration: Aug’ 2010 – Present

Position: Sr Oracle DBA

Environment: Oracle Server 11g/10g/9i, applications 11i, R12, SQL, PL/SQL, Linux Itanium, Solaris

10, Shell scripting, TOAD, OEM 10g

RESPONSIBILITIES

24 X 7 Production database administration, support and monitoring to ensure a proactive problem

recognition and resolution of database issues.

Supported 40 production and 300 plus development and testing databases with database ranging

from 100GB to 40TB.

Up gradation and Migration of Database from 9i to 10g,11g and applying patches whenever

required.

Monitored database log files, data block corruption, segment fragmentation, performance issues,

security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)

Experienced with 11g, 10g DATA GUARD IMPLEMENTATION and Point in time Recovery.

Worked on many RAC Databases (2, 4, 8 node) over 40 TB size and involved in troubleshooting

the issues faced in the RAC Databases.

Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data

Guard, Replication.

Good Interaction with Application Team and Network Team in resolving issues relevant

to LDAP adapter, OCM setup.

Tuned SQL queries using EXPLAIN PLAN, SQL TRACE and TKPROF utility.

Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.

Auditing the Database at the user, object, session and privilege levels.

Installation of Database, Designing Security, Space Management, Design Backup Recovery

processes, Tuning SQL queries. Performed Database Space management.

Carried out Backup and recovery with Online (HOT) and Offline (COLD) strategy.

Used Export, Import for database backup and defragmentation and SQL* Loader for data

loading.

Oracle 10g configuration and maintenance Oracle tuning using SQL TRACE, STATSPACK,

AWR, EXPLAIN PLAN and TKPROF.

Implemented Streams, Data Pump, Export & Import utilities on both 9i and 10g

Databases.

RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery

Manager (RMAN) for backups

Experience in using 11g Datapump (export, import) to migrate data from our production

environment to multiple development environments.

11g RAC with ASM installation, configuration, administration and troubleshooting issues

Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and

Raw Devices and 11g CRS.

Extensive experience in system architecture of 11i, R12 Applications implementation of various

Financials modules like GL, AP, AR and FA.

Exploring the METALINK and familiar with SOX auditing.

Client: Leap Frog, Emeryville, CA

Duration: Sept’ 2009 – July’2010

Position: Sr Oracle DBA

Environment: Oracle Server 10g/9i, 11i, R12,sSQL, PL/SQL, Linux Itanium, Solaris 10, Shell

scripting, TOAD, OEM 10g

RESPONSIBILITIES

Responsible for the design, development, implementation, integration, and maintenance

of multiple premium and core database management technologies, tools and utilities .

Participated in a team environment for the delivery and maintenance of data and/or

database management systems.

Provided interpretation and responses to vulnerability assessments from written

benchmarks or scanning tools

Provided technical, interpersonal and administrative skills in performing day to day work

Escalated issues in a timely manner and provide mitigation recommendations to Data

Team Lead and Project Director.

Identified architectural issues and proposed alternative solutions

Adhere to database management standards and guidelines

Strong knowledge and experience of managing Oracle 9i and 10g RAC environments

using the OEM Grid Control tools

Actively participated in installing of 10g RAC on Linux environment with two nodes and ASM as

storage.

Supported 40 production and 300 plus development and testing databases with database ranging

from 100GB to 2TB.

Excellent Experience in installing 9i and 10g databases on HP –UX and LINUX.

Highly experienced in using STATSPACK, AWR to check health of database & hardware.

Good Intensive Knowledge in using operating system command line utilities like SAR, TOP,

MPSTAT, VMSTAT

Deep Knowledge in using tools such as TKPROF; EXPLAIN PLAN, ORADEBUG and TRACE

FILE to tune SQL Queries.

Performed database Cloning using hot backup and cold backup to setup test and development

database.

Conducting sizing & capacity planning for Oracle databases.

Up gradation and Migration of Database from 9i to 10g and applying patches whenever required.

Monitored database log files, data block corruption, segment fragmentation, performance issues,

security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)

Maintaining schemas and partitioning tables.

Experienced with all kinds(Status, Performance, Trend Analysis) of DB MONITORING

Experienced with SRVCTL for monitoring and configuring RAC Environment.

Developed RMAN scripts for database backup and recovery including hot and cold backup

options for both RAC and standalone instances.

Installing ASM environment and migrating database from NON-ASM to ASM.

Designed and Developed shell scripts to automate the processes and to proactively monitor the

database.

Used Veritas Net Backup (6.0) for data protection, Veritas Volume Manager (5.0) for I/O

functionalities, volume management.

Created table spaces, tables, and users for custom applications.

Installed and Upgraded Oracle e-Business Suite 11i(11.5.10) to R12 with AP,AR,GL, HR,

Financials, Advanced Supply Chain Management and Mfg. modules on Solaris 10.

Creating and dropping of users, granting and revoking permissions to users/roles as and when

required.

Applied critical patch updates (CPU) released by oracle quarterly.

Advanced replication using Oracle Streams.

Experienced in using 10g features like Datapump, Flash-Back Recovery and ASM.

Experienced with DATA GUARD IMPLEMENTATION and Point in time Recovery.

Implemented oracle high availability solution using oracle 10g PHYSICAL STANDBY.

Importing data from flat files into database using SQL loader and External Tables.

Monitoring and optimizing system performance using index tuning, disk optimization, advanced

database techniques, and other methods, including the use of automated tools

Client: Dana Holdings Corporation, Maumee, Ohio.

Duration: Oct’ 2007 – Aug’ 2009

Position: Sr Oracle DBA

Environment: Oracle Database 9i/10g RAC Dataguard, apps 11i, SQL, PL/SQL, HP-UX, Solaris10,

Shell scripting, OEM 10g.

Responsibilities:

24 X 7 Production database administration, support and monitoring to ensure a proactive problem

recognition and resolution of database issues.

Creating of databases for Testing, Development and Production.

Taking periodic backup of the database and the software.

Installed and Implemented Backup & Recovery procedures.

Used RMAN for backup and recovery. Performed backup validations using RMAN.

Implement Hot, Cold and Logical backup plans

Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF,

Statspack.

Developer Environment Setup, Support, Cloning and Refreshes.

Installation Configuration and Maintenance of RAC, Stand by database.

Performed database cloning to setup test and development database

Setup of Standby database for faster disaster recovery and data guard setup for high availability.

Written shell scripts for digitization the process.

Load balancing, databases/schema/table re-organization for faster performance.

Installation of Oracle version 10g on Solaris, HP-UX

Database dot release upgrades using oracle universal installer and catpatch.sql

Migration of Database from 9.2.0.6 and to 10.2.0.2

Was involved in developing a disaster recovery (DR) plan

Continuous Performance monitoring and tuning of the databases and application using OEM

Tuning Pack, Diagnostics Pack, STATSPACK etc.

Rebuilding of Indexes

Conducting sizing & capacity planning for Oracle databases.

Handling Database storage.

Monitoring Alert. Log and User trace Files and Diagnosing the Problem.

Scheduling jobs through Oracle job Scheduler.

Providing Solutions to the Problem Faced by end Users Or Programmers

Automation of Startup Shutdown on all Production and Development Database.

Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables, Cold

Backups.

Client: EDS, Madison, Wisconsin

Duration: Dec’ 2006 – Sep’ 2007

Position: Sr Oracle DBA

Environnent: Oracle 11i, AIX 5.2, Sun Solaris 2.8/2.9 RHEL 4

24x7 Oracle Production Database Administration.

Installation, Configuration, Upgrade, patching of Oracle 10g database and applications.

Create table spaces, tables, and users for custom applications.

Refresh/Cloning of Database and applications for development, testing

Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning

Contentions)

Taking Backups on scheduled time and monitoring scheduled Backups

Data refresh from production to test and development

Maintain user security.

Supported various client modules such as 11i Financials, Oracle Spreadsheet Server, MFG,

CRM, AR, OWB, AP, GL, PO, INV, FA, OM etc.

Extensive experience in system architecture of 11i Applications implementation of various

Financials and CRM modules like GL, AP, AR, FA, etc.

Assist Programmers and Developers with Oracle problems.

Write Korn shell scripts to monitor and maintain the Oracle database.

Write SQL scripts to monitor tablespaces and extent growth.

Resolve various application failures due to data entry errors or system errors.

Involves identifying problems and implementing corrective actions.

Providing Solutions to the Problem Faced by end Users Or Programmers

OS level activities like space monitoring of Mount points

Automation of Startup Shutdown on all Production and Development Database.

Daily Health Check Up of the Database

Client: Infovision Pvt Ltd, Hyderabad, India

Duration: July’ 2005 – Nov’ 2006

Position : Sr. Oracle DBA

Environment: Redhat Linux 4, AIX 5.1, Oracle Database 9i, 10g RAC, Oracle Application

Server 10g, OEM 10g.

Responsibilities:

Performed Database Administration activities such as Upgrades, Patches, TAR-Support, Cloning,

Backup and Recovery, Performance Tuning, capacity planning, script development, and

documentation

Installed and Upgraded Oracle 9i(9.2.0.8) database to Oracle 10g(10.2.0.4) database.

Database performance tuning using STATSPACK, TKPROF, SQL Trace and Explain Plan .

Migrated Database schemas and full Database using export and import utilities, Datapump.

Performed Cross Platform migration of Oracle 10gR2 from Linux to AIX.

Installed and Configured 10g RAC using OCFS2 and ASM on AIX.

Troubleshooting RAC ASM and Oracle Cluster ware related issues.

Involved and Implemented Disaster Recovery Plan (Oracle 10g Data Guard).

Developed Korn, Perl, shell scripts for automating the Database job processes.

Performed Backup/Recovery of the Oracle databases using RMAN Incremental & Hot Backup .

Installed and Configured Oracle Application Server 10g(10.1.2.0.2 & 10.1.3 SOA) with Portal,

Discoverer as an active applications

Installed and used Oracle 10g OEM Grid control and TOAD in monitoring and accomplishing

Database Administration issues.

Troubleshooting problems with oidldapd process and oc4j processes in Oracle Application Server

10g.

Release manager responsibility for releasing mainline patches to customers through Automated

Release Updates System for the entire Oracle Financials.

Monitoring infrastructure tier and middle tier processes using OEM 10g Application Control

Consoles and database with OEM dbconsole.

Export and Import of Portal Schema using Transport Set utility and Oracle Internet Directory

Users with LDIF utility.

Applied Portal SVU Patch to validate the Portal Schema and also ran Report Diagnostic Assistant

(rda).

Installed and Integrated Oracle Internet Directory with 9i database with Single Sign On.

Strong Experience in configuring, troubleshooting Oracle Identity Management.

Designed and Developed OAS 10g Portal Application for users.

Good Experience in Troubleshooting and Administration of Oracle10g Application server.

Client: Magna Info Tech, Hyderabad, India

Duration: Aug’ 2003 – Jun’2005

Position: Oracle DBA

Environment: Oracle Server 9i/10g, SQL, PL/SQL, HP-UX, AIX 5.1, 5.2, SQL*Loader

Responsibilities:

Designing the logical and physical database structure.

Designing the security and database access strategies.

Logical and Physical data modeling.

Enforcing the Null and check constraints.

Taking Backups on scheduled time and monitoring scheduled Backups

Performing backups and recoveries using RMAN/ conventional hot backups.

Establish and Document Backup and Recovery strategies and procedures after evaluating various

options including RMAN.

Creating and dropping of users, granting and revoking rights as and when required.

Cloning databases and Disaster Recovery Database.

Tuning heavy data loads. Monitoring and Performance tuning.

Using TKPROF, EXPLAIN PLAN and STATSPACK for the Better performance.

Partitioning strategies for very large tables.

Diagnose and troubleshoot Database problems and failures

Implementing range, list partitions, hash sub partitions.

Creating and refreshing materialized views.

Performing SQL*Loader jobs for data loading.

Monitoring of database for growth and performance

Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Monitoring Growth of tables and undertaking necessary re-organization of database as and when

required.

Client: Quantum Technologies, Bangalore, India

Duration: Apr’2002 – July’2003.

Position: Jr. Oracle DBA

Environment: Oracle 9i, Linux AS.

Responsibilities:

Involved in 24x7 production database maintenance and on-call support.

Responsible for administering and supporting production and development Oracle 9i databases.

Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage

structures and objects; database backup and recovery, monitoring and optimizing database

performance.

Other duties include applying oracle database patches, creation of database users, monitoring,

tuning, troubleshooting, backup and recoveries, monitoring and optimizing database performance.

Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot

backups.

Perform SQL tuning and assist developers with coding PL/SQL.

Instance cloning done to create test and training environments.

Created PL/SQL procedures (jobs) to automate maintenance tasks.

Partitioned large tables to increase the performance.

Configured scripts to monitor activity with database.

Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring

their growth rate

Contact this candidate