On -Line Resume

Current resume

 

Main Page - ResumeEmployer - SummaryEmployer - Part 2Education - SummaryReferences for Resume

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 2010

Extensive 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


City of Aurora, Aurora , Co. 2000 to 2007
Database Administrator
 
MS SQL 4.2/6.5/7.0/2000/2005  - design, maintain, DBA/ SA.
Maintained, 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.

Nupremis, 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 internal/external VPNs/Firewalls.

 
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
 
Maintained, 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.

 
Built and maintained Windows NT 4.0 based LANs

 
Built and maintained Windows NT based HR internal LAN and Windows NT server systems.