Manager Oracle

Title:DB* DBA Consultant

*********@*****.***

Document

Source below

NAME: galperin, igor

ADDRESS: **** ****** *****

ADDRESS2:

CITY: san ramon

STATE: CA

ZIP: 94583

CANDIDATE ID: 2252676

US CITIZENSHIP: US

Citizen

EDUCATION:

EXPERIENCE: 15

WILL RELOCATE: Yes - CA

JOB WANTED: Any

RATE NEEDED:

TELEPHONE: 925-***-****

EMAIL: *********@*****.***

HOMEPAGE:

HOTTEST SKILLS: db2,oracle,unix,aix,informix,sybase,assembler,cobol,rexx,udb

REVISION: 11-OCT-01

YOE: 15

RESUME:

RESUME

Technical Skills

Operating Systems: UNIX / AIX on different servers,

OS/390, MVS/ESA on IBM Mainframes, Windows NT. Database

Systems: DB2/UDB, ORACLE, SYBASE, INFORMIX, MS SQL Server,

IMS/DB. Languages: C, ASSEMBLER, SHELL Scripts, REXX,

COBOL,. Real Time Systems: CICS, QMF. Software: BMC,

Candle, CA, Platinum, SMP-E. Hardware: IBM mainframes,

RS/6000, HP, DEC Alpha, NCR, UNISYS, SUN/Solaris.

Applications: Data Warehouse for major platforms,

PeopleSoft HR for DB2.

Professional Experience

Oct 1998

PresentCHARLES SCHWAB INC

SAN FRANCISCO, CA

DB2 DBA Consultant

Contract

Database Administration for DB2. Support for the

application development teams for the Integrated Customer

Information System, Securities, Mutual Funds and 25 other

databases.

All database maintenance activities are done using BMC

Change Manager, BMC Catalog Manager and BMC DASD Manager

products, BMC Logmaster, Platinum Detector, CDB Utilities,

etc.

Application support includes: Physical Data Base design

and implementation, SQL reviews, troubleshooting for the

Application programmers and Operations, migrating between

Development Acceptance, Host Fall Back and Production

environments, sizing application data, tuning SQL,

monitoring all systems using Omegamon, Platinum Detector

and DB2 PM.

Consulting Application Development community and Data

Modelers on properly utilizing DB2 environment and helping

them to optimize their design and programs.

Created Auditing and Data Replication system using Log

Master from BMC and RepliData from IBM.

Participated in the company-wide DB2 Performance committee.

Production support 24X7 for the DB2 Data Sharing (13 ways

data sharing) environment. Setting up and supporting

Reorgs, Image Copies, Recovers, Runstats jobs for all of my

supported systems. Periodic ON-CALL duties involve problem

solving for the entire DB2 environment

Developed multiple REXX routines to automate various DB2

activities.

Oct 1993

Oct 1998PRISM SOLUTION

- Sunnyvale, CA

Lead Software Developer/ DBA

(11/9510/98

Part-time

Consultant (10/93 - 11/95)

Data base administration for DB2 UDB (Version 5), Oracle

(Versions 7.x/8), Sybase (Versions 10.x/11.x) Informix

(Version 7.x) on multiple UNIX platforms and AIX.

Responsible for all DBA activities for various DBMS

systems. Support, installation and maintenance for DB2/UDB,

Oracle, Sybase, Informix for various servers (HP, DEC

Alpha, Sun Solaris, NCR, Unisys, RS/6000, etc.). Developed

recovery methodology for the different databases for the

various platforms. Also set up procedures for performance

monitoring and tuning.

Developed software for loading Data Warehouse on Target

platforms (MVS, various Unix systems, AIX and NT) for

Oracle, DB2, DB2/UDB, MS SQLServer, Sybase, and Informix,

utilizing ODBC and native loaders.

Architected, designed and coded Changed Data Capture

facility in DB2 and IMS for the Prism Warehouse Manager.

System consists of the Assembler routines that read and

transform data from DB2 and IMS archive logs for the

subsequent input into the Prism Warehouse Manager (PWM).

User interface for these systems was written in COBOL II,

REXX and ISP Panels. DB2 and IMS CDC products are currently

implemented in multiple customer sites in US, Canada and

Europe.

Developed the architecture for PSM (Prism Scheduling

Manager).

Designed and wrote the MVS part of PSM which interfaces

with CA-7 and is written in Assembler and Cobol II and

various shell scripts and C programs for the Unix

environment. Developed POSQL, the proprietary scheduling

language for CA-7 interface. The product schedules jobs and

transports data between Unix and MVS environments.

.

Sep 1989

- Nov 1995SIEMENS ROLM

- Santa Clara, CA

DB2 System Administrator DBA / Oracle DBA

Installed and maintained Oracle databases in AIX/UNIX

environments.

Set up Oracle distributed environment using SQL*Net V2.

Developed hot backup system utilizing Oracle Snapshot

feature.

Developed set of backup and recovery procedures for Oracle.

Responsible for the entire DB2 activity in the company.

Installed (SMP-E) tuned and maintained three production

and two test DB2 subsystems.

Installed and customized CICS interface for all DB2

subsystems.

Performed monitoring using different tools (Omegamon, DB2

PM).

DB2 maintenance utilities (BMC, Platinum). Set up shop

standards for the DB2 environment.

Designed different recovery and backup procedures for 24x7

requirements.

Consulted application development staff (60 programmers)

for various DB2 design and implementation issues.

Installed and implemented first release of the PeopleSoft

HR system for DB2.

Implemented logical and physical design for Order Entry,

Manufacturing and Inventory systems for DB2/CICS

environments.

Helped application programmers in developing Cobol code

for those systems for the performance optimization.

Set up and supported company wide QMF environment (250

users).

Worked with the end users on the query optimization issues.

Set up distributed environment between different DB2

subsystems and a client server environment between RS/6000

and DB2 using DRDA.

Jan 1981

- Sep 1989BREUNERS

- San Ramon, CA

DB2 System Administrator / IMS Systems Programmer

/ CICS

Systems Programmer

As DB2 System Administrator installed first release of DB2

in 1986.

Developed all DB2 standards from scratch.

Taught DB2 classes for application programming staff.

Developed all DB2 backup and recovery procedures.

Designed and implemented conversion for the main online

application from IMS to DB2. Designed, coded and

implemented problem tracking system using first release of

DB2.

As IMS Systems Programmer, installed and maintained

several releases of IMS DB.

Developed backup, recovery and IMS DB repair procedures.

Wrote several utility programs for maintaining data

integrity in IMS DB.

As CICS

System Programmer, installed and maintained

several CICS systems.

Set up RDO for CICS 1.7. Set up MRO for CICS environment.

Installed CICS and IMS tools to monitor and tune CICS and

IMS in CICS environment.

Migrated major Online Reservation System to CICS command

environment from macro environment.

Installed and customized CICS interfaces for DB2 and IMS.

All DB2, IMS and CICS products have been installed with

SMP-E software.

Nov 1979

- Jan 1981BANK OF AMERICA

- San Francisco, CA

Senior Systems Analyst

Implemented the Corporate Payroll Systems.

Responsibilities included design, coding, setting up

backup and recovery procedures.

1967

- 1979STATE BUILDING CONSTRUCTION CORPORATION

- Odessa, USSR

STATE TRANSPORTATION DEPARTMENT

- Odessa, USSR

Programmer / Programming Department Manager

Responsible for all design and programming activities in

the enterprise.

Education

1966

- 1972

ODESSA UNIVERSITY

Masters Degree

in Computer Science and Applied Math

Database Management classes at IBM / Oracle

Contact this candidate