Sql Server Data

Bryan D. Lombardozzi

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

[pic]

Home Phone: 727-***-****

Cell Phone: 727-***-****

Summary Of Responsibilities

Over the last 15 years of being in Database Administration I had to

Operate, maintain, and administer database servers, hardware and software

in support of network management platforms; provide technical problem

solving for customer computer support of database applications; Develop,

implement, upgrade and maintain Microsoft SQL Server, DB2/ZOS, UDB on AIX,

MYSQL, Oracle, UNIX based and LINUX based databases using code for

development which includes SQL, and T-SQL scripts, Troubleshoot issues with

existing or developed systems, work with the appropriate resources to

resolve problems, Develop database interfaces to corporate databases and

maintain and design data warehouse systems. I have also managed teams

ranging from 6 to 10 people through various positions over the years. I

specialize in database performance and have been contracted out from many

firms to tune their systems. Some of the firms include IBM, Price

Waterhouse-Coopers and Ernest and Young. I have been doing this from 1997

until present time. I am also a system integrator and specialize in data

migration.

SPECIFIC SKILLS & KNOWLEDGE

Hardware: IBM, IBM Compatible PC's, Sun, HP

Software: DB2 OS/390, Z/OS, SQL, SPUFI, TSO, QMF, JCL, Oracle

RDBMS

Version 7.3,8 & 8I, Oracle forms V4.5,

Windows NT, MS Windows, Visual Basic V5,

Access 2002 Office 2000, Clarify, Visual

Source-Safe, Changeman, BMC Tools,

MVS-OS/390, Platinum Tools, Endeavor, Data

Warehousing, Data Sharing,

CA Insight, SQL Server Version 6.5, V7, 2000,

2005 and 2008, VSAM, Enterprise Manager,

Top Session, OLAP, Quest tools for Oracle,

Unix, DB2 Connect, Shadow Direct,

JD Edwards Administration, Quest Tool

package, UDB on Sun Solaris Version 7.2 and 8.1

Embarcadero Tool Set for UDB and SQL Server,

Remedy, Informatica,

Organizations Oracle Developers Alliance

IDUG

Certifications: IBM -DB2 OS390 and ZOS Database Administration

Version 7, 8

New York City, NY

Oracle - Oracle V7.3 and V8, V9i and 10g

Database Administration

Orlando Fl.

MSSQL Server - SQL Server V6.5, V7, 2000, 2005 and 2008 Database

Administration

Horizon Software Consulting Group Corp.

March 2004 to Present

Tampa Florida

[pic]

Position: Senior Database Administrator for SQL Server 2000 and SQL Server

2005, UDB/AIX, DB2/ZOS

and Vice President of Database and Data Architecture

Groups.

CONTRACTS WHILE WORKING FOR Horizon Software Consulting Group Corp.

If I am not on a specific contract I will manage and work with the teams we

have on multiple contracts to insure they are keeping within the guidelines

of the company they are placed at. I will work hands on with the teams to

help lighten the load they have.

NJ Manufactures Trenton NJ (Remote Contract through Horizon Software

Consulting Group)

9/2009- Present

Position Senior UDB DBA V8.1 and SQL Server DBA V2000, DB2 DBA ZOS

Responsibilities:

Responsible for implementing and monitoring physical

databases, including designing

table spaces and any required database-partitioning

strategies for SQL Server, UDB & DB2 ZOS.

Create and support project-related development, test and

production database instances

and, working with Data Architect(s), execute DDL and

create database schemas for

SQL Server, UDB & DB2 ZOS..

Designs and supports data staging environments for

business-critical application(s) for

SQL Server, UDB & DB2 ZOS.

Responsible for the development and data architecture of the

data warehouse system. I am

also responsible for loading all data and tuning the

applications accessing the data warehouse.

My Matrix, Tampa Fl (through Horizon Software Consulting Group)

1/2009 - 9/2009

[pic]

Responsibilities:

. Established and wrote Performance Tuning guidelines to enhance quality

of product.

. Redesigned a thorough backup and recovery strategy for all major

production systems.

. Upgraded all SQL Server 2000 to SQL Server 2005, without service

interruption and applied all appropriate patches

. Migrated all Matrix accounting databases that will be used for

trending which consisted of 15 databases

spanning over 150 gig.

. Setup database replication using transactional replication to be used

as a hot standby using active/passive method

. Setup up a two node cluster as a failover recovery option.

. Tune all SQL from online applications

. Designed and implemented complex database architecture.

. Implemented strategies for database highly availability and

scalability.

. Established standards for SQL installations, maintenance, tuning, and

coding.

. Lead in the development of our OLAP data warehouse reporting

initiative.

. Provided training, mentoring, and feedback to team members to enhance

communication and performance.

. Take ownership of current operational data structures and initiate

optimizations and reconfigurations as warranted.

. Envisioned and presented employees' ideas on the concepts of

technologies to management to enhance staff development and boost team

spirit.

Lehman Brothers, New York City, NY

6/2008 - 1/2009

(through Horizon Software Consulting Group Corp.)

[pic]

Senior Database Administrator (Virtual Position)

DB2 OS/390 & ZOS V8, DB2/UDB EEE Sun Solaris, AIX V5L, SQL

Server 2000, 2005

I was hired as and independent contractor to support there SQL

Server, UDB and Mainframe environments

from home in Palm Harbor Florida. Due to the problems Lehman's was

having many DBA's leaving for other

positions and they needed systems support until all accounts were

migrated.

Responsibilities Include

. Install and upgrade of UDB V9.5 & SQL Server servers & clients.

. Working with development groups for migration into production

environments of other companies taking over the accounts for Lehman

Brothers.

. SQL Server Clustering

. Set up disaster recovery with hot standby for SQL Server and UDB

environment during the migration effort.

. Backup and recovery DB2/ZOS, SQL Server & UDB

. Data migration from DB2 ZOS to Oracle, Sybase, UDB and SQL Server

. Managing and supporting 24/7 production clustering environments for

Mainframe, UDB & SQL Server.

. Problem determination and resolution in Mainframe, SQL Server and UDB

. Performance, scalability and tuning for DB2, UDB & SQL Server.

. Help developers with stored procedures and triggers during the

migration period.

. Logical and Physical Design of Systems using Erwin

. Provide appropriate suggestions to developers in their implementation

of SQL or other

data access code

. Assisting and guiding developers with any issues.

. Research problems and provide solutions

. Capacity Planning & space management for SQL Server

BIPT, Florida (through Horizon Software Consulting Group Corp.)

1/2008 - 6/2008

[pic]

Position: Senior DB2 UDB Database Administrator on AIX \Sr. Infrastructure

Architect

Responsibilities:

. Created physical database with 4 physical nodes and 8 logical nodes.

. The data warehouse has 8TB of data.

. Worked with system architects to design the data warehouse.

. 24x7 on call rotation support.

. Supported ETL team, during load issues and for general testing of the

load process.

. Created 4 instances across 4 physical nodes with 4 different databases

for testing purpose.

. Identified benchmark queries for data warehouse.

. Load testing for Open enrollment & performance for 400 concurrent

users.

. Work with system admins to make system available for production.

. Design and implement the proof of concept on development environment.

. Applied latest fixpaks .

. Creation of database / nodegroups / tablespaces and various objects.

. Write scripts to unload data and automate autoloader scripts.

. Create test cases for benchmark testing.

. Enhance the performance to meet the desired standards.

. Handle Engineering change requests.

. Performance tuning was an on going process, tuning queries .

. Rebalance the nodes for even distribution of load on all nodes.

. Established the backup/recovery process.

. Help the developers to formulate the queries.

. Work with application development team to design new and re-engineer

existing applications.

. Automation of weekly update process using scripts.

. Creation and implementation of triggers and stored procedures for

implementation of custom required processes.

. Migrated the Oracle database to db2 udb.

. The migration was manual, generated ddls and exported the data from

oracle with comma delimiter,

. Loaded the oracle data in db2, created all the oracle objects in db2

udb.

. Performance monitoring and tuning.

. Automated the backups, Reorgs, Runstats, Space monitoring, moving the

db2diag.logs, monitoring the size

. of the Table spaces by setting up a threshold (70%) etc.

. Led training for developers and operations staff on DB2 issue

resolution procedures to reduce DBA support calls.

Masonite International Florida

6/2007 - 1/2008

(through Horizon Software Consulting Group Corp.)

[pic]

Position: Senior SQL Server DBA \Sr. Infrastructure Architect

SQL Server 2000 and 2005

Responsibilities:

. Evaluate requirements for the relevancy to (and impact on) the

databases.

. Database maintenance for SQL Server 2000 & 2005

. Convert Access Database and Excel spread sheets into SQL Server 2005

Database

. Data cleansing for all converted data

. Data Warehouse design and development

. Perform database capacity planning.

. Ensure that the system and software architectures properly address

persistence.

. Performance tuning for all databases and stored procedures.

. Determine the appropriate database technology (relational extended

relational or object database)

. Migration from SQL Server 2000 to SQL Server 2005

. Database maintenance, logical and physical design

. Determine if existing database access software requires modification.

. Collaborate with others to determine the:

o Impact of database changes on the other systems

o Staff cost for making changes to the databases.

. Design and develop all security for all database systems

. Set up and implement disaster recovery for all systems within the

company

. Perform platform assessment regarding proper support for the selected

databases.

. Produce the database-related contents of the following and operations

documentation:

. Deployment Plan

. Installation Manual

. Operations Manual

CSX Jacksonville Florida (through Horizon Software Consulting Group Corp.)

1/2007 - 6/2007

[pic]

Position Senior DB2 DBA ZOS & OS/390, UDB DBA V8.1 and SQL Server DBA V2000

Oracle V9.i

Responsibilities

. Migrate from DB2 ZOS version 7 to DB2 ZOS Version 8

. Partitioning for DB2 ZOS.

. Database maintenance for DB2 ZOS, SQL Server and UDB on AIX

. Backup and recovery DB2/ZOS, SQL Server, UDB and Oracle

. Data migration from DB2 ZOS to Oracle, Sybase, UDB and SQL Server

. Performance, scalability and tuning for DB2 ZOS, UDB & SQL Server

V2000.

. Install and upgrade of UDB V8.1 & SQL Server servers & clients.

. Install and setup UDB /DB2e Everyplace

. Help developers with stored procedures and triggers in SQL Server and

DB2/ZOS.

. Managing and supporting 24/7 production clustering environments for

DB2 ZOS, UDB & SQL Server.

. Problem determination and resolution for SQL Server, DB@/ZOS and UDB.

. Logical and Physical Design of Systems using Erwin for SQL Server,

DB@/ZOS and UDB.

. Provide appropriate suggestions to developers in their implementation

of SQL or other

data access code

. Manage and maintain third party vendors tools like DBArtisan, BMC,

BMC Iwatch,

and Autosys.

. Responsible for Participation in disaster recovery tests for SQL

Server, DB2/ZOS and UDB

. Assisting and guiding developers with any issues.

. Research problems and provide solutions for SQL Server, DB2/ZOS and

UDB

Publix Lakeland Florida (through Horizon Software Consulting Group Corp.)

7/2006 - 1/2007

[pic]

Position Senior DB2 DBA ZOS & OS/390, UDB DBA V8.

Responsibilities:

. Installation, configuration and support for large high volume DB2 for

Z/OS Database environment.

. System monitoring, performance tuning, capacity planning, backup and

recovery management plus 7 X 24 on call support.

. Work with developers to resolve SQL performance problems and insuring

the proper indexes are created per production request.

. Performance, scalability and tuning for DB2, and UDB.

. Work with DBA team testing our disaster recovery scenario.

. Responsible for building business cases and recommendations along with

DBA team.

. About 25% of my time is working with UDB in an AIX environment.

CSX Jacksonville Florida (through Horizon Software Consulting Group

Corp.) 2/2005 - 7/2006

[pic]

Position Senior DB2 DBA ZOS & OS/390, UDB DBA V8.1 and SQL Server DBA V2000

Oracle V9.i

Responsibilities

. Install and upgrade of UDB V8.1 & SQL Server servers & clients.

. Partitioning for UDB.

. Backup and recovery DB2/ZOS, SQL Server, UDB and Oracle

. Data migration from DB2 ZOS to Oracle, Sybase, UDB and SQL Server

. Managing and supporting 24/7 production clustering environments for

UDB & SQL Server & Oracle.

. Problem determination and resolution

. Install and setup UDB /DB2e Everyplace

. Performance, scalability and tuning for DB2, UDB & SQL Server.

. Help developers with stored procedures and triggers.

. Logical and Physical Design of Systems using Erwin

. Provide appropriate suggestions to developers in their implementation

of SQL or other

data access code

. Manage and maintain third party vendors tools like DBArtisan, BMC,

BMC Iwatch,

and Autosys.

. Responsible for Participation in disaster recovery tests.

. Assisting and guiding developers with any issues.

. Research problems and provide solutions

New Jersey Manufactures West Trenton NJ

3/2004 - 2/2005

(through Horizon Software Consulting Group Corp.)

[pic]

Position Senior DB2 DBA ZOS, UDB DBA V8.1 and SQL Server DBA V2000

Responsibilities:

Responsible for implementing and monitoring physical

databases, including designing

table spaces and any required database-partitioning

strategies for SQL Server, UDB & DB2 ZOS.

Create and support project-related development, test and

production database instances

and, working with Data Architect(s), execute DDL and

create database schemas for

SQL Server, UDB & DB2 ZOS..

Designs and supports data staging environments for

business-critical application(s) for

SQL Server, UDB & DB2 ZOS.

Responsible for the physical aspects of DB2 databases

including logging and rollback

configuration.

Responsible for database reorganizations, backups and

recovery during all project

phases including production for SQL Server, UDB & DB2

ZOS..

Monitors, analyzes and manages database logs and related

transaction journals for

SQL Server, UDB & DB2 ZOS..

Executes database performance monitoring and assists

developers in tuning &

optimization of SQL for SQL Server, UDB & DB2 ZOS..

Work with the Application Architect and Data

Modeler\Architect to devise appropriate

indexes and associated data retrieval/transaction

strategies.

Responsible for physical database creation, maintenance,

and change control for

SQL Server, UDB & DB2 ZOS..

Monitors DB2 databases for optimal query and transaction

performance and resource use.

Monitors and maintains database-level security in

collaboration with enterprise security

Administrators for SQL Server, UDB & DB2 ZOS..

Responsible for database fault analysis and resolution,

including the ability to take after

hour support calls.

Bank Of Tokyo-Mitsubishi LTD Jersey City NJ (Perm Position)

Jan 2002 To March 2004

[pic]

Position Senior DB2 DBA, Oracle DBA, SQL Server DBA and UDB

I am responsible for most of the DB2 OS/390 development and

Production systems running in

Version 6. I perform all maintenance, upgrades, space

management, performance tuning, change

control along with backup and recovery for these systems. I

am also responsible for maintenance,

upgrades, performance tuning and space management for some of

the Oracle and SQL Server

systems in our shop. My primary responsibility is our Data

Warehouse which is over a terabyte

in size running in DB2 OS/390. I handle all performance

tuning, space management, maintenance

along with backup and recovery.

LVMH in New York City (Perm Position)

2001 To Jan 2002

[pic]

Position (Consultant) Database Manager DB2, Oracle & SQL Server

This company sends me out to different sites to do

performance tuning in DB2, Oracle and SQL Server.

Was On Contract: at LVMH in New York City setting up there

databases using SQL Server 2000.

I was also assigned the task of designing the data warehouse

an implementing it. I am also responsible

for the administration of there JD Edwards system. Other task

include database maintenance, security

system monitoring logical and physical design, space

management. Other assignments include companies

such as Lettuce Marketing, Essilor of America and Parker

Reorder.

Merrill Lynch New York, NY Information Technologies Group

Nov 1999 To Mar 2001

(Perm Position)

[pic]

Position Assistant Vice President, Senior DB2 & Oracle Administrator

I am responsible for over 40 DB2 and Oracle production systems

Including the US & International

Payroll & Human Resource System. My duties include performance

tuning, daily maintenance,

logical and physical design, code review for development

staff, system upgrades & enhancements,

backups, restores, security, referential integrity, disaster

recovery, normalization for new system

development, Oracle installs and upgrades. The systems that I

am responsible for range from 2 gig

to 300 gig in size and a data warehouse with a total of 11

terabytes of data. Seventy percent of the systems are in

DB2 and 30% are in Oracle. I was also on the DB2 version migration team for

all production and

development systems. I've been working with Platinum, BMC

and Quest tool packages in this

environment.

Information Technologies Group, Tampa, FL Placed At TECH DATA CORP.

May 1999 To Nov 1999

[pic]

Position (Consultant) Senior DB2 Database Administrator & Senior

Oracle Database Administrator

- Implementing Version 5 utilities (DB2)

- Testing of Platinum 97 (DB2)

- Support of all production systems

- Design reviews for all new development

- Maintenance of security

- Design and implementation of referential Integrity.

- Maintenance of all production systems

- Performance tuning and enforcing SQL Standards.

- Normalization of new development Replication

- DBA for their new Siebel web production system in Tampa

Florida.

- Responsible for data conversion from their legacy system to

the new SQL Server and UDB databases.

Renaissance WorldWide, Inc. Tampa, FL.

Nov 1998 To May 1999

On Contract at: Time Customer Service

[pic]

Position (Consultant) Senior DB2 Database Administrator & Senior

Oracle Database Administrator

- Support development groups with Y2K testing

- Migration of Test and Production applications into Data

Sharing. (DB2)

- Test and Production support

- Object Management for Test and Production

- Performance tuning and analysis for Data Warehouse

- Database support for Data Warehousing and working

closely with our development staff to ensure object design

and statistics for efficient data retrieval.

- Building backup and recovery strategies for all production

applications.

- Physical and Logical design of systems

- Design and Implementation of referential integrity

- Capacity planning for production systems

Renaissance WorldWide, Inc. Tampa, FL.

April 1998 To Nov 1998

Placed At Franklin Templeton 205 9Th Street North ST. Petersburg Fl.

[pic]

Position Database Administrator DB2 and SQL Sever Version 6.5

Consultant

I was responsible for the logical and physical design of all new

systems being developed in DB2 and Sql

Server. Other area's of responsibility include maintenance,

performance tuning, system support, index

design and system implementation. I was also responsible for

development and testing of the conversion

scripts utilized for system upgrades.

Renaissance WorldWide, Inc. Tampa, FL.

Jan 1998 To April 1998

Placed At Intermedia Communications, Sabol Park Tampa, FL. 33610

[pic]

Position Senior Oracle DBA\Consultant

I was hired for a three month period of time to work with their

3rd tier support group and was performing

general maintenance with Oracle V8 for development of the

Electronic Forms Interface project. I was also

responsible for the space management and performance tuning for

developers in the organization.

HSCG Tampa Florida

Sept 1997 To Jan 1998

[pic]

Position Senior DB2 DBA, Oracle DBA V7.3.4.5, SQL Server & Oracle

developer/2000 forms V4.5

I am contracted out to different organizations doing performance

tuning in DB2, SQL Server and

Oracle. My most recent assignment was for Parker ReOrder in Coral

Gables Fl.

- Performance tuning on designated accounts

- Maintenance on tablespaces and indexspaces when needed. (Runstats,

stospace and system binds)

- Monitor space utilization

- Manage the backups and image copies on a weekly basis.

- Capacity planing for test and production systems.

- Logical and physical design.

GSI Corp. 6401 Harney Road Tampa FL.33610

Jan 1995 To Sept 1997

[pic]

Position DB2 DBA and OracleV7.3 DBA

Accounts: Kash & Karry and Jumbo

Sports

- Reorganization of tablespaces and indexspaces

- Process runstatats, stospace utilities

- Rebind the production system when needed

- Manage the quiesce points and backups for the production systems.

- Monitor the space utilized for tablespaces and indexspace.

- I would work with the application staff to ensure that modules going

into production would

have peek performance.

- Interface with users for application development and design to

enforce the database design.

- Work with the development staff for unit testing.

- I would work along with the Data Base Manager for the implementation

of new security.

- Create indexes in the test and production systems when approved by

the data base manager.

- Logical design, physical design and normalization.

- Developing and testing conversion scripts as needed

Contact this candidate