PROFESSIONAL EXPERIENCE:

Confidential, Bethlehem, PA

DBA, Database Developer

Responsibilities:

• MySQL administration and development including backup/restore scripting (Percona XtraBackup and MySQL Data Dumper), database architectural improvements, query optimization, ad - hoc database analysis, troubleshooting and maintenance (Percona Toolkit), and monitoring (including Cacti and Percona Cloud Tools).
• Provide regional MySQL database migrations and hot backups via asynchronous replication, daisy chaining and EC2.
• Built and maintain a datamart using MySQL 5.6 (Percona Server) for the OLAP database and PHP/Talend for ETL processing (including various third-party APIs).
• OLAP Cube server administration and development leveraging open source MDX/XMLA Business Intelligence suite (icCube).
• Cassandra 1.2/2.0 administration and development including backup/restore scripting, CQL3 queries, and OpsCenter for management and monitoring.
• DevOps role of writing and customizing scalable Puppet modules and Python Fabric scripts for automated configuration management.
• Administration for Debian/Ubuntu LTS infrastructure including various backup processes and reporting using Bash/Python scripting.
• Installing and maintaining network/system monitoring applications such as Nagios, Munin, and Monit, as well as writing custom plugins for these tools.
• Leveraging Amazon Web Services including S3 storage and scripting with EC2 API/AMI Tools.
• Revision control using Git to create and manage numerous repositories.
• Use of company Wiki for technical documentation.
• Participate in Agile software development, including daily standup and iteration planning.
• Notable s include MySQL MMM (Multi-Master Replication Manager) cluster setup and migration, creating a scalable bulk video file importer, developing a complete custom Tomcat log rotator system, and creating custom reports to streamline sales and customer support.

Confidential, Easton, PA

Database Analyst, DBA

Responsibilities:

• Designed queries for various RDBMSs (SQL Server 2005/2008, Access, other vendors)
• SQL Server Integration Services (SSIS) development for ETL including Fuzzy Lookup, Fuzzy Grouping, and other transformations.
• Created tools to streamline data cleansing and data entry using VBScript, Access 2007 VBA and Forms, and other programming languages.
• Built reports, prepared and published summaries, including use of company Wiki for technical documentation.
• Worked with management, development, and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases (SQL, schema, and network architecture for Microsoft SQL Server 2008/2005).
• Identified, measured, and improved company KPIs.
• Administration for hosted cloud Windows Server 2008 development environment including regular maintenance, Batch/PowerShell and Bash (Cygwin) scripting, and various backup processes and reporting.
• Assisted with LAN/WAN, PC, and laptop configuration and maintenance.
• Communicated with and trained company personnel and vendors regarding business systems and improvements.
• Participated in Agile software development, including daily standup and iteration planning.
• Notable s include developing applications implementing Google Geocoding API, integrating and optimizing custom programming and database objects to achieve various data cleansing requirements, and co-developing bulk data feed ETL processes.

Confidential, Stroudsburg, PA

Developer, System Consultant

Responsibilities:

• Built and maintained Amazon Web Services Elastic Cloud 2 Instances (Fedora servers) including regular maintenance, adding new features, EC2 API Tools/Bash/Batch scripting, DNS management, solving email issues, configuring various backup processes and reporting.
• Built and maintained PHP/MySQL applications.
• Provided guidance on migrating from PostgreSQL to MySQL.
• Subversion configuration and administration.
• Wrote Emacs Lisp macros.
• Managed Google Apps and Google Analytics.
• Consultation for AWS architecture improvements.
• Notable s include automating EC2 operations using Java and Python, developing applications implementing OAuth and Google Wave protocols, and leveraging Amazon Simple Email Service (SES) for bulk email requirements.

Confidential, Ambler, PA

LAMP Consultant

Responsibilities:

• Administration for a hosted Virtual Private Server (CentOS 5) including regular maintenance, security patching, Bash scripting, configuring various backup processes and reporting.
• Performed modifications and maintenance for PHP application.
• MySQL administration and development including database architectural improvements, query optimization, ad-hoc database analysis, troubleshooting, and maintenance requiring the optimization and backup/restore scripting for a legacy MyISAM dominant database (mysqlhotcopy).
• Completed and maintained the ETL of medical data from various online sources leveraging the PHP application.
• Subversion administration.

Confidential

Freelance SEO Consultant

Responsibilities:

• Provided keyword research and analysis for several local businesses.
• Optimized client sites for improved indexing, including best practices for maximizing SERP effectiveness while avoiding search spamming.
• Performed regular follow up to adjust keywords and web content for improved results.
• Implemented Google Analytics where conversions are applicable.

Confidential, St. Davids, PA

Web Developer, Systems Administrator

Responsibilities:

• Debugged code, added new features, site and data optimization in general.
• MySQL and PostgreSQL administration and development including backup/restore scripting, database architectural improvements, query optimization, ad-hoc database analysis, troubleshooting and maintenance.
• Administration for Windows Server 2003 and Red Hat Enterprise Linux 4 servers including regular maintenance, added new features, Bash/Batch/PowerShell scripting, DNS management, solved email issues, NAS, configured various backup processes and reporting.
• Maintained PHP applications, including Smarty.
• Maintained Classic ASP sites with Access databases.
• Maintained several third party LAMP applications for CRM and email campaigns.
• Configured and maintained several Google Apps sites.
• Implemented and maintained Search Engine Optimization.
• Assisted the CTO in the delegation and follow up of assignments, employee, technical writing, and in making decisions regarding services and resources.
• Notable s include high availability server configuration, Subversion configuration and administration, co-developing new PHP/MySQL applications (including mobile and VoiceXML features), SMS notification mechanisms, and site internationalization.