Brian Zelli

Senior Database Administrator
Roswell Park Cancer Institute

Adjunct Faculty:
Medaille College
SUNY at Buffalo

Click to send me email
BZ vita

Roswell Park Cancer Institute
Buffalo, New York
Senior Database Administrator
Sept. 2006 - present

Directs and controls activities related to data planning and development of policies and procedures relating to data management, security, maintenance and utilization. Sets and monitors standards, advises on database concepts, technology and functionality. Maintains dictionary of database structure, elements, stored procedures and standard database interfaces. Evaluates changes in database technology and functionality; recommends, plans and implements changes. Develops procedures for back-up and recovery. Provides technical help for trouble shooting, tuning, database and application efficiency. Designs, specifies, configures, installs, documents and maintains application software. Evaluates hardware and software requirements and prepares justifications for upgrades, enhancements or new purchases.

Greatbatch, Inc.
Clarence, New York
Senior Infrastructure Analyst
May 2004 - Sept. 2006

Responsible for managing and monitoring the databases and applications for the Oracle ERP and SQL Server systems within Greatbatch, Inc. Duties include creating and populating databases using logical data models. developing back-up and recovery procedures and guidelines that are compliant with client security principles. Provide both functional and technical advice on related Oracle database issues such as: Monitoring database performance and efficiency, Performance tuning, Troubleshooting database and Applications issues as they arise. Logging tars w/Oracle Support, SQL Debugging, Administering Concurrent Managers, Applications Tuning, Web Server Administration, Unix File System Maintenance, Installation and configuration of Applications and Database Related tools, Configure Unix Servers, System Administration, Software installation, and develop, implement and enforce data security procedures. Systems Administration duties include the following: Installation, configuration, maintenance, support of computer hardware, software and archive log setup, administration and maintenance, experience with Discoverer and Portal, backup and recovery, performance tuning and database design and understanding of relational database concepts and applications within 8i and 9i.

West Seneca, New York
Database Administrator
April 1998 - May 2004

Assist in the design, documentation and maintenance of the company's independent subscriber management databases. Provides a daily turnover of accomplishments, issues and status of all related database applications. Will develop and enhance database applications for all aspects of the subscriber management systems. Research new technologies with vendors as they pertain to company's business strategies.

State University of New York College at Geneseo
Geneseo, New York
Database Administrator
Sept. 1996 - April 1998

Provide a high degree of coordination and integration in managing the college data resource by providing support for the needs of management, systems analysts, programmers, operations, external agencies and end users. Maintain, upgrade and insure the security of institutional databases including SCT BANNER administrative database and HRMS Human Resources database. Plan and implement all Oracle upgrades. Implement all BANNER application upgrades, working in conjunction with CIT staff and various college offices. Monitor the performance of the Oracle instances and tune as necessary to optimize available resources. Develop procedures and guidelines to guarantee database security, assuring the capability of performing regular database backups and developing software or media recovery strategies to assure continuous database activities.

State University of New York at Buffalo
Buffalo, New York
Senior Applications Analyst/Academic Database Administrator
Feb. 1995 - Sept. 1996

Responsible for consultation, training, and documentation of university time-sharing systems. Served as Oracle Academic Database Administrator. Specialized in database design and application programming advisement for faculty, staff and students. Support staff resource for university computing HelpDesk.

State University of New York at Buffalo
Buffalo, New York
Senior Programmer/Systems Analyst
Oct. 1984 - Feb. 1995

Responsible for managing university wide administrative systems. Developed, maintained and enhanced systems through application programming and analysis to end-user problems. Wrote, tested and documented programs. Kept all related documentation current and accurate. Coordinated implementation and training for completed projects.

State University of New York at Buffalo
Buffalo, New York
Lecturer II
Aug. 1995 - present

Instruct students, prepare and grade tests, prepare and grade project materials, prepare course outlines, descriptions, lesson plans and lecture materials; maintain class records and attendance book; assist students as faculty advisor; providing tutorial help as required by students.

Course offerings:
MFC215 - Cobol Programming
MFC310 - Project Analysis and Design
MFC312 - Database Management Systems (Oracle)
MFC318 - Microcomputer Applications (Access)
MGS404 - Database Management Systems - School of Management

Medaille College
Buffalo, New York
Adjunct Faculty
Dec. 2012 - present

Course offerings:
BIS300 - Database Design & Development
BIS350 - Computer Architecture
BIS390 - Comparative Programming Languages
BUS430 - Business Data Communications
HIA330 - Information Systems & Technology
MGT362 - Information Systems Management Theory
MOL624 - Leadership Interactions: Teams, Coaches, and Mentors

Erie Community College
Orchard Park, New York
Adjunct Faculty
Sept. 2009 - May 2012

Course offerings:
DA103 - Introduction to Information Technology
DA106 - Microcomputer Applications
DA150 - Programming Visual Basic
DA240 - Systems Analysis
DA261 - Database Concepts

Trocaire College
Buffalo, New York
Adjunct Faculty
Sept. 2008 - Dec. 2008, Sept. 2012 - May 2014

Course offerings:
BU099 - Introduction to Computer Literacy
CNA208 - Linux/UNIX Administration

Bryant & Stratton College
Orchard Park, New York
Adjunct Faculty
Jan. 2007 - Dec. 2011

Course offerings:
INFT100 - Information Technology I
INFT110 - Advanced Information Technology
INFT111 - Introduction to Information Technology
INFT120 - Programming I(Visual Basic)
INFT140 - Internet & Web Page Development
INFT224 - Database Programming (Oracle)
INFT230 - Data Communications & Networks
INFT245 - Internet Network Administration
INFT250 - Systems Analysis & Design
TECH140 - Networking Fundamentals
BUSS420 - Project Management
BUSS450 - Strategic Management

ITT Technical Institute
Buffalo, New York
Adjunct Faculty
Dec. 2010 - Aug. 2012

Course offerings:
IT104 - Introduction to Programming
IT143 - Introduction to PC's
IT203 - Database Development
IT306 - Software Application Programming

- Oracle 7x, 8x, 9x, 10 and 11g rdbms, RAC, ASM
- SQL*Plus and PL/SQL
- Microsoft SQL Server 7, 2000, 2005, 2008, 2012, 2014
- Sybase
- Suse and RedHat Linux
- UNIX SUN Solaris OS 2.4 - 2.8, UNIX HPUX
- Digital OpenVMS & VAX/Alpha
- Cobol, CA/Ideal(4GL), CA/ROSCOE
- Apple/Mac operating systems
- Novell Network Systems 2.15 - 3.11
- MS Visio, Project, Access, FoxPro
- Assorted other commercial software

Bay Path College - Postgraduate work in Communications & Information Management

SUNY at Buffalo - Ed.M. in Educational Computing

Canisius College - B.S. in Education

Erie Community College - A.A.S. in Data Processing

United States Marine Corp 1976 - 1978

BZ courses
Teaching Schedule
Institution Course # Course Name Sem Day & Time
Medaille HIA330E Information Systems & Technology Spring Online
MGT362X Information Systems Management Theory Spring Thurs. 6:00pm
UB MFC310 Project Analysis & Design Spring Online