Umesh Khatavkar

Sr. Oracle Architect/DBA

St. Louis, MO

ablvp2@r.postjobfree.com

BACKGROUND SUMMARY

Over 16 years of experience working as an Oracle specialist held different

titles like Data Center main Oracle DBA, Sr. Data Warehouse Architect/DBA,

Sr. DBA, DBA supervisor, Sr. Software Engineer, Database Developer/DBA,

Data Architect, Sr. Engineering Specialist and Oracle Developer (front-end

and back-end) in the Client/Server environment. Extensive experience while

working with various types of industries like, Pharmaceutical, Banking,

Utility, Finance, Manufacturing, Steel Industries, Universities

(educational) and US Government Offices (USDA). Very strong in Architect,

Administer, Design, Develop and Maintain databases on various platforms and

database applications as well as managing and supporting off shore

projects. Powered knowledge with ORACLE 11g, 10g, 9i, 8i, 8.x, 7.x, DBA,

Developer Suite (Forms, Reports and Designer), Stored Procedures, Triggers,

PL/SQL Programming, Database Programming, Oracle Apps 11i (customization of

forms and reports application). Also deploy J2EE applications using Oracle

Application Server Administration Console along with Web archive (WAR), an

EJB Java archive (JAR) or an application client JAR file sets.

HARDWARE/SOFTWARE EXPERIENCE

Operating Systems UNIX/Tru64 (HP, Sun Solaris, SCO), Linux, WINDOWS/2000/2003, XP,

VAX/VMS, IBM-AIX, DOS, LAN, WINDOWS 98, NT 4.0

Databases ORACLE 11g, 10g, 9i, 8i, 8.x, 7.x, Oracle Internet Developer

Suite (Forms 10g, 9i, 6i, 5, Reports 10g, 9i, 6i, 5), Oracle

Designer (10g/9i/2.1), ORACLE Apps/ financials 11.5.10, Oracle

Discoverer, Data Base Cloning, RAC, Data Guard, and Streams (in

the process), DB2, IBM AS/400, MS SQL Server

Languages Java, C, C++, SQL, PL/SQL, Advanced SQL etc.

Software / Tools TOAD, Erwin, Version control tools - Visual SourceSafe,

IBM-Rational Case tool, Autosys for Cron job scheduling, MS

Project for Project Management, PowerCenter.

Data Storage NAS, SAN, Vmware for all Oracle and SQL Server Databases

Database Migrations Oracle: 8i to 9i, 9ik to 10g, 10g to 11g

SQL Server: SQL Server 2005 to Oracle 10g and 11g

Forms and Reports Forms: 3 to 4.5, 4.5 to 5, 5 to 6i, 6i to 9i and 9i to 10g

Migrations Reports: 2.5 to 3, 3 to 6i, 6i to 10g

Oracle Apps 11i.x Customization of Forms and Reports.

SAS Conversion SAS Programs conversion to Oracle using SQL and PL/SQL

Data Warehouse Using 9,10g and 11g sizes in Terabytes between 2.5, 3.5, 7.5 and

12.7

As a DBA 10 Years (Data Warehouse + OLTP)

ETL Architect 7 Years

Physical + Logical DB 9 Years

Design

Shell Scripting 5 Years along with DBA work

Project Mgmt. 5 Years using MS Project, Excel etc.

Data Modeling 10 Years - complete life cycle in OLTP and Data Ware House

Environment

RAC Configurations

Sr. DB Gri RAC ASM Operating System Hardware Platform # Mem. Stora

No. Names d CPUs GB ge

1 DWPRD1 Yes Y Y SunOS 5.10 Sun Blade T6300 16 32 SAN

Generic_138888-05 Server Module

(64-bit)

2 DWPRD2 Yes Y Y SunOS 5.10 Sun Blade T6300 16 32 SAN

Generic_138888-05 Server Module

(64-bit)

3 PROVPR Yes Y Y SunOS 5.10 Sun Blade T6300 32 32 SAN

D1 Generic_138888-05 Server Module

(64-bit)

4 PROVPR Yes Y Y SunOS 5.10 Sun Blade T6300 32 32 SAN

D2 Generic_138888-05 Server Module

(64-bit)

5 NSMPRD Yes Y Y SunOS 5.10 Sun Blade T6300 12 32 SAN

1 Generic_138888-05 Server Module

(64-bit)

6 NSMPRD Yes Y Y SunOS 5.10 Sun Blade T6300 12 32 SAN

2 Generic_138888-05 Server Module

(64-bit)

7 PROVTS Yes Y Y SunOS 5.10 Sun Blade T6300 32 32 SAN

T1 Generic_138888-05 Server Module

(64-bit)

8 PROVTS Yes Y Y SunOS 5.10 Sun Blade T6300 32 32 SAN

T2 Generic_138888-05 Server Module

(64-bit)

9 UTLPRO Yes Y Y MS Windows 2003 SP2 (64 6 Disk Array (120 2 8 NAS

D1 Bit) GB)

10 UTLPRO Yes Y Y MS Windows 2003 SP2 (64 6 Disk Array (120 2 8 NAS

D2 Bit) GB)

11 UNTRNP Yes Y Y HP UNIX - Itanium 8 64 NAS

1 (22/23)

12 UNTRNP Yes Y Y HP UNIX - Itanium 8 64 NAS

2 (22/23)

13 DCSIPR Yes Y Y Oracle - Linux 8 16 SAN

D1

14 DCSIPR Yes Y Y Oracle - Linux 8 16 SAN

D2

15 DHCPPR Yes Y Y SunOS 5.10 Sun Blade T6300 32 32 SAN

D1 Generic_138888-05 Server Module

(64-bit)

16 DHCPPR Yes Y Y SunOS 5.10 Sun Blade T6300 32 32 SAN

D2 Generic_138888-05 Server Module

(64-bit)

* Cluster Services: 11g R1 with Oracle DB's - 9i, 10, 11g

profesional Training and CERTIFICATIONS

> PowerCenter (Level - one) Training

> SQL Server DBA Training for experienced Oracle DBA training by Microsoft.

> ISO 9001:2000 Training

> Oracle DBA, Backup and Recovery, Security Training.

> Brain Bench Certification in Oracle PL/SQL Programming with distinction

(87%)

professional EDUCATION

> Master's Degree in Computer Management, Poona University, India 1993

> Bachelors of Commerce In Advanced Accounting and Auditing, Poona

University, India 1990

Highlights

. Self-Starter with a "Can-Do" attitude

. Process Oriented

. Ability to multi-task

. Work in a demanding-fast paced environment

professional EXPERIENCE SUMMARY

Monsanto - on contract Oct, 2009-July 2010

Data Center - Sr. Oracle DBA/Architect

Servers Instances ASM Data Guard OS

189 256 Yes Yes HP-UNIX, AIX,

UNIX-SOLARIS, LINUX,

WINDOWS

Data Base 11g 10g 9i 8i

Ver.

No. of DB 31 172 20 23

RAC In Process In Process In Process NA

Duties and Responsibilities involve:

. Install, upgrade and maintenance of Oracle Databases.

. Install and configure ASM instances for RAC in 10g and 11g.

. Provide database services and consulting to the design and

implementation teams utilizing Oracle Database technology.

. Analyze, develop and maintain data architectures and process models

within the Database support team.

. Database performance, monitoring and tuning.

. Oracle database backup and recovery administration.

. Evaluation and design of interfaces between Oracle Databases and

external systems.

. Migration of database application programs, changes, and objects into

production.

. Cutover implementation support.

. Database configuration administration.

. Provide emergency support 7 days x 24 hours for Oracle Databases.

Mediacom - Temp May 4, 2009-Sep 23, 2009

Data Center - Sr. Oracle DBA/Architect

Duties and Responsibilities involve:

. Develop and maintain logical and physical data models for the

databases using data modeling tools.

. Promote changes from Development to Test and then Production

environment using Change Control Management.

. Work with technical architects to ensure data model meets the

platform's requirements for the business and technical perspective.

. Define business object/database table mappings and structures, fail-

over strategies and distributed data strategies.

. Ensure database objects (views, stored procedures, triggers,

constraints, defaults, etc.) or SQL statements meet performance and

security objectives.

. Ensure database migration scripts and programs meet data integrity,

performance and security objectives.

. Maintain and publish the data dictionary and database

installation/operation guide.

. Install and maintain Oracle databases on Sun UNIX and Tru64;

maximizing availability, reliability, and performance, and minimizing

issues.

. Develop, review and enforce database standards (data objects

standardization, data access/retrieval standards, etc.).

. Use various techniques for Database performance monitoring such as OEM

Grid Control, AWR, ADDM, ASH, StatsPack, TKPRoff, explain plan etc.

. Design, Develop and maintain Procedures, Packages, Functions and

Database Triggers in Oracle 9i, 10g and 11g Databases on various

platforms

. Create and maintain Oracle databases using Database Configuration and

Upgrade assistant.

. All aspects of database administration including installation,

configuration, upgrades, patching, migration, capacity planning,

performance tuning, backup and recovery.

. Evaluate patch releases from Oracle

. Change management including maintenance of multiple development, test,

QA, and production environments.

. Evaluate and Recommend Hardware and Software platform for RAC and non-

rac databases according to business requirements

. Analyze the current situation of problems, investigate the permanent

solution instead of temporary fix

. Implement solutions in Development, Test and then Production

environment as per company rules and regulations

. 24x7 rotational on-call support, including driving Root Cause Analysis

(RCA)

. Implementation and support of high availability architecture (RAC,

Data Guard etc.)

. Work with their vendors to apply and maintain application and database

upgrades

. Work with development project teams to design and implement database

solutions

. Maintain, design and implement new interfaces between Oracle Databases

and other systems like Customer Order DB in AS400 (legacy systems),

Remedy Ticket information designed in SQL Server 2005 DB etc.

. Assisting developers in writing PL/SQL code, triggers, procedures,

packages, functions etc.

. Work with Application Configuration Management team to migrate or

upgrade applications

. Participate in project design and Oracle database design decisions

. Support of the nightly ETL processing.

. Create and maintain Database implementation standards and procedures

documents

. Understand the current situation, prepare a case study, and

participate in problem or impact analysis when suggest or apply new

solutions in all environments like Development, test and Production

environment

. Develop and implement Database security policies and procedures

. Work with Cognos Developers for improving query performance

. Define process and standards for routine database maintenance (data

files, partitioning, indexing, data life cycle scripts and utilities)

. Co-ordinate my development plan, guidelines and procedures with POC

(Proof Of Concepts) to my team members

. Review developer designed jobs targeted for production databases

. Work as a Developers Team Lead by sharing my application design,

development and deployment knowledge among developers teams

. Assists in the development of repairs for inconsistent/incorrect data

. Develop and maintain documentation, including schema versioning,

change plans, and diagrams

. Participate in the analysis, conceptual design and in determining the

technical direction for the implementation of new projects

. Responsible for integrity of technical work on significant projects.

. Provide end-to-end DB integration with associated application support

and architecture level support for complex application enterprise

service infrastructure

. Identifying requirements, interpret design, and implement solution

related with Oracle Databases

. Understand Application infrastructure lifecycle and detailed

configuration management

. Involve in Custom off the Shelf (COTS) software integration with their

vendors on best practice implementation of application software

. Working with Senior Server Infrastructure team for Database

maintenance

Environment: Oracle 11g R1, 10g R2, 9i R2 Databases, Oracle 10g R2

Application Server, SAN, NAS, Sun Blade Servers with Sun OS, MS Project,

TRU64, Linux - Red Hat 5, Windows/2003, Blade Logic Server monitoring tool

KV PHARMACEUTICALS Feb 20, 2007-FeB 5, 2009

Data Center Main Oracle DBA

Duties and Responsibilities involved:

. Maintain 47 Oracle databases 8i, 9i, 10g and 11g on various OS

platforms - HP UNIX/TRU64, Linux and Windows to support their various

applications like CARS, GOV. PRICING, MEDICAID, LABORATORY INFORMATION

MGMT. SYSTEM, LEARNING MANAGEMENT SYSTEM, SIEBEL, and EVIGILENCE etc.

. Maintain 99.99% availability for all mission critical databases in

Production and Test environment including Siebel (7.7) CRM DB.

. 100% Disaster Recovery implemented using RMAN backups.

. Create and maintain Oracle databases using Database Configuration and

Upgrade assistant.

. Clone production databases for Test and Dev environment using Cloning

method.

. Applied various db backup types like RMAN, export/import, cold and hot

backups.

. Involve in physical database design using 11g (Data Warehouse and Data

Mart), Backup and Restore, Archive and Purge data in accordance with

company standards or practices using Informatica and other ETL tools.

. Create new interfaces with other applications to improve and implement

process, procedures and automation.

. Administer, maintain, develop, and implement policies and procedures

for ensuring the security and integrity of company databases.

. Troubleshoot and resolve issues related to database performance (by

providing additional indexes, monitoring slow running queries using

Stats Pack and AWR Report), accessibility, functionality and data

integrity.

. Analyze, develop and maintain data architectures and process models

within the Database support team.

. Evaluation and design of interfaces between Oracle Databases and

external systems

. Manage and complete Database upgrade projects for small to medium

group of team members.

. Review, plan, and evaluate database systems.

. Troubleshoot database systems and recommend improvements.

. Migration of database and application programs, changes, and objects

into production after testing in Test environment.

. Provide tactical and strategic input on overall database planning and

related projects.

. Coordinate with vendors for product acquisition and service support.

. Manage assigned projects, investigate alternative, evaluate vendors,

test products, and recommend solutions.

. Install DBMS, upgrade and apply patches in test environment and work

with System Administrators to update production environment.

. Perform and verify database backups and recovery.

. Administer and monitor servers and application configurations to

ensure system integrity.

. Work closely with technical and client management to design and

implement of Oracle databases, to support complex business application

development.

. Participate in the validation/qualification of new or modified

infrastructure to ensure compliance with Company standards.

. Consider the impact of new software/hardware installations on existing

systems.

. Create and follow test plans.

. Lead and direct the work of others as a project leader.

. Follow other related duties as assigned to meet departmental and

Company objectives.

. Install Oracle 11g, 10g, 9i Databases and 10g R2 Application Server.

. Provide support in new OC4J instance creation and manage existing

instances.

. Design and maintain documents as per SOX requirements.

. Heavily involve in Database and Application Auditing process, work

with internal as well as external Auditors.

. Use Data Guard to create physical and logical databases.

. Fine tune and troubleshoot Oracle Application Server.

. Heavily involve in Data Management and Data Modeling in support of

multiple and diverse projects, construct and maintain complex data

models and identify opportunities for reuse of data across the

enterprise.

Environment: Oracle 11g R1, 10g R2, 9i R2 and 8i (8.1.7) Database, Oracle

10g R2 Application Server, SAN, NAS, MS SQL Server, MS Project, Siebel 7.7,

Siebel Analytics, Business Objects, Information Builder, Informatica - 8.x

PowerCenter, IBM/AS 400, HP-UNIX/TRU64, Linux, Windows/2000 and 2003.

UNITRIN AUG 21, 2006-Feb 16, 2007

Sr. Oracle Architect-DBA (Financial, Claim and 8 Home grown Applications)

Duties and Responsibilities involved:

. Maintain 99.99% availability for all Production and Test Databases.

. Administration, tuning, and migration of Oracle Databases including

changes, security, performance analysis (using explain plan, OEM,

Stats Pack), and capacity planning.

. Create and maintain Oracle Databases, table spaces, indexes and other

objects.

. Monitor and tune database sub-systems to ensure optimum performance

(using Grid Control).

. Define content and structure of database dictionaries and integration

of systems through database design.

. Interact with systems development groups; concerning the impact of

application changes will have on the database.

. Adhere to and enforces database standards and procedures.

. Provide technical guidance to development personnel in the

investigation, analysis, and resolution of database problems.

. Maintain database in AIX and windows environment.

. Work as a leader between company developers, users, software and

hardware vendors, and Data center people to solve the database

problems.

. Work as an Oracle Database Security Administrator.

. Creativity and initiative in problem solving.

. Assist and train less experienced developers.

. Manage 5 developers and 1 Jr. level DBA in the team.

. Perform troubleshooting, maintenance, installation and security

administration of several Oracle Databases.

. Perform routine preventive maintenance on supported systems.

. Develop and maintain new skills to accomplish assigned tasks and

responsibilities.

. Perform miscellaneous job related duties as assigned.

. Maintain documentation on hardware and software for supported systems.

. Provide systems expertise to team members.

. Travel within branch sites to perform any of the above duties.

. Design, implement and maintain production databases and data

dictionaries in compliance with application specifications and company

policies, standards and procedures.

. Process customer request to create new and modifying existing

databases and database objects.

. Setup Oracle Database servers, install and configure third party

software.

. Install and configure Designer on the database server for Data

Modeling.

. Assist developers with the creation of stored procedures, scripts, and

utilities as necessary.

. Also assist them in fine-tuning and efficient query writing

methodology using explains plan utility to meet the performance

requirements (using OEM).

. Create new, review, recommend, test and implement existing physical

data model changes.

. Support production and development of Oracle Database infrastructure.

. Work with Oracle Technology groups to share and get different kinds of

software implementation methodology to bring latest knowledge to the

organization.

. Use Data Guard to create physical and logical databases.

. Manage and force version control methodology within the team and

organization.

. Manage 6 different applications on 4 production databases on

UNIX/TRU64 as well as Windows platform.

. Work with Mainframe groups and IBM AS/400 groups to arrange and manage

schedule jobs.

. Provide assistance between Oracle and Oracle 11i (Apps) databases in

terms of transferring data between the systems.

. Manage and deploy third party software's on the database servers.

. Provide leadership in the implementation of Client-Server technology

using Oracle Forms, Reports, Application Server, and Automation of job

scheduling processes as well as provide support as a Data Modeler for

Java/J2EE Application development.

. Evaluate and recommend software products, which are economically

affordable, best fit for business needs as well as supports new

technology implementation.

. Work as a Jr. Security Officer.

This is for Grid Control R2 Implementation:

. DB availability using home page of Grid Control

. Application Server Performance monitoring

. Performance monitoring for Web based Applications like, Java/J2EE,

Forms and Reports

. Manage groups for instances those have some problems like Disk

space full, TS full etc.

. Patch updates on the server

. Monitor Db performance centrally

. Schedule Db maintenance tasks like: backup, export and import to

and from files etc, load data from files etc.

. Automating maintenance task using Jobs

Work for RAC and High Availability:

. Determine the Oracle10g RAC architecture

. Configure the raw disks for Oracle RAC on Windows/2000, 2003 and LINUX

platform.

. Install Oracle10g RAC software on Windows/2000, 2003 and LINUX

platform.

. Performance tuning for Oracle Real Application Clusters (RAC) (using

SQL Tuning Advisor)

. Provide Oracle RAC clustering solutions for Oracle 10g R2 databases

. Perform server/application audits and health checks

. Administer database, application server and application environments

. Tune the database, application to ensure optimum use of resources

. Ensure the database architecture is able to meet the clients ongoing

needs

. Architecting solutions to meet clients performance and HA requirements

(using RMAN Backup and Data Guard)

Environment: Oracle 10gR2 High Availability, High Performance solutions -

RAC, GRID, Streams, Data Guard, ASM, TOAD, IBM AIX UNIX/TRU64,

Windows/2003, PL/SQL, MS SQL Server, MS Project, Developer Suite (10g Forms

and Reports), MS Visio, Designer and Erwin for Data Modeling Tool, PL/SQL

Developer, Oracle Partitioning, IBM AS/400.

US Bank, St. Louis, MO (on Contract basis) Nov 2005 - AUG 18, 2006

Sr. Oracle Architect-DBA (Data Warehouse)

Duties and Responsibilities involved:

. Lead the efforts to formulate and define scope and objectives based on

user needs related to a large complex data warehouse that supports

enterprise wide compliance and business initiatives.

. Work with internal business groups to collect and define requirements;

translate these into Detailed Business Requirements and Functional

Design documents.

. Develop Erwin Data Models for a dimensional enterprise data warehouse

to set up various distributed databases.

. Create Data Mapping documents for source to target objects within the

warehouse.

. Work closely with development team to implement technical design.

. Involve in test planning, participate in various stages of testing to

include writing of test cases, unit testing and integrated testing.

. Relate business-reporting need as it relates to the data.

. Implement System Development Life Cycle to include both iterative and

waterfall approaches.

. Support existing processes for loading Oracle data warehouses and data

marts using SQL loader scripts, scheduled by AutoSys.

. Work with analysts and developers to design and develop ETL processes.

. Evaluate ETL processes to improve performance to meet or exceed

service levels (using in-depth analysis of index usage, provide

additional indexes as and when require).

. Manage growth of databases and provide estimates for new projects.

. Develop, mentor and train less experience staff.

. Maintain 99.99% availability for all Production and Test Databases.

. Assist developers with the creation of stored procedures, scripts, and

utilities as necessary.

. Assist in application development with analysis and query/access

design recommendations to support application performance

requirements, and recommendation for query/access modifications to

enhance application performance (using common program units converted

into PL/SQL procedures for multi task).

. Made specific changes in a system or in own work methods to improve

performance (includes something better, faster, at lower cost, more

efficiently, improves quality, customer satisfaction etc.), with a

setting of specific goals (by suggesting additional memory on box, by

applying different types of partition methods as per business data

requirement).

. Design and develop PL/SQL Programs using Dynamic SQL to improve

automation process occurring within a one to three-months period of

time frame.

. Deploy 10g top-notch technology to improve the database performance

(using SQL Tuning Advisor, SQL Profiles).

. Made complex ideas or situation clear, simple, and understandable to

all level of users.

. Created template for PL/SQL procedure development, where user or

developer can add or pass only table name(s), column name(s), join

condition(s) and deploy that code as a procedure in the database and

run it for faster processing.

. Assess and linked short-term, day-to-day, weekly and monthly jobs or

tasks in the context of long-term business strategies or a long-term

perspective; considers whether short-term goals will meet long-term

objectives.

. Use Data Guard to create physical and logical databases.

. Review own actions against the organizations strategic plan; considers

the big picture when considering possible opportunities or projects or

think about long-term applications of current activities.

. Create and maintain Oracle Database Objects including tables, indexes,

views, schemas, and user privileges.

. Create and maintain Oracle SQL Loader scripts.

. Schedule and control Systems for Oracle processes.

. Create Unix/Tru64 Shell scripts.

. Maintain and improve existing Oracle database and processes.

. Balance and validate reports created to original source data.

. Develop new databases and automated processes to meet new reporting

requirements.

. Develop tools and solutions to improve overall financial visibility.

. Determine business requirements including logical and physical design

for relational and data warehouse environment.

. Convert SAS programs in to the Oracle Data Base Tables and PL/SQL

Procedures.

. Use Secure Mail File Server, FTP method and UTIL_File method to

implement EDI.

Environment: Oracle 9i, 10g (Database and Application Server), TOAD, HP-

UNIX/TRU64, Windows/2003, PL/SQL, Oracle Portal, OLAP, Data Warehouse

Builder, Discoverer, MS Visio, Appworks, SecureFX.

Distribution Control Systems Inc. St. Louis, MO Oct. 2001 - Oct. 2005

Sr. Oracle Architect-DBA (Data Warehouse)

Sr. Engineering Specialist (Sr. Oracle Developer/DBA)

Duties and Responsibilities involved:

. Design, develop, upgrade and implement new & existing forms (5, 6i,

9i, and 10g).

. Perform Requirement analysis, System analysis & Design; Project co-

ordination, Testing and implementation, Integration with third party

software, User training, and Documentation.

. Implement data models and database designs, data access security,

Backup/Recovery strategy plans.

. Upgrade Databases from 7.3.4 to Oracle 8i (8.1.7), Oracle 9i (9.2) and

Oracle 10g (R1).

. Install & configure Oracle9i and 10g Designer using Software

Configuration Management.

. Heavily involve in Data Collection, Validation, ETL, Processing and

Loading into the Staging Tables using SQL*Loader (using .CSV, .txt

files). Design and develop procedures to load data from Staging Tables

into Production in different environment such as Windows, UNIX/Tru64

(HP) and Linux. Provide assistance in application tuning (.XML files -

SQL Part).

. Oracle Discoverer management and administration.

. Design and develop system interfaces with customers Billing Company

Software.

. Set-up test, integration and production environment using Oracle 9i

(R2) and Oracle 10g.

. Back up the Databases using Export and Import utility.

. Reverse Engineer application using ERWin Tool as well as Designer

(2.1, 6i, 9i, and 10g).

. Deploy existing application on Web using Developer 9i and 10g

Application Server.

. Maintain, develop and implement test as well as production databases.

. Work on Oracle Financials 11i, to customize forms and reports of the

following modules: Purchase

Order, Sales Order, Account Receivable, Account Payable, Invoice,

and Inventory.

. Use Mail File Server, FTP method, Corn Job on UNIX/TRU64 and Job

Scheduler on Windows/2000 Server, and UTIL_File method to implement

EDI.

. Support customer-oriented Oracle Databases for a high-volume, complex,

distributed, 24x7 commercial system software application hosted on a

J2EE, Oracle 10g on UNIX/TRU64 platform.

. Use lead Oracle DBA skill to support (Account Maintenance) team, which

support customers of our software after implementation.

. Provide Level 2 or 3 Oracle DBA support for issues escalate from

customer site or Level 1 Call Center.

. Provide 24x7 on call support and problem resolution as necessary.

. Provide DBA support which include: perform database capacity planning,

create, administer and maintain databases, install and patch server

software, upgrade and downgrade databases, implement disaster recovery

strategies, perform database backup and recovery, cloning, perform

application and performance monitoring and tuning (by converting major

codes in PL/SQL procedures in Client-Server Environment), identify and

resolve any database bottlenecks proactively, respond to raised

problems quickly.

. Monitor database log files, data block corruption, segment

fragmentation, performance issues, security threats, and contention

issues (deadlocks, I/O, memory, CPU, etc.) (using Session Browser

Monitor - Provided by TOAD application).

. Recover databases as necessary.

. Manage and maintain high volume transactional tables and indexes.

. Use Data Guard to create physical and logical databases.

. Reorganize Databases as per customer's request.

. Monitor and maintain Oracle replication and queues.

. Adhere to database management standards and guidelines.

. Automate daily database operations via UNIX/TRU64 shell scripting.

. Escalate any issues in a timely manner and provide mitigation

recommendations to Data Team Lead and Project Director.

This is for Grid Control R1 Implementation:

. DB availability using home page of Grid Control

. Application Server Performance monitoring

. Performance monitoring for Web based Applications like, Java/J2EE,

Forms and Reports

. Manage groups for instances those have some problems like Disk

space full, TS full etc.

. Patch updates on the server

. Monitor Db performance centrally

. Schedule Db maintenance tasks like: backup, export and import to

and from files etc, load data from files etc.

. Automating maintenance task using Jobs

This is for Data Warehousing Project Implementation for DCSI:

. Analyze the customer's requirement like: Transactional History Data

should be loaded into the Data Warehouse.

. Involve in reports specification and design.

. Calculate the resource load and space requirements to store the

data.

. Suggest hardware and software configuration to the customer for

Data Warehouse implementation.

. Install Oracle Data Warehouse database and setup environment to

accept data from the Production System.

. Transfer data from Production to Data Warehouse Database, resides

on different server than the Production and Testing environment.

. Use various kind of tools to extract data (comma delimited, tab

delimited) from Production like SQL*Loader, plain SQL scripts or

some times export command.

. Implement ETL (Extract, Transformation and Loading) process using

batch process.

. Keep the Data Model for this using ERWin as simple as I can. So

that it can grow easily as well as allowing for good performance.

To do this, I was involved in the following:

- Heavily involve with the users to gather their requirement to

do logical model design, and then translated into the

physical data model.

- Define the table structure and decide either it is slow

moving or fast moving data.

- As per gathered information, decided how many tablespace(s)

required.

- Designed and developed reports as an output for the Data

Warehouse.

For RAC and High Availability:

. Determine the Oracle10g R1 RAC architecture

. Configure the raw disks for Oracle RAC on Windows/2000, 2003 and LINUX

platform.

. Install Oracle10g RAC software on Windows/2000, 2003 and LINUX

platform.

. Performance tuning for Oracle Real Application Clusters (RAC) (using

SQL Tuning Advisor)

. Provide Oracle RAC clustering solutions for Oracle 10g

. Perform server/application audits and health checks

. Administer database, application server and application environments

. Tune the database, application to ensure optimum use of resources

. Ensure the database architecture is able to meet the clients ongoing

needs

. Architecting solutions to meet clients performance and HA requirements

(using RMAN backup method)

Environment: Oracle 7.3.4, 8i, 9i, 10g (Database and Application Server),

10g RAC, OID/LDAP, TOAD, Grid Control R1, Windows/2000, HP-UNIX/TRU64,

PL/SQL, Oracle Forms and Reports (5, 6i, 9i, 10g), ERWin, MS Visio, Clear

Quest, Clear Case, VSS.

Mascot Systems, Pittsburgh, PA June, 1998 - Oct, 2001

Sr. Software Engineer-Project Leader

As a Senior Software Engineer, completed various projects were using Oracle

front-end (Forms 4.5, Reports 2.5), Designer/2000 (2.1), Oracle Application

11.0, Client/server implementation and extensive PL/SQL programming

(Database procedures, packages, functions & triggers) for:

> GE Capital Commercial Finance, Stamford, Connecticut.

> Cummins Engine, Columbus, Indiana.

> Wheeling-Pittsburgh Steel Corporation, Wheeling, West Virginia.

> University of Wisconsin, Madison, Wisconsin.

> United States Forest Service (USDA), Arlington, Virginia.

Duties and Responsibilities involved:

. Work on Oracle Financials 11i, to customize forms and reports of the

following modules: Purchase Order, Sales Order, Account Receivable,

Account Payable, Invoice, Inventory

. Design and built relational databases. Develops strategies for data

acquisitions, archive recovery, and implementation of a database.

Cleans and maintains the database by removing and deleting old data.

. Generate file deletion utility using Oracle8i-Java Procedures for

Windows/2000 platform.

. Maintain the existing system, and make sure system runs smoothly with

the help of strong Exception handling, in front-end as well as back-

end applications.

. Customize forms as per customer's requirement. Design, develop and

implement new forms.

. Upgrade application from (forms 5.0, reports 3.0) to Developer6i

(forms 6i, reports 6i).

. Convert Business requirements into database, design and develop

application using Forms, Reports and PL/SQL.

Oracle Financials:

Wheeling Pittsburgh Steel Corporation: Work on: Purchase Order, Sales

Order, Account Receivable, Account Payable, Invoice, and Inventory.

. Requirement analysis

. Customization of Forms and Reports as per user's requirement

. Deploy those forms with 11i

. Create ETL process to upload data from Legacy system to 11i database.

. Use Mail File Server, FTP method, Corn Job on UNIX/TRU64 and Job

Scheduler on Windows/2000 Server, and UTIL_File method to implement

EDI.

Cummins Engine: Work on PO - Purchasing and Planning, Order Management and

WMS-Warehouse Management.

. Requirement analysis

. Customization of Forms and Reports as per user's requirement

. Deploy those forms with 11i

. Create ETL process to upload data from their Oracle 9i 8i Database 11i

database.

. Use Mail File Server, FTP method, Corn Job and AUTOSYS on UNIX/TRU64

and Job Scheduler on Windows/2000 Server, and UTIL_File method to

implement EDI.

About the company:

A global power leader, a corporation of complementary business units that

design, manufacture, distribute and service engines and related

technologies, including fuel systems, controls, air handling, filtration,

emission solutions and electrical power generation systems.

GE Capital: 11i DB, 8i database, Siebel CRM tool.

. ETL Processes create to meet the requirements of their customers

(mainly banking and money lending businesses).

. Using procedures, process 8i and Siebel data and passed that data to

the Customer and Supplier chain.

. Work on "WMS-Warehouse Management" module for their Energy and

Electrical plant. Worked as a 100% functional and 100% Development

side to deploy their application into the Oracle Apps.

. Requirement analysis

. Customization of Forms and Reports as per user's requirement

. Deploy those forms with 11i

. Create ETL process to upload data from 8ik Database and Siebel CRM to

11i database.

. Use Mail File Server, FTP method, Corn Job on UNIX/TRU64 and Job

Scheduler on Windows/2000 Server, and UTIL_File method to implement

EDI.

Environment: Oracle, 8i, 8.1.7, Oracle Financial 11i, PL/SQL, Oracle Forms

4.5 to 6i, Reports 2.5 - 6i, Designer 2.1 to 6i, Erwin, IBM-AIX, Windows

2000, UNIX/TRU64, TUXIDO, Siebel.

Grindwell Norton Ltd, India Mar. 1997 - Nov. 1997

As a Project Leader, Sr. Programmer Analyst, involved in project lead of

five team members, designed, developed and provided maintenance of Capital

Appropriate Request system using Oracle front-end (Forms 4.5x, Reports

2.5x), Designer/2000 (2.1), Oracle 7.2, Client/server implementation and

extensive PL/SQL programming (Database procedures, packages, functions &

triggers).

Duties and Responsibilities involved:

. Estimate project time, resources.

. Provide assistance to team members in all the levels.

. As a team lead, gather all requirements from co-workers and related

department leads.

. Analyze and validate collected data to create test cases.

. As a Sr. Programmer Analyst, Design, develop and build relational

databases.

. Customize, design and develop forms as per user's requirement.

. Sent data to our parent company, "Saint Gobain", located at France via

V-sat link.

Environment: Oracle 7.2, PL/SQL, Forms 4.5, Reports 2.5, Designer/2000

(2.1), VAX VMS, HP-UNIX/Tru64, and IBM AIX.

Groupware INFORMATION SYSTEM, India Feb.1995 - Dec.1996

As a Project Leader, involved in gathering information from various

departments, process collected data, demonstrated users how the new system

will work to help them doing daily activities, submit project estimation in

terms of cost and time with the number of resources, lead of four team

members, designed, developed this system using Oracle front-end (Forms

4.5x, Reports 2.5x), Designer/2000 (2.1), Oracle 7.2, Client/server

implementation and extensive forms and reports design, PL/SQL programming

(Database procedures, packages, functions & triggers).

Duties and Responsibilities involved:

. Requirement analysis, System analysis & Design, Project co-ordination,

Testing and implementation, Integration with third party software,

User training, and Documentation.

. Database Design including, logical and physical (tablespaces, database

files, tables, views, etc.)

. Matrix Diagram, Module Logic Editor to create Packages, Procedures,

Triggers, Cursors, and Functions, Database Design Transformer

(including tables, views, etc.), Application Design Transformer

including (Forms, Reports, Libraries etc.).

. As a Database Administrator, maintains, develops and implements

production database and procedures for ensuring the security and

integrity of the company database.

. Data transfer from one system (Application to Application) to another

system using SQL Queries.

Environment: Oracle 7.2, PL/SQL, Forms 4.5, Reports 2.5, Designer/2000

(2.1), HP-UNIX/Tru64, and IBM AIX.

SUPRABHA COMPUTERS AND ENGINEERS, INDIA 1990 - 1995

As a Senior Programmer-Analyst, involved in design, development,

maintenance and coding of various commercial systems like: Accounting,

Inventory, Bill Of Material (BOM), Purchase and Sales order system, work

with their customers to design and develop applications as per their

requirements using Oracle front-end (Forms 3, Reports 2.x), Oracle Case

Tools, Oracle 5.0, Client/server implementation and extensive forms and

reports design, PL/SQL programming (Database procedures, packages,

functions & triggers).

Duties and Responsibilities involved:

. Requirement analysis, System analysis & Design, Testing and

implementation, Integration with third party software, User training,

and Documentation.

. Work with their Accountants and Auditors to computerize their daily

activities.

. Data transfer from one system (Application to Application) to another

system using SQL Queries.

. Design, develop and implement forms and reports.

Environment: Oracle Release 5.0, Forms 3, Reports 2, Oracle Case Tools, and

HP-UNIX/Tru64.

Contact this candidate