John Kroneberger Email & Phone Number

Highlands Ranch Co

 Provided Prod/Stg/Dev/UAT Database Administration on multiple SQL 2005/2008R2/2014/2016 Servers including Large Data warehouse.  Upgraded and Maintain Prod/Stg/Dev/UAT to SQL 2014 including Clustered, Mirrored, and Availability Group configuration.  Maintained business critical daily night cycle including Replication, Performance tuning, SSIS maintenance, Stored Procedures and Views. Work with Developers to implement best SQL practices and policies.Review and update all SQL objects including SSIS packages, Reports, Sprocs, Views, Functions, and Triggers.Assist with Prod Data Migration to East Coast Data Center.

Centennial, Co

Provide Prod/Dev Database Administration on multiple SQL 2012 Servers. Develop and Maintain SSIS Packages, SSRS Reports, Stored Procedures, Views, SQL Replication, Data Maintenance Plans, and SQL performance tuning.Upgraded existing 2008 R2 to SQL 2012 environments, including SSRS and SSISDeveloped and Maintain Tableau 8.1 Reports and Dashboards

Greenwood Village

SQL Database Administration:- Provided Production/Development Database Administration on multiple SQL servers including versions 2000, 2005, 2008(R2), and 2012. Duties include, SSIS / SSRS Development, TDE Encryption, Transactional Replication, Database Mirroring, Log-Shipping, Maintenance Plans, SQL performance tuning, Virtual Server Migration, and implement and migrate to SQL 2012.- EMC Replication and HP Virtual Copy to build Test, Beta, and Training Environments.- Upgraded to MS SharePoint 2012 and assisted with Administration.

Arapahoe County Government

 Provide Database Administration on multiple SQL servers including versions 2000, 2005, and 2008 R2. Develope/Design Database, Stored Procedures, views, and SSIS packages for reports and applications. Administer BMC Remedy 7.6 including users, workflow, and ITIL processes. Administer secondary support on SAP Basis Administration including patches and upgrade. Administrator for License Plate Reader (PIPS) for Sheriff Department. Supported Applications and Database for MugShot System. Implemented administration support for Documentation Management System EDMS.

Migrated Brio Intelligence suite to Hyperion Performance suite 8.3Provided Database Administration, maintenance, and support of multiple SQL Servers.Executed Oracle9i and Sybase 6.x Production Database Administration support. Primary support on Remedy BI System and DatabaseDeveloped knowledge of SAP BW 3.5 environment and integration with Hyperion PS 8.3.1

Expedited and troubleshot support tickets requiring Microsoft SQL Server and Database knowledge as well as network and other expertise.Assisted customers through e-mail and phone support and dispatched hotfixes and patches as necessary.Utilized knowledge of HEAT, SQL Server, and Clear Quest

Mcts Mcdba Mcse, Sql Server Administration / Development

Activities and Societies: MCTS - SQL 2008 Administration

Computer Science, System Engineer, Database Administrator

Chmistry, Chemical Engineering