Job Description

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building:
• Salary Range: $100,000 - $120,000

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.

Position Summary

In this role, the incumbent will be essential to the seamless operation of REDCap and related systems, focusing on server and database management and maintaining current applications. As a PHP LAMP developer, responsibilities will include coding, troubleshooting, and deploying robust, secure, and scalable web applications using the LAMP stack (Linux, Apache, MySQL, PHP).

A strong emphasis on data security, compliance, and proactive system monitoring is critical to this position. The incumbent will manage cloud infrastructure on AWS, ensure application configurations are optimized, maintain database integrity, and develop integrations with systems such as Epic and OpenSpecimen. The ideal candidate will possess a solid background in computer science, experience in application support or system administration, and proficiency in database and cloud services. Preferred qualifications include certifications and hands-on experience with REDCap, Epic, and Twilio/Mosio, along with excellent problem-solving and teamwork skills.

The LAMP Application Developer & Support Analyst to work closely with the IT Director.

Responsibilities

PHP LAMP Development:

• Design, develop, and maintain web applications using the LAMP stack (Linux, Apache, MySQL, PHP), focusing on both front-end and back-end development tasks.
• Write clean, well-documented, and maintainable code following best practices to ensure long-term scalability and security.
• Troubleshoot and resolve issues related to application performance and security.
• Ensure applications are scalable, secure, and optimized for performance.
• Work on both front-end and back-end development tasks as required.

System Integration:

• Develop and maintain robust integrations between REDCap, Epic, OpenSpecimen, and other relevant systems, ensuring seamless data flow and functionality across platforms.
• Utilize APIs and custom scripting to automate workflows, data transfers, and other system operations.
• Conduct rigorous testing and validation of integrations to ensure that data exchange is accurate, secure, and meets compliance standards.

Cloud Infrastructure Support:

• Manage and optimize cloud infrastructure on AWS, ensuring that systems are scalable, reliable, and able to handle fluctuating demands.
• Develop and implement disaster recovery and backup strategies to prevent data loss and ensure business continuity.
• Conduct regular security assessments to identify and address vulnerabilities within the cloud infrastructure, protecting sensitive research data.

Application Maintenance:

• Regularly review and implement software updates, patches, and upgrades to ensure applications run on the latest versions with enhanced features and security.
• Perform regular data backups, validate the integrity of those backups, and ensure quick recovery in the event of data loss.
• Document changes and updates in system logs and user guides.

Database Support (MySQL):

• Maintain database integrity, performance, and security by regularly reviewing configurations, running optimizations, and implementing best practices.
• Perform regular data backups, validate their integrity, and ensure quick recovery in the event of data loss.
• Optimize database performance through tuning queries, indexing, and other techniques to ensure efficient data retrieval and storage.

Minimum Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field or combination of education and experience.
• 3+ years of experience in enterprise application development, support, or system administration.
• Strong experience in PHP LAMP stack development, including Linux, Apache, MySQL, and PHP.
• Proficiency in database management and maintenance (MySQL).
• Familiarity with cloud services, preferably AWS.
• Understanding of data security practices and compliance regulations, particularly in healthcare environments.
• Demonstrated ability to develop and manage complex system integrations.

Preferred Qualifications

• Advanced degree in a relevant field.
• Certifications in AWS, database administration, or cybersecurity.
• Experience with scripting languages (e.g., Python, JavaScript) for automation and integration tasks.
• Experience with Epic and FHIR protocol.
• Experience with Twilio/Mosio for developing and integrating advanced communication solutions.
• Strong problem-solving skills and the ability to work independently.
• Experience in healthcare or academic environments. 
• Excellent communication and collaboration abilities to support a multidisciplinary research team.

Other Requirements

Equal Opportunity Employer / Disability / Veteran

Columbia University is committed to the hiring of qualified local residents.

About Columbia University

Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.

Job Tags

Similar Jobs