theCalico.com
 

David G. Clark

Summary:
Experienced database/web developer, DBA and systems administrator with a proven history of planning, deploying and maintaining creative solutions to business problems. Adept at individually executing projects as well as mentoring and assisting other team members with shared responsibilities. Well-versed in refactoring applications to keep pace with changing business goals without resorting to complete redesigns. Excellent troubleshooter often called upon by colleagues in "last resort" situations.

Professional Experience:
The MathWorks, Inc. (Natick, MA - www.mathworks.com)

Principal Database Engineer
November 2012 - Present

Database administrator, developer and DevOps engineer for applications and web services supporting the use of MATLABĀ®.

  • Performed audits of MySQL (5.*) databases to evaluate and improve query performance.
  • Developed policies and best practices for Amazon RDS usage; then created centralized deployment, management and inventory scripting to govern 50+ instances across multiple AWS accounts and regions.
  • Implemented the use of Tungsten Replicator to securely and reliably copy information from internal databases to remote Amazon RDS deployments.
  • Used bash shell scripting, Python, Ruby, and Team City to develop continuous deployment and production release processes for Java-based web applications hosted in Amazon EC2.
  • Participated in Agile development cycles to construct a web application for logging user experience data for analysis.
  • Responsible for all MongoDB (2.*, 3.*) planning, administration, schema design review, and ad-hoc querying.
  • Promoted from Senior Database Administrator (level 3) to Principal Database Engineer (level 4) after four years.
Avant Marketing Group (Park City, UT - www.avantlink.com)

Chief Technology Officer
April 2007 - November 2012

Architect, developer and systems administrator for an online advertising network.

  • Developed web applications built on PHP (4.*, 5.*) and MySQL (4.*, 5.*).
  • Designed database schema, compression & loading procedures, and application logic to store and report on over 100,000,000 actions each month.
  • Utilized high availability approaches and geographically dispersed data centers (one in Utah and one in Pennsylvania) to offer network services with over 99.999% uptime during my tenure.
  • Set up, monitored, and maintained MySQL replication among multiple servers using both master-slave and master-master (a.k.a. circular) configurations.
  • Responsible for all systems administration duties in a Linux server environment: hardware purchase & configuration, system installs & updates, bash shell scripting, backups, and Nagios monitoring.
  • Made use of cloud-based solutions from Amazon Web Services (EC2, ELB, CloudFront, CloudWatch) to segregate and improve scalability of certain services.
Rastar Digital Marketing (Salt Lake City, UT - www.rastar.com)

Senior Developer
July 2001 - March 2007

Lead developer, systems architect, and DBA for a print media and marketing strategy company.

  • Developed web applications built on PHP (4.*, 5.*) and Microsoft SQL Server (2000, 2005), and desktop/distributed applications using C# and Visual Basic (6.0).
  • Engineered customer relationship management solutions for the automotive industry, generating several million dollars in revenue per year.
  • Designed analytical systems for segmenting customer databases in the automotive, educational, and retail industries into sectors that would be most profitable to market to.
  • Created data selection and production logic for targeted marketing campaigns that resulted in over 1,000,000 pieces of printed mailings per month.
  • Assisted IT department with configuration of essential network services including DNS, DHCP, web and file servers, firewalls, and routers for a mixed network environment (Windows, Linux, and Mac).
  • Oversaw the growth and hiring of the development team from being the only full-time member to a maximum staffing of seven professionals.
  • Presented with inaugural award for "Innovation" in 2005 at a company-wide gathering, one of only two such awards given.
Yanni Partners, Inc. (Pittsburgh, PA - www.yannipartners.com)

Systems Programmer
November 1997 - June 2001

Member of a two-person team responsible for all facets of IT required for a mid-sized investment consulting and asset management firm.

  • Developed client/server applications built on Visual Basic (5.0, 6.0) and Microsoft SQL Server (6.5, 7.0, 2000) for customer relationship management and investment reporting.
  • Made extensive use of Microsoft Office automation capabilities to create client reporting and graphing systems used in quarterly presentations to over 200 clients.
  • Designed and implemented databases and libraries used in computing financial statistics for investment accounts, forming the basis of all consulting decisions made by the firm.
  • Created an ASP and COM-object based data-entry website for collecting investment performance data from over 600 money management firms each quarter.
  • Built reporting and mail merge engine using Crystal Reports (6.0, 7.0, 8.0); mail merges were used in sending over 4,000 investment-related questionnaires each quarter.
  • Performed network administration duties for a 50-user Windows domain, including configuration and management of Windows NT 4.0 and 2000 desktop PCs, user account management, server management and backups.
  • Responsible for purchasing all desktop PCs and servers, installation and trouble-shooting of third-party software, and printer management.
University of Connecticut, Department of Metallurgy (Storrs, CT - www.ims.uconn.edu/ims)

Research Assistant/Systems Administrator
December 1995 - August 1997

Assisted in software development and Linux systems administration for a materials science research center.

  • Developed applications in C, used for viewing and analyzing computer simulation data.
  • Maintained web pages for software documentation, system news and personnel.
  • Performed computer maintenance and troubleshooting, including updating software, installing new PC hardware, and printer management.
Education:

Bachelor of Science in Applied Mathematics, May 1997
University of Connecticut, Storrs, CT
Graduated Summa Cum Laude with a GPA of 3.9 on a 4.0 scale.
 

Publications:

Use XML Query Definitions in .NET Applications, May 2004
(available at SitePoint, or locally here)
Stored Procedures on PHP and Microsoft SQL Server, November 2003
(available at SitePoint, or locally here)
 

Certifications:

Zend Certified Engineer, PHP 5.3, June 2012
Oracle Certified Professional, MySQL 5.0 Database Administrator, March 2012
Microsoft Certified Systems Engineer, December 1999
 

References:

Available upon request.

Last Updated: 2017-10-29

Pumpkin the cat with a rubber band
10/29/2017 14:44:00

Valid XHTML 1.0 Transitional