Senior-level database architect with wide range of experience. Strong technical, organizational, and planning skills. Honest, ethical, and loyal; committed to doing the best job possible. Wide knowledge range, resourceful and dedicated, and able to multitask effectively. Enjoys leading small teams, or handling any size of project independently. Looking for long-term full-time employment in an environment which values proper design and efficiency, where I can really enjoy my work and make a positive difference.

Project Management

• Analyzed requirements, designed, and managed development of products, both for in-house and client-facing purposes.
• Evaluated business needs and developed outlines to provide solutions in the most efficient manner possible.
• Designed and deployed scalable & failsafe solutions for websites, backup systems, E-mail filtering, and more.
• Managed small teams of developers with diverse experiences and skillsets.
• Created development roadmaps and timelines for handling many upcoming projects.

Database Design

• Excellent knowledge of SQL (ANSI, PostgreSQL, IBM DB2, Microsoft SQL, Oracle, MySQL).
• Strong familiarity with stored procedure languages (PL/pgSQL, PL/Perl, PL/Ruby, PL/SQL, & MySQL).
• Designed database schemas for CRM systems, email storage, data mining/archiving, hardware & license management, reporting systems, spam filtering, and much more.
• Designed numerous database-driven websites and web applications.
• Extensive expertise with PostgreSQL, including administration, tuning, and writing complex queries for best performance on this platform.
• Optimized index and table structures for performance on many database platforms.
• Completed several data warehousing and statistics-generating projects.

Development & Design

• Fluent with: Ruby, Perl, PHP, SQL, HTML, UNIX Shell Scripting. Also experienced with Java, C & C++.
• Wrote complex application for incident processing and providing information - a key part of daily workflow for staff.
• Wrote several centralized data mining and reporting interfaces using heterogeneous database systems.
• Authored documentation of business software and products.
• SQL-based statistics and graphing reports in web interfaces and Crystal Reports.
• Authored many web applications for hardware management, real estate listings, shopping carts, image galleries, and more.

System Administration

• Operating Systems: Linux, FreeBSD, Mac OS X, Solaris, Windows.
• Setup and administered production Website, E-Mail, FTP, DNS, etc. services.
• Designed and implemented networks and office solutions for businesses, from small start-ups to medium companies.
• Implemented and heavily customized service monitoring applications.
• Wrote many tools to automate common tasks, monitor services, and to perform automated processing.

Security

• Performed Intrusion Detection/Prevention packet-level and pattern analysis for both wired and wireless networks.
• Identified and corrected existing code to protect it against SQL injection attacks and other vulnerabilities.
• Developed analyst interface for Vulnerability Assessment product.
• Very familiar with traffic monitoring, filtering, performing diagnostics of network issues and, identifying security issues.
• Good knowledge of UNIX/Linux advanced security measures, including IPtables firewalling, GRSecurity, PAX, and hardening.

• Wrote data management (database querying via stored procedures, caching of results, and unifying access to multiple datasources) framework in Perl.
• Addressed major performance issues impacting production performance and developer productivity.
• Refactored database schema and deployed these changes in multiple environments with a fully automated scripted approach.
• Implemented change management system to fully control and document every change reaching any production server.
• Refactored SQL to allow upgrading to newer PostgreSQL versions cleanly.
• Refactored Perl code to utilize stored procedures via a data management framework rather than having SQL embedded in code.
• Set up production servers utilizing DRBD for synchronously-replicated data for high availability.
• Contact: John Armstrong, VP, Engineering

• Performed large volumes of data correction and transformation.
• Worked with other teams who needed to work on exported data and later import changes.
• Performed performance tests and tuning advice.
• Wrote various scripts and automation utilities in Ruby and Perl.
• Executed planned many changes in production environment, coordinated with application deployments.
• Tested and documented change steps for planned database schema changes.
• Modified Java code to use database more efficiently.
• Fullfilled reporting needs from other departments of company.
• Contact: Matt Lanier, Database Team Manager

• Designed and managed development of many small projects.
• Built PHP/PostgreSQL-based reporting interface that queried databases of different types to show all information in a single interface.
• Designed and co-authored Perl/MySQL-based dynamic content management framework.
• Built hardware and configuration database and management system based on the above framework.
• Wrote many utilities using Perl, PHP and database stored procedures.
• Modified existing applications to add capabilities, improve maintainability, and increase performance.
• Wrote templating system for main website and updated code to be XHTML 1.1 compliant.
• Contact: Cameron Jones, Owner

• Built infrastructure to support very little human time needed to administer a large quantity of servers.
• Replaced entire aging infrastructure with new systems, migrating all data and services without downtime.
• Setup and administered many server applications (PostgreSQL, MySQL, Apache, DJBDNS, Exim, Qmail, SpamAssassin, ClamAV, Dovecot, and Pure-FTPd).
• Greatly increased scalability of company through efficient design.
• Developed reporting and administrative tools for staff and clients based on Perl, PHP, Ruby, and PostgreSQL.
• Performed migrations of applications and data between MySQL and PostgreSQL.
• Performed on-site consulting work for other companies.
• Built complex E-mail filtration system at the SMTP level using Exim and PostgreSQL.
• Contact: Travis Butcher, Business Owner; Many Client testimonials available

• Was responsible for uptime of an offsite seven machine cluster running a large Java/MySQL application.
• Configured and extended Nagios monitoring software.
• Wrote Shell, Perl, and SQL-based scripts used for monitoring, reporting, and common tasks.
• Researched problems and reported software issues to developers (QA).
• Performed upgrades to new releases during maintenance windows.
• Contact: Eamonn Maher, Lead Developer

• Designed about 45 detailed and final-form client reports using Crystal Reports.
• Wrote application to transfer data from a heavily-loaded database to a dedicated reporting database to provide near real-time reporting with minimal impact on production database.
• Created application for replicating data between production and reporting databases running two different database platforms.
• Contact: Issam Haddad, Director of Development

• Designed and implemented Linux-based networks, using Windows NT Terminal Server and Linux clients for the most cost-effective Windows desktop access.
• Configured Samba/Linux to act as a primary domain controller and file server for Windows networks.
• Used IPTables/Linux to setup firewalls for large internal networks.
• Configured VPN server for remote user network access.
• Configured Linux-based E-mail servers with web-based access, mailing lists, and spam filtering.
• Designed PostgreSQL-based complex website for real estate agency with an administrative interface to allow the client to easily update their site.
• Set up FTP services.
• Setup DNS servers using DJBDNS.
• Worked with Brainbench to finalize new Linux administration tests.
• Contact: Pedro Perez, Business Partner; Scott Sanders, Client

• Analyzed packet logs to determine whether suspicious/blocked traffic was actually malicious.
• Wrote PostgreSQL backend for a Perl program written by another developer to automatically send client E-mail notifications for malicious traffic (was before done by hand, and often skipped).
• Wrote PostgreSQL & PHP-based tool for analysts to analyze Intrusion Prevention trouble tickets. This same system came to be used for reporting to all of the different departments, from development to sales, and was used as the framework for newly-introduced technologies, including the Network Scanning device which SecureWorks now offers. This product combined data from multiple sources, including it's own PostgreSQL database, several Microsoft SQL servers, two IBM DB2 servers, and several other PostgreSQL databases.
• Used TCPdump, NMap, Snort, IPTables, and other network analysis tools on a daily basis.
• Became intimately familiar with general network security issues.
• Contact: Craig Bray, Director of Operations

• Verified data integrity and accuracy during migration of data from an AS/400 to Microsoft SQL.
• Worked in a self-managed environment, given several months worth of work in advance and completing it ahead of schedule.
• Contact: Steven LaFleur, QA Manager

Brainbench Internet Skills Certifications

IT Security Fundamentals	2003-06-29	(85th percentile)
Relational Database Management System Concepts	2003-06-29	(82th percentile)
IT Industry Knowledge	2003-06-28	(75th percentile)
HTML 3.2 Programming	2003-06-28	(94th percentile)
Computer Technical Support	2003-06-28	(91st percentile)
Computer Fundamentals (Win 95/98)	2003-06-28	(Master, 99th percentile)
Computer Fundamentals (Mac OS X)	2003-06-28	(92nd percentile)
Typing speed & accuracy	2003-06-28	(Master, 97th percentile)
Linux Administration	2003-06-28	(Master, 97th percentile)
SQL (ANSI)	2002-12-14	(Master, 81st percentile)
MS Windows 95 Administration	2002-02-25	(82nd percentile)