Nirmala Krishnappa

**** ******** ****, ********, **-21075

Cell : 443-***-****

Home:410-***-****

abmri6@r.postjobfree.com

* **** *******:

6+ years of experience in Database Administration on oracle 10g, 9i and 8i

on both Unix & windows Platforms.

Oracle certified Professional in Oracle 9i database administration.

Areas of Expertise:

Design and creation of databases as per the Optimal Flexible Architecture

standards.

Installation, configuration, Migration of Oracle server software and

Database.

Applying patches to Oracle database server

Capacity Planning and growth estimation of database objects and structures.

Database backup and Recovery strategy implementation.

User administration, Auditing, Security.

Re-organization of database objects and storage structures as required for

performance of the database and also ensuring maximum uptime of the

database.

Performance tuning - Instance tuning, SQL Tuning and troubleshooting of

database problems.

Excellent skills in UNIX and Shell Scripting.

Expertise in oracle utilities -OEM, RMAN, Stats pack, Sql*Plus,

Export/import, TKPROF, Explain Plan, Logminer and Sql loader.

Expertise in PL/SQL programming

Expertise in Cloning of database.

Knowledge of Automated Storage Management (ASM) and Oracle Real

Application Clusters.

Setup and maintain documentation and standards.

2

3 Education & Certifications

Bachelors in Computer Science and Engineering.

Oracle Certified Professional (OCP) in Oracle 9i.

4 Technical Skills

RDBMS: Oracle 10g, Oracle 9i, Oracle 8i, SQL Server 2003

Platform: Linux, HP-UX, Solaris,Windows 2003/2000.

Programming/

Scripting: Unix Shell Programming, SQL, PL/SQL, C.

Tools/Utilities: OEM, AWR, ADDM,RMAN, Export/Import, SQL *Plus, TOAD,

Stats pack,

Explain Plan, Log miner, SQL Loader,

Erwin, Crystal Reports.

5

6 Professional Experience:

Magellan Health Services, MD

Senior Oracle DBA

Nov 2007 - July 2009

Environment Linux, HP-UX, Windows

RDBMS Oracle 10g, Oracle 9i

Tools Toad, STATS PACK, TKPROF, EXPLAIN PLAN, Export/Import

,ORADIM, Enterprise Manager 10g Grid Control

Job Responsibilities

Daily maintenance of Oracle databases, troubleshooting & resolving

database issues.

Execution of all Oracle database tasks within Magellan Database Service

Level guarantees.

Implementation of new stored procedures and scripts.

Installation of Oracle software & Creation of Databases and schemas.

User Account Management - creation of database users, quota, roles,

privileges and managing password and resolving connectivity issues.

Set up & update backup scripts, verify backup jobs for successful

completion and take action for failed jobs.

Assist in tuning the databases for optimum performance.

Refreshing development & test schema/tables using Export/import and

Datapump.

Creating and maintaining Tables, Partition, indexes, Global Temporary

Tables, Triggers, stored procedures etc.

Applying CPU patches to development, test & production databases.

24x7 on-call support for production databases.

Support to development & operational team -creating database structures,

deploy code to production, set up & monitor jobs, tune SQL queries to

improve performance of jobs etc.

Maintain & conform to company security standards with proper documentation

& Change management.

Maryland State Highway Administration, MD

Oracle DBA Mar 2007 -

Nov 2007

Environment Windows 2003/2000

RDBMS Oracle 10g Rel 2, Oracle 9i,

Tools Toad, STATS PACK, TKPROF, EXPLAIN PLAN, Export/Import

,ORADIM, Enterprise Manager 10g Grid Control

Job Responsibilities

Installation of Oracle software, database creation and configuration.

Successfully migrated 9i (9.2.0.1, 9.2.04) databases to 10g (10.2.0.3).

Successfully installed and configured 10g Grid Control for a centralized

administration of databases.

Creation of Database objects like tables, views, indexes, stored

procedures, functions.

Applying bug fixes & Critical Patch Updates (CPUs) to Databases.

Created a 10g development/test Database environment.

Developing PL/SQL procedures for Business applications.

Schema refresh using Export/Import to move data from Production to

Environment.

Recovering Data corrupted by Batch processes.

Creating Users and granting roles and privileges.

Tablespace and segment space management.

Monitoring and tuning the database to improve performance.

Loading data into database from external files/database.

Developed scripts for Database Monitoring activities such as tablespace

threshold level, reporting broken jobs, DB health check.

Verizon, MD

Oracle DBA Sep 2006 -

Feb 2007

Environment Sun Solaris

RDBMS Oracle 10g,Oracle 9.x, Oracle 8.x, MS SQL Server

Tools Toad, STATS PACK, TKPROF, EXPLAIN PLAN, Export/Import

Job Responsibilities

Creation of Database objects.

Developing PL/SQL procedures for Business applications.

Schema refresh using Export/Import to move data from Production to

Environment.

Recovering Data corrupted by Batch processes.

Creating Users and granting roles and privileges.

Tablespace and segment space management.

Creating and managing LOB segments.

Monitor & tune the Database for performance using STATSPACK, EXPLAIN PLAN,

TKPROF.

Loading data into database from external files.

Developed shell scripts for Database Monitoring activities such as

tablespace threshold level, reporting broken jobs, DB health check.

Scheduling Cron Jobs.

Enforcing Security policies on Database.

7 ON Semiconductors, AZ

1 Oracle DBA Jan

2006 - Aug 2006

Environment Sun Solaris, Suse Linux, Windows 2000

RDBMS Oracle 10g, Oracle 9.x, Oracle 8.x, MS SQL Server

Tools Toad 7.x, STATS PACK, TKPROF, EXPLAIN PLAN, Export/Import

2 Job Responsibilities

Installed, created and upgraded oracle databases as needed for development

effort. Worked with application architect to design and implement common

database objects and resources (tables, views, packages, stored procedures,

triggers, etc)

Created, configured and maintained oracle 10g databases.

Upgraded/Migrated databases from version 9.2.0.1.0 to 10g.

Applying Oracle Patches using Opatch Utility.

Database Cloning to copy data from production to test database.

Schema Refresh using Export/Import Utility.

Managing and monitoring Physical standby database.

Automation of jobs using shell scripts -database startup & shutdown, backup

scripts, checking health of DB, running Stats pack, deleting old backups

and log files.

Oracle performance tuning -sizing shared pool, buffer cache, SGA structure,

optimize sorts, diagnosing contention for latches, tuning rollback and Undo

segments, Monitoring and detecting lock contention, tuning shared server,

application tuning.

Performed data loading from flat file to Oracle database using SQL Loader.

Administration of SQL Servers

24/7 support for production database and server side application.

8 Bearing Point

1 Oracle DBA Aug

2005 - Dec 2005

Environment HP-UX

RDBMS Oracle 9.x, Oracle 8.x,

Tools Toad 7.x, STATS PACK, EXPLAIN PLAN, SQL Loader, Logminer

2 Job Responsibilities

Tuning Database Design.

Database security - responsible for creating and maintaining database

users, roles and profiles. All work is performed based on application

requirements and pre-defined standards.

Set up cron jobs to schedule and automate jobs.

Restore and recovery of Database using Operating system Utilities.

Proactively monitor the growth of database and tune using stats pack.

Optimization of SQL queries using Explain Plan scripts.

Monitoring memory processes, disk I/O affecting performance using OS

utilities.

Recovery of user errors.

Creating/populating data based on the application/requirement.

Monitoring Backup jobs for success and managing archive log files by

frequently moving to tapes.

Successfully upgraded database from Oracle 8.1.7.0 to Oracle 9.2.0.1.0.

Involved in data extraction and load operations using SQL*Loader utility

for data warehousing application. Significantly reduced the time for data

load using SQL Loader Direct Path and Parallel load.

Interact with Oracle Corporation for technical support.

9 Unilever

Oracle DBA July 2004 -

July 2005

Environment AIX, Linux, Windows 2000

RDBMS Oracle 9.x, Oracle 8.x, MS SQL Server

Tools OEM, STATS PACK, EXPLAIN PLAN, RMAN

1 Job Responsibilities

Configured the Recovery Manager Environment with repository which contained

set of metadata that RMAN uses to store information about the target

database and its backup and recovery operations

Creating and validating Backups and restoring and recovering Database using

RMAN Utility.

Object level logical backup using export utility.

Creating users and granting appropriate roles and privileges.

Make requested database changes in a timely manner using change control

procedures.

Checking trace files and handling ORA errors.

Identify potential database performance improvements

Performance tuning using STATSPACK and Explain Plan and Monitoring the

Database growth.

Using RMAN handled database recovery and implements backup strategies.

Checking for tablespace and object fragmentation.

Developed Perl scripts to check the disk usage of archive logs and data

files, creating new users and granting privileges, dropping users.

Migration of Oracle 8i database to Oracle 9i Rel 2.

10 Satyam Computer Service Ltd, India

Oracle DBA Feb 2003 -

June 2004

Environment Sun Solaris, Linux, Windows 2000

RDBMS Oracle 9.x, Oracle 8.x

Tools BSTAT, ESTAT, EXPLAIN PLAN, SQL TRACE, TKPROF

1 Job Responsibilities

Installation and setting up of Oracle database dedicated server and multi-

threaded server (MTS).

Created database physical & logical components

Setting up optimal (OFA) disk space utilization to improve response time.

Created users, roles, profiles and granted roles, profiles & privileges to

users.

Tablespace and Segment Space management.

Planning backup strategies and creating backups.

Configuration & maintenance of standby database.

Database replication and migration.

Monitoring load on the server, memory usage, disk space etc.

Tuning of database performance. Finding Performance bottlenecks using

UTLBSTAT, UTLESTAT, ANALYSE, EXPLAIN PLAN, SQL TRACE, TKPROFF

Support to developers, end-users.

11 Siare Technologies, India

1 Oracle DBA Dec

2001 - Jan 2003

Environment Linux Red Hat 7.2

RDBMS Oracle 8.x

Tools BSTAT, ESTAT

1

2 Job Responsibilities

Installation of Linux.

Installation & configuration of Oracle on Linux.

Creation of Instance, database, table spaces/data files, RBS, users and

roles, schemas, tables, indexes.

Created users, roles, profiles and granted roles, profiles & privileges to

users.

Segment Space Management.

Backup and recovery procedures of Oracle database: Cold/offline backup and

Hot/online backup through Archive log mode.

Managing table spaces/data files, archived redo log files, control file

Monitoring load on the server, memory usage, disk space etc.

Checking the health of the database.

Database performance tuning using BSTAT and ESTAT.

Taking export backup.

Contact this candidate