PHP/MySQL Developer

Quantam; Lansing (MI); Hybrid; USD 55,000 - 83,000; Full time

Benefits offered by this job

Health benefits

Paid time off

401(k) plan

Competitive hourly wages

Job summary

Quantam Solutions seeks an experienced PHP/MySQL developer to support REDCap on AWS. You will manage users, projects, reports, and surveys; implement updates, modules, and APIs; and ensure secure, reliable operation.

Responsibilities include integration, automation, and collaboration with Vanderbilt University. Strong focus on OIDC/LDAP, SSL/TLS, backups, and disaster recovery is expected.

Qualifications

• Bachelor’s degree in a related field is required.
• 5+ years in PHP Microservices development, configuration and troubleshooting.
• 5+ years in MySQL database management and PHP troubleshooting.
• 5+ years in Python scripting for data load and queries.
• 5+ years in RESTful API design and enterprise AWS hosting.

Responsibilities

• Support REDCap on AWS with user/project management, reports and surveys.
• Coordinate REDCap updates, patches, and version upgrades with Vanderbilt University.
• Install, configure, and support REDCap External Modules on Linux/AWS (Apache/Nginx).
• Develop, maintain, and troubleshoot REDCap API integrations and data flows.
• Serve as primary technical contact for REDCap issues.
• Implement and maintain OIDC, Active Directory/LDAP, and SSL/TLS certificates.
• Prepare scripts to load data to REDCap database via import tools or APIs.
• Coordinate with AWS infra teams on servers, storage, networking, security, backups, and monitoring.
• Provide day-to-day operational support and training; monitor performance.
• Support disaster recovery, backup validation and system recovery activities.
• Develop automation scripts for reporting and data validation (PHP/SQL).
• Maintain MySQL databases; run queries and validation.
• Maintain technical documentation and SOPs; coordinate with vendors and stakeholders.
• Participate in change management, release management and production support.
• Ensure HIPAA compliance and proper audit logging.
• Create Azure DevOps work items for REDCap enhancements and maintenance.

Skills

PHP Microservices

MySQL management

PHP troubleshooting

RESTful APIs

AWS Cloud (EC2 S3 VPC)

OIDC/SAML integration

Python scripting

HTML/CSS/JS

REDCap API integration

REDCap External Modules

REDCap administration

HIPAA compliance SSL/TLS

Education

Bachelor’s Degree in related field

Tools

AWS (Cloud services)

Job description

Quantam Solutions provides IT solutions and consulting for various clients. We offer competitive hourly wages, health benefits, paid time off, and a 401(k) plan. The work schedule for this role is hybrid with two days onsite and three days remote.

Overview:

Our client is 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.

Responsibilities:

• Support the REDCap application hosted in AWS with user/project management, reports and surveys.
• 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.
• Monitor dashboards and reports to identify aging or overdue work.
• Provide status reporting to IT leadership and Public Health program stakeholders.

Required Qualifications:

• Bachelor’s Degree is related field.
• Five or more years of experience with PHP Microservices development with configuration and troubleshooting.
• Five or more years of experience with MySQL database management.
• Five or more years of experience with PHP configuration and troubleshooting.
• Five or more years of experience with Python scripting for loading and query data.
• Five or more years of experience designing, developing, implementing and troubleshooting RESTful APIs.
• Five or more years of experience supporting enterprise web applications hosted on AWS.

Preferred Qualifications:

• 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.

Technical Skills:

• PHP Microservices Development
• MySQL database management
• PHP configuration and troubleshooting
• RESTful APIs
• Amazon Web Services (AWS) Cloud services (EC2, S3, VPC, security groups)
• OIDC/SAML integration
• Python scripting
• HTML, CSS, JS front-end coding
• REDCap API integration
• REDCap External Modules implementation
• REDCap administration (user/project management, reports and surveys)
• SSL/TLS certificate management and HIPAA compliance