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.

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.

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.

• 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.