Developer Sql Server

Anthony

P. Pedone

*** *.**

ST

New York, NY

**128

CELL: 570-***-****

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

HARDWARE/SOFTWARE:

MS SQL Server (2008,20005,2000,7.0,6.5,6.0), TSQL (transact sql)

Visual Studio 2005/2008 C#.Net,ADO.NET, C/C++/ (Microsoft)

Sybase System 12.5,12.0, Sybase System 11.9.2

UML(Visual Uml)

EXPERIENCE:

08/2006 - present NEXTJUMP, INC

DBA Manager Developer/Analyst

Designer/Optimizer

Data Modeler/Architect

C# Developer

Responsible for designing and implementing frameworks to foster overall

efficiency.

Create proactive solutions to promote standards and operational policies

within the highly transactional OLTP and support for an OLAP Enterprise.

Also responsible for normal DBA duties

of backup/restore, and creation of all database objects. A highly skilled

optimizer and performance

tuner capable of increasing server/database performance by balancing the

three major Bottlenecks

of CPU, MEMORY and I/O. Incorporates correct use of CLR and T-SQL

integration

Partial list of examples written in Visual C#/CLRs and implemented across

the Enterprise:

FileStream- Database and application to store/retrieve all documents

types.

Multithreading App- Code to multi thread code requests

Data Movement- One Standardized Framework to move data within the

organization using

Various engines.

EventingSystem- A system built using Service Broker/EventNotifications

to pro actively

Capture and report on system events

Monitoring- A system built using DMVs to capture trends and spot system

issues for correcting

Replication- A framework for Peer-to-Peer Replication and Database

Mirroring.

Scripting- Dynamic Process to script All Servers/Database objects used

for version archiving.

Service Broker App- Time Out Blocking report produced when timeout

Events occur.

And other event notification

processes.

Showplan Interface- A process to pre-check Production queryplans with a

pass or fail designation

Activated by developers.

AutoReplicate-Automatically queue modifications and replicate changes to

subscribing

server/databases.

Various DBA Tools- IndexDefragger- maintain all indexes online.

EnableDisabler( Indexes)- A consistent way to disable/then enable

indexes for data movement

Speed.

The Replicator- An interface for manually moving db object(s) to

local/remote servers/databases.

SSIS C# FrameWork - activate SSIS applications using a proprietary API

to facilitate reuse of code

ACTIVE LEARNING:

Database Training -Teach a 10-week internals database course for Manager,

Developers, DBAs.

C# Training- Teach the DBA team the fundamentals of good OO design.

EXPERIENCE:

08/2005 - 08/2006 MERRILL LYNCH --consultant

DBA Developer/Analyst

Designer/Optimizer

Data Modeler C#

Developer

PHASE 1:

Sole individual involved in an Architectural redesign /rewrite of mortgage

processing division, Current system is Access and Excel based. Developed a

C# parser to read/parse the current Access objects of Modules, Queries,

Reports, Macros, Forms and Tables into normalized SQL SERVER tables. This

allows a detailed analysis of current Enterprise System.

PHASE 1I:

Preparing the System Design using .Net Sql Server 2005.

Optimized servers for Emeta/MacroVision

Optimized various servers for various departments in Merrill

09/2003 - 08/2005 EBSCO

(Online Publishing)

DBA/Developer/Analyst/Designer/Optimizer

Optimization code written to maintain all servers/databases.

Query tuning, index crafting and maintenance for Sql Server 2000/2005.

Normal backup/restore plans created.

Normal DbA duties of writing stored procedures, trigger, function and other

database objects.

Proative system written to interrogate performance to maintain consist

server/database performance.

The following actions helped elevate this Company from number Three to

Number One in the World.

06/2002 - 07/2003 The Manhattan

Club of Allentown, PA

Manager-

DBA/Developer/Analyst/Designer

06/2001 - 06/2002 Triple Point

Technology, Inc, New York, NY

SYBASE and MS

SQL SERVER DBA/Developer

04/1999 - 01/2001 Air Products and

Chemicals, Allentown,PA

SYBASE and MS

SQL SERVER DBA/Developer

12/1996 - 04/1999 Dun and

Bradstreet, Bethlehem, PA

SYBASE and MS SQL SERVER

DBA/Developer

04/1995 - 12/1996 Mack Truck,

Allentown, PA

Programmer/Developer

07/1989 - 04/1995 New York Life

Insurance, New York, NY

Programmer/Developer

10/1987 - 07/1989 Brown Brothers

Harriman, New York, NY

Programmer

05/1985 - 10/1987 Hapag-Lloyd

America, Staten Island, NY

Programmer

EDUCATION:

Bernard M. Baruch College,NY,NY-Attended courses in MicroComputer

Technology

Certificate Program

Empire Technical School, NY,NY Computer Programming Training - Completed

September 1985

Wilkes College,Wilkes-Barre,Pa . B.A. in Psychology Graduated June 1975

Loma -FLMI Insurance Courses-Completed Courses 1 through 5

Earned an Associate Customer Service (A.C.S) designation

Contact this candidate