System Analyst 6 (REDCap Application Support)

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

Location Requirement

Candidate must reside within 90 miles of Lansing, MI (48933) at time of submission — hard requirement.

Position Summary

We are seeking an experienced PHP/MySQL developer with strong skills in PHP microservices development, MySQL database management, and cloud infrastructure to provide operational and technical support for an existing REDCap application hosted on AWS. This resource will handle maintenance, troubleshooting, version upgrades, user support, vendor coordination, and integration work to keep the platform secure, reliable, and highly available.

This role requires close collaboration with business stakeholders, infrastructure teams, cloud administrators, security teams, and the REDCap platform's support organization.

Key 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

Top Required Skills

• 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

Top Preferred Skills

• 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

Other Desired Qualifications

• AWS Cloud services (EC2, S3, VPC, security groups)
• Apache or Nginx web servers
• OIDC/SAML integration
• SSL/TLS certificate management and HIPAA compliance
• Application security, authentication, and user access management
• Vendor/software upgrade coordination
• End-user support, documentation, and training
• Active Directory, LDAP, or SSO experience
• Enterprise ticketing system experience (e.g., ServiceNow)
• DevOps tooling experience
• SSIS/SQL Server Agent experience
• AWS Cloud Practitioner, SysOps Administrator, or Solutions Architect certification
• Strong analytical, troubleshooting, and communication skills