Oracle System

Santosh Hulage

Email: **************@*****.***

Cell: 302-***-****

Professional Summary:

. Senior IT professional with 10+ yrs of experience.

. Oracle Certified DBA with 9 yrs of Database Administration

experience which includes Database System configuration and

implementation, Database Design, Performance Tuning, Backup &

Recovery

. Experienced in managing Data warehousing as well as OLTP database

systems.

. Worked on database support in various operational environment

including ETL, Business Intelligence Reporting, ERP, Web

Application etc.

. Worked on implementing Oracle advanced technologies like Real

Application Cluster (RAC), Automatic Storage Management (ASM), Data

Guard - Physical/Logical standby, partitioning, Database

replication etc. And also actively involved in various projects on

Oracle Database Upgrade / Migration, Data Archiving, Re-engineering

of the existing systems etc.

. Knowledge of various database backup utilities like VERITAS

flashsnap, SQL Backtrack, BCV and Oracle RMAN.

. Knowledge of Storage level replication technologies and utilities

like EMC SnapView/MirrorView, TimeFinder.

. Extensively worked on back-end like Oracle 7.x, 8i, 9i, 10g and

11g.

. Knowledge in writing stored procedures and triggers using PL/Sql.

. Worked on heterogeneous environment involving Oracle, Sybase & SQL

server.

. Worked on Operating Systems like IBM AIX, Sun Solaris, HP UX and

Linux.

. Knowledge and working experience with Agile/scrum Methodology

. Excellent techno-functional, communication, analytical and problem

solving skills and ability to get along well with people including

cross-cultural backgrounds.

. Provided extensive DBA support for Prime Clients like The Hartford

Insurnce, GE Consumer Finance, World Bank, Ford Motors, Kuwait

National Petroleum Co. (KNPC), BSES (Reliance Energy) and presently

at ING Direct.

. Worked on multi-terabytes database systems - GECF-DSS systems

(which include 24TB Consumer Instance, 2.2 TB Collection Instance

etc), The Hartford -7TB Personal lines Insurance & 3.0TB Claims

Datawarehouse, ING Direct 1.5 TB etc

Education & Certifications:

Oracle Certified Professional for Database administration.

Bachelor of Engineering from VJTI, Mumbai University, India

Work Experience:

ING Direct USA (ING Bank, fsb), Wilmington DE.

Feb'07-current

Sr. Oracle DBA

Environment:

Oracle 9i/10g/11g, Oracle RAC, Oracle Clusterware, Oracle ASM, Oracle

RMAN, Physical/Logical Standby,Oracle CDC, OEM grid control, IBM

AIX5, Linux, Windows, EMC SAN,EMC Timefinder/clone, EMC Powerpath,

Foglight, Informatica 6/8/9, Cognos,ReportNet, SAS, Hyperion,

PeopleSoft, Profile MDB, VersionOne, Shareplex, Tidal

Support for Major IT Projects:

. DS Upgrade involved migration of legacy Oracle Datawarehouse database

system from Windows to Unix and also upgrade from Oracle 9.2.0.6 to

Oracle10.2.0.4

. BPM initiated to build overall Bank wide new Orange Datawarehouse with

Industry standard Start Schema and Top-Down architectural approach

evolving various Data Marts down the line.

. PeopleSoft- GL Finance system re-engineered to 2-node RAC with ASM and

2-node DR set up - Physical Standby.

. OLTP System migrated from Oracle 8.1.7.4 Single Instance to 3-node

Oracle10.2.0.4 RAC and DR.

. Migrated large ODW Datawarehouse from regular cooked file system to

Oracle ASM.

. Set up Data Mart refresh process leveraging storage level consistency

technology using EMC Timefinder/clone and Oracle RMAN.

. Upgrade of Development databases from 10.2.0.4 to 11.1.0.7.

Responsibilities:

. Set up Oracle10g (10.2.0.4) environment on IBM AIX 5 lpars and

migrated existing Oracle 9i (9.2.0.6) database from Windows to new

laprs.

. Set up various Oracle10g database environments like Staging (DSL),

Main warehouse instance (ODW) and DataMart instance for new

datawarehous development and deployment.

. Involved in physical design layout of overall Datawarehouse

database system and DataMart refresh process

. Worked on designing physical data model including partitioning

large fact tables and Type II dimension tables, indexing strategy,

building Materialized views for appropriate performance response

for Informatica ETL Loads and complex Cognos/SAS BI Reporting.

. Configured and tested Oracle CDC, logical Standby for sourcing

Customer dimesion from OLTP system

. Worked on tuning long running ETL loads, Cognos OLAP cube

build/refreshes and other complex ad-hoc reporting. Used AWR, ASH,

SQL Tuning Advisor, ADDM, Explain Plan, Stats gathering etc

. Worked on facilitating production database implementations like

Data fixes to meet the Data quality per Data Governance, huge

history data loading etc.

. Worked on Migrating databases from cooked file system to ASM

. Involved in building 2-node RAC with ASM & Oracle10g Clusterware

for Peoplesoft - GL Finance system which is also one of source

system for ODW.

. Involved on testing various failover scenarios while building RAC

Instances.

. Implemented DR in the form of Data Guard -Physical Standby set up

for 2 nodes RAC - GL System and single instance for ODW warehouse

system.

. Implemented Server Side Load Balancing SSLB on three node RAC

cluster database

. Worked on optimizing RAC Instances performance

. Worked on tuning and optimizing RMAN Backup. Set up image copy

backup for OLTP system ensuring fast recovery if needed. Also, set

up Datapump export/import wherever necessary for backup and

archiving

. Involved in quarterly DR testing - manual switchover and

switchback.

. Installation of Grid Control OMS, EM Agent and setup, created

monitoring templates, User Defined Metric for customized

monitoring.

. Installation and configuration of Foglight for database/application

server monitoring

. Implemented user level security, object level security, data

encryption using DBMS_CRYPTO, data masking, Fine Grained auditing

using DBMS_FGA package.

. Applied the CPU patches at regular interval as per Oracle's

recommendation and application need.

The Hartford Insurance, Hartford CT

Sept'05-Jan'07

Sr. Oracle DBA

Environment:

Oracle9i/10g, Solaris8/9, HP-UX11i, Informatica, BO, Cognos, SAS,

Autosys

As part of integrating IT requirements for different business lines like

Personal lines, Claims, Commercial etc, The Hartford EDW - Enterprise

Datawarehouse initiated Infrastructure upgradation and consolidation.

Individual SUN servers replaced with HP Superdome. All existing Oracle

Instances upgraded from 9i to 10g and migrated to HP Superdome on different

vpars allocating to Central warehouse (Production/Test/Development) and

Data Marts.

Responsibilities:

. Involved in formulating Migration strategy assuring system

availability with full proof overall System testing, minimum

downtime and effective usage of available Hardware resources

. Migrated Oracle9i(9.2.0.4) to Oracle10g(10.1.0.4)

Dev/Test/Production Instances

. Migrated above instances from SUN server to HP Superdome

. Involved in corresponding Application migration and testing

. Involved in performance tuning of certain ETL Informatica Mapping

& Sqls

. Worked on performance tuning of Data Mart systems supporting BO,

Cognos OLAP queries from field users

. Worked on reveiwing and implementing scheduled production releases

. Involved in formulating Oracle Datamart refresh process, Database

Backups, Batch jobs like ETL load jobs, Cognos Cube bulding for

reporting etc.

. Offered required training and guidelines to respective User

community ensuring overall System Operational & Usages efficiency

GE Consumer Finance/GE Money, Shelton CT

Feb'04-Aug'05

Sr. Oracle DBA

Environment:

Oracle9i/8x, Sorlaris8/9, Ab Initio, SAS, BO, Essbase

GECFA IT-Data Management Team is building and operating multiterabyte

datawarehouses (Consumer/CDCI, Commercial and Collections) supporting GE

Consumer Finance's Business Analysts, Marketing and Risk Analysts who uses

SAS, Business Ojects, Essbase etc, reports analyzing their North America

consumer finance business with prime clients like Jcpenny, Walmart,

ExxonMobil, Lowes, Dilliards, SAMs, Mens Warehouse and others.

Responsibilities:

. Performance Tuning of overall Data warehouse Database systems

. Tuning ETL Loads (customized ETL using Oracle PL/sql, Sql*Loader,

SAS, perl, Pro*C etc and Advanced ETL using Ab Initio)

. Tunning End-users SAS, BO extracts/reporting queries and Essbase

Cubes

. Involved in formulating various Loading strategies for efficient

ETL

. Capacity Planning of Database system handling Terabytes of History

Data, regular

loads from FDR (who maintains the source application systems) &

Authorizations data etc and multiple processing of the same

. Involved in formulating Backup and Recovery strategy which includes

RMAN, Veritas Flashsnap and Netbackup, BCV etc

. Configured and set up Oracle Transparent Gateway for cross platform

databases like Sybase.

. Implementation support for newly coming project requirements

. Database Refresh for New developments and Data validations,

reporting and extracts

. Involved in re-engineering of existing SAS staging in ETL and

Oracle database

. Involved in re-engineering of existing partitioned tables to meet

wide requirements from End-user, ETL loading perspective.

. Managing oracle connectivity to BO, SAS, Essbase for End-users and

oracle connectivity to Ab Initio - EME & GDE for ETL Developers

. Involved in managing Ab Initio cooperating system, EME and GDE

. Mentored ETL team for effective ETL design by appropriate mapping

between Oracle and Ab Initio level features like partitiong,

sorting etc

. Knowledge of Ab initio Data Profiler which can be used to analyze

the data and hence for effective design of ETL stream and report

. Regular administration for space management, database healthcheck,

user management, Database reorganization etc.

Kuwait National Petroleum Company (KNPC), Kuwait

Sep'03-Feb'04

Oracle DBA

Environment:

Oracle9i R2, Oracle9iAS R2, Data Stage, Oracle Designer, Oracle

Discoverer, Oracle Portal

KNPC EIS - Executive Information System is an online Portal for KNPC

(Kuwait National Petrolium Company) executives. Discoverer reports

published in Oracle 9iAS Portal uses the EIS Datawarehouse for various

trend analysis. Monthly ETLV (Extraction Transformation Loading and

Validation) loading is done using Data Stage.

Responsibilites:

. Production set up for Oracle9i Datawarehouse and Oracle9i Application

Server Portal

. Migrated one of Oracle Database System supporting various repositories

from Dell PowerEdge 6650 running Windows NT to Sun Fire V440 running

Solaris 8.

. Involved in tunning OLAP Complex queries and Datawarehouse database

. Formulated loading strategy (Batch Job) as per server load

. Designed and maintained backup strategy for DW Database and

Application server

. Troubleshooting and Monitoring database system issues

. Interacted with End users and Report devolopers towards Datawarehouse

system usage and performance

FORD Motor Company

FMC-Satyam Offshore Development Center, India

Mar'03-July'03

Oracle DBA

Environment:

Oracle8.1.7, Designer6i, Oracle Devpartner, loadjava.

MIDAS, Mazda's Integrated Database and Application System is a

Vehicle Engineering Release System. Through this system Mazda Engineer

registers the Vehicle parts design changes. These changes as notice gets

circulated to the concern people in different divisions. Present system was

running in the mainframe system. Mazda wants to convert this system into

web technology. Satyam FITSI involved in the Data Conversion from the

Mainframe System into Oracle Database. The pushed data from the mainframe

system gets validated, processed and loaded to the Oracle Database based on

various processing logic using UTL_FILE package in Oracle Stored

Procedures. The data loading summary & error messages if any, gets recorded

in separate error log files and the summary log during the run.

Responsibilities:

. Analyzed & designed the system towards the requirement of

datawarehouse considering the Data conversion or transformations

wherever required as per end usage of the system, runtime issues like

performance, purging of stage if exists, database sizing etc.

. Created database supporting Japanese characters & tested against

multibyte Japanese data input file on English OS.

. Set up the Designer6i repository & generated ERD considering

denormalized database design towards better performance etc.

. Developed a working prototype stored procedure using UTL_FILE

. Configured the database to support the loadjava & Java stored

procedures for file operations.

. Tested export/import of data in multilingual database environment.

. Created Bitmap indexes, Partitions, Materialized views to test the

performance aspects in Test database.

World Bank

WB-Satyam Offshore Development Center, India

Oct'02-Feb'03

Oracle DBA

Environment

Oracle8.1.7, Oracle Migration Workbench, SQL Server 2000,

WebSphere4.0, J2EE. Platinum Erwin3.5.2, Sun Solaris 2.8, TOAD

GDLN-AMS is basically workflow management system. The existing system

was in SQL server & ASP & many operations were offline. This project is

about re-engineering the system & platform migration to Oracle 8.1.7, J2EE.

It is a multilingual web application.

Responsibilities:

. Reverse Engineering of the existing system using Platinum Erwin

. Re-engineering the existing Data Model to new requirements & System

Design supporting J2EE in Struts framework.

. Set up the offshore development & test environment.

. Migrated the existing SQL server database to Oracle for offshore

Development & Test Database setup.

. Building the business logic in Oracle Procedures, functions wherever

required.

. Supported to the development team to locate issues like connection

pooling, opened cursors, database resource locks towards better

application design and so the overall system performance.

. Database Support to the developers to incorporate special features

like file upload, multilingual support etc,

. Offshore support to on-site System testing & UAT.

. Analyzed the impact on the system to incorporate the Change Request.

. Managing the different schemas to test various application

requirements.

Tondon Groups, Mumbai, India

Mukund Infotech

Aug'00-Sept'02

Oracle DBA

Environment

Sun-Solaris 2.6, Oracle 8.1.6, Developer6i.

The project involved Software Installation, database creation, Oracle

Enterprise Manager Configuration, performance tuning and backup and

recovery strategy plan. Database was managed using Server Manager and

oracle enterprise manager.

Responsibilities:

. Installation of Oracle 8i on Sun Solaris 2.6.

. Installation of Developer2000 on windows.

. Involved in regular backup and weekly tape backup.

. Analyzed the system for complete integrated ERP solution.

. Involved in Acceptance & Release to Production of databases.

. Created Database and Logical/Physical Storage structures.

. Involved in rehearsing the contingency plan for the database

environment ensuring adequate fallback procedures are in place for

database failures.

. Memory Tuning (Database buffer cache, Shared Pool Area, Redo log

Buffer Cache).

. Resolved client - server connectivity issues.

. Managing Redo log files, Control file and Parameter file.

. Support to developers and users verifying the query performance.

. Used various diagnostic and Admin tools, SQL Trace, TKPROF, Explain

Plan.

. Coordinated developer to develop stored procedures, functions and

triggers to manage business functionality and complex constraints.

BSES Ltd/Reliance Energy Ltd, Mumbai, India

Jun'99-May'00

Trainee Engineer/Programmer Analyst

Environment:

Sun-Solaris 2.5, Oracle 8.1.6, SQL*Loader, SQL, PL/SQL.

Maintenance Management and planning control department facilitates the data

for 3 different types of maintenance planning: Breakdown Maintenance,

Preventive Maintenance and Conditional Maintenance. The internal in-house

system supports for this basic functions in the departments.

Responsibilities:

. Analysis, Design & Development of the complete Operation & Maintenance-

MIS.

. Data flow diagrams, ER-diagrams, Normalization for the system &

database design.

. Created Database and Logical/Physical Storage structures.

. Created index policies for optimizing the application performance.

. Analyzing table's indexes, rebuilding indexes.

Contact this candidate