Rajesh Kumar Oracle DBA

Phone: 210-***-****

: abphb1@r.postjobfree.com

Resumes ID: 48963

Location: Columbus, Ohio

Posted: 04.13.2012

Resume Details:

Oracle Certified Database Administrator with 8+ years of experience in installing, configuring, administering and managing oracle databases & implementing solutions like high availability(HA), disaster & recovery, cloning, and database security.

Very good experienceas Oracle DBA in production, development and test environments

Experience in Migration and upgradation Projects. Hands on experience in upgrading from Oracle8i to 9i and 10g (10.2.0) to 11g.

Implemented Oracle RAC in different UNIX platforms with multi nodes (2 and 3).

Installation of Oracle 10g RAC software with ASM & OCFS2File systems has been implemented.

Installed & Configured Oracle10g grid and maintained in large environments.

Implemented RAC and Dataguard on Linux & multiplexing of control files and redo-logs for disaster recovery scenario.

Created database & database objects like table, index, table space, rollback/undo segments and views & analyzed relevant objects to collect statistics to tune the system performance

Sound knowledge and experience in user managed and server managed online and offline backup and recovery using RMAN and other conventional methods

Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.

Extensively worked in setting up Oracle physical, logical standby database and data guard.

Setup, Configured and Maintained Oracle Data Guardto control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.

Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.

Knowledge on SAP basis administration.

Knowledge on client/server model, special Oracle/SAP naming conventions, administrator roles, and basic administrative operations.

Database replication using snapshots, materialized views and advanced replication methods.

Expert in Administering 7X24 OLTP, Data Warehouse, OLAP, and Hot Standby (Data Guard) databases. Ability to analyze, plan and execute to perfection.

Hands on experience with Oracle Gateway, in order to interact with other databases.

Sound Knowledge and experience in Oracle Golden gate for implementing streams, data replication process.

Have knowledge on Oracle Apps R12 and have experience in maintaining R11i databases.

Knowledge in Business Objects administration and BI tools.

Have knowledge on UNIX administration on OS installations.

Possess top quality skills in project management, customer support & system maintenance and a Team player with good analytical and communication skills, ability to quickly adapt to new environment.

Knowledge on Oracle 11i applications like financial, application server suite.

TECHNICAL EXPERTISE:

Tools

SQL*Plus, SQL Developer, Oracle Enterprise Manager (OEM), RMAN, Toad,

OEM, ODBC, Erwin, Export/Import, Data pump, Data Guard,ASM,RAC, Oracle Golden Gate, Developer (Forms, Reports ), Net Backup, TSM, VB, Oracle Gateway.

RDBMS Database

Oracle 8i, 9i, 10g, 11g, 10g RAC

Shell scripts (Korn & C), Perl

Operating Systems

Sun Solaris 8,9,10 Linux Red Hat 8.0/7, Digital Unix 4.0,Windows XP/2000/NT/98/95, Novell NetWare 3.0, DOS

Languages

SQL, PL/SQL, C, C++, XML, JAVA, J2EE, UNIX Shell Scripting, Perl Scripting, Assembly Language 8086.

PROFESSIONAL EXPERIENCE

Jan-10 TO Till Date

JP Morgan & Chase Columbus, OH

Designation

DataWare House Oracle DBA

Environment

IBM AIX 5.3,Linux,Solaris 10,Oracle 9i,10g,11g,OEM 11g,SQL*Plus, SQL Developer, Xming, Putty, Shell Scripting, ASM, Peregrine, Enterprise change Management Systems(ECMS),TSM, Veritas

Responsibilities:-

24X7 oncall Support for Prod and Non-Prod Databases in a Dataware House environment.

Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments.

Performed Necessary Failover Testing for the Failover Servers.

Installed Oracle 11g Software and built multiple databases.

Experience with 11g ASM Features and environment.

Applied necessary Patches during installation.

Performed lead role during migration of databases from AIX to Linux by giving proper directions to the team members to maintain allotted down time for the business users.

Well experienced with Migrating Oracle Databases from AIX to Linux and implementing further necessary validation after the migration.

Handy in utilizing datapump tool for exporting and importing the data.

Upgraded Analytical Databases from 10g to 11g.

Experience with DataGuard Features, Implemented building and Rebuilding of Standby Databases if needed.

Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.

Performance tuning of queries consuming Excessive Resources or slow running queries by Providing Required Hints to the Query.

Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan.

Played a Critical Role during DR-Test.

Played a lead role during SCRA project for restoring archival data from the tapes.

Understood the concepts of AMS (Archival Management System) and implemented successfully in production environment to archive historical data.

Well Experienced in taking Cold Backup for a very Huge 64-Tb Database.

Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN.

Experience with RMAN and its Features.

Experience with DDL and DML operations and having sound knowledge.

Having good exposure in user management, Tablespace Management, Session Management, undo Management issues.

Experienced in managing space issues in the Database Level for tablespace and Regular file system cleanup at unix level.

Experienced with troubleshooting the failed backups by working closely with TSM and Netbackup Support.

Experienced in troubleshooting Shell Scripts.

Implemented Procedures for calculating regular ASM space usage for the space estimation in the environment.

Experienced in using sqlldr for loading the flat file (.dat) into a table.

Experienced in Installing OEM agent and hooking up to the grid.

Configuring Heterogeneous Gateways in the OEM grid for monitoring the Listeners present in the oracle environment.

Performing TNS centralization using ifile, for the databases having multiple oracle homes on a single unix server.

Implemented Oracle Golden Gate to enable Business continuity plan for the client and to maintain a zero downtime during disaster recovery or during planned maintenance.

Implemented Oracle GoldenGatein the strategic replication solution for Oracle Databases.

Implemented active-active configurations usually require data conflicts to be managed by the application, suitable for custom applications.

Installed Oracle Golden Gate version v11.1.1.2 for Oracle 11g on Linux.

Debugging and troubleshooting issues when Oracle Golden Gate Abends.

Performing DNS remediation on all the unix servers by converting from one DNS(svr.bankone.net) to another DNS(card.jpmchase.net)

Performing ESM (Enterprise Security Manager) scan on all Oracle databases.

Well Experienced with Enterprise change management system by creating ECM’s, WRM, EURC and maintaining good customer Relationships by maintaining SLA’s in the environment.

Experience with peregrine ticketing tools for resolving the tickets.

Ability to manage pager rotation in the team.

Oct-08 TO Dec-09

Teachers Insurance and Annuity Association Charlotte, NC

Designation

Oracle DBA

Environment

Solaris 10, Aix, Hp-Ux,Linux 4,Oracle 9i/10g/11g RAC, Toad 9.6,10g Grid, Windows NT/2000,OEM,Oracle streams, Oracle Gateway,SQL*Plus, Shell Scripting

Responsibilities:-

Provided 24x7 support and On-Call rotation when needed for very large databases.

Installed Oracle 10g on Linux and Solaris and Aix environments and RAC 10g and worked on ASM feature of Oracle.

Estimate the size of the database and its objects (in large database of 1 to 2 Terabyte).

Upgraded database from Oracle 9i to 10g and 10g to 11g, having a good exposure on Oracle11g.

Installation and configuration of Oracle 10g RAC 2 node on Linux.

Applied CPU security patches in both RAC and standalone systems in ASM environment.

Experience with Oracle 10g grid control.

For the improvement of database performance implemented database tuning and its requirements and reviewed it.

Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations.

Experienced with all kinds of backup procedure like physical, logical and RMAN backups and Oracle 10g expdp/impdp utilities

Experienced with Oracle 10g ASM feature.

Acted as a release coordinator for all changes in databases and used to work closely with developing team.

REMEDY tool used for the change control process and followed SLA rules.

ImplementedOracle Replication through materialized view.

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.

Performance tuning of Queries by maintaining Aggregates,Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.

Experience with Oracle Gateway.

Ability to manage and support Oracle Applications.

Experience with database partitioning and responsible for daily loads.

Experience with DDL and DML operations and having sound knowledge.

Good experience with Oracle performance issues in both application tuning &memory tuning.

Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.

Writing UNIX shell scripts to manage Oracle environment and application processes.

Responsible for maintaining Oracle 10g data guard and 9i standby databases in Solaris, Linux and Aix platforms.

Daily databases Health checking and monitoring.

Mar-07 To Aug-08

Washington Mutual Seattle, WA

Designation

Oracle DBA

Environment

Solaris 9.0/10.0,Windows 2000/2003,RHEL AS4 Oracle Database 9i,10g R1, Toad 8.5.3, Siebel, RMAN, OEM, PL/SQL,SQL*Loader, Shell Scripting.

Responsibilities:-

Review of Database logical and Physical design.

Install, upgrade and maintain Oracle 10g on Sun Solaris and Windows 2003

Upgraded database from 9i to 10g in Solaris, Windows, Linux environments.

Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.

Implementing Database Security, Management of role-based security.

Used and Implemented Oracle Gateway which helps Oracle to talk to other databases.

Database Restore using RMAN, Cold Backup and Export.

Applying Patches 9.2.0.6 and applying Oracle Patches on Oracle database.

Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Cloning of databases from production to test environments.

Corporation and installation of patches.

Write and modify UNIX shell scripts to manage Oracle environment.

Problem analysis involving interactions/dependencies between UNIX and Oracle.

Net backup, Legato, EMC (Time finder and SRDF), RAID, RAW Devices.

OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator (RAM), Data Migration as part of enterprise data warehouse project.

Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.

Implemented Data Guard for DR process to enable Business continuity plan.

Experience with reading ERD(Entity Relationship diagram) and convert into necessary table structures, keys and indexes.

Provided Level2 and Level3 support to the client.

Built datasets in order to manage the applications easily.

Used Siebel for Customer Relationship Management available On demand.

Followed Stringent Process and best industry standard practices for production or any component changes.

Helped Development team by interacting with development team and in coding SQL and PL/SQL.

Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.

Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.

Performed scheduling Control-m for scheduling jobs.

Supported SAP and SAP Basis environment.

Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.

Apr 06 To Feb-07

Tundra Hyderabad, India

Designation

Oracle DBA

Environment

Oracle9i/10g, WindowsNT/03, Linux AS, AIX5.1, Hp-UX, Sun Solaris, SQL, PL/SQL, Shell Scripting.

Responsibilities:-.

Provided Technical Support to the client during normal business hours for the applications involved.

Design Evaluation and Analysis of physical and logical data model.

Involved in Installation and customization of Databases (10g&9i) in Windows, Linux and Solaris environments

Involved in Schema management, Tablespace Management, User Creation.

Monitoring the Extraction and loading processes of Data.

Upgraded and applied patches as and when required. Database Refreshes from Prod to Dev. Troubleshooting Day-to-Day Users Issues in various modules

Responsible for Oracle implemented logical Export & import .

Evaluated the hardware requirements before upgrading/migrating the database.

Good experience with recovery managed backups i.e RMAN

Migrated the database from SQL Server to Oracle from Windows to Linux.

Responsible for implementing database auditing and implemented the security features.

Maintained and audited Application and data servers.

Monitored and tuned Java Applications. Involved in Java Memory management and Log analysis.

Documented the complete project including all pre installation, post installation and database configuration steps.

Involved in writing UNIX shell scripting for automating the jobs.

Manage users, privileges, profiles, schemas.

Experience in using automatic monitoring and management processes like batch processing using crontab for processes like import, export databases.

Used analyze table, analyze indexes to tune queries and increase performance.

Used hints for SQL tuning and optimization.

Experience with SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.

Tuning Oracle9i database servers using tools dynamic, dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.

Maintained and implemented Oracle Data guard in high availability(HA) environment

May-04To Apr-06

iGate,Hyderabad, India

Designation

Oracle DBA

Environment

Oracle7, 8i/9i, RHEL 4, HPUX v2, Toad, Database tools/utilities, Sybase, SQL,PL/SQL

Responsible for administering and supporting production and development Oracle 8i/9i databases. Responsible for installing, upgrading and configuring the Oracle server, creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Implemented the Unix shell scripts for day to day database checkups.

Taking care of regular activities like Space management issues, capacity planning, Back up status and any user management issues.

Implemented Hot, Cold and physical backups.

Experience and having knowledge in batch processing which include interfaces to execute or run scripts automatically.

Enrolled users and applications, setup them with the integration of database to access their applications easily.

Creation of Test and Production databases for Oracle Enterprise Edition 8.1.7

Involved in Schema management, Tablespace Management, User Creation.

Used Sybase software for analyzing, managing and mobilize information using RDBMS.

Scheduled jobs automatically using automatic job scheduler tecniques like crontab for backup process like import, export, cold backup(copying) and to start(open),shut(close) the databases.

Experience with monitoring alert log files and determining data errors.

Implemented Backup & Recovery strategies for OLTP systems.

Worked as Support Database Administrator. Responsibilities include creation & maintenance of table spaces, datafiles, rollback segments, etc.,

Managing RMAN backups and created recovery plans by keeping in archive log mode.

Educational Qualification:

Bachelor of Technology in Electronics and Communications, JNTU, Hyderabad, INDIA.

Oracle Certi

Contact this candidate