Dear David,
I am Vaughn Frost - over 30 years of I.T. experience. My background spans multiple companies and multiple engagements both in the United States and around the world. Currently, I work from home for a fortune 500 company performing data architecture services. While I do not reside in the NYC area; I do work from home and have the capability for internet meetings and unlimited phone contact. Note that in my current full-time job, I perform Data Architecture work I work from home allowing for meetings with business owners, logical data modeling, validation, creation of data schemas, loading, testing, etc. To attempt to identify where I would match your needs, I perform Business Analysis to glean logical data structures. I do this via the Erwin data modeling toolset. Once the key logical concepts are determined and validated (to the business rules/requirements), I create the MySQL design based upon those business rules and other underlying data architecture concepts. With that completed, the process of designing the application begins. The concept is to follow the DBMS structures with the application code to create a system that encompasses all current business needs with an eye on growth potential. That potential being available in a DBMS that is properly designed to accommodate such growth without costly application code re-writes. I have worked extensively to develop a recent Content Management System for Vuria in North Scottsdale, AZ (www.vuria.com <http://www.vuria.com/> ). Most recently I developed a manufacturing system using the LAMP solution. Please understand that data-driven design and proper systems design/implementation is my passion. I perform the same type of activities in my regular 'day-job'; but, within the DB2 and Postgres areana. My preferred method of data-driven design is via the Erwin toolset. Additionally, utilize my CodeCharge product to perform application development (MySQL/PHP) in 1/3 the time of normal coding methods. The generated code is modified slightly with available 'exits' to allow for any/all application needs. It is my experience that the resultant code is very error free and very reliable. I have developed dozens of applications and web-sites with this tool. As you can see by my statements later in this email; I am a proponent of data-driven design. That is, the emphasis I use is on the 'data' initially. When the navigation rules and business user interface needs are identified, the underlying data design will flow and allow for smooth application coding. I have implemented some internal business MySQL/PHP solutions over the past several years - of which the most recent was for a manufacturing process. The MySQL version used was 4.1 using multiple engines (INNODB and MYISAM). I elected to not use referential integrity (FK constraints); however, the system could use them with no issues. Some of the key elements I looked for and designed were: 1) Separation of information into 3NF (3rd Normal Form) so that repetition and duplication is handled logically. 2) Creation of underlying code/reference tables that drive attributes of the system design (e.g. Color Codes for electrical wiring) 3) Use of link names for large objects (e.g. *.jpg files) such that MySQL queries can locate the jpg to be displayed without burdening the MySQL database with the large object item itself. That is, the jpg files are actually stored in a separate folder on the Linux file system. 4) Allow for dynamic upload of new images with automatic naming. 5) Architecturally: a. Design reference/code tables (at a minimum) to allow for deletion 'flags' instead of physical delete; therefore, allowing the application to utilize old code values on display but not for new instances of code usage. b. Limit the number of rows in tables for key application data needs by creating 'inactive' prefixed tables and logic to offload unused/inactivated information on an ongoing basis (part of application design) 6) Create indexing schemes for each table to accommodate complex MySQL queries (joins and where clause use). 7) Develop a backup/recovery plan (Data Continuity) to minimize (or eliminate) any potential data loss from any hardware/network issue. Vaughn G. Frost Data/Information Architect Home/Office: 480 993 2230 Mobile: 480 226 2838 [EMAIL PROTECTED] PS: your original requirement follows: David Blum dblum <mailto:jobs%40lists.nyphp.org?Subject=%5Bnyphp-jobs%5D%20Off-site%20PHP%20% 26%20MySQL%20gig%20&In-Reply-To=> at ttspersonnel.com Wed Apr 2 15:35:54 EDT 2008 * Previous message: [nyphp-jobs] <http://lists.lists.nyphp.org/pipermail/jobs/2008-April/001097.html> PHP Developer - Full time position in NYC with a growing company * Next message: [nyphp-jobs] <http://lists.lists.nyphp.org/pipermail/jobs/2008-April/001099.html> Software Engineer / Programmer opening * Messages sorted by: [ <http://lists.lists.nyphp.org/pipermail/jobs/2008-April/date.html#1098> date ] [ <http://lists.lists.nyphp.org/pipermail/jobs/2008-April/thread.html#1098> thread ] [ <http://lists.lists.nyphp.org/pipermail/jobs/2008-April/subject.html#1098> subject ] [ <http://lists.lists.nyphp.org/pipermail/jobs/2008-April/author.html#1098> author ] _____ Hi, One of our smaller clients asked us to keep our eyes open for a freelancer with experience in PHP & MySQL to create a CMS that will be used to create custom contest entry forms. We need someone with lots of experience with PHP & MySQL for this gig. Work will be 100% off-site, however, we are looking for someone in the NYC metro area who can meet for occasional briefings. Rate & schedule open at this time. Please respond if this looks like a good fit for you or someone you can refer to us. Best, David David Blum Operations Manager TTS Personnel, Inc. 60 East 42nd Street, Suite 858 New York, NY 10165 www.ttspersonnel.com dblum at ttspersonnel.com <http://lists.nyphp.org/mailman/listinfo/jobs> e-mail 212-687-9001 voice 212-983-7134 fax
_______________________________________________ New York PHP Community Jobs Mailing List http://lists.nyphp.org/mailman/listinfo/jobs NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
