Consulted for TEKsystems at Select Portfolio Servicing. I was one of two Database Developers for DispoSolutions Real Estate Management Software. Software that will help manage and sell millions of dollars of real estate nationwide and is critical to the future of the company. I designed databases, tables, triggers, wrote thousands of lines of SQL code in stored procedures. Set up two way transactional replication over a secure point-to-point VPN for data sharing with another company using the software. Upgraded many Data Transformation Services (DTS) packages to SQL Server Integration Services (SSIS) packages for use on SQL 2005 and 2008. Configured SQL server tuning, monitoring and database mail on multiple SQL Servers for use in text message and email alerts and notifications to support staff. Created SQL Agent Jobs that run by the minute, hour or day to automate data import and export from other companies and complete database tasks and maintenance. I created all of the written and visual technical documentation for this project.

I consulted primarily on IT and database administration for small businesses. MySQL 4 to MySQL 5 database migration for upgrade to new version of Xoops software, had to design custom SQL stored procedures for data migration and security rights creation. Hired to verify data integrity of MS SQL 2005 database for medical office worried about data loss. Changed database backups from tape based to file based solution with database file storage over the Internet improving restore time. For many small businesses I have done the following. Router configuration for Internet access, DNS and DHCP setup, computer and printer setup, network cable installation, Windows Server 2003 domain setup and configuration for users and groups, virus and spyware software setup for domain, office software installation.

The company was small and lacked a quality assurance (QA) environment with proper methodology and practices. This became the top priority for the company as software delivery dates were approaching and software bugs had to be found and corrected in a much more efficient manner. Because of my experience in IT, database administration and software engineering, I was asked if I would become quality assurance team lead to design and implement a QA solution. I was assigned two full-time engineers as team members, given a budget and five months to have the QA environment working. My team worked very hard on the design of an automated software test environment that would free company software engineers from manual testing. Because of the nature of our company software, we could not use a simple QA lab with virtual machines to conduct testing. We needed a complex test environment with multiple servers, twenty computers and five networks. I lead the team to design a solution, I purchased and setup all equipment, then conducted tests until the QA environment could be verified as working correctly. My team was able to do this under budget and one month ahead of schedule.Write automated test software in Java, C# and C that does unit, integration and system testing, black and white box testing, performance and security testing, etc. for all company software.Administer all company database servers (MS SQL 2005, MySQL 5). Design and create all databases, tables and stored procedures to store massive amounts of QA test data. Write software that creates dynamic HTML pages based on queries to the test database. These pages can be shown securely in a browser to any company employee in the USA or Japan who has rights to view test results.Meet with other team leads and software engineers for software design meetings to discuss best practices, attend code reviews and assist engineers with individual debug issues.

Work as part of a team in a multi-team environment to design, code, test and release company software. The primary language used by my team was Java, but I also improved other language skills in C# and C so I could work with other teams when assigned or function as a backup for any team member.The company had one IT employee with little database experience, so I also worked as a backup for IT and as the database administrator (MS SQL 2000/MySQL 5) in the company.

Design and create company and customer databases, tables, views, triggers, and stored procedures. Write database queries, reports, and data transformation Services (DTS) packages. Work in a team environment with software engineers to design, develop, and deploy software utilizing the databases for online transaction (OLTP) and analytical (OLAP) processing functions.Administer all database servers, MySQL 4 and MS SQL 2000 single instance servers and two MS SQL 2000 clustered server environments. Purchase server hardware and software platforms for multiple environments (Development, Quality Assurance and Production) that maximize cost savings, stability and uptime, ease of development and code updates, scalability under light to heavy usage, security, fail over/redundancy, and administration simplicity. Configure database clustering, replication, data import/export, alerts, logs, maintenance schedules, backups, security, software patches, user accounts, and performance monitoring/tuning.

Architect and implement automated build processes for over 4,000 computers at all venues during the Olympic games. Define and document computer hardware, operating system, and application software specifications. Engineer development, quality assurance, production, and distribution processes to ensure accurate and timely delivery of computer systems.Create all software components including, operating system images, security policies, application software installation, update, and removal packages. Write shell scripts to configure the operating system, registry, user interface, and application software. Write build scripts to automatically load correct operating system image, application software packages, and configuration shell scripts based on computer type and venue location.Design computer asset management and software distribution solution utilizing, LANDesk software, onsite computer imaging, software package delivery, hardware and software inventory database with secure online reporting, remote control and help desk support. Produce web based training and operational documentation for technical support and volunteer staff.

Manage computing resources for 12,000+ students and faculty, including all servers, switches, networks, computer labs, microcomputers, software, and peripheral equipment in the Center for Student Computing facilities.Administer student information systems including, IIS web servers, online registration, e-commerce server, student information databases, telephone registration, online tuition and bookstore payments, user accounts, and help desk system.Define student computing operational policies and procedures. Conduct staff and faculty training. Automate management and support tasks through computer imaging, software packaging, software distribution, security policies, and operating system shell scripting.

Support 3500+ faculty and staff, install and administer all servers, switches, networks, microcomputers, software, and peripheral equipment. Respond to faculty and staff problems and questions by phone, onsite support, and conduct training courses.