WORK EXPERIENCE

Confidential,Glen Allen, VA

Programmer/Database Administrator

Responsibilities:

• Maintain and troubleshoot a ‘Classic ASP’ Web Application.
• Maintain and troubleshoot a large ‘Microsoft Access’ - based Database Application.
• Continue the design and development of an existing ‘prototype’ ASP.NET MVC Web Application.
• Design and implement database changes to meet application requirements and business needs.
• Create and maintain database backups.
• Perform database restores to recover from system issues and user errors.
• Set up jobs and alerts to facilitate the administration and monitoring of databases.
• Proactively monitor for potential issues, using DMVs (Dynamic Management Views), Alerts, and SQL Server Error Logs.
• Monitor database performance; Conduct performance tuning and query optimization.
• Setup, monitor, and troubleshoot database replication.
• Develop custom queries and reports, both ad-hoc and automated.
• Audit and maintain database/system security.
• Audit databases for data issues/inconsistencies and develop plans for remediation/improvement.

Confidential, Ft. Lee, VA

Database Administrator / SharePoint Developer

Responsibilities:

• Manage and maintain Garrison Mission Systems Databases
• Meet with end users and other system stakeholders to analyze business processes and gather system requirements.
• Design and develop new Database Systems
• Manage and maintain Garrison SharePoint Site Collection
• Train and assist Content Managers and users in the usage of SharePoint
• Develop business solutions using SharePoint “Out-of-the-Box” functionality and JavaScript
• Automate processes utilizing SharePoint workflows

Confidential, Williamsburg, VA

Helpdesk Manager / Systems Administrator

Responsibilities:

• Managed a helpdesk providing 24/7 coverage to military and government clients for assets across the globe.
• Engaged in weekly meetings for key contracts and partners.
• Established and maintained a working relationship with partner companies to more effectively meet contractual requirements.
• Ensured focus on customer satisfaction and prompt issue resolution.
• Provided counseling, direction, and instruction to helpdesk personnel.
• Ensured that technicians have the appropriate training and resources for successful completion of their duties.
• Coordinated resources and objectives with staff in other departments.
• Database Admin responsibilities - as described below in my previous roll.
• Prompt handling of issues reported by staff or discovered through monitoring.
• Setup and managed user accounts / mailboxes / distribution lists.
• Managed Active Directory and File Server permissions.
• Managed Exchange
• Created and managed users Mail Accounts, distribution lists
• Fought SPAM ( maintained IP Blacklists, ‘fine-tuned’ settings for SPAM filter heuristics)
• Setup and configuration of ticketing systems.

Database Administrator / Assistant Manager

Responsibilities:

• Deployed a new ticketing system built on top of a SQL Server 2008 R2 database to be used for key contracts.
• Cleaned, normalized, and migrated asset/client/location/contract data from an externally hosted ticketing system to the newly constructed internal one. (ETL)
• ‘Fine-Tuned’ and configured the ticketing system to maximize its utility, in accordance with business requirements.
• Performed database tuning and monitoring using tools/techniques such as, Dynamic Management Views (DMVs), SQL Server Profiler, Performance Monitor (perfmon), Activity Monitor, and analysis of query Execution Plans.
• Configured and managed the SQL Server Reporting Services (SSRS) Portal for use by internal and external clients.
• Developed scheduled and ad-hoc reports in Business Intelligence Development Studio - Report Designer
• Performed data analysis to ensure valuable metrics and insights where being captured in our reports.
• Maintained database backups.
• Assisted helpdesk manager in oversight of helpdesk personnel. Provided instruction and guidance to helpdesk personnel.

Field Technician

Responsibilities:

• Troubleshot and repaired for Lexmark Printers and Sun Servers.
• Preformed quality checks of tickets to ensure a sustained focus on customer satisfaction and issue resolution
• Worked with the contracting offices on the local bases to secure a base access necessary for effective fulfillment of contracts.
• In charge of local office management and maintenance to include acquisition a local business license, filling of monthly for local business taxes, and prompt payment of office utilities to include internet/phone/power
• Represented company at the local AFCEA conference in 2011

Lead Helpdesk Technician

Responsibilities:

• Prompt entry, troubleshooting and resolution of a wide variety of issues on broad scope of systems - covering multiple vendors - Dell/HP/Sun/Lexmark - and multiple system types - Desktops / Laptops / Workstations / Servers / Tape Drives / Storage Arrays / Printers.
• Created documentation for ticket entry and handling for key contract service requests - Dell / Lexmark /Sun.
• Provided training and guidance to junior personnel.
• Conducted monthly billing reconciliation & reporting for Dell & Lexmark contracts.

TECHNICAL SKILLS

Database: Backups, Database Design, ETL (extract, transform, and load), Data transformation & cleansing, Data mining

Tools: Database Management (RDBMS), SQL Server Management Studio (SSMS), Quest Toad, Atlantis SQL Everywhere, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

Languages: SQL, TSQL, .Net:, PowerShell, C#, MVC (Razor), WebForms, ASP, Visual Basic, JScript, JavaScript

Libraries/Frameworks: Knockout.js, jQuery jQuery UI, SPServices, Underscore Lo-Dash, Visual Basic for Applications (VBA), Bash, Zsh, Sh, HTML, CSS, XML, XSLT

Technologies: REST Services, SOAP Services

Troubleshooting: Desktops / Workstations / Laptops, Servers: Dell / HP / Sun, Printers: Detailed working knowledge - specific experience with Lexmark

Software: Operating Systems:, Windows XP / Vista / 7, Windows Server 2003 / 2008 (R2), Unix/Linux (Solaris, CentOS, Debian, Ubuntu, etc.), Microsoft Server Systems:, SQL Server 2005 / 2008 R2, Internet Information Services (IIS), Exchange, Active Directory (AD), Cisco VPN Client, VMware Server, VMware Workstation

Networking: Subnetting, Routing, Switching, DNS, DHCP, ACLs, VLANs, NAT/PAT