Sql Server Professional Experience

Gary T. Thompson

**** ******* ****, ********* ***** Carolina 28277 (732) 595 - 1745 act16q@r.postjobfree.com

Information Technology Professional

Master’s degree specializing in Information Science and Digital Libraries.

15 years of hands-on experience programming web technology with an emphasis on Information Systems.

Diverse self-taught programming language background in SQL, ASP, VB, CSS, HTML.

Relational database architect with expertise in design including conceptual, logical and physical processes.

Technical Expertise

Web Technologies

Database Technologies

IIS 7.5

WAMP

Visual Basic

UNIX

XHTML

ASP

CSS

Google Analytics

SQL Server 2014 R2

Access 2013

Tableau

Crystal Reports

T-SQL

MySQL

ODBC

Relational Databases

Professional Experience

Unit Computing Manager / SQL DBA, April 2002 – August 2015

Rutgers University, Institute for Health, Health Care Policy and Aging Research, New Brunswick, NJ

Administrator responsible for all Web and Database projects in the department. Created/Supported distributed database driven ASP web pages utilizing Microsoft Access as well as SQL Server on the backend. Researched, procured and supported over 200 computing systems for over 150 users on and offsite for both the Institute for Health as well as the Center for State Health Policy. Maintained a proactive approach to user support by initiating effective information science techniques which allowed for solid knowledge transfer with the user population.

Administered multiple database migrations starting with SQL Server 6.0 and ending with SQL Server 2008 R2 including recovery from a few major security breaches at the university.

Improved the efficiency of the previous database architecture, developed, maintained, and debugged thousands of lines of dynamically coded Internet applications with SQL/Access backend databases for information dissemination.

Added Transact SQL coding in the form of stored procedures which improved web database connectivity as well as security for the production SQL server.

Established multiple web reports containing statistics information for main websites with an average of 3000 hits a month using Symantec Webtrends and Google Analytics.

Administered major dynamic website migration working with an outside consultant to construct an ASP.NET site with Microsoft SQL server backend. At each critical release performed multiple “smoke tests” for quality assurance on the working model of the site and guided the process to completion.

Designed / Configured an SQL data solution for a high performance dell workstation on a secure LAN for large data set 60 Gigabyte in size. This solution involved SQL Server 2014 and an external RAID 5 array with tiered security policies to make sure the data analyst had the necessary access to the SQL data but not control of the database itself.

Created a WAMP server using IIS 7.5 and Windows 2008 R2 Server. Installed / Configured the Joomla 3.3 CMS and J/Events module for departmental event scheduling of the shared conference rooms.

Managed part-time and student staff in various areas from training and orientations to interviewing and assigning of long and short term projects.

Performed countless orientations & created vital instructional materials for end users and computing staff to decrease time spent troubleshooting recurring issues and increase time spent on long-term projects.

Gary T. Thompson

Professional Experience

User Support / Web Programmer, September 1999 – April 2002 Rutgers University, Office of The Vice President for Continuous Education & Outreach, New Brunswick, NJ

Converted the Summer Session paper catalog containing over 200 categories for Rutgers Summer Session into a cohesive website that would allow students full access to information. Installed and maintained multiple Red Hat Linux and Windows workstations in a hybrid work environment backed by Linux servers for file storage and group collaboration. All coding was done in Unix on an Apache server that also ran without the need for third-party software products.

Ordered, installed, updated, and secured computer hardware and software for over 60 office staff members.

Provided expert technical support for multiple buildings on different campuses which increased user efficiency.

Web programmer for Rutgers Summer Session Catalog Online for two years. Worked with a team of three to design and code the product.

Installed a Red Hat Linux Firewall Server to protect Intranet traffic.

Database Programmer, December 1998 – May 1999 Rutgers University, Learning Resource Center, New Brunswick, NJ

Utilized computer science expertise to apply to a massive database project on Macintosh system utilizing Filemaker Pro 3. Repaired numerous faults left from previous database programmer’s creations that included the student payroll tracking system as well as the student/tutor database system for the entire University.

Incorporated programming knowledge and scripting theory into database system creations with only a prior 45-minute evaluation of Filemaker Pro.

Re-invented large database for all of Rutgers Learning Resource Centers containing over 10,000 records.

Created and updated various multi-user database management systems for center personnel.

PC Lab Specialist, May 1997 – September 1999

Rutgers University, Dimacs Research & Education Institute (DREI), New Brunswick, NJ

Lead computing personnel in charge of computing lab as well as website for DREI program for all three years of the program. Formulated user-friendly curriculum for novice users for introduction to the computing lab.

Constructed multiple websites based on teacher labs and overheads that required a cohesive transfer from paper to web for every year of the DREI 96-97-98 programs.

Conducted training workshops for education program participants on computing and working in a network environment which enabled them to perform daily computing assignments.

Assisted teachers and researchers in daily computing needs, which included extensive email assistance due to variations in user home in a windows network environment.

Educational Experience

Rutgers School of Communication & Information, New Brunswick, NJ

Master of Library and Information Science, 2013 GPA: 3.7

Rutgers College, Rutgers the State University, New Brunswick, NJ

Bachelor of Arts in Computer Science, May 2001

Microsoft Hands-On Security Training, 2004

SANS GIAC Security Essentials Training (GSEC), 2002

Contact this candidate