Joe Seamour Email & Phone Number

Ashland, Oh, Us

Broomfield Co

• Part of the Site Reliability Engineering team, working on an Infrastructure as Code project to the AWS cloud.• Design and maintain database HA/DR for VLDB’s with a 25 TB footprint.• Work with the Development teams to develop new SQL code and optimize existing SQL code.• Design and research best use of SQL Server running on EC2’s using EBS and S3 storage for performance and data retention.• Implement HA/DR with SQL Availability Groups and Log Shipping.• Implement and maintain SQL TDE encryption for all databases with HIPAA ePHI data.• Follow HIPAA and HITECH compliance for all data.

Denver Co

• Build Servers and migrate SQL databases from Rackspace to AWS.• Implement HIPAA and HITECH compliance for medical data.• Implement SQL security to include TDE encrypted databases.• Implement backup and maintenance plans.

Broomfield Co

• DBA for over 50 client production environments using MS SQL in Amazon AWS.• Work closely with development team to troubleshoot client performance issues.• Experience HA/DR to include AlwaysOn, SQL Clusters, Replication, Mirroring and Log Shipping.• Experience with SQL Server on VM's in VMware, Hyper-V, AWS EC2 and Azure.• Work directly with clients who have our product in on premises environments to troubleshoot database related issues.• Provide custom scripts in both MS SQL and Oracle for clients wanting unique functionality within our product.• Design, implement and maintain SaaS and hosted client’s HA/DR plans in Amazon AWS.• Maintain over three hundred internal MS SQL and Oracle database servers running on VMware.• Work closely with our IT team to ensure all client SLA’s are met for internal and external clients.

Greater Denver Area

• Worked with clients as a DBA to integrate external systems into internal databases, including designing databases and mapping data.• Setup maintenance plans and instruct clients on how to perform and maintain.• Clean up client’s jobs and overnight processing to allow for maintenance windows and logic sequencing of jobs.• Troubleshooting performance issues and identify hardware bottlenecks and MS SQL configuration issues.

Greater Denver Area

Leading Edge Recovery Solutions, LLC was acquired by Affinity Global on September 1, 2014. I maintained my role as a DBA with Affinity Global. • Maintain an Always on production environment that supported 500 users and had geographically separated replicas.• Administered multiple databases that were larger than 1TB in a production environment, with some tables having over a billion rows. • Maintained HA/DR for Mirroring, Log Shipping, Replication and AlwaysOn.• Implemented a PCI compliant database environment for client's data on premise eight years.• Developed complex queries and stored procedures to meet business requirements.• Developed SQL processes to integrate third party data into overnight processing.• Mentored and managed junior SQL Developers on the team.

Greater Denver Area

• Directly involved with corporate growth planning and system design and requirements.• Responsible for designing and coding client requirements on a daily basis for financial institutions.• Designed and coded many company critical applications as a DBA.• Identify business cases and then design and implement software solutions.• Responsible for SQL installation and maintenance of production servers.• Design, implement and maintain virtual SQL Server servers using Microsoft Hyper-V.• Designed and maintain Mirroring, Log Shipping and Replication as part of a HA/DR plan.

Greater Denver Area

• Designed and implemented databases for internal and external projects.• Performed database tuning to increase database speed and efficiency. • Designed and implemented a data warehouse to work with Analysis Services.• Designed and developed the database architecture for a phone payment system. • Designed and implemented the interfaces to third party vendors using SQL SSIS packages.• Created a Commission application for 250 employees that calculated commissions.

Greater Denver Area

Developed predictive models for the collection industry that returned values based on client specifications. These values were based on account collect-ability, the ability to contact an account and account churn.As a technical lead I was responsible for project management, software design, resource allocation, strict time lines, product deployment, and managing and mentoring a team of six developers spanning multiple projects while maintaining an active role in developing projects of my own.

Greater Denver Area

Developed back-end functionality with C++ in a pre ASP environment for web projects that included companies such as Forbes and Bridge International.Worked closely with the Marketing Department to provide electronic commerce solutions for such companies as Charles Schwab, First Call, Bridge Information Systems and Goldman Sachs.

Greater Denver Area

Worked on team that maintained and provided new functionality on a system used in television stations that scheduled commercials based on demographics and priority. This system was written in VAX C in a mainframe environment.Worked on a team that maintained and provided new functionality on client software written in C++ that front ended a VAX based mainframe environment.

Boulder Colorado

Part of a six person design team to implement airport automation for Northwest Airlines. This included all aspects of operations from reservations to ticketing. This included gathering requirements, design and implementation.Part of team that implement a travel reservation system for SATO travel. This included writing an API into the major reservation systems at the time Saber, System One and Apollo.Responsible for development and maintenance on a 4th GL language (Macro Scope) that was written in the language C.