I run a software company that develops software for an open-source project called OpenEMR, an application that runs medical clinics, hospitals, and other medical organizations. I am looking for a part-time 20 hours per month junior developer to assist me and my company with completing tasks for OpenEMR. As time progresses this has the ability to turn into more hours. You would be a 1099 contractor for my company. More info about the project (this is the project you will be working on): https://www.open-emr.org/ Before the interview I need you to read the following document. In your cover letter please be able to demonstrate as much as possible what is contained in this document. You probably won't get 100% but please give it a solid try. Requirements for OpenEMR Development This document defines the minimum skills and tasks you must demonstrate to be considered ready for OpenEMR development. Review carefully and be prepared to show working examples for the interview. Core Competencies Using Git and standard source control workflows Understanding the OpenEMR database schema at a basic level Setting up multiple virtual hosts using LAMP (preferred), WAMP, or MAMP Configuring and troubleshooting Apache Virtual Host Setup Task Demonstrate your ability to set up a local sandbox by: Creating a new Apache virtual host Installing the latest community version of OpenEMR (use the most recent patch release) Cloning the OpenEMR GitHub repository outside of any vhost folder. (basically, not storing the git repo in the /var/www/ directory, but using an rsync script to update the vhost ) Setting up local instances for both: Master branch and most current stable patch release At minimum: Run OpenEMR v703v4 on a dedicated vhost Git and Source Control Best practices for managing a project with Git Why repositories must not be stored directly on Staging or Production vhosts What cherry-picking is and why it is useful How git reflog can help find a file’s history Xdebug Task Place a breakpoint in login.php at the line that includes globals.inc.php Step over into the next line and explain why globals.inc.php is critical Identify a variable or function from globals.inc.php that is used in login.php OpenEMR Schema Explain the purpose and stored data of these tables: patient_data form_encounter forms users users_secure list_options layout_options Write a query to return: patient first name, last name, PID, encounter number, and forms used in encounters within a specific date or date range Write a query to return: PID and encounter ids for a date range Identify which table/column records when a form has been deleted Identify the view in the OpenEMR interface that updates the list_options table Identify the view in the OpenEMR interface that updates the layout_options table Make a change using the OpenEMR interface and demonstrate the change in the raw data (phpMyAdmin view) Explain how layout_options and list_options are related to creating or updating layout based forms