Sql Server Engineer

John Wysocki

**** ** ** *******

Kansas City, Mo. 64118

http://www.itadministrator.info

aborqp@r.postjobfree.com

Home 816-***-****

Cell 816-***-****

Summary:

System Administrator experienced in Microsoft, Linux and Unix Servers with expertise in Sys Admin, Networking, Security.

Network Servers: Microsoft Server 2003 /Server 2008, Sun Solaris 9, Active Directory, DHCP Server, DNS, WINS Server, FTP Server, Terminal Server, MS SQL 2008, Microsoft NT 4.0 Server, MS Systems Management Server (SMS), Red Hat Linux Server, PostgreSQL (PGSQL) Server, Remote Access Server (RAS), DHCP Server, Exchange Server, (Veritas) Backup Exec, GraphOn GoGlobal Server, MS Internet Information Server 4.0, Apache Web Server, and Print Server.

Operating Systems: Microsoft Windows: 3.1, 3.11, 95, 98, NT 4, 2000, XP, and XP Professional, UNIX: Sun Solaris 9, SCO Open Server V. Linux: Red Hat 7, Red Hat 8, Fedora Core 4. Macintosh: System 6, System 7, and System 7.55.

Database Software: PostgreSQL Server, Microsoft Access 2003, Microsoft SQL Server 2003, Microsoft SQL Server 2008. Navicat, PGaccess, PHPpgadmin, PCaccess, PGadmin 3, Open Office Base, and EVA3 Database Converter.

Security Software: Wireshark, Microsoft Baseline Security Analyzer (MBSA), Nmap, Microsoft Network Monitor, Clam Antivirus, McAfee Antivirus, Symantec Norton Antivirus, Trend Micro Internet Security, ZoneAlarm, Ethereal, ClamAV, Computer Associates (CA) eTrust, Information Assurance Vulnerability Alert updates (IAVA), and Ad-Aware.

Security Clearance: DOD Secret Clearance, HSPD-12 MBI

EXPERIENCE:

Comtech LLC Kansas City, MO (May 2010 – Present)

IT System Admin Specialist for Government Services Administration (GSA) Contract at the Bannister Federal Complex of Kansas City MO. Part of a 2 Billion Dollar American Recovery and Reinvestment Act of 2009, (ARRA) which includes (major upgrade to Building Automation Systems and also installing IP based advanced utility metering systems which interface to Government BAS systems as well as a SQL server in Washington DC. Support the planning and design review of how theses upgrades will be integrated into the existing backbone of the GSA network at various sites. Supplement the support of existing GSA IT personnel and work directly with the Design and Construction Division project managers for each building to insure that we have a robust and secure design of the network infrastructure. BAS upgrades and advanced metering (Region 6) includes Federal Buildings in North Platte NE, Grand Island NE, Omaha NE, Sioux City IA, Des Moines IA, Davenport IA, Wichita KS, Topeka KS, KCKS, KCMO, and St Louis MO.

Computer Science Corporation Leavenworth, KS (January 2007 – October 2009)

Senior System Administrator at the US ARMY DLDC Army Battle Command System (ABCS) and the FAA Flight Control Center. Administration of Sun Solaris,MS Server 2003 Red Hat Linux servers. Upgrades of system hardware and software as required. Installation of Windows XP, Windows 2003 Server, Windows Vista, Solaris, Red Hat Linux operating systems. Installation of system Adaptations and Security patches as necessary. Manage and documentation of system events to ensure integrity of servers. NTFS system level commands. Set up of network for Global War Games. Installation of Information Assurance Vulnerability Alert updates (IAVA). Analyze logs, tracks, to resolve hardware/software issues pertaining to networking, connectivity issues, printers, servers, and applications. Manage and documentation of system events to ensure integrity of servers. Monitored remote computers and servers using Real VNC, HP Openview, and Whats Up Gold. Maintenance and installation of printers, servers, and workstations when required. Analyze logs, tracks, to resolve hardware/software issues pertaining to networking, connectivity issues, printers, servers, and applications.

Persuadable Research Overland Park, KS (May 2006 – January 2007)

Director of Technology of network operations, systems, and processes. Cloud Computing utilizing GO-Global application server to provide client-applications to remote users. Installation / administration of Red Hat Linux, Apache, PostgreSQL, Samba and VNC servers. Build and creation of a Microsoft Net Meeting Server for virtual presentations and meetings . Administrating Sonic Wall VPN, Firewall, DHCP Server, Veritas Backup Exec, SQL Server, Internet Information Server, Trend Micro Antivirus, and Print Server. Installation of Windows XP, 2003 Server, Windows 95, Windows 98, Windows 2000, and Macintosh Operating Systems. Support of network and VOIP systems and processes. Network management systems, infrastructure, workflow and other network applications. Installation and configuration of PC hardware and software components. Determining requirements and developing plans to ensure smooth installations of new software and hardware.

SI International Lees Summit, MO (July 2001 – May 2006)

Network Engineer / DBA

Supervisor of Information Technology (IT) Department and Data Center supporting over 300 personnel at the DHS (Department of Homeland Security) National Records Center (NRC). Created and maintained network user accounts: Novell, MS Network, NFTS (National File Tracking System), and CCMAIL. Setup of new user workstations utilizing Norton Ghost. Maintained Network Administrator Rights on the INS's network. Created new email accounts with Lotus CCMAIL. Resolved complex network and computer issues through direct action. Provided technical expertise in resolving network and computer user issues by acting as a liaison between SI International and the INS Administration, creation, and programming of SQL databases. Database conversions from MS Access to PostgreSQL Server. Maintain SQL database models on both Windows on Linux operating platforms. Creation of databases from customer supplied documentation. Develop customized data base front ends to meet the needs of individual department requirements. Test newly created databases and optimize before releasing to production floor. Update and validate data tables pertaining to changes in personnel, contract requirements, and production statistics. Generate Statistical Analysis reports, charts, and spreadsheets in support of production and Project Management.

Computer Task Group, Overland Park, KS (April 2001 - June 2001)

Software Engineer on assignment to resolve client's Adobe Acrobat software issues. Researched and recommended methods of reducing the file size of the client's PDFs, wrote technical guidelines for ensuring optimization (Fast Web Viewing) and maximum reduction of PDF database files, and conducted extensive testing of third party software for the purpose of splitting up PDF documents by batch as opposed to splitting them up one-by-one. Trained the client's personnel in the procedures for splitting and optimizing their PDF documents.

Best Tool and Manufacturing, Kansas City, MO (February 1996 - March 2001)

Network Administrator in charge of network operations, systems, and processes. Network migration from XENIX (Unix System V) to Windows NT4 Server platform. Administrating MS Systems Management Server (SMS), Remote Access Server (RAS), DHCP Server, Exchange Server, Seagate (Veritas) Backup Exec, SQL Server, Internet Information Server, and Print Server. Installation of Windows NT 4.0,Windows NT 4.0 Server, Windows 95, Windows 98, Windows 2000, and Macintosh Operating Systems. Support of network operating systems and processes; network management systems, infrastructure, workflow and other network applications. Installation and configuration of PC hardware and software components. Identified, analyzed, and resolved simple to moderately complex network problems. Installing and troubleshooting user’s software and hardware problems. Determining requirements and developing plans to ensure smooth installations of new software and hardware.

Certifications / Training:

CompTIA – Security+ - Certification # COMP001007872641

MS – MCP 2.0 Certified Professional Certification # 6637024

Brainbench – MS Windows Server 2003 Administration - Certification

Brainbench – MS Windows Server 2008 Administration - Certification

Brainbench – MS Windows NT 4.0 Administration - Certification

Brainbench – MS SQL Server 2008 Administration – Certification

Brainbench – RDBMS Concepts –Certification

Brainbench – Linux Administration (Red Hat) - Certification

Brainbench – UNIX Administration (General) - Certification

Brainbench – MS Internet Information Server 4.0 Administration - Certification

Brainbench – Web Server Administration - Certification

Brainbench – Web Design Concepts Certification

NCSA CS-332 - Windows 2000 Server - Certification # 1960857

NCSA CS-312 - Windows 2000 Professional – Certification # 1962909

NCSA CS-313 - Windows XP Professional – Certification # 1961028

NCSA CD-295 - Microsoft Office XP – Certification # 1963251

NCSA CS-235 - MS Access 2002 – Certification # 1961199

NCSA CS-255 - MS Word 2002 – Certification # 1964961

NCSA CH-111 - Computer Hardware Technician – Certification # 1962225

DOD 8570.01 Certification Technical I and II

US Army – CIO/G-6 NETCOM Information Assurance Technical Level 1 Certification 10/23/2008

US Army – CIO/G-6 NETCOM Information Assurance Security Plus 09/04/2008

US Army - G3 Computer Security 07/22/2008

US Army – Information Assurance Security Officer Certification Course 07/23/2008

US Army Communications Security 08/05/2008

US Army Infrastructure Security 08/29/2008

Professional Membership:

IEEE Computer Society Member

Microsoft Certified Professional (MCP)

EDUCATION

Webster University,

St. Louis, Missouri

Bachelor of Arts, Business Administration

May 1992

Contact this candidate