John Tavenner Jr Email & Phone Number

Columbia, Md, Us

http://www.thorntech.comLocated just outside Baltimore, Maryland, Thorn Technologies LLC is a software development and consulting firm that specializes in building end-to-end mobile software solutions. We excel in delivering large-scale, enterprise mobile solutions as well as professional mobile websites and cutting-edge iOS and Android applications. Our work includes the development of location-based content management systems, data warehouse & analytics systems, real-time alerting and messaging platforms, bulk SMS & MMS marketing platforms, and mobile applications and websites for Fortune 500 companies including Sprint, Nokia, H&R Block, & Caesars Palace.

Baltimore, Maryland, Us

• Responsible for primary support for over 250 Microsoft SQL Server instances which contained over 3000 databases and housed multiple Terabytes of business critical data.• Installation, upgrade, configuration, and support of Development, QA, and Production Microsoft SQL Servers versions 7.0, 2000, 2005, 2008 and 2008 R2 on standalone and clustered Windows servers• Responsible for backup and recovery of critical production data and updates to QA and Dev environments utilizing SQL Server maintenance plans, SQL Litespeed, and IBM Tivoli Data Protection products.• Created and implemented detailed Disaster Recovery procedures for all critical database systems including MSSQL Server, Sybase SQL Anywhere, MySQL, and PostgreSQL.• Responsible for primary support (including installation, configuration, and upgrades) of Development, QA, and Production Oracle Hyperion Essbase servers.• Worked with the T. Rowe budget support team to test and upgrade Hyperion Essbase version 7 to Oracle Hyperion Essbase version 11.

• Primary support for Development, QA, and Production Microsoft SQL Server 7.0 and 2000.• Install and configure multiple instances of SQL Server 2000 on various platforms.• Install, configure, and maintain SQL 7.0 and SQL 2000 log shipping disaster recovery databases.• Create complex DTS packages and stored procedures including error handling and statistics for a critical reporting Data Mart.• Install, configure, and general administration of MicroStrategy reporting platform.• Support of reporting needs by creating ad-hoc reports and enhancing existing reporting methods.• Support of the Development team including but not limited to, script creation, JDBC driver support, VBA and Access support, and review and optimization of code.• Responsible for data migrations, data refreshes, database modifications, and security implementation on all SQL servers.

Us

• Installed, maintained, and provided 24-hour support for 70 Microsoft SQL servers of versions 6.5, 7.0, and 2000.• Implemented and maintained disaster recovery plans using SurviveIT 2000 providing 24x7 availability for production SQL servers at multiple site locations.• Configured and maintained central management SQL servers dedicated to companywide SQL backups, task management, and DTS package management.• Established and supported Development and V&V database environments.• Performed data conversions and migration of data using DTS packages, BCP, and DBArtisan 5.1.• Managed SQL server logins and permissions ensuring proper security for all servers and applications.• Installed and configured Windows 2000 Server for deployment of SQL 2000 upgrades from SQL 7.0.

• Researched and implemented hardware and software configurations designed to improve efficiency and reliability for all SQL servers.• Performed SQL server upgrades and conversions of character sets/sort orders using BCP and DBArtisan.• Implemented disaster recovery plans consisting of disk based SQL backups, tape backups using Arcserve 6.61, offsite storage rotation of tapes, and hot spare servers.• Implemented upgrades of all SQL servers from version 6.0 to version 6.5 SP5a.• Monitored and tuned performance of daily SQL server operations and reporting processes.

Us

Microsoft SQL Server database support and Novell/Windows network support.