Andrew Liles

I am seeking a challenging and responsible position as a SQL Database Administrator that would use my current education and job skills to the fullest

Ajilon Consulting Inc On location at U.S. Bank                                Cincinnati, Ohio

SQL Database Architect / SQL Programmer and ASP Developer

·      Member of a Project Team Developing SQL 2000 Databases

·      Administered, Maintained, Secured and Programmed SQL 2000 Database Server

·     Converted Existing Access Data to SQL 2000 using SQL Programming

·      Developed ASP and SQL 2000 Data based Website

·      Transferred Data using BCP and DTS Programming in SQL 2000

·      Performed and Maintained Windows 2000 Server and SQL 2000 Database Backups

·      Programmed SQL 2000 Stored Procedures for Database Performance Enhancements

·      Developed ASP Website to show Team Database Documents and Projects

·      Created New Databases, Tables, Triggers, and Views using SQL 2000 Programming

·      Consulted and Worked Directly with Project Managers on Multiple Database Projects

CheckMark Inc                                                                      Cincinnati, Ohio

SQL Database and Systems Administrator

·     Administered Several IIS 5 Web Servers and ISA Firewall Servers for 400,000 Users

·     Administered, Maintained, Secured and Programmed SQL 2000 Database Server

·     Converted All Existing Access Data to SQL 2000 using SQL DTS Programming

·     Developed ASP and SQL 2000 Data based Website for 400,000 Users

·     Performed and Maintained Windows 2000 Server and SQL 2000 Database Backups

·     Programmed SQL 2000 Stored Procedures for Database Performance Enhancements

·     Used SQL 2000 DTS to Update All  SQL 2000 Database Servers in the Server Farm

·     Created New Databases, Tables, Triggers, and Views using SQL 2000 Programming

·     Monitored Windows 2000 Server Performance and Server Performance Tracking

·     Maintained Windows 2000 Servers and SQL 2000 Database Security and Integrity

Applied Card System                        Ashland Kentucky and  Huntington, W. Virginia

CTI Engineer / Network , Systems, and SQL Database Administrator

·     Administered Several NT, 2000, Sun Solaris, and AIX Unix Servers for 5,000,000 Users

·     Administered, Developed and Maintained Database Integrity and Security

·     Program, Maintain, Secure and Administrate SQL 6.5 and SQL 7.0 Databases

·     Maintained All Aspects of LAN and WAN for 5,000,000 Users

·     Project Management for Multiple Projects, All Completed Ahead of Schedule

·     Used DTS to Convert Data from Different Formats to SQL

·     Moved Large Amounts of Data via Stored Procedures, DTS and BCP

·     Created Triggers, Stored Procedures and Replication Procedures

·     Developed Backup Strategies and Plans for Multi Site SQL Servers

·     Developed ASP Pages to Monitor, and Maintain Servers, and Databases Remotely

CNS Internet                                                                          Carlsbad, California

Senior Systems Administrator and SQL Database Administrator                                                      

·     Designed SQL Databases for Tracking and Administration of our 12,000 Internet Users

·     Administered, Maintained, and Secured Multiple SQL Servers and Databases

·     Tested and Documented SQL Backup and Recovery Methods

·     Designed, Developed and Populated SQL Databases with User Information

·     Developed SQL 6.5 Databases for Internet Use, Website Development

·     Developed ASP and SQL Pages to Monitor Servers Remotely

·     Programmed SQL 6.5 Server Stored Procedures

·     Maintained and Developed Security using Routers and NT 4 Operating Systems

·     Planned, Designed, Developed and Maintained SQL 6.5 Database for Authentication

·     Built, Maintained, and Administered Workstations and Servers for 55 in-House Users

Time Warner                                                                          San Diego, California

Fiber Optic Technician                                                      

·      Completed Splicing and Testing Over 2 Weeks Ahead of Schedule

·      Converted Multiple Users SQL 4.2 Databases and Flat Files to SQL 6.0

·      Created a SQL 6.0 Database for Data Tracking of Fiber Optic Locations

·      Implemented Splice Diagram and Spreadsheet from SQL 4.2 and 6.0 Databases

·      Converted Spreadsheets to SQL 6.0 Database for Web Browser Integration

Chemtronics                                                                         San Diego, California

Telecommunication Engineer                                                     

·      Provided Voice and Data Service to over 1,000 Users

·      Implemented SQL for all Company Database Requirements

·      Used SQL 4.2 and 6.0 Databases for Inventory and Progress Tracking

·      Converted to SQL 6.0 from Multiple Small Database Platforms

·      Maintained an Exact Inventory of All New Equipment and Supplies Using SQL Database

Qualcomm Inc.                                                                     San Diego, California

Corporate Telecommunication Engineer                                                     

·      Generated SQL 4.2 Database for Inventory Tracking of Phone Numbers

·      Integrated Accurate SQL 4.2 Database for PBX Punch Down Blocks

·      Provided Phone Service to over 8,000 Users at Multiple Sites Worldwide

·      Converted Sybase Database Files and Other Formats to SQL 4.2

·      Designed Voice and Data Systems for Multiple Sites Worldwide

Operating Systems (OSs): Windows NT 4.0 Server, Windows 95/98, Windows for Workgroups, Window 3.x, OS/2, MS-DOS, SCO UNIX, Linux, Windows 2000 Server

Services : Post Office Protocol 3 (POP3), Simple Mail Transfer Protocol (SMTP), Network News Transfer Protocol (NNTP), IIS 4.0, IIS 5.0

Domain Name Service (DNS), File Transfer Protocol (FTP), Trivial File Transfer Protocol (TFTP), World Wide Web Service (WWW) , ISA Firewall                                   

Vendor's Equipment: Fore, Cisco, Ascend, Intergraph, 3Com, StrataCom, Cascade, Intel, HP, Sun, Digital, Compaq, Bay Networks, WhiteTree, Novell                                                            

Web Site Development: HTML, JAVA, Active-X, CGI, Perl, Active Server Pages

Programming: Visual Basic 6.0, BackOffice, SQL Server 6.5, SQL 7 & SQL 2000 Oracle, Visual Interdev 6.0, Visual C++, Visual J++, FoxPro, Access97, RPC, ActiveX                         

Software: Internet Browsers, E-mail Clients, Server Networking, Adobe Suite, Microsoft Office Suites, Quicken 2002, CuteFTP, Ultra Edit, mIRC, Visual Studio 6.0, QuickBooks, OCR, Adobe PhotoShop 4.0, Adobe Illustrator 7.0, PGP, SDK, Lotus Notes, Visual Café, WinZip 7.0, Visio 5.0, Apache, WordPerfect, Plus many others

Donated Computers and Networking Equipment for Carlsbad Senior Center Computer Lab

Volunteered Time to Build Computer Lab at Carlsbad Senior Center

Donated Internet Service for Carlsbad Senior Center and Other City Projects in Carlsbad

Volunteered as Computer Users Group Leader at Carlsbad Senior Center

Held a Top Secret Military Clearance

Member of the Microsoft Beta Testers Team

Assistant Technical Consultant for Elisabeth A. Parker, Author

February 1994-June 1994      AT&T Fiber Optic School      University of Arizona

Fiber Optic Technician Certification                                                      Certified

June 1994                   Helix Cabling School                 San Diego State University

Helix Cable Splicing and Termination Certification                             Certified

January 1992-January 1994    ITT Technical Institute        San Diego, California

Electronic Engineering

Graduated January 1994           GPA-3.9                                   Associate Degree

February 1988-September 1988      United States Navy Aviation Electronics                           

Aviation Electronics

Graduated September 1988      GPA-4.0                                   Associate Degree

September 1997-March 1998 Adv. SQL Server Administration Ziff Davis Univ

SQL Server 6.5                                                                          (via the Internet)

Graduated March 1998                      GPA-4.0                                    Certificate

September 1997-March 1998  Adv. SQL Server Programming Ziff Davis Univ

SQL Server 6.5                                                                         (via the Internet)

Graduated March 1998                      GPA-4.0                                   Certificate                                                 

August 2001-May 2001   SQL Server 7 Administration    Ashland Comm Coll

SQL Server 7                                                                       Ashland, Kentucky

Microsoft MSDBA Certification Training

September 1997-March 1998  Adv. Java Programming   Ziff Davis University

Advanced Java                                                                      (via the Internet)

Graduated March 1998                    GPA-4.0                                  Certificate

September 1997-March 1998 Adv. Visual Basic 5 Programming Z. D. Univ

Advanced Visual Basic 5                                                       (via the Internet)

Graduated March 1998                     GPA-4.0                                 Certificate

March 1996-September 1997 Visual Basic 5  Programming  Ziff Davis Univ

Visual Basic 5  Programming                                               (via the Internet)

Graduated September 1997        GPA-4.0                                       Certificate

March 1996-September 1997     Java Programming     Ziff Davis University

Java Programming                                                             (via the Internet)

Graduated September 1997        GPA-4.0                                     Certificate

August 2001-May 2001   Cisco CCNA Certification    Ashland Comm Coll

Cisco CCNA Certification                                               Ashland Kentucky

Cisco CCNA Certification Training                                                     

August 2001-December 2001    C++ Programming     Ashland Comm Coll

C++ Programming                                                         Ashland Kentucky

Microsoft MCSD Certification Training