Oracle DBA

Karthik Govindarajan

Tel 914-***-**** / email: ********@*****.***

SUMMARY:

Oracle DBA with over Fourteen Years of experience in the Information Technology industry.

Extensive experience in administration of Oracle Database Administration.

Hands-on experience on installation/up-gradation/migration, capacity planning, performance tuning, backup/recovery of Oracle Database.

DBA support of multiple production, test, and development environments.

Experience in Installation, Configuration of various Application software’s like Oracle 7.x/8.x/9.x/10g/11g Database, Oracle Management Server (OMS), Oracle Enterprise Manager (OEM), Enterprise Manager Grid Control(Grid), Oracle Real Application Cluster (Oracle RAC), Oracle WebDB, Oracle Application Server, Apache Server, JRun Server

Maintaining High availability of database and Disaster management using Standby databases, Data Guard, Cloning, Replication, Oracle Streams and Oracle Real Application Clusters (RAC).

Analyze user requirements and define Conceptual Data model and derive Logical and Physical data models

Expertise in 11gR2/10g RAC, ASM, Grid Control, RMAN, handling very large single database 20TB.

Excellent communication and interpersonal skills.

Technical Skills:

Software:

Oracle (11gR2,10gR2, 9i, 8.1.7.4, 8.1.6, 8.0.5, 7.1.6), SQL* Forms 4.5, Reports 2.5,SQL*Menu5.0, SQL* Loader, Net 8, OEM, Siebel 8, Veritas netbackup, ERWin, BMC Patrol, Perl 5.X, JDK 1.1.7B, Pro*C, C, Delphi 1.0

Languages: SQL, PL/SQL, ADL, UNIX Shell Script (Bourne, Korn), HTML, Java(jdk 1.5), JavaScript, J2EE,C/C++, Perl

Application and Web Servers: SAS, Oracle 9i AS 9.0.2.0.0/1.0.2.2, Portal 3.0.9.8.1, Apache 1.3.12.0.0a, Web Logic 4.5.1, IBM Web Sphere, Netscape Enterprise Server 3.6.2, iPlanet, Lawson 8.0.2

Utilities: JRUN 2.3.3, JDBC Oracle Thin Driver 8.0.5.2, CLEAR CASE

Operating System: Solaris 2.7, HP-UNIX 11.0,10.2, IBM-AIX 4.3.3, Windows NT, Windows 98, Ms-Dos 6.22

Hardware:

SUN SPARC ULTRA E250/E450/E3500/E5500, HP 9000 (D, E & G Series), HP PA-RISC, HP Itanium ,RS/6000, Digital DEC Alpha 3.2

Professional Experience

Accenture, White plains, NY July 2009 till date

Oracle DBA Lead

Responsibilities:

Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, capacity planning, space management, database security, auditing and troubleshooting.

Installation of Real Application Clusters (RAC)

Upgrades, migration and patch installation

Monitoring performance of various activities like Disk I/O, Resource Contention, SGA etc.

Configuration of Oracle 10g R2 OEM Grid Control to monitor database

Experience in resolving the issues related to installation, upgrades and patches

Implementation of High Availability solutions with Oracle 11gR2/10g RAC and Replication using CDC, Oracle Streams and GoldenGate.

Implemented RMAN Backups, Creation of catalog database

Partitioning Strategies for very large tables

Physical data warehouse design, table partitioning, indexing strategy, materialized views, hands on PL/SQL development using packages, procedures

Design, model, implement fact and dimensional tables

OS/Platforms: AIX 6.1, HP-UX 10/11, Sun Solaris 2.6, Windows NT

Environment: Oracle 11gR2, 10gR2/9i/8i, Oracle Streams, GoldenGate, Enterprise Manager Grid Control, PL/SQL, Siebel, Net 8/ SQL *Net, C/C++, RMAN

Starwood Hotels and Resorts Inc, White plains, NY Dec 2003 till July 2009

Sr. Oracle DBA

Responsibilities:

Installation and Configuration of database software (Oracle 8i / 9i and 10g ), Application software’s like Enterprise Manager Grid Control and Grid agents, Toad on HP-UX, Linux, Solaris and Windows platform.

Optimize Data warehouse ETL process by implementing Change Data Capture (CDC) process.

Implement and maintain database security using Database Resource Manager, Encryption, Roles, Privileges, Audit Trails, Listener logs and Profiles features.

Installation and Configuration of Oracle ASM (Automatic Storage Manager)

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Implementing Table and Index Partitioning for optimizing the performance.

Capacity Planning, Space Management, Database Upgrades / Migration and Data Extraction.

Performance Tuning of Database and SQL statements using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK, AWR, ADDM Reports, and Oracle Enterprise Manager Grid Control etc.

Monitoring and optimizing the performance of the database through database tuning, tuning applications, and tuning disk usage.

Implement Oracle Streams for schema and table level replication

Writing effective Shell Scripts for monitoring and maintenance of various databases.

Disaster recovery using Standby database, Database cloning, Replication and Data Guard technology.

Use of Recovery Manager (RMAN), Data pump, DBMS_SCHEDULAR, DBA_JOBS, Import-Export utilities and SQL * LOADER.

Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support.

OS/Platforms: HP-UX 10/11, Sun Solaris 2.6, AIX V4.2, Windows NT

Environment: Oracle 10gR2/9i/8i, Oracle Streams, Enterprise Manager Grid Control, PL/SQL, Siebel, Net 8/ SQL *Net, C/C++, RMAN, HTML, ClearCase, SQL Server 2000

HCL ES, Oak Brook, IL Oct 2002 Nov 2003

Sr. Oracle DBA

Responsibilities:

Install and upgrade oracle databases and perform capacity planning

Install and configure Lawson application and Crystal Enterprise

Implements and enforces security for all of the Oracle Databases

Performance tuning using STATSPACK and SQL Trace and TKPROF

Refresh data from one Lawson Product Line to another Product Line

Implement Oracle 9i’s new features like Automatic Undo Management, Dynamic Memory Allocation etc.

Develop and enforce database related policies, standards, naming conventions, operating procedures and best practices

Installing, upgrading and configuring Oracle databases, Oracle 9i Application Server

Performed Oracle database and Portal applications administration activities such as monitoring and troubleshooting 9iAS for 24X7 uptime, patching the application software, setting the database storage parameters correctly, Capacity planning, monitoring alert logs

Installed and configured Oracle Workflow

Tuned the database by using the right hints in queries, running statspack, using Explain Plan and TKPROF, eliminating chained rows, using histograms and avoiding flushing of shared pools

Installing and maintaining Apache web servers

Refreshing the Test databases with the production data

Installing and administering monitoring tools like Precise etc.

Performed Database reorgs and preventative maintenance. Troubleshooted Database errors effectively identified and resolved production problems. Monitored disk space usage, balanced I/O load.

Scheduling jobs for loading data and application support

Monitoring, tuning & auditing users, maintaining security, assigning roles & privileges to the users

Involved in creating/moving/migrating databases, restoring database from a disk corruption, configuring for distributed databases, scheduling jobs, and automating the routine tasks using Shell/SQL * Plus

Extensively involved in tuning Sql code, database tuning

Involved in loading the data using SQL LOADER utility, importing and exporting database

Reorganized tables and indexes to reduce fragmentation and increase performance.

Managed application security and storage allocation. Analyzed tables and indexes. Used Export/Import for migrations across machines

Managed Oracle advanced futures like Replication, partitioning and transportable tablespaces

Cloning the databases to replicate in different environment

Created logical and physical database design and provided support to developers

Application and Database performance tuning

OS/Platforms: Sun Solaris 2.7, Windows NT, AIX 4.3.3

Environment: Oracle 9iAS(3.0.9.8.5), oracle 9i/8.1.7.2, Oracle Portal, Lawson 8.0.2, PL/SQL, HTML, TOAD 7.3.0.0, Net 8PL/SQL, HTML, TOAD 7.3.0.0, Net 8 and Precise

Objectwin Technologies Inc, Houston, TX Aug 2001 Oct 2002

Sr. Oracle DBA

Responsibilities:

Installing, maintaining, tuning and upgrading multiple Oracle databases

Installed Oracle 9i (9.0.1 Enterprise Edition) Database

Installation and Configuration of Oracle 9iAS for the Components HTTP Sever, Database Cache, Web Cache

Worked on components of the Oracle9i Application Server

Database support which use Oracle WEB Portal to build application components, such as dynamic Web pages

Configuring web server and registering the adapter with the Oracle WEB Portal

Maintain and support Oracle Advanced Replication

Study and Analyze Business requirements

Sizing tablespace and rollback segments

Used RMAN for backups and recovery.

Frequently use Oracle’s Export and Import utilities to defragment, upgrade and copy databases

Responsible for writing Database Triggers, Stored Procedures and Back end PL/SQL functions

Setup backup and recovery procedures, and create primary objects including tables, views, indexes, etc

Configured SQL *NET/Net 8 to connect to the database server from the client

Load data into tables using SQL*Loader

Writing Stored Procedures, functions and triggers

Work with development team to write/fine tune SQL*Plus queries, procedures etc.

Establish security policies and enroll both developers and end users

Monitor alert logs and trace files.

Supporting Siebel applications.

Write Unix shell scripts to assist with automated backup procedures, startup and shutdown of databases as well as analyze table scripts and set up unix corn jobs

OS/Platforms: Sun Solaris 2.6, AIX V4.2, Windows NT

Environment: Oracle 9iAS, oracle 9i/8.1.6, Oracle WEB Portal, PL/SQL, iPlanet 3.0, Java, Siebel, Net 8/ SQL *Net, RMAN, HTML, ClearCase, Team Track, Designer 2000

Formulasys Inc, Cupertino, CA Mar 2001 Aug 2001

Sr. Oracle DBA

Responsibilities:

Install and upgrade Oracle database

Create tablespaces, schema objects, procedures and functions

Setup and maintain documentation and standards

Designed and implemented Backup/Restore strategy and created Backup / Restore scripts and procedures

Implement the oracle database security policies

Performance tuning using Oracle diagnostics tools and Unix performance monitor tools

Configure Oracle performance monitoring utility STATSPACK

Implementation of OLAP (Online Analytical Processing) concepts, Planning for Performance Monitoring

Capacity planning for Oracle database, Creation of Users and give access permissions, monitor user and group management

OS/Platforms: Sun Solaris 2.6, Windows NT

Environment: Oracle 8i, PL/SQL, OEM, RMAN, Veritas netbackup, Java, HTML, TOAD

Hi-Tek Consulting Svc Inc, Sunnyvale, CA May 1999 Mar 2001

Oracle DBA

Responsibilities:

As Oracle DBA:

Installed Oracle 8.1.6 on HP UX 11.0

Analysis of Logical Data Model and Preparation of Logical Design Document

Involved in designing database, developing PL/SQL and maintaining database

Configured SQL *NET/Net 8 to connect to the database server from the client

Perform Oracle installations, upgrades, migrations, and re-organizations

Participate in web based application development requiring Oracle database expertise and design skills

Physical and logical database design for the whole database system which is expected to grow to large sizes

Responsible for writing Database Triggers, Stored Procedures and Back end PL/SQL functions

Extensively involved in System Study and Business Requirements Analysis

Implement and maintain database security (create and maintain users and roles, assign privileges)

Generated SQL scripts to monitor database performance and tuning purpose. Also performed tuning of Production database using UTLBSTAT, UTLESTAT

Providing support to end users by writing procedures and functions for reports

Worked on Capacity Planning of the current system according to the demand and load on the system

Replication using Standby database and snapshots

Write scripts for loading data using SQL*Loader

Configured SQL *NET to connect to the database server from the client

Backup and recovery using inconsistent and consistent (Hot and Cold) scripts and RMAN

Responsible for writing Database Triggers, Stored Procedures and Back end PL/SQL functions

Build scripts to create users (database and system), roles, tablespaces, tables, indices, synonyms, db links, sequences, procedures, constraints (FK, PK, UK, CK), grants

OS/Platforms: Sun Solaris 2.6, HP Unix 10.2/11.0, Windows NT, Compaq Alpha/VAX OpenVMS, Veritas File System

Environment: Oracle 9i, Oracle 8.1.6, Oracle 8.0.5, Oracle WEB Portal, PL/SQL, OEM, RMAN, iPlanet 3.0, Web Trends, Veritas netbackup, Java, HTML, Weblogic 4.5.1,Netscape Enterprise server 3.6.2, Jrun 2.3.3,Oracle Thin Driver 8.0.5.2,Apache 1.3.6, Tuxedo, BMC Patrol

Byzen Software Pvt. Ltd., Mumbai, India Jan 1998 April 1999

Oracle DBA

Organization Profile:

Citibank N.A had a clustered network consisting of three clusters viz. Development, Control and Production. The clusters were interconnected using dedicated X.25 links. The machines within a cluster were interconnected using TCP/IP links. The development network consisted of approximately 12 servers with at least 3 databases in each. The programs developed in development were transferred to control for compilation and testing after which they were finally transferred to production to be used in OLTP transactions by end users. The production cluster consists of about 75 servers with at least 2 databases in each. Oracle 7.3/7.1.6 was used in production.

Responsibilities:

As Oracle DBA:

Installation of Oracle 8.0.5, 7.1.6

Partitioning tables and indexes

Backup and recovery using RMAN

Work with the architect team to arrive with the optimal design of the Database to meet user requirements

Implementing Oracle 8’s new security features

Installed and configured Net 8

Creating Users and allocating Space

Creating Database Links

Tuning Database for optimal performance

Recovery of Database from Disk or Instance failure

Monitoring alert log, system log

Written Scripts for SQL* Loader etc.

Monitoring database for fragmentation and de-fragmenting the tables

Refreshing development database from production for testing

Implementing Snapshots

Application SQL code tuning using TKPROF and Explain Plan utilities

Writing shell scripts to automate various tasks

Providing support to end users and developers

24 X 7 production support and contingency servers.

Recovering Production database using the offline and online backup for contingency drills.

Reorganization of the tables, table space, database

OS/Platforms: HP-UX 10.2, 10.1, Solaris 2.6, Compaq Alpha/VAX

VMS, AIX V4.2

Environment: Oracle 8.0.5, 7.1.6, Sybase, SQL* Loader

Pambban Software Systems Ltd., Chennai, India Jun 1995 Dec 1997

Software Engineer

Worked as a Software Developer in a team of 9 people to develop the following product using Oracle Forms 3.0. Also involved in Physical and Logical Data modeling.

Medico Marketing – Clinical Trial

System that enables you to store, manipulate and query data that is collected during Registration and Clinical trial. It is specifically designed for companies in the pharmaceutical, biotechnology and consumer products industries. This product accelerates new drug registration by simplifying the management of clinical data throughout all phases of clinical trials. This software is for Clinical Data Management As a fully integrated software product this application:

Shortens time to market

Enhances data quality

Promotes standardization in clinical data management operation

Environment: Oracle 7.1, SQL* Forms 3.0, SQL Plus, PL/SQL

Contact this candidate