Bob Horkay's Resume

Experienced in multiple facets of Leading a SQL Server Database Team. Partnering with Business and Developers to leverage the database backend to provide business value. I have considerable experience in administering SQL Server 2000 and 2005 databases (I won't even admit having worked with SQL 6.5 and 7.0!), from very small MSDE implementations to enterprise applications running terabytes of data complimented with Clustering and other high availability solutions such as Polyserve and EMC BCV's and Clones.

Having worked for many years as a developer and database administrator I have a unique perspective to find the necessary balance of providing data with the flexibility needed by a business to deliver solutions. Working in the enterprise I have gained considerable experience in leveraging SQL Server to ETL; I have have considerable experience using the Visual Studio tools.

With the recent introduction of SQL Server 2005, I have spent considerable time working on upgrades and new deployments. The product itself (SQL 2K5) has matured to a point where it now has many other products as part of the database (Reporting Services, Analysis Services, SSIS Etc). These other products "raise the bar" considerably in what a DBA must know to properly administer the product. Check back on my website to see my extensive knowledge base on SQL 2K5, anyone who claims to know SQL 2K5 (certified or not), is probably not properly analyzing their skill sets against what the product offers!

August 2002 - Present

H&Block

Kansas City, Missouri

SQL Server DBA Team Lead

As the SQL Server Team Lead at H&R Block my job is to provide technical expertise in the planning, design, implementation, and maintenance of SQL server database management systems that support H&R Block business applications. This includes the installation and maintenance of the DBMS Software. In addition to providing day-to-day monitoring, optimizing, database maintenance and developer support. Develop backup and recovery procedures both from an application view point as well as disaster recovery. Define and administer database security requirements.

As the Team Lead in the administration of over 100 SQL Server instances, starting in 2002 with 15 SQL Servers I have grown with product, seeing it evolve from a departmental reporting database to an enterprise database running many of the day to day operations of the business. During this time the scope of management of these servers and instances has grown from a staff of one to a complete department of four DBA's and a data modeler. The administration of these servers has encompassed the standard DBA Tasks of Development, Tuning and replication to include the management of growth, capacity, long term planning and costs.

Recent major tasks include leading a SQL Server consolidation project using HP Polyserve Clustering technology to provide Consolidation, High Availability and capacity on demand, 64 Bit SQL Server Environments and Conversion of SQL Server 2000 to 2005. Evaluating SQL Server 3rd party vendors and culturing a relationship with Microsoft to ensure SQL Server resources are properly utilized

April 2000 - July 2002	Quilogy, Inc.	Overland Park, Kansas
Senior Consultant
As a Senior Consultant at Quilogy my job is to provide a comprehensive background in all areas of the software development life cycle. In this role I have provided consulting services to Quilogy's clients in the roles of Business Analyst, Database Analyst and in a Mentoring role for other development teams. As a Database Analyst I have designed and integrated legacy AS400 DB2 systems with Microsoft SQL Server. I have designed data load and replication procedures between Oracle and Microsoft SQL Server in a distributed environment. While consulting as a Business Analyst my role was to document the feasibility of implementing a new web site using the Universal Modeling Language. I have mentored other development teams in the creation of Intranets and Extranets.

April 1996 - April 2000	DST Systems Inc.	Kansas City, Missouri
Senior Systems Analyst
Primary duties are Project Manager / technical lead for DST FAN Mail, Vision Mutual Fund Gateway (Back office / administration product only) and Consolidated Portfolio Services Products. Primary duties are to enhance and maintain the products, operating hardware, and appraise management of new technologies and solutions. Initial task was the conversion of FAN Mail from a FoxPro 2.0 DOS Email application to an Internet enabled application using FTP in a Windows NT and Unix environment. Other projects included the launch of the new Consolidated Portfolio Services Application and the creation of the Vision Administration programs. Operating environments used were Windows NT 4.0, Unix and MVS. Strong background in the Visual Studio development Environment ( Visual C++, Visual Basic and Visual FoxPro ), Visual Source Safe and Java. Database tools used are DB2 Universal Database and Visual FoxPro.

December 1994 - March 1996	Computer Data Systems, Inc.	Kansas City, Missouri
Sr. Systems Development Specialist
Task Leader on two Visual FoxPro applications involving the complete development cycle. This encompassed project management, system design and programming, development of administration of system policies and procedures, training and troubleshooting. Analyze, document, program, test, and implement a SABRS ( Standard Accounting Budgeting, and Reporting System) Training environment on the mainframe and a PC based emulation as a backup for training. Perform analysis, documentation, programming, and cycle processing of SABRS on the mainframe. Conduct training classes on the use of SABRS and the Personal Computer. Systems knowledge includes IBM compatibles, Novell network, Natural, JCL, ROSCOE, Visual FoxPro, FoxPro 2.x, dBase, Novell network, Microsoft Office, and various application packages.

October 1990 - January 1995	United States Marine Corps	Camp Lejeune, North Carolina
Disbursing Technician
As a database administrator for 2d FSSG Disbursing Office, I directed and designed white work tracking systems and other labor saving programs. I was involved with coordinating the development and implementation of an automated disbursing system. This system was used to track all documents and related work within the office. Responsible for installation, setup, and configuration of all new hardware and software. Maintained database of all system hardware within the Disbursing Office. Responsible for accurately computing Military pay and Allowance of active duty Marines. Conducted classes concerning Military pay and allowances to Marines and their dependents. PC software utilized was FoxPro, dBase and Lotus Smartsuite.