REDCap Application Administrator (AWS/PHP/MySQL)

Job Description:

Responsibilities

• Administer and support the REDCap application hosted in AWS.
• Provide day-to-day operational support, including troubleshooting application, infrastructure, and user issues, documentation and training.
• Coordinate and implement REDCap software updates, patches, and version upgrades in collaboration with Vanderbilt University.
• Serve as the primary technical contact for REDCap-related issues.
• Install, configure, and support REDCap External Modules.
• Develop, maintain, and troubleshoot REDCap API integrations with internal and external applications and automate data flows.
• Maintain MySQL databases, perform queries and validation.
• Support REDCap External Modules development and deployment using PHP on Linux/AWS environments including Apache/Nginx.
• Implement and maintain OIDC integration, Active Directory/LDAP, and SSL/TLS certificates.
• Coordinate with AWS infrastructure teams regarding servers, storage, networking, SSL/TLS certificates, security groups, backups, and system monitoring.
• Monitor application performance and proactively identify and resolve issues.
• Support disaster recovery, backup validation, and system recovery activities.
• 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.
• Develop automation scripts for reporting, and data validation (PHP and SQL).

Required Qualifications

• Experience supporting applications hosted on AWS.
• 5- 6 years of Experience with MySQL database management.
• 5-6 years of Experience with PHP application environments and Microservices Development with configuration and troubleshooting.
• 5-6 years of Experience with OIDC/SAML integration.
• Experience coordinating software upgrades and vendor support.

Preferred Qualifications

• Five or more years of experience supporting enterprise web applications.
• Experience using AWS Cloud services (EC2, S3, VPC, security groups).
• Experience with REDCap API integration.

Other desired Qualifications

• Experience with Apache or Nginx web servers.
• Experience with SSL/TLS certificate management and HIPAA compliance.
• Experience implementing and troubleshooting REST APIs.
• Experience managing application security, authentication, and user access.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent written and verbal communication skills.
• Experience supporting REDCap in a public health, healthcare, higher education, or research environment.
• AWS Cloud Practitioner, SysOps Administrator, or Solutions Architect certification.
• Experience with Active Directory, LDAP, or Single Sign-On (SSO).
• Experience using ServiceNow or another enterprise ticketing system.
• Experience with Devops or similar tools.
• Knowledge of HIPAA, security, and data privacy best practices.
• Experience supporting API integrations with enterprise applications.
• Experience with Python scripting for automation.
• Experience with SSIS/ SQL Server agent.
• Experience with Twilio / SMS survey gateway experience.

Technical Skills

• REDCap API integration
• Amazon Web Services (AWS) Cloud services (EC2, S3, VPC, security groups)
• MySQL database management
• Apache/Nginx web servers
• PHP Microservices Development
• OIDC/SAML integration
• SSL/TLS certificate management and HIPAA compliance
• REST APIs
• Identity and Access Management
• Application Monitoring
• Backup and Disaster Recovery
• Vendor Coordination
• Technical Documentation