DETAILED TECHNICAL SKILLS:

• Microsoft SQL Server - (SQL Server 6.5, 7.0, 2000, 2005, 2008,2012,2014)
• Design, Deployment and Administration of Databases, Tables, Stored Procedures, Extended Stored Procedures, Triggers, DTS Packages, SSIS packages, Views, Synonyms, User Defined Functions and Queries
• SQL HADR
• Data Governance
• SQL Reporting Server
• Backup and Recovery
• SSIS and DTS packages
• Web Services (HTTP Endpoints)
• Analysis Services
• Full-Text Search Engine
• Performance Monitoring
• Code Generation (Stored Procedures, Views and Functions)
• Data Modeling (Erwin / Embarcadero / PowerDesigner / Toad)
• Microsoft Team Foundation Server for Database Professionals
• SQL Service Broker Applications
• Database Engineering (Design, Deployment and Administration)
• Clustering / High Availability / Load Balancing
• SQL Server Replication
• Database Mirroring and Log-Shipping
• User, Group, Application Security
• Upgrades / Service Packs
• Performance Optimization
• Building and Updating Maintenance Plans
• Migration of data from other database technologies
• Proficient in ISQL, OSQL, Query Analyzer and SQL Profiler
• Performance Monitoring and Alerting
• Disaster Recovery and Planning (Backup / Restore)
• SQL Jobs
• Crystal Reports 8.6
• Red Gate
• Oracle - (Oracle 7i and Oracle 8i)
• User, Group and Application Security
• Design, Deployment and Administration of Databases, Tables, Synonyms, Queries, Scripting and Triggers
• Performance Monitoring and Alerting
• Proficient in SQLPLUS, SQL LOADER and other various tools
• Crystal Reporting
• Disaster Recovery and Planning (Backup / Restore)
• PL SQL
• Oracle Financials
• Oracle Reports
• Visual Studio - (VB, VB.Net, C#.Net)
• .Net Framework 1.1, 2.0, 3.0, 4.0 and 4.5
• Various Client / Server Applications
• CodeSmith Code Generation
• CSLA Framework
• Complex modeling architectures
• .Net Nuke
• Web Services
• Web Applications
• SharePoint
• AJAX
• Smart Phone Applications
• Scripting Technologies
• VBScript
• PowerShell
• WMI
• Perl
• MS Batch
• Bash
• Perl
• Awk
• Sed
• Java
• Microsoft IIS -
• Deployment and Administration of IIS 4.0, 5.0, 6.0, 7.0
• Creation of Web sites, FTP sites, Web Services and Indexing Services
• SSL Certificates
• Packet Level and Directory Level Security
• Script Debugging
• Web Development (HTML, XML, Java, Jscript, JHTML, DHMTL, ASP, ASP.NET, PHP and Flash)
• NT / 2000 / 2003 Administration -
• Design, Deployment and Administration of all Microsoft Server Technologies
• User, Group and Resource Management
• Local, Group and Security Policies
• Login Scripts utilizing MS Batch, VBScript and Kixstart
• Auditing and Monitoring of all user and system activities
• Server Performance Monitoring and Optimization
• Active Directory Design, Implementation, Migration and Administration
• DHCP, DNS, WINS, Telnet, RAS, SNMP, SMTP, NNTP, WWW, FTP, GSNW, LDAP, Terminal Server, File and Print Services and Trust Relationship Administration
• Centralized Backup / Restore (Veritas Backup Exec, Veritas Volume Manager, Veritas NetBackup and ArcServ)
• IIS 4.0 / 5.0 / 6.0, Apache Web Administration
• Anti-Virus Protection (Norton, Trend and Cheyenne)
• Load Balancing and Clustering (Compaq, HP and EMC hardware)
• Hardware and Software Installations / Upgrades
• Provide up-to-date fixes and Service Packs
• Migration from NT 4.0 to Windows 2000 (Active Directory)
• RIS (Remote Installation Service)
• Automation of Administration utilizing VBScript, WMI, Perl and ASP
• Unix / Linux - (Operating Systems: Sun Solaris 7 / 8, HP/UX 10.20 / 11.0, RedHat, Debian, Free BSD, Mandrake, Yellow Dog, Ubuntu)
• Design, Deployment and Administration of Unix, Linux and Sun Technologies
• User, Group and Resource Management
• DNS, DHCP, FTP, NFS, NIS, Telnet, FTP, SSH, Samba, Sendmail and Firewalls
• Modify/Re-Write Kernel to optimize specified operations
• Network / Host Intrusion Detection (Snort, Firewall, Backlog, Razor Back and Nessus)
• Web Administration utilizing Apache and Netscape technologies
• SQL Administration utilizing MySQL, Postgresql and Oracle 7i / 8i
• Shell Scripting (Perl, Awk, Sed)
• Bourne/Korn and C-Shell
• Centralized Backup / Restore (Legato Networker)
• Tarantella Terminal Server
• Provide real-time server monitoring using HP Open View, Nagios (Netsaint) and Spong.
• Hardware and Software Installations / Upgrades
• File and Print Services
• Novell - (Operating Systems: Novell Bindery, Novell 4.11, Novell 5.0, Novell 5.1)
• User, Group and Resource Management
• NFS and NDS
• Volume / Disk Administration
• Off-Line Storage
• Network Monitoring
• Disaster Recovery (Backup and Restore)
• Update Modules
• Hardware and Software Installations
• GroupWise Mail Administration
• Server Platforms -
• Compaq (DL320, DL360, DL380, ML530, ML580, etc…)
• HP NetServer (8000r, LP 2000r, LPr, LH Pro, etc…)
• IBM (Netfinity, AS/400, AS/390, iSeries)
• Sun Enterprise Systems (Enterprise 5500, Enterprises 10000)
• Dell (PowerEdge 2450, 2500, 2600, 6650, etc…)
• Quantum Snap Server
• Microsoft Access 97 and Microsoft Access 2000
• Design, Deployment and Administration of Databases, Forms, Queries, Web Applications, Macros and Reports
• Built several large applications utilizing MS Access.
• Designed, Deployed and Administered centralized backups
• Backups for Windows NT 4.0, Windows 2000, SQL Server, Exchange Server, Notes Server, Oracle Server, Unix / Linux Agents and Novell 4.11 and 5.2
• Off-Site Storage
• HP SureStore, Compaq Storage Works, Breece Hill, Storage Tek (DLT, DAT and LTO)
• Veritas Backup Exec and Netbackup, ArcServ and Legato Networker
• Exchange Server 5.5, 2000 and 2003
• Mailbox, Distribution List, Groups and Security Group Management
• Public Folder Administration
• Upgrade from Notes Domino 4.6, Exchange 5.5 to Microsoft Exchange 2000 and Exchange 2000 to Exchange 2003
• Design, Deployment and Administration of OWA
• Management of Site Connectors, Internet Mail Service, SMTP, NNTP, POP3, IMAP4, Mail Routing, Routing Groups, Administrative Groups, Mail Stores, Pubic Mail Stores, Policies, Monitoring and Alerting, Mail Routing, Message Tracking, Chat, Instant Messenger and Conferencing Server
• Disaster Recovery and Planning
• Support End Users Daily
• Install Service Packs and Fixes
• Exmerge for Exporting, Importing and Migrating mailboxes
• RightFAX integration with Exchange
• Utilized Syntegra and Sendmail to synchronize Address Books between different mail systems
• Active Directory Connector
• 1.2 and 2.0
• Design, Deployment and Administration of SMS 1.2 and 2.0
• Remote Administration
• Package Creation and Deployment across multiple OS(s)
• Inventory of Software and Hardware
• SNMP Event to Trap
• User and Group Security
• Automate Client Installation
• Design, Deployment and Administration of ISA Server
• Utilized Proxy Services (HTTP, FTP and Telnet)
• Proxy Cache Engine
• VPN and Firewall Solutions
• Integrate with Surf Control SuperScout and Linux SquidGuard
• User and Group Security
• Service Packs and Fixes
• Metaframe 1.8 and XPe
• Design, Deployment and Administration Citrix Metaframe 1.8, Xpe and NFuse
• Printer Administration
• License Administration
• Publish Applications and Content
• Load (Application) Balancing
• Users accessed through NFUSE and ICA Client
• Server Farms of 30 Servers (Clustering)
• LAN / WAN organization, deployment, configuration and administration utilizing Cisco Routers, Switches, Catalyst, ISDN Router, Pix Firewall, Local Director and Arrow Point Cache Engines. Configured and maintained nationwide via remote access and console.
• T1 / T3 / OC3 / ISDN / DSL
• Frame Relay, Point to Point
• Setup and Administration of VLANs
• Design, Develop and Administration of Secure VPN solutions
• TCP / IP, IPX / SPX, UDP, PPTP, PPP, SLIP, OSPF, RIP, NIS, NFS, ARP, SMB, SMTP, SNMP, POP3 and X.25.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Software Engineer

Responsibilities:

• Windows Azure
• Data Architect
• Database Performance
• Database Development (stored procedures, triggers, views, tables, etc.)
• Data Governance
• Database Monitoring
• SSIS / SSRS Development
• SQL HADR
• .NET Web Development
• Kentico Development
• Business Analyst
• Testing Engineer
• Project Management

Confidential, Lincoln, Nebraska

Software Engineer

Responsibilities:

• Database Performance
• Database Development (stored procedures, triggers, views, tables, etc.)
• SSIS / SSRS Development
• Enterprise monitoring and alerting system with Nagios / Centreon
• Enterprise Automation
• Cisco Phone System Reporting
• Microsoft DFS
• Disaster Recovery

Confidential, Omaha, Nebraska

Software Engineer

Responsibilities:

• Database Administration
• Database Development (stored procedures, triggers, views, tables, etc.)
• VB.NET and C#.NET development
• SSIS / SSRS Development
• Project Management
• Automation of data collection for administration purposes

Confidential, Omaha, Nebraska

Software Engineer

Responsibilities:

• Database Administration
• Database Development (stored procedures, triggers, views, tables, etc.)
• VB.NET and C#.NET development
• Microsoft Reporting Services 2008
• Automation of data collection for administration purposes
• SSIS Development
• Visual Studio 2008 / 2010 for Team Foundation Server

Confidential, Omaha, Nebraska

Software Engineer

Responsibilities:

• Database development (stored procedures, triggers, views, tables, etc.)
• VB.NET and C#.NET development
• SharePoint development
• Microsoft Reporting Services 2008
• Testing, automated testing and optimizing SQL
• SSIS Development
• Visual Studio 2008 / 2010 for Team Foundation Server
• Data Warehousing

Confidential, Omaha, Nebraska

Database Developer / Administrator

Responsibilities:

• Data Modeling using PowerDesigner and Toad
• Database development (stored procedures, triggers, views, tables, etc.)
• Log Shipping and Database Mirroring for all production environments
• Microsoft Reporting Services (2005 and 2008)
• Testing, automated testing and optimizing SQL
• Created and maintained over 300 SSIS and DTS packages used for automation of data movement
• SQL Web Services
• SQL Server 2008 Governor
• Securing and Auditing SQL Server 2000, 2005 and 2008
• SQL Server 2008 Data Collector
• SQL Server Replication (2000, 2005 and 2008)
• FullText search, utilizing over 20 languages
• Database Security for over 15 servers and over 150 databases
• Created and maintained 3 SQL Server Clusters
• Disaster Recovery
• Backup and Restore
• Visual Studio 2008 for Database Professionals
• Analysis Services
• Proactively monitor and optimize all database performance
• RedGate SQLCompare and SQLDataCompare
• SharePoint development
• VB.NET and C#.NET development
• Project Management
• WebTrends

Confidential, Seekonk, Massachusetts

Database Developer / Administrator

Responsibilities:

• Data Modeling using Erwin
• Database development (stored procedures, triggers, views, tables, etc.)
• Analysis Services
• Log Shipping
• Fine tuning stored procedures and indexes
• Created and maintained SSIS and DTS packages used for automation of data movement
• Production support of all database servers
• Proactively monitor and optimize all database performance
• SQL Server Replication for reporting and load balancing purposes
• Load Balancing and High - Availability, utilizing virtulization
• Microsoft SQL 2005 Reporting Services
• .NET development
• Project Manager for the following: New SQL Architecture utilizing SQL 2005 and F5 BIG IP Load Balancers and P2P Replication,
• SharePoint, Microsoft CRM, Event Log Archive, System Monitoring and Move-To-Live tools.
• Redgate SQLCompare and SQLDataCompare
• Backup and Restore

Confidential, Omaha, Nebraska

Database Administrator

Responsibilities:

• Data Modeling utilizing Embarcadero
• Database Development (Development / Test / Integrated Environments / Production) Worked with developers and business owners to build SQL schema and refactor existing SQL schema and move up through environments
• Production Database Support
• Created applications that utilized Microsoft SQL Replication, which allowed for users to work offline and then synchronize with the server once connected to the network
• OLTP and OLAP
• Load Balancing and Clustering (High Availability)
• Performance Monitoring utilizing Server-Side Traces, SQL Scripts and SQL Alerts
• Log Shipping for Disaster Recovery
• VB.NET and C#.NET Development
• Project Management
• Red-Gate
• Planned and organized several training classes for developers and DBAs

Confidential, Omaha, Nebraska

Sr. Systems Engineer

Responsibilities:

• Provide and Implement Standards across all Servers (Security, Builds and Maintenance)
• Document Policies and Procedures
• VBScript Automation (Install, Login, Inventory, etc.)
• Active Directory Administration
• Microsoft SQL Server 6.5 / 7.0 and 2000 Administration
• Siebel Administration
• L-Soft / Listserv Administration
• Solaris Administration
• Patch Management (Multiple OS)
• LanDesk (Similar to Microsoft's SMS)
• Citrix Metaframe 1.8 / Metaframe Xpe
• Linux RedHat / Debian Administration
• Port Scanning and Network / Host-Based Intrusion Detection
• Centralized Backups utilizing Veritas Netbackup and Veritas Backup Exec
• Project Management: Patch Management, Server Inventory System, Event Log Archival, SAN

Confidential, Lincoln, Nebraska

Sr. Systems Engineer

Responsibilities:

• Active Directory Design and Migration
• Lotus Notes 4.6 / 5.0 Administration
• Migration from Lotus Notes to Microsoft Exchange 2000
• Microsoft SQL Server 6.5 / 7.0 and 2000
• SMS 1.2 / 2.0
• Citrix Metaframe 1.8 / Metaframe XPe
• Linux RedHat / Debian Administration
• Port Scanning and Network / Host-Based Intrusion Detection
• Centralized Backups utilizing Veritas Backup Exec and Veritas NetBackup
• Application Development: Server Auditing System with SQL repository and Web Based Front End, Documentation Creation and Search via Web, PC Inventory with SQL repository and Web Based Front End
• Project Management: Notes / Exchange Migration, AD Migration, 600+ PC Rollout, AD Planning and Design

Confidential, Nebraska

Systems Administrator / Production Support Administrator

Responsibilities:

• HPUX 10.20 and 11.0, Oracle 7i and 8i, Sun Solaris, SAN Administration
• Netscape Web Administration, VB Applications, PL/SQL, Perl, Shell, Awk, Sed
• Database Administration, Centralized Backups, System Security, Hardware Installation on HPUX
• White paper processes, Installation Documentation (Major Installs), Project Management

Confidential, Tempe, Arizona

Systems Administrator / Production Support Administrator

Responsibilities:

• Enterprise Network(s) (NT 4.0, NT 2000 Advanced Server, Novell 5.2, Solaris, RedHat, Debian and Free BSD) Provide Administration and connections between the Enterprise Networks(s).
• Web Administration, VB Applications, Network Security, Help Desk Support, Routing / Switching
• Exchange Server, Database Administration, Nortel Option 11c Mini, MAT, Meridian Mail
• Scripting, Web Design, (Discover and deploy new technologies), Virus Protection
• Centralized Backups, User account administration

Confidential, Tempe, Arizona

NT Administrator / Network Administrator

Responsibilities:

• Centralized Backups, Help Desk Support, LAN / WAN planning and implementation
• Web Administration, Database Administration, Routing / Switching, Exchange Server
• Nortel Option 61c, Meridian Mail, MAX, CCR
• Network Security, Operating System Deployment, Discover and deploy new technologies
• Network and Systems Administration
• Associate of Occupational Studies Degree in Personal Computer/Network Technology