Oracle Data

aKHIL KARDAM

C ram Application Database Administrator

Professional Summary:

> Over 11.0 years of DBA experience

o 10.0 years of DBA experience in Oracle.

o 6.0 years of DBA experience in DB2

> Oracle Certified DBA Professional.

> Over 6 years of experience with IBM C ram Social Program

Management platform

> Good knowledge of the C ram SPM platform and its associated Data

Model.

> Installation, Configuration and setup of C ram Application

Database versions 5.x and 6.x

> Experience in C ram database upgrades, applying iFixes, data

fixes.

> Installation, Configuration and Maintenance of DB2 database

versions 9.1, 9.5 and 9.7 on IBM AIX

> Installation, Configuration and Maintenance of Oracle database

versions 11g, 10g, 9i on Linux, Solaris, IBM AIX, HP Tru64, and

Windows.

> Has working experience as 24x7 Production support DBA

> Expert in Oracle RAC installation, configuration, monitoring and

maintenance.

> Expert in Oracle DATA GUARD (physical & logical standby database)

configuration, maintenance and switchover standby database.

> Experience in Database design including creations, modification,

and deletions of Tablespaces, Data-files and/or Containers,

Rollback Segments, Schema, Tables, Indexes, Views, Sequences,

Synonyms, Roles, Procedure, Function, Package, Triggers and DB

Link.

> Expert in .sh and ksh shell, sed, awk, perl, sql, pl/sql etc.

programming skills in UNIX and DOS batch programming skills in

Windows

> Worked on scripting for DB2 LUW database for automated alerts and

data collection related to space, DB2DIAG errors, DB Instance

availability, backup completion and status (offline & online), RUN

STATS and REORG collection etc. and data feed to the database for

reporting purpose

> Worked on scripting for Oracle database for automated alerts and

data collection related to space, ORA errors in Oracle, DB

Instance availability, backup completion and status (offline &

online), DBMS STATS collection etc. and data feed to the database

for reporting purpose

> Worked on scripting for System Admin based alerts and data

collection related to Unix LPAR File-system utilization, Server

Availability, Server Resources (CPU, Memory, Disk I/O, Virtual

Memory, Paging etc.) utilization and data feed to the database

for reporting purpose

> Expert in diagnosis and obtaining recommendations on Database

Resource Utilization and Performance using AWR and ADDM in Oracle

and DB2 Snapshots, DB2DART and OPTIM performance Manager for DB2.

> Worked on upgradation / migration of production database from

Oracle 9i to 10g and DB2 9.0 to 9.5 to 9.7

> Worked on planning and scheduling of Offline and Online backups of

DB2 DB using CLI on TSM and Oracle DB using RMAN on TSM and

logical backups using data export/import.

> Good working experience in Disaster Recovery.

> Expert in Partitioning Administration: creating, managing

partitioned tables.

> Experience in analytical and Troubleshooting skills and Problem

solving,

> Proficient in Unix Administration part pertaining to DBA i.e. User

maintenance, Performance Monitoring of CPU load statistics,

Process monitoring, kill process, Disk and Memory usage, and File

system monitoring.

> Worked on data migration from Oracle to DB2 using IBM Migration

toolkit and data types mapping between Oracle and DB2

Technical Skills:

Database IBM DB2 LUW v9.1, 9.5, 9.7, Oracle 11g, 10g, 9i.

Tools & TOAD, DB2TOP, DB2 Snapshots, OS TOPAS, DB2DART, Export/Import,

Utilities TSM backups,

OEM (Oracle Enterprise Manager), RMAN (Recovery Manager),

SQL*Loader, SQL Trace, STATSPACK, Management packs, Log Minor,

Explain plan, TKPROF,

CA Erwin Data Modeler, IBM Migration Tool. OPTIM performance

Manager for DB2

Operating AIX, Unix, Linux, Windows, Solaris, HP Tru 64

Systems

Scripting Shell, Sed, Awk, Perl

Languages:

Languages: SQL and PL/SQL

Certification Oracle 9i & 10g Certified Professional

COTS IBM C ram SPM V 6.x & 5.x, Advantage, Business Objects,

High-View, Informatica

PROFESSIONAL EXPERIENCE:

Arkansas Department of Human Services, Little Rock, Arkansas, USA

Jul 2013 - till date

C ram Application DBA

Eligibility and Enrollment framework (EEF) is a C ram implementation of

Medicaid and CHIP programs under the Affordable Care Act for the State of

Arkansas. C ram HCR module is being customized to meet the state specific

requirements. The project went live successfully with the first milestone

of the ACA on October 1, 2013. It is an online application, where Medicaid

reimburses healthcare providers for covered medical services provided to

eligible needy individuals in certain categories. Eligibility is determined

based on income, resources, Arkansas residency, and other requirements.

Covered services also vary among categories and categories are mainly

summarized below under two headings of "Aged, Blind and Disabled" and

"Children and Family"

Responsibilities:

> Database administration. Planning & architecting databases for CURAM

application

> Design and implement database configurations, customizations and data

modelling in C ram versions 6052 and 6053

> Providing architectural guidance to DBA & development team

> Worked on production go live database activities.

> Developed and implemented DB Delta process to upgrade C ram

application database to higher C ram releases

> Installed and configured production database for C ram using DB2

version 9.7 fp6

> Installed and configured C ram version 6052 on production database

> Upgraded production database from C ram version 6052 to version 6053,

while retaining end user applications and/or cases in C ram

terminology

> Applied various C ram iFixes using DB delta process.

> Worked and developed scripts to migrate C ram user/organization

structure from one environment to another environment.

> Developed various SQL scripts for reporting data from normalized C ram

database.

> DB support for SNAP conversion activities.

> Implemented security and encryption mechanism in CURAM database

> Providing 24/7 support for critical situations in production

environment.

> Analyze and sustain capacity and performance requirements

> Installed and configured IBM DB2 databases v9.7 on AIX

> Worked on planning and scheduling backups for DB2 databases using

CLI and DB2 table export/import.

> Wrote shell scripts to automate physical and logical backups in

all environments using TSM including production

> Day to day DBA Support for backup, restore and recovery in all

environments including production

> Worked on DB2 DB upgrade

> Responsible for applying DB2 patches on Dev, QA and Prod databases

> Worked in designing database including creations, modification,

and/or dropping of table spaces, data-files, undo-segments,

schemas and schema objects like tables, indexes, views, sequences,

synonyms, roles, procedures, functions, packages, triggers etc.

> Wrote scripts for DB2 database for automated alerts and data

collection related to space, DB2DIAG errors, DB Instance

availability, backup completion and status (offline & online), RUN

STATS and REORG collection etc. and automation of data feed to the

database for reporting purpose

> Responsible for writing database monitoring shell scripts and

setting cronjobs. Expert in .sh and .ksh shell, sed, awk, perl,

sql, pl/sql etc. programming skills in UNIX and DOS batch

programming skills in Windows

> Responsible for SQL and PL/SQL tuning and full support to

development/application team for various tasks.

> Build, deployments and data fix support for development, testing

and production environments

> Automated database deployment processes

> Troubleshooting database for any errors and contact IBM support

for DB2 DB, if needed.

> Perform root cause analysis and document troubleshoot steps and

presentation to the management

Environment: IBM AIX 7.1, DB2 9.7 fp6, Toad, CURAM 6.0, Web-Server,

TSM, ERwin

MphasiS Corp. (USGS Healthcare - CA), California, USA

Jul 2008 - Jul 2013

C ram DBA (Module Lead)

The Case Management, Information and Payrolling System (CMIPS) tracks

case information and processes payments for the state of California

Department of Social Services (CDSS), In-Home Supportive Services

(IHSS)Program, enabling nearly 400,000 qualified aged, blind, and

disabled individuals in California to remain in their own homes and

avoid institutionalization.CMIPSII is an application combined of multi-

vendors based Case Management (IBM C ram), Advantage (Payroll CGI),

Business Object (Reporting) and Timesheet Processing (High-View).

CMIPSII has 65+ databases including Oracle (versions 10g, 11g) and IBM

DB2 (versions 9.1, 9.5) supporting multiple environments in

development, QA/testing, performance, tools and production. Production

environment has 4 databases including Oracle 11g on Linux and DB2 v9.5

on IBM AIX. CMIPSII tools, for e.g., Starteam, HP Quality Center, CA

Service Desk and Autosys are also considered as production and have

total 4 Oracle databases on Linux and Windows platforms.

Responsibilities:

> Installation and configuration of Oracle databases 11g, 10g on

Linux and Windows

> Installation and configuration of IBM DB2 databases v9.1 fp7 & 9.5

fp7 on AIX

> Installed, configured and tested physical stand-by database with

Data Guard 11g for operational database and implemented in

production

> Installed, configured and tested 4 node RAC 11g with ASM for

operational database, which is planned to be implemented in

production

> Worked on planning and scheduling backups for Oracle databases,

online and offline using RMAN with TSM, table data exports using

data-pump

> Worked on planning and scheduling backups for DB2 databases using

CLI and DB2 table export/import.

> Wrote shell scripts to automate physical and logical backups in

all environments including production

> Day to day DBA Support for backup, restore and recovery in all

environments including production

> Worked on Oracle DB upgrade

> Installed Oracle 10.2.0.1 and upgraded to 10.2.0.3 for tools

databases

> Responsible for applying Oracle patches on Dev, QA and Prod

databases.

> Responsible for applying DB2 patches on Dev, QA and Prod databases

> DBA support for application patches and application version up-

gradation

> Worked in designing database including creations, modification,

and/or dropping of table spaces, data-files, undo-segments,

schemas and schema objects like tables, indexes, views, sequences,

synonyms, roles, procedures, functions, packages, triggers etc.

> Wrote scripts for Oracle database for automated alerts and data

collection related to space, ORA errors in Oracle, DB Instance

availability, backup completion and status (offline & online),

DBMS STATS collection etc. and automation of data feed to the

reporting database for reporting purpose

> Wrote scripts for DB2 database for automated alerts and data

collection related to space, DB2DIAG errors, DB Instance

availability, backup completion and status (offline & online), RUN

STATS and REORG collection etc. and automation of data feed to the

database for reporting purpose

> Wrote scripts for System Admin based alerts and data collection on

AIX and Linux LPARs for File-system utilization, Server

Availability, Server Resources (CPU, Memory, Disk I/O, Virtual

Memory, Paging etc.) utilization and data feed to the database

for reporting purpose

> Wrote scripts for collection of system response time for daily

transactions in HTTP logs and automation of loading data in to

reporting database for generating daily, weekly and monthly SLA

based reports for the client

> Responsible for writing database monitoring shell scripts and

setting cronjobs.

> Proactive database monitoring using AWR, ADDM, grid control and

monitoring shell scripts

> Monitoring wait events like db scattered reads, db sequential

reads, locks, blockers.

> Monitoring long running SQLs

> Performance and tuning using explain plan, TKPROF, SQL tuning

advisor, Index management.

> Responsible for SQL and PL/SQL tuning and full support to

development/application team for various tasks.

> Gathering table statistics on daily basis statistics using

DBMS_STAT package and rebuilding indexes jobs monitor schedule

task for gathering stats/ analyze tables.

> Index monitoring (usage), designed new Indexes by monitoring

performance of existing code and new development code before

deployment on production db.

> Build, deployments and data fix support for development, testing

and production environments

> Automated database deployment processes

> Troubleshooting database for any errors and contact Oracle support

for oracle DBs and IBM support for DB2 DBs, if needed.

> Perform root cause analysis and document troubleshoot steps and

presentation to the management

> Responsible for regular O/S Administration like CPU load, IDLE CPU

%, time taking session/processes, Disk and Memory usage, and File

system monitoring.

> On-call production support for Oracle & DB2 databases on rotation

basis

> Expert in .sh and .ksh shell, sed, awk, perl, sql, pl/sql etc.

programming skills in UNIX and DOS batch programming skills in

Windows

> Experience in running Quick Test Pro (QTP) to validate application

functionality and to collect user response time

> DB support for GO LIVE conversion activities.

> Analyzing system and user response time and document root cause

analysis

> Worked on installing IBM Migration Tool-Kit and performed data

migration from Oracle to DB2 tables

> Author and ownership of client deliverable - DDD (Database Design

Document)

> Co-author of client deliverables - DSD (Detailed System Design)

and Operations Plan and Manual.

> Worked with architects on capacity planning

> Maintaining ERDs and data dictionaries using CA ERWIN data

modeling tool in the design document 'DDD' and quarterly

presentation to the client

Environment: Linux (Red Hat), Windows NT 2003, IBM AIX, NFS, apache web

server, http server, Tivoli Server, Oracle 10g & 11g, DB2 9.1&9.5,

Oracle Grid, Toad for Oracle and DB2, C ram 5.2, Business Objects,

Universe, CA Erwin for data modeling, QTP, Starteam, HP Quality Center,

CA Service Desk

MphasiS Limited (VeriSign Corp. and Metro PCS), Bangalore, India

Jan 2007 - Jul 2008

Sr. Oracle DBA

MetroPCS is an American mobile phone service provider. It operates the

fifth largest mobile telecommunications network in the US. Over 8 Tera

Bytes of production database in Oracle 10g on Linux and in total 72

development, testing, conversion activities based databases in Oracle

9i & 10g on Linux.

Responsibilities:

> 24x7 production DBA support for standalone databases on Linux

environment

> Created UNICODE database (multi language database)

> Implementation of Char semantic setting in production database.

> Upgraded the DB from 9206 to 10202

> Configuration, Managing, Monitoring RMAN Backups and view catalog

reports for validating backups.

> Responsible for configuration and maintenance of HOT CLONE

database

> Responsible for configuration and maintenance of DATA GUARD

logical standby database.

> Development, Alpha/ Beta Databases refresh from Production

database using 10g Data Pump for system testing, alpha/beta

testing before production deployment.

> Performance Tuning using 10g features like OEM performance page,

AWR reports, ADDM and SQL tuning advisor.

> Performance tuning using dictionary views like V$latch,

V$system_event, wait event statistics, sequential/scattered read

count, dba_blocker etc.

> SQL, PL/SQL scripts performance tuning using Explain Plan, Tkprof

and Statspack utilities.

> Responsible for design and implementation of Partitions, (Managed

Partitioned Tables, Partitioned Indexes. Created Local Partitioned

Context Index on Range partitioned table).

> Configuration of Flash Recovery Area.

> Worked on 10g Flashback Technologies: Flashback version query,

Flashback Transaction Query, Flashback Table. Configured and

Enabled Flashback Database.

> Responsible for Rapid Response Tickets (Urgent Hotfixes in

database).

> Responsible for regular Unix Administration like CPU load, time

taking session/processes, Disk and Memory usage, and File system

monitoring.

> Responsible for Routine database check up (check Alert log file,

monitor space available in tablespace, UNDO tablespace monitoring,

RMAN backup check up, delete expire backups, CPU load, Instance

activity)

> Responsible for Configuration, Monitoring database GRID.

> Design, review and testing Subprograms like Procedure, Functions,

Triggers and Packages.

> Involved in the process of analysing SQL Queries, Pl/Sql scripts

and estimating Access Speeds.

> Responsible for preparing application baseline for new application

release

> Implementation of Basic Replication through Read-Only Snapshots

(Materialized View)

> Monitor running jobs and root cause of time taking jobs.

> 24/7 support to Oracle DBs

Environment:

Oracle 10g/ 9i, SQL, PL/SQL, DB GRID, Sun Solaris, Linux, Windows,

TOAD.

Oracle India Pvt. Ltd., Bangalore, India

Aug 2004 - Dec 2006

Sr. Oracle DBA

Oracle Files is designed as an enterprise file server replacement, with

added content management features (for example, versioning). Oracle

Files provides support for file-sharing and collaboration protocols. A

Web UI, designed for large-scale deployments, Workspace-based

collaboration. Content management features like extensible metadata,

versioning, and content-based searching etc. OLTP based standalone 157

Tera Bytes sized production oracle 9i database on solaris platform to

support application 'OCS-Files Online' configured using 9 Middletiers.

OLTP based 4 node RAC Oracle 10g 160 Tera Bytes sized production DB on

linux platform to support application 'Enterprise Content Management'

configured using 15 Middletiers

Responsibilities:

> 24x7 production DBA support for 4 node RAC Oracle 10g database on

Linux environment and standalone Oracle 9i on Sun Solaris

environment

> Planning, Installation, Configuration of Oracle 10g - 4 node RAC

on Linux for production

> Monitor storage Management like tablespace free space, Extent

Management, Manual Rollback Segment monitoring (for 4 databases)

> Validate RMAN backups, Catalog RESYNC, crosscheck backups, delete

expire backups.

> Performed RMAN disaster recovery.

> Regular deletion of unwanted backup pieces and sets and up-to-date

the recovery catalog

> Implementation of Basic Replication through Read-Only Snapshots

(Materialized View) using force option, scheduling for fast

refresh according to transaction load.

> Analyze and monitor lock problem, latch wait event,

logical/physical read count, sequential read/scattered read count,

total response time for SQL, Pl/SQL Performance Tuning

> Reorganization of Database and database objects on periodic basis.

> Proactive Monitoring And Planning For Space Related Problems And

Requirements In The Production Database.

> Maintenance of physical Standby Database (DATA GUARD) server, To

Ensure High Availability of the Database.

> Implementation of Offline (Cold) Backup.

> Exports (Logical Backups) Of Database

> Design a Backup And Recovery Strategy Based On User-Managed

Backups

> Reorganization of the Database Using The Exports Generated.

> Created 9i DBs on Linux using DBCA and also manually.

> Refreshed DBs from One Box to Another.

> Created DB Link between two dbs.

> Creating and Dropping temporary table space Groups.

> Tablespace Management, Undo Management, Managing Users, Resources,

Managing User Privileges and Roles

> Scan and Repair, compact of BO domains (weekly)

> Review of DBA tables

> Automated ADDM report generation using shell scripting

Environment - Oracle 9i and 10g, SQL, PL/SQL, Oracle Application Server

(iAS) 9i/10g, Sun Solaris, Linux, TOAD, Enterprise Manager Grid Control

10g, Oracle Real Application Cluster

Center for Railways Information Systems (CRIS), New Delhi, India

Nov 2002 - Jul 2004

Oracle Database Administrator

CENTRE FOR RAILWAY INFORMATION SYSTEMS (CRIS) an umbrella organisation

for all computer activities on Indian Railways (IR). It is entrusted

with the task of design, development and implementation of the FOIS and

PRS projects. FOIS enables management and control of freight movement,

optimisation of asset utilisation, and generation of freight invoices

("Railway Receipts"). A countrywide online passenger reservation and

ticketing system, developed and maintained by CRIS, is a complex online

distributed client server application developed in C and Fortran

programming languages on Digital OpenVMS operating system using RTR

(Reliable Transaction Router) as middleware. It consists of Oracle RAC

9i databases on HP Tru64 unix operating system.

Oracle standalone 8i & 9i databases on Linux, Solaris and Windows

operating systems with total of 64 oracle databases to manage inclusive

testing, development and production environment. Oracle 9i Real

Application Cluster (RAC) - 2 node cluster in production environment on

HP Tru64 OS.

Responsibilities:

> 24x7 DBA support for Oracle 9i RAC in OLTP based production

environments

> Refreshed Dev/Alpha/Beta DBs from Prod Box for application

release.

> Performance and Tuning using Tkprof, explain plan.

> Implemented Materialized View for time taking queries.

> Implemented new Function base indexes for Performance issue.

> Backup: RMAN Backup and Recovery, Cold Backup and Logical

Backups (weekly).

> Configuration of Oracle RMAN Repository and Testing the Backup and

Recovery Operations Using Oracle RMAN Utility.

> Regular checkups of RMAN backups using list, report and

crosscheck and validate commands.

> Regular deletion of unwanted backup pieces and sets and up-to-

date the recovery catalog

> Implementation Of Basic Replication Through Read-Only Snapshots

(Materialized View).

> Performance and Tuning using Stats pack, Tkprof, Explain Plan.

> Reorganization of Database Objects

> Proactive Monitoring And Planning For Space Related Problems And

Requirements In The Production Database.

> Maintenance of Standby Database Server, To Ensure High

Availability of the Database.

> Implementation of Offline (Cold) Backup.

> Incremental Exports (Logical Backups) Of Database

> Design Of A Backup And Recovery Strategy Based On User-Managed

Backups

> Reorganization Of The Database Using The Exports Generated.

> Created 9i, 8i DBs on HP-UX using DBCA and also manually.

> Refreshed DBs from One Box to Another.

> Creating and Dropping temporary table space Groups.

> Tablespace Management, Undo Management, Managing Users,

Resources, Managing User Privileges and Roles

> Implemented Auditing the Database.

Environment - Oracle 8i, 9i SQL, PL/SQL, Pro C, Sun Solaris, UNIX,

Windows, TOAD.

Dehradun Institute of Technology, Dehradun, India

Sep 2002 - Nov 2002

Responsibilities

Worked as full-time lecturer in an Engineering college under computer

science and engineering department for teaching 4.0 yr. engineering

degree pursuing students in the following courses

1. Java programming

2. Computer Architecture

3. Analysis and Design of Algorithm

Contact this candidate