Resume of Stephen G. Bergkamp
658 S. Alkire St.
Lakewood, CO 80228
(303) 969-8822
email: sgbergkam@comcast.net

 

Synopsis: 
Database and data warehouse administrator with team lead and management experience in production and development environments in a national and international scope. 

Skills:
Programming Languages:
PL/SQL,T-SQL,K-Shell,C-Shell,HTML,C,Perl,Pascal,Ada,Fortran,SmallTalk.

Operating Systems:
Windows 2003, Windows 2000, HP-UX, Solaris, UNIX, DOS, VMS, Novell, Citrix..

RDBMS:
MS SQL Server, Sybase Oracle, RedBrick, Visual FoxPro

Other Software Experience:
Crystal Reports,Sybase Rep. Server,Oracle 9i, Oracle Spatial, Oracle Financials, Erwin Data Architect, DBArtisan, Starteam, Visual Source Safe, PVCS, Redbrick,SQL - Back Track, Siemens Invision, Siemens EAD/LCR, Siemens Signature, Siemens Novius Data warehouse 4.2,Monarch,SQL Back Track, Patrol

 

Experience:

Production and Development DBA
Cheaptickets.com                                                                   November 2003–Present

• Preformed tuning, backup, 24X7 support, documentation, code management, design, development, and implementation, tasks on Oracle, Sybase, and Microsoft SQL Server production databases.

•  DBA tasks include installing servers, setting SPN, stored procedure code development, testing, and  installation of stored procedures, triggers, DTS packages, and shell scripts

• Assisted in design and implementation of Oracle 9i instances.

•          Designed and assisted with implementation of daily backup routines and monitoring routines on corporate databases.

•          Monitored and managed instances and bi-directional Sybase replication, and MS SQL Server replication.

•          Completed corporate Sarbanes Oxley security and auditing implementation for databases.

 

Database Consultant to DexMedia

Robert Half                                                                     August 2003 – November 2003

•          Preformed tuning, backup, 24X7 support, documentation, code management,   and design tasks on Oracle, Sybase, and Microsoft SQL Server production databases.

•          Assisted in house DBA staff with design and implementation of new Oracle 9i instances.

•          Designed and assisted with implementation of daily backup routines and monitoring routines on corporate portal hosted on Microsoft SQL Server instances.

•          Monitored and managed instances and bi-directional Oracle replication, and Sybase replication on corporate website.

 

Biostatistics Manager/ Data Warehouse Administrator

Denver Health and Hospitals                October 2001 – July 2003

•          Managed team of analysts to produced over 500 reports a year.

•          Managed departmental budget issues.

•          Successfully supported eight million dollar federal grant and joint commission review.

•          Performed DBA tasks on Microsoft SQL Server data warehouse including development, testing and production installation of stored procedures, triggers, DTS packages, and shell scripts.

•          Managed contract staff to install and verify new data warehouse.

•          Saved 12 mandays through converting report creation from FoxPro to SQL Server.

•          Developed and taught data warehouse training.

Senior Database Administrator

Regency Consulting                                             August 2000 – October 2001

•          Perform database manager, design, and replication tasks on production databases and data warehouses supporting corporate web sites.

•          Perform database development tasks on various projects using various RDBMS packages including development, testing and production installation of stored procedures, triggers, DTS packages, and shell scripts.

•          RDBMS packages include Oracle 8 &9i, Sybase SQL Server 11, Sybase Replication Server, Sybase Open Client/Open Server, Redbrick, Microsoft SQL Server, Brio, and Informatica, Crystal Reports, Patrol.

 

Solutions Architect /Database Administrator.

The Interlink Group, Denver CO                                    December 97 – August 2000

•          Performed project manager, team lead, database design, and replication design tasks.

•          Performed DBA tasks on various projects including development, testing and production installation of stored procedures, triggers, DTS packages, and shell scripts.

•          Developed data mart methodology, contributed to estimating methodology.

•          Provided database design and developer tasks on four e-commerce applications utilizing Java and Visual Basic.

•          Contributed to business re-engineering project to double company revenue.

•          Used RDBMS packages include Oracle 8i, Sybase SQL Server 11, Sybase Replication Server, Sybase Open Client/Open Server, Microsoft SQL Server, Microsoft Access, Crystal Reports, Oracle Server and Oracle Financials.

 

College Education:

Old Dominion University, Continuing Education in ADA, C and Calculus.

University of Denver; study in Classical Music Performance and Computer Programming.

 

 

Other Training:

Siemens Medical Systems Training., Oracle database administration courses, Business writing courses., Microsoft SQL Server advanced performance and tuning.

Sybase database design and engineering courses.