Denver, Colorado, United States
SQL DBA Manager and Lead Senior DBA with strong troubleshooting and implementation skills. Experience Summary: 17 Years – Administering SQL Server 32 Years – Administering HP Servers, Datacenters, Azure and AWS environments 32 Years – Administering Windows Servers, DNS, DHCP, and Active Directory 10 Years – Administering Exchange 10 Years – Administering Networking, Cisco PIX, HP Procruve Network 6 Years – ShoreTel VoIP Telephone System 6 Years – Administering Enterprise Antivirus and AntiSPAM software 4 Year – Administering TrendMicro OfficeScan & Ironport Appliance Technical Summary: Environments: SQL Server, Windows Server, Exchange, Lotus Notes, Linux, Novell, Citrix, VMWare, Cisco PIX, Azure, AWS Applications: MS Office, ACT, Outlook, Word, Excel, Symantec Backup Exec, Active Directory, IIS, PowerShell, JasperSoft, Transact-SQL, Network Protocols: HTTP, FTP, SFTP, SSH, SNMP, SMTP, TCP/IP, UDP, DHCP, DNS
• Manage Shift Rotation, Escalations, System projects, Resource Knowledge and KT sessions • Developed Azure VM best practices for large SQL Server environment deployment. • Attended EIM calls to provide input for escalated incident resolution • Attended High Priority client calls • Provided SQL Server and Windows Server Tier 3 support • Provided Support for SAI resources and support for rare and unique issues • Provided Support for SQL Server when SQL resources were not available
• Implemented SQL Standards for HOC3 SQL deployments • Developed processes for QNXT Application overlays • Created custom scripts for clients to update roles in QNXT Application • Provided training for offshore resources to deploy SQL Standards • Worked with clients to resolve issues arising from the SQL Deployment • Provided Senior level support to any escalations
• Designed processes used for data warehousing data from ServiceNOW • Developed Stored Procedures and Tables to automate reporting process • Created SSRS report packages to standardize the reporting process • Developed trended database and stored procedure processes to provide trended reporting • Worked on JasperSoft BI Software to deliver trended reporting to end users • Managed Metrics team to provide standardized reporting solutions to our customers • Met with stake holders to design new report structures as needed including complex calculations for SLAs and OLAs • Provide training for our offshore resources on new
• Managed Nagios System Outage Monitoring • Managed Microsoft System Center Monitoring • Proposed and Tested Microsoft Office Communication Server • Administered Windows 2000/2003 Servers • Administered WSUS and Patching for Servers and Desktops • Administered Exchange 2003 Server • Administered Citrix Xen Server • Managed datacenter with HP ProLiant Server and HP Workstation Hardware • Managed user accounts and access control • Managed BackupExec and offsite tape storage • Rebuilt BackupExec tape jobs to complete successfully • Worked with SOX Auditors for SOX compliance • Researched System Center products to provide streamlined support and better auditing tools • Researched Windows 7 and Exchange 2010 products
• Support and Administer the ShoreTel Phone system • Exchange server 2003 to Exchange 2007 Migration • Implemented TrendMicro OfficeScan anti-virus solution. • Implemented Email Faxing system to provide Exchange Integration for Inbound and outbound faxing. • Setup Cisco PIX VPN Access for remote access for Exchange and some database software utilizing Radius to provide seamless integration with Active Directory • Setup Citrix to provide file server access and utilized Active Directory to provide seamless integration. • Implemented Spam and Virus gateway solution for Exchange • Managed user accounts and access control • Managed BackupExec and offsite tape storage • Studied virtualization solutions including VMWare and Windows 2008 to get more out of the server hardware
• Consultant for information technology • Standardized Laptop and Desktop Hardware • Standardized the Operating Systems for the office • Exchange server 4.0 to Exchange 2003 Migration • Worked with Telecom providers to reduce phone bills by half • Updated server software to Windows 2003 Server and implemented Active Directory • Updated server equipment with Compaq Proliant servers and rack mounted equipment for better storage and efficiency • Managed user accounts and access control • Managed BackupExec and offsite tape storage
• Worked as the System Administrator of almost 700 employees providing hardware and software support to all Netware Servers, NT/2000 Servers, and Cisco equipment onsite. • Configuration of DHCP, SQL, Catalysts, and Server Structure • Performed over 5 server conversions in 2001; being the lead in design, implementation, and setup • Upgraded Novell Servers from 4.11 to 5.0; then later to 5.1 • Implemented an APC Symmetra UPS System • Redesigned the Cisco Network Core switch and wiring for the office infrastructure • Supervised local technology group of 5 people • Converted office from Windows 95 to Windows 2000 • Interviewed and selected new candidates for the technology • Implemented and trained users on the Vantive ticketing system • Built portions of the solution database and provided troubleshooting skills complex issues • Trained new technology employees over our environment and where to find solutions