VB .net, Sql Developer, SSRS, SSIS

Jerome S. Stelmach

** ******** *** *******, ** **075 716-***-**** ***********@*****.***

OBJECTIVE

To secure an opportunity with a progressive organization that values a strong work ethic and a positive contribution.

PROFESSIONAL SUMMARY

●Over 35 years of professional software development, database administration, report generation combined with personnel and project management

●Detail and results-oriented professional with excellent people, communication, project management, presentation, motivation, and development skills

●Strong technical background, giving me the ability to adapt and learn new products and technologies very quickly

EMPLOYMENT HISTORY

Avox Systems, Lancaster NY 3/14 - Present

●Sr. Systems Analyst/DBA responsibilities/tasks/highlights …

●VB.Net/SQLServer App development - Full Stack (both replacing MS Access apps and creating new apps)

●Build SSIS packages for data integration between Progress and SQLServer DBs

●Create SqlServer online reports (SSRS)

●Build SQLServer Stored Procedures for table loading and reports.

●Daily tasks include – Oracle 11gR2 & SQLServer database performance maintenance, Oracle backup & recovery

●Maintain and migrate MFGPro Progress databases.

Baillie Lumber, Hamburg NY 7/13 – 2/14

●Sr. DBA responsibilities/tasks/highlights …

●Daily tasks include – Oracle 11gR2 & SQLServer database performance maintenance, SQLServer backup & recovery

●Migrated production SQLSever 2005 database from Windows 2003 server to vSphere VM

●Upgraded SQLSever 2005 database to SQLServer 2012 on VSphere VM Running Windows 2008

●OBIEE 11g administration & report/analysis development

Seevast, Amherst, NY 1/01 – 4/13

●Sr. DBA responsibilities/tasks/highlights …

●Daily tasks include – SQL tuning, performance maintenance, monthly/nightly processing, backup & recovery

●Migrated production Oracle 11GR1 database from Sun 6900 to Sun 1280 (Solaris 10) w/SAN storage to Hitachi disk array

●Setup ‘Poor Man’s Dataguard’ (applying rsync’d archivelogs to quiescent database)

●Upgraded production & test Oracle 9iR2 databases to 11GR1 databases

●Setup OEM grid control 10.2.0.5

●Built multiple Mysql replicated databases on linux servers for application caching

●Migrated production Oracle 9iR2 database from Sun 880 to Sun 6900 (Solaris 9) w/SAN storage to Hitachi disk array

●Assisted in setting up Netbackup 6.0 using Shadow Image technology on Hitachi disk array via SAN

●Upgraded production & test Oracle 8i databases to 9iR2 databases

●Migrated production Oracle 8i database from Sun 450 to Sun 880

●Migrated production Oracle 8i database from VA site to Buffalo site ( Sun 450)

●Setup RMAN for backup and recovery using Veritas 5.0

ClientLogic, Buffalo, NY 9/99 – 12/00

●Informix (HPUX 10.20), SQLServer 2005/2008 & Oracle 7.3/8i (HPUX 11.0) Site DBA responsibilities including …

DBA for Installation, upgrade, maintenance, backup and support of Client and Customer databases

Installed and configured Veritas 3.4 NetBackup software

Kaleida Health, Buffalo, NY 12/98 – 6/99

●Oracle 8.0.5 (HPUX 10.20) Site DBA responsibilities including …

DBA for upgrade, maintenance, backup and support of Lawson Financial Systems Application (Oracle8)

West Valley Nuclear Services, West Valley, NY 12/97 – 11/98

●Oracle 7.3.4 (NT 4.0) Site DBA responsibilities including …

Development and Implementation of Training Server MSAccess/VB/SQLBase Application modules

EDMS Oracle7 Application database development, installation and backup strategy planning and implementation

AlliedSignal, Information Systems & Services, Buffalo, NY 5/90 - 12/97

●DBA/Application Developer of Buffalo Research Lab database applications including ...

●A MSAccess/VB/Oracle refrigerant property database application for searching of corporate refrigerant data

●A MSAccess/VB/Oracle site budgeting/project expense application

Calspan Corp., Transonic Wind Tunnel Dept., Buffalo, NY 10/85 - 5/90

●Modified & implemented algorithms for reduction of transonic wind tunnel data using FORTRAN

EDUCATION

●12/12 – Oracle 11gR2 RAC, ASM, Dataguard, Golden Gate training via Oracle University

●2/02 – Oracle 9i New Features for DBA Training

●5/00 – RedBrick Data Warehouse Admin Training

●10/99 – Informix 7.3 DBA Training

●5/96 – Oracle7 Backup/Recovery Certification Training

●3/96 – Oracle7 DBA Certification Training

●5/85 - Bachelor of Science in Computer Science, Minor Concentration in Chemistry,

Canisius College, Buffalo, New York.

Contact this candidate