Work Summary - Part 1
Independent contractor - MS SQL - DBA, RS reporting , WEB DATA Sites development and Database design and DB
maintenace and Performance tunning & enhancing. Daily DBA maintenance and SQL reporting - FEB 2010 to Present
Accelerated Data Systems/PBC Corp - Collection Agency, Greenwood Village, CO. - FEB
2008 to FEB 2010Extensive MS SQL DBA and Reporting services
including custom log shipping and mirrored / replication environments ; Data Center Systems Engineer for off-site co-location/
remote customer VPN hosted terminal services applications/databases /IIS web Sites. Built Windows 2003 and windows 2008 R2
(32/64bit) enterprise edition servers including Hyper-V systems and SQL 2005/2008 (64bit). Extensive Reports
services (SQL 2005/2008) and SAN backup Environments.
Independent contractor - MS SQL - DBA, RS reporting , WEB Site development and Database design and DB maintenace.
DBA maintenance and reporting - Adam Aircraft - Feb 2007 to JAN 2008
of Aurora, Aurora , Co. 2000 to 2007
MS SQL 4.2/6.5/7.0/2000/2005 - design, maintain, DBA/ SA.
designed and deployed MS SQL rational Databases including MS SQL super text - search engines and extensive DTS (SSIS) &
maintenance Stored Procedures, Reporting services to .net(VB) 1.1,2.2 web forms updates,
SQL alerts/email services, SQL OLAP\OLTP analysis cubes for data trending (Costs), Diagramed Database schemas and dataflows
(MS VISO) for configuration documentation and change updates, T-SQL query routines for daily ASP/ASPX web page data
updates using MS Visual Studio 2003/2005 (.net(VB) 1.1,2.0). SQL scripts for Veritas quicker database nightly backups and
hourly transaction log backups. Developed .net 1.1(VB) Program for tracking Qwest lease lines outages for reimbursement purposes
using Visual Studio 2003, operated Verisign PKI for city wide SSL Certificate (IIS & apache) procurement & management,
migrated , upgraded City’s Data Warehouse to Enterprise Edition of MS SQL 2000 SPK 4 , built testbed and early adoption
SQL 2005 servers for SQL 2000 warehouse migration studies and sharepoint SQL reporting services migrations from 38 SQL 2000
server systems. Active Directory, Exchange (Email) and Windows 2000/2003 server administration for Database roles & permissions
and as a Windows SA backup. Build DB2 version 9 testbed server for Crystal Reporting from IBM AS-400 mid range mainframe data.
Helpdesk third level/tier support for all applications connecting with MS SQL client/webbased applications. Carried and responded
to On-Call systems & networking Admin Pager (mostly 911 issues) as scheduled. Installed and supported Data
in and out of IIS , Apache, BEA(Weblogic), Websphere internet servers. Cisco Router to support the above Projects.
Inc / Centera Information Systems, Boulder ,CO 1999 to 2000
Microsoft IT Systems Engineer
Webmaster - E Commerce Development/Production
Performed Webmaster function on development & production web Sites including daily administration, maintenance,
upkeep and new .net web sites deployments. Maintain offsite web hosting environments at QWEST Hosting company. Completed weblog
analysis function using MS SQL server analysis software and Mediahouse Statistical weblog server 5.0. Supported Windows 2k,
NT 4.0, MS Exchange 5.0/5.5, MS Proxy , active directory, DDNSs as required for the Enterprise and database roles. Administered
MS SQL 6.5/7.0 - design, DBA/ SA
Maintained, designed and deployed MS SQL/Oracle 8i (DBA/SA on NT systems) rational Databases including
MS SQL super text - search engines and associated P&M (Personalization&Membership– Ecommerce ). SQL Query
Routines/ASP .net pages. Wrote for E-commerce developers specialized SQL stored procedure and data queries.
Network Support/Troubleshooting Specialist
Performed Network Support/Troubleshooting Specialist function (DNS, DDNS, SMTP, DHCP) including network upgrades
using Cabletron/Cisco Routers and network gigabyte optical hubs.
MCI-WORLDCOM, Denver 1993 To 1999
IT Engineering Specialist
Provided HR intranet web operations and services
designed and deployed MS SQL (6.5/7.0) databases and associated VB web sites
Designed, maintained, and deployed MS SQL (6.5/7.0) databases
& associated IIS development and production VB6 web sites for HR specialized daily reports. Performed daily HR data imports
from three separate data management systems.
and maintained Windows NT 4.0 based LANs
Built and maintained Windows NT based
HR internal LAN and Windows NT server systems.