Our Ability Jobs

Employer Name: Columbia University

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.