Consulting

Database Solutions

I have been working with various database technologies since 2002. I have a vast experience with large networks from the database infrastructure to the physical environments. I worked in environments with over 500 production databases and databases as large as 1TB. I understand how the physical infrastructure interacts with SQL Server and how to optimize it.  I can provide database design and architecture services.  I maintain complex database systems and look for potential bottlenecks in current configurations and make suggestions on improvements.  I can help identify future growth patterns and forecast future requirements.

Business Intelligence Solutions

I have developed complex BI solutions using SSIS and other tools. Each tool pulled data from a variety of sources including SQL, Flat Files and FTP Sites.

Website Development Solutions

I have been involved in the development of over 100+ websites. These websites have a vast array of technology differences and complexity. I have developed some in Classic ASP using a SQL server backend and some i have developed using PHP with a MySQL backend. I can assist in a tradition website to wordpress conversion or a new website from the ground up. Many of my site have a unique twist that goes beyond a tradition cookie cutter site.

Monitoring Solutions

I have developed a complete set of infrastructure monitoring tool with the 3-tier approach. Monitoring solutions include services, event logs, responsiveness and historical performance on machines. In addition to gathering historical and alerting data I have a suite of tools which interact with SQL and query specific performance and available information. These tools have help organizations beef up there monitoring environments and make a proactive effect to finding problems before it interrupts business flow. My tool set include all client side service to gather information and report it to the database. In addition to building my own framework I have also worked closely with SolarWinds Orion and built custom applications and monitors within their suite of tools. I am very comfortable in finding alternative solutions to monitoring and devising creative ways to figure out monitoring requirements.

Automation Solutions

I have developed many unique automated solutions which consisted a a series of processes which humans would traditionally perform.  I took these sets of processes and combined them and made a automated solution from them.  I have been involved with 5 human to machine automated development processes.  These processes individually saved many man hours per week.  Each process was built in a way which there were muliple attempts and self correcting error handling.  Most of these processes were setup as nodes in which there could be multiple machines handling the same task for scalibility and availability.