Our client is looking to hire a consultant/auditor/reviewer with a high enough level of back-end database and programming expertise to review the work of their programmers and provide analyses of the following work:
The development of reliable and effective databases for interactive educational programs, ensuring high levels of data quality and security.
The design of databases using principles of normalization, transactions and time-oriented data concepts.
The maintenance of databases, including writing stored procedures and triggers, managing user rights, and database backup and recovery.
The potential outdatedness of programming.
The connection of user interfaces developed by front-end programmers with back-end tables, based on specifications for use. This includes but is not limited to: using MySQL to manage relational databases; connecting pages within web programs; tailoring features per study condition; collecting usage data; implementing SSLs to maintain security.
The programming of study participant tracking and flow from recruitment to the completion of the program. This includes: randomization and treatment assignment, ID and user code generation, online informed consenting, online surveying, and providing links to the educational content sequentially.
The extraction of quality usage data for analysis for research purposes.
The candidate selected for this role must have significant working knowledge and experience with:
Object-oriented programming and software concepts
Mastery of data management (e.g., permissions, recovery, security, and monitoring)
Expertise with SQL
Proficiency working with front-end user requirements
Microsoft IIS/Apache web server setup, maintenance and security
Project management tools (e.g., Basecamp, Wrike)