Vince Collogan
Columbus, Georgia

Contact

Recruiters, please note: 
I am not interested in temporary, temp-to-perm, contract-to-hire, or any other type of contract job.

HIGHLIGHTS

• Self-starter, hard-working and goal-oriented Microsoft SQL Server Database Administrator and Data Analyst with a strong background in network and Windows operating system administration and support.
• Problem-solver with a history of achieving excellent results with high customer and co-worker satisfaction.
• Able to reach goals using current skills, by acquiring new skills and by working with diligence.
• Team player and team leader.

EDUCATION

Florida State University
         Part-time graduate student in the Master of Science in Management Information Systems (MS in MIS) program (Graduating after the Summer semester of 2008)

Saint Petersburg College
         Bachelor of Applied Science in Technology Management
(2004)

Various SQL Server, information technology, and management related education / seminars / training courses (1999 to current)

Saint Petersburg Junior College
         Associate in Science: Computer Information Systems-Network Systems (1998)
         Certificate: Networking Systems Specialist (1998)

EXPERIENCE

10/2007 - current: TSYS - Lead Client-Server Software Analyst / Database Administrator

Perform all Microsoft SQL Server related duties for the Finance Division.
Ensure high performance and availability of backend databases for Microsoft Dynamics AX ERP system and other applications used by Finance.
Create and maintain queries and stored procedures, and perform other T-SQL programming.
• Provide SQL queries to software developers and analysts.
Automate database maintenance tasks using maintenance plans and SQL Agent jobs.
Scheduling and assurance of backups.
Perform code migration tasks for Dynamics AX X++ code and hot fixes.
Index monitoring and tuning, hardware and network status monitoring and other items related to database performance.
Design and maintenance of SSRS (SQL Server Reporting Services) reports.
Windows Server system administration.
Technical application support for Dynamics AX and other applications used by Finance.

04/2000 - 09/2007: Flash Data, Inc. - Database Administrator / Data Analyst

Sole DBA, performed all Microsoft SQL Server related duties including but not limited to: 
- Design and maintain multi-million record databases
- Stored procedures, triggers, queries, and other T-SQL programming
- Relational views and database diagrams
- SSIS (SQL Server Integration Services), DTS (Data Transformation Services) and BCP (Bulk Copy)
- SQL Agent job scheduling
- SQL Server and file server backups
- Security and user administration
- Index tuning and other database performance issues
- Automated updates
- T-SQL scripts for merge/purge and other data processing tasks
Organized, normalized and increased performance of several, multi-million record databases.
Responsible for over 300GBs of SQL Server data consisting of several hundred million records in multiple databases.
Increased disaster recovery preparedness.
Data modeling and statistical analysis.
Create and maintain complex MS Access queries, forms and reports.
Upgraded database servers from Windows NT 4.0 and SQL Server 7.0 to Windows 2000 Server or .net Server (2003) and SQL Server 2000. Upgraded from SQL Server 2000 to 2005.
In-depth experience with service packs and upgrades.
Maintain and troubleshoot local area network (LAN) and virtual private network (VPN) connectivity and performance, including remote administration of SQL Servers.
Compile and manipulate data from various sources into marketable databases.
Creation of relational databases for use in custom software application.  

02/1998 - 03/2000: Contractor for IBM (End User Support - Global Services Division) - Senior Technical Support Representative

Provided operational and technical support for IBM customers at a Level II/Level III helpdesk.
"Subject Matter Expert" for all supported database and spreadsheet applications.
Certified Microsoft Office Expert Specialist in Access and Excel.
Maintained and distributed Customer Satisfaction and other reports through Access and Lotus Notes.
Performed technical interviews.
Mentored and trained other employees including teaching in a formal classroom environment.
Maintained consistent 100% satisfaction rating on customer surveys.
IBM certified on Lotus Notes and Domino Server administration.  

09/1994 - 02/1998: PrimeNet Marketing Services - Senior Computer Operator

Assisted IS Manager with troubleshooting, repair and upgrades to Novell NetWare and Windows NT networks.
Manipulated data and created projects using FoxPro.
Data Processing.
Wrote FDL and PDL scripts for Xerox commercial laser printers.
Trained and supervised employees in Data Processing and Laser Print departments.
Experience with AccuMail and PostalSoft address processing software.

09/1992 - 09/1994: Master Mailers - Computer Operator / Laser Printer Operator

Prepared data using Accumail and custom software.
Performed PDL (Printer Definition Language) script programming.
Setup and ran print jobs on Xerox commercial laser printers.
Maintained laser printers.

06/88 - 06/92: U.S. Navy - Gunners' Mate

Graduated in top ten percent of class in Electrical and Electronics school.
Part of a team that maintained, operated and repaired all shipboard gun and missile systems.
Active participation in Desert Storm (veteran of foreign war).
A lead member of the Ship's Security Force.
Honorably Discharged in 1992.
 

AFFILIATIONS  

• Professional Association for SQL Server (PASS) member.

St Petersburg College alumnus.

• Part-time graduate student in an MS in MIS program through Florida State University (graduating after the Summer semester of 2008). Current GPA: 3.83.

Contact