PHP/MySQL Developer

Job Description

We are seeking an experienced PHP/MySQL developer with knowledge and skills in PHP Microservices development, MySQL database management and cloud infrastructure and applications management to provide operational and technical support for an existing REDCap application hosted on Amazon Web Services (AWS). The resource will be responsible for the maintenance, troubleshooting, version upgrades, user support, vendor coordination, and integration of the REDCap application to ensure a secure, reliable, and highly available platform. This position requires close collaboration with business stakeholders, infrastructure teams, AWS administrators, security teams, and Vanderbilt University REDCap support. Support the REDCap application hosted in AWS with user/project management, reports and surveys. Day to day responsibilities include: -Coordinate and implement REDCap software updates, patches, and version upgrades in collaboration with Vanderbilt University. -Install, configure, and support REDCap External Modules using PHP on Linux/AWS environments including Apache/Nginx. -Develop, maintain, and troubleshoot REDCap API integrations with internal and external applications and automate data flows. -Serve as the primary technical contact for REDCap-related issues. -Implement and maintain OIDC integration, Active Directory/LDAP, and SSL/TLS certificates. -Prepare the scripts to load data to Redcap database using Data import tool or using Redcap APIs. -Coordinate with AWS infrastructure teams regarding servers, storage, networking, SSL/TLS certificates, security groups, backups, and system monitoring. -Provide day-to-day operational support, including troubleshooting application, infrastructure, and user issues, documentation and training. -Monitor application performance and proactively identify and resolve issues. -Support disaster recovery, backup validation, and system recovery activities. -Develop automation scripts for reporting, and data validation (PHP and SQL). -Maintain MySQL databases, perform queries and validation. -Maintain technical documentation, standard operating procedures, and configuration documentation. -Coordinate issue resolution with vendors, developers, database administrators, security teams, and business users. -Participate in change management, release management, and production support activities. -Ensure compliance with State security standards, applicable data privacy requirements, HIPAA compliance, and proper audit logging. -Create and maintain Azure DevOps work items for REDCap enhancements, defects, upgrades, API development, and maintenance activities. -Maintain priorities, assignments, status, dependencies, and target completion dates.

$50/hr - $60/hr

Exact compensation may vary based on several factors, including skills, experience, and education. Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401K retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.

Skills and Requirements

-5+of experience with PHP Microservices development with configuration and troubleshooting. -5+ years of experience with MySQL database management. -5+ years of experience with PHP configuration and troubleshooting. -5+ years of experience with Python scripting for loading and query data. -5+ years of experience designing, developing, implementing and troubleshooting RESTful APIs. -5+ years of experience supporting enterprise web applications hosted on AWS. -Bachelor's Degree -Experience supporting REDCap in a public health, healthcare, higher education, or research environment. -Experience with REDCap API integration and External Modules implementation. -Experience with Twilio / SMS survey gateway.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].