SUMMARY:

I am looking for a SQL SERVER DBA role where the requirements allow me to leverage over 25 years of I.T. experience providing a full range of Database design, support, executive - level reporting, hardware troubleshooting, repair, software development, networking, Confidential, and help desk tasks. I have developed software, trained users, and enjoy communicating these disciplines with both technical and non-technical users alike. I am looking for CTP or Full-Time only.

TECHNICAL SKILLS:

• MS T-SQL Server 6.5 through + Hyper-V- 5 VMWare Vsphere 5-2
• SQL DBA and Developer-20+ LAN/WAN/Routing/ACLs-15 Dbase-20+
• Business Objects/Crystal Reports-15 Groupwise/Exchange/Sendmail-10 Pascal/Delphi-20+
• Excel/VBA Macros-20+ Pagemaker/Xpress/INDesign-20 Sybase SQL Anywhere-15
• Blackberry Enterprise Server 4/5-7 ER/WIN, DTS, SSIS ETL-10 MS C - 20
• ODBC/ADO-15 Firewalls-20+ MS Assembler -1
• HTML/JavaScript/CSS/ASP/VBScript-15 VOIP/CSU/DSU-5 AS/400 connectivity-2
• Crash Dump Debugging-10 Novell Netware 3/4/5/6-20 Autocad 12 through
• Foxpro DOS/Windows-20+ AD/NDS/LDAP issues-15 Confidential issues in code/databases-10
• Visual Foxpro 3 through 9-15 MS Office Break/fix for PCs/Printers-25
• Windows NT/2000 Prof/Server/RRAS-15 Routers/PPTP/IPSec VPNs-15 Intrusion Detection/ Confidential -8
• Linux 2.4/2.6-8yrs Iptables/routing-5 Avaya IP Office 400/500-2

EXPERIENCE:

Confidential

SR SQL DBA

Responsibilities:

• 25 SQL Servers, 120 Databases, Creation of SSAS Cubes, SSIS ETL Workflows, SSRS Reports, Windows Clustering, SQL Upgrades, Extensive use of Powershell for Scripting and Automation, XML/JSON, SOAP/REST, Performance and Query Tuning, Agile/Scrum Methods, TFS/GIT, SQL Saturday Speaker. Manage team of two DBAs

Confidential

IT Mgr/SQL Server DBA

Responsibilities:

• Responsible for entire company infrastructure including all Windows Servers, AD, Helpdesk, training, SQL Server DBA, Applications Management, Avaya IP Office PBX, VOIP Lines, Server Maintenance, EDI transformations, Exchange 2007 Server with Powershell, Hyper-V 2008 R2, VMWare 5.1, 30 total VM guests.
• RF Barcode Scanning in warehouses with Confidential handhelds over telnet. Purchase authority over IT resources. 40 employees.
• Converted SQL 2000 Warehouse Mgmt app to 2008 R2. SQL DBA for WMS ‘Abecas Insight’, Trucking/Dispatch ‘PCS’.

Confidential

Private Consultant, SQL DBA, Network Engineer

Responsibilities:

• As private consultant, resolved all IT problems for clients on MS Exchange, Windows 2003/XP, Novell GroupWise, SQL Server platforms. Designed data-driven websites with ADO/ODBC/HTML/Javascript/ASP/VBScript.
• Wrote custom reports for NewStar home construction ERP system, a hybrid Progress/MS SQL 2000 system with Visual Foxpro 9
• Performed DBA function and wrote custom reports for EAutomate ERP system in Crystal Reports 11 on SQL 2000
• Managed all IT infrastructure, LAN, Confidential, printing and internet access issues as they arise.
• Implement ASSP on Debian Linux for Anti-spam, iptables firewall and Samba file sharing duties as budgets demanded.
• Install and managed Snort Intrusion Detection Software on the networks of key clients.
• MS SQL experience includes using Business Objects to answer line-of-business queries, specifically for a Banking client’s physical branch operations. Created reports: Time to Fix, Average Response Time, Total Repair time, Repeating Calls etc.

Confidential

SQL Developer/DBA/IT Mgr

Responsibilities:

• Created Executive-Level Management Reporting Tool using VFoxPro7 talking to SQL Server 2000, DTS package imports from Sybase SQL Anywhere 5 vertical app vendor (Mitchell Shopman). Performed both SQL Architect and Front-End developer Roles. Designed system from scratch to function as a weekly roll-up of branch office data.
• DBA Role focused on SQL2000 DB design Stored Procedures, DTS transformations created to import Sybase Anywhere data from 15 branch offices in SQL 2000. Over 80 tables, custom DTS imports.
• Also responsible for entire IT infrastructure, purchasing, setups, installs of 15 AutoBody repair shops.
• Custom application development - Bank Deposit tracking tool - VFP 6/7, Crystal Reports 8.5 development
• Answered all Helpdesk calls for PC Hardware/Software issues,
• Used Win2K Server Terminal Services to interface POS system to Accounting system over internet VPN
• Interfaced custom payroll app to ADP PC/Payroll 3.11 as batch import
• Responsible for branch office automation - Hardware, Software, Confidential, Remote Access, Netopia VPNs, DSL setups, configs and maintenance.
• Maintained company Email server, nightly Tape Backups and company Web Site (HTML/CSS)

Confidential

Contract Programmer

Responsibilities:

• Project maintenance on Telecom application utilizing Visual FoxPro 3.0 as front end, MS SQL Server 6.5 on backend.
• Project work on Confidential issues related to remediating over 50 FOX DOS/WIN apps used by the Nuclear division.
• Responsible for converting all Clipper, DBASE, FOX-DOS apps to Visual Foxpro 6
• TTFMS Telecom app used ODBC to connect to SQL Server 6.5. FoxPro front end heavily utilized OOP features including visual classes, inheritance, overriding, using registry hacks to manually manipulate the ODBC connection. App used SQL Views, SQL pass-thru and Stored Procedures.
• Required re-writing some of the TTFMS Stored Procedures when SQL was revved from 6.0 to 6.5.
• Rewrote the TTFMS Circuit Index report to allow multiple user access.
• Responsible for fixing other stored procedure anomalies related to the SQL Database upgrade.
• Used ER/WIN 3.52 data modeler to maintain and enhance the TTFMS logical model