Senior PHP/MySQL Systems Analyst — AWS & REDCap

Stafford Gray; Town of Lansing (NY); On-site; USD 90,000 - 140,000; Full time

Job summary

Stafford Gray seeks an experienced PHP/MySQL developer to provide operational and technical support for an AWS-hosted REDCap application. You will manage maintenance, upgrades, and integrations, collaborating with stakeholders and cloud teams to ensure security, reliability, and high availability.

The role requires strong PHP microservices expertise, MySQL management, and Python scripting for data flows, with extensive AWS experience and a focus on HIPAA compliance and audit readiness.

Qualifications

• 5+ years of PHP Microservices development, configuration, and troubleshooting.
• 5+ years of MySQL database management.
• 5+ years of PHP configuration and troubleshooting.
• 5+ years of Python scripting for loading and querying data.
• 5+ years designing, developing, implementing, and troubleshooting RESTful APIs.
• 5+ years supporting enterprise web applications hosted on AWS.

Responsibilities

• Support a REDCap application hosted in AWS, including user/project management, reports, and surveys.
• Coordinate and implement REDCap software updates, patches, and version upgrades.
• Install, configure, and support REDCap External Modules using PHP on Linux/AWS (Apache/Nginx).
• Develop, maintain, and troubleshoot REDCap API integrations with internal and external systems; automate data flows.
• Serve as primary technical contact for REDCap-related issues.
• Implement and maintain OIDC integration, Active Directory/LDAP, and SSL/TLS certificates.
• Prepare scripts to load data into REDCap via the Data Import Tool or REDCap APIs.
• Coordinate with cloud infrastructure teams on servers, storage, networking, security groups, backups, and monitoring.
• Provide day-to-day operational support, troubleshooting, documentation, and training.
• Monitor application performance; proactively identify and resolve issues.
• Support disaster recovery, backup validation, and system recovery.
• Develop automation scripts for reporting and data validation (PHP/SQL).
• Maintain MySQL databases; perform queries and validation.
• Maintain technical documentation, SOPs, and configuration records.
• Ensure compliance with security standards, data privacy requirements, HIPAA compliance, and audit logging.
• Track work items (enhancements, defects, upgrades, maintenance) in the team's work-tracking system, maintaining priorities, assignments, and status reporting.

Skills

PHP

MySQL

Python scripting

RESTful APIs

AWS

Security/compliance

Tools

Linux

Apache/Nginx

AWS

REDCap

Job description

Stafford Gray seeks an experienced PHP/MySQL developer to provide operational and technical support for an AWS-hosted REDCap application. You will manage maintenance, upgrades, and integrations, collaborating with stakeholders and cloud teams to ensure security, reliability, and high availability.

The role requires strong PHP microservices expertise, MySQL management, and Python scripting for data flows, with extensive AWS experience and a focus on HIPAA compliance and audit readiness.