I am one of the top database design specialists on Upwork. My sophisticated hand-crafted database design will save your organization significant time and money.
I am a serious professional with over 20 years of experience as a programmer and database specialist. My emphasis has been on creating elegant SQL database design integrated with user-friendly front-end software (desktop and web applications).
I have worked mainly as a database designer, programmer and database administrator for bioinformatics, biochemistry, molecular biology, and biomedical research applications. I also have extensive experience programming database-centric software (websites, web applications, desktop applications) for publishing, business, financial, personnel and other purposes.
One of the things I enjoy most is creating database schemas which make sense for both programmers and non-programmers, designing with an eye toward flawless data integrity, maximum maintainability and optimal performance. I love crafting websites and web applications which perform with shocking speed. It makes for a better experience for users, developers and administrators. My expertly designed database systems - with well-written queries, intelligently chosen indices, and sensible caching strategies - can easily perform 10 to 100 times faster (using the same underlying hardware).
My emphasis when working with clients is on their data and system usability, not specific trends or technologies. But in case you're wondering about some specifics, I strongly believe that the database data should be integrated with but also somewhat independent from a presentation/application layer. Data in the database should be easily accessible from one or many different applications built using one or multiple different technologies. Currently I favor PHP/JavaScript/HTML5 for web applications, RealBasic/Real Studio/Xojo for cross-platform applications [Mac OS X/Windows/Linux], Xcode for Mac OS X-only/iOS applications, Visual Studio for Windows desktop applications. I prefer using MySQL for back-end RDBMS. I also use Oracle, Microsoft MS SQL Server, MariaDB on a regular basis and I have considerable experience using SQLite, PostgreSQL, and SAP Adaptive Server/Sybase.
If your data and information organization is already in great shape, and if you are satisfied with how your database-integrated software and website performs, then you probably don't need a high-end expert like me. I can make routine modifications, add to well-crafted existing systems, etc. But so can many other people.
But if you're just getting started on a new system that you want done right, or if you suspect your database website programming strategy needs an overhaul, then I can get you on the right track in a short amount of time.
* * * * * * * *
Let me mention a few of the client-friendly policies and practices I apply with all my clients. I don't do these things to distinguish myself from other contractors. (I would hope they all do the same.) I do these simply because this is how I would want to be treated if I was the client:
- You don't need to have your own web servers. I can host development and/or live production work on my own high-capacity servers.
- I can work on a client's servers, or do development work on my servers and transfer finished work to a client's servers.
- I do not charge clients any fees for hosting their websites or software systems, or for moving their websites or software systems elsewhere.
- I provide clients with root log-in access to all the work I do for them; you are welcome to log into the server (cPanel, FTP, and phpMyAdmin) at any time and copy or back-up or move any work I do for you.
- If I am working for you, all work product, all source code, all database design belongs to you. Always.
- I do not provide mysterious "black box" solutions. I am happy to have you look under the hood at everything I do. You don't need to know anything about the inner workings of a system. Or you're welcome to ask about the most intricate details.
- If we're developing a system from scratch, I prefer to do so using widely-available technologies (PHP/MySQL/JavaScript/HTML5). Standard LAMP stack. Other developers can easily be found to work with these technologies.
- Don't be embarrassed to ask ANY question! I routinely work with clients who have zero technical know-how about databases. I appreciate their expertise in OTHER fields (science, finance, medicine, real estate, etc.).
SQL
SQL Programming
Database Administration
Microsoft SQL Server Programming
Adobe Photoshop
Adobe Illustrator
Mac OS App Development
PHP
MySQL
Database Programming
Database Design
