Sr. Web Developer and DBA
Last active: 11/30/2014
I have been developing software and working with databases for the past 16 years. I design object-oriented, tiered applications and write code in PHP, C#, and VB.NET. I have also written applications in C++ / MFC / Win32 as well as VB 6.0. I design and administer databases in MySQL and Postgres and excel at writing triggers, functions/procedures, and views. I have also worked with SQL Server and Oracle.
Over the past couple of years, I have moved into being a PHP developer with a preference for the CakePHP 2+ framework (though I also know Zend 2+). I truly believe that PHP, HTML5, and CSS3 are the future of the software world. Since PHP was specifically designed for creating web pages, it only makes sense to use it for web development, especially now that object-oriented features and other modern functionality have been added to the code base.
I hold a computer science degree (1998) and have several years of practical experience. I have been using the .NET Framework since the Visual Studio .NET Beta and write .NET code primarily in C# and VB.NET. I prefer to work with applications that follow an n-Tier architecture along with object-oriented concepts such as inheritance and abstraction but will work with just about anything. I have vast experience using C++ and the Microsoft Foundation Classes along with the Win32 API. Other languages/frameworks include PHP, LINQ, Regular Expressions, VB 6.0, and straight C.
I have been designing and administering SQL databases since SQL Server 7.0. Software Engineers tend to be bad DBAs but I believe that I am the exception. Database concepts such as normalization/denormalization, primary/foreign keys, and check/default contraints are not new to me. Whether it be T-SQL or PL/SQL, I also excel with database programmability, such as triggers, procedures, functions, and views. File organization and usage, backup and maintenance, and database efficiency are also strengths. I currently primarily use PostgreSQL 9+, where available and MySQL 5+ where it is not. Other databases include SQLite, Oracle, and yes, Access (95 on up).
During the past 16 years, I have created and maintained custom line-of-business Windows applications, with a focus now more on Web applications. These have included applications for law enforcement, 911 centers, jails, retail businesses, nursing homes, trucking companies, charities, talent brokers, community/group sites, and e-commerce. I have also designed and coded applications for GIS mapping systems and some data mining and sharing initiatives. I have created custom TCP/UDP servers and clients for low-bandwidth mobile applications. I have worked with O/R mappers such as LLBLGen Pro and are used to using entities in data layers rather than reading/writing data directly. Where applicable, I prefer to use the MVC (model-view-controller) mantra, where manipulating, presenting, and controlling the data is abstracted out. I am used to using source control systems such as Git, SVN, Vault, and SourceSafe. I excel at Web Applications, Windows Forms applications, Windows Services, records management applications, interfaces with third-party APIs, integration of systems, and middle tiers such as the business or data layer (just in case you already have a web application but need the back-end to work).
Records Management/Business Applications
Back-end Work (business, data layer, facade)
Windows Forms Applications
Integration of Systems
C / C++
Databases and Languages:
LINQ to SQL
LINQ to XML
SQL Management Studio
Microsoft Office (Word, Excel, PowerPoint, Outlook)
CakePHP 2 & 3
Mac OS X