2009 – Present, Microsoft SQL Database Administrator
for Navigant Consulting, Inc., a specialized, global expert services firm dedicated to assisting clients in creating and protecting value in the face of
critical business risks and opportunities.
- Management of the Microsoft SQL Server Datacenter hosting 25 large servers and a variety of SQL Databases in a high security environment under HIPAA regulations.
- Responsible for the secure data exchange between Navigant and its clients under HIPAA regulations.
- Responsible for the IT infrastructure, including purchase, installation, setup and maintenance.
- Responsible for all backup procedures under HIPAA regulations.
- Desktop/Laptop support for 50+ consultants in multiple locations.
- Development of company internal web sites for maintenance and informational purposes using vb.Net and T-SQL.
- Setup of a variety of automated tasks to free up time for consultants and their clients.
2007 – 2009, Software Engineer and System/Network Administrator for Quality Education Data (QED), Inc. (A Scholastic Company).
QED is a marketing services firm focused solely on the education market. QED provides mailing lists, market research, and marketing planning, execution and analysis.
05/2006 – 01/2007, System / Network Engineer for Sopheon Corporation.
Sopheon (LSE:SPE) is an international provider of software and services that help organizations improve the business impact of product development.
- Responsible for the smooth operation of the Enterprise Network, Hardware and Software Infrastructure including 35 Windows 2000/2003 based Servers and over 200 Windows 2000/XP/Vista based Workstations in different locations.
- Planning and setup of Servers and Workstations from scratch and integration into the existing Active Directory environment including Domain Controllers, SQL Server, Exchange, SharePoint, (s)FTP, Email, and Web Server.
- Setup of and IT Lab environment for a variety of testing procedures before final production rollout.
- Responsible for the migration from SQL Server 2000 to SQL Server 2005 of a variety of Systems including SharePoint, Project Server, Mercury Quality Center, and other proprietary systems.
- Introduction of new backup strategies utilizing Symantec Backup Exec, Continuous Protection Server and Drive Imaging Solutions as well as verifying and troubleshooting the scheduled backups.
- Test restores in an IT Lab environment to ensure backup quality.
- Setup of centralized Software and Antivirus update management.
- Installation of virtual machine technologies.
- Implementation of an Enterprise wide System Status Monitoring solution utilizing Microsoft Operation Management (MOM) and WhatsUp Gold.
- Enterprise wide IT Help Desk for about 70 employees across 5 global offices including diagnosis and fix of hardware failures, virus infection, driver and application problems.
- Preparation, configuration and Firmware updating of network cabling, wireless access points, routers, switches and firewalls.
- Support and maintenance of sales demos and pilots, customer application hosting and QA lab administration.
05/2004 – 05/2006, Software Engineer and System Administrator for DMX-direct, Inc. Direct Marketing Excellence, Inc. dba DMX-direct (DMX), is a single accountable source for a wide range of direct marketing, fulfillment and production services. Based in Denver, Colorado, DMX has built a reputation, since 1991, servicing both national and regional clients.
- Update and/or re-installation of Windows XP Professional/Windows 2003 Server on all Workstations and Servers within the organization and integration/migration into a new domain structure based on Active Directory.
- Firewall / VPN setup and configuration using ASTARO.
- Setup and maintenance of SQL servers, web servers, e-mail servers, (s)FTP servers and print servers.
- Re-code many existing web sites, web applications and other applications using an enterprise wide standard methodology of coding practices resulting in time and money savings during future code changes.
- Development of a variety of e-commerce web sites using advanced SQL Stored Procedures, ASP, asp.NET, VBScript and Visual Basic.
- Established reliable backup methodologies for SQL Servers, Workstations, web sites and client data in case of data loss and for fast disaster recovery purposes.
- Test restores of backups taken to ensure quality of backup data.
- Developed a wide variety of solutions to automate daily or otherwise reoccurring tasks saving time and money on employee and client side.
- Integrated error trapping and user notification into all automated tasks and applications for fast failure recovery and in order to keep system downtime to a minimum.
- Development of a web-based application from an existing database provided by the US Securities and Exchange Commission (SEC) featuring enhanced search capabilities for Investment Adviser Firms. The resulting database contained searchable information for 24,000 Investment Advisor Firms and 60,000 contacts. State of the art web scraping and data mining tools as well as a high level of automation enabling DMX-direct to update the entire database within 8 hours and generate $6,000/year revenue per subscription.
- IT Help Desk for about 15 employees including diagnosis and fix of hardware failures, virus infection, driver and application problems.
- Graphic Design for a variety of web sites.
2002 – 2004, Web Developer and Database Administrator for Benefit Management Systems, Inc. Development of an Online Benefit Enrollment Solution and database backend for Graphic Packaging International. Due to the ease of use and the integration of the complex benefit regulations Graphic Packaging International was able to save over $10,000 dollars during the enrollment process of more than 5,000 employees in the entire US.
2000 – 2002, Network System Administrator / Webmaster for the Architecture Department of the University of Wuppertal, Germany. Support of several small Companies as a System Administrator and Webmaster.
- Setup of a new sub domain within an existing Active Directory environment including a new Domain Controller based on Windows 2000 Advanced Server and 20 Windows 2000 workstations based on Active Directory.
- IT Help Desk for the entire Civil Engineering and Architecture Department of the University of Wuppertal, Germany.
1997 – 2000,Assistant Network Administrator. Development of an interactive course for the Civil Engineer Department of the University of Wuppertal, Germany using PHP, HTML and JavaScript. |
