The Division of Anthropology seeks a DBA & Software Developer to carry on the work laid out over the past 25 years in which our programmer developed our Collections Management System. The system consists of the Archaeological and Ethnographic Collections at its core and includes components for Biological Anthropology, Conservation, Archives, Integrated Management, Image Management and Thesaurus Management. Some components are in a SQL Windows/SQL Base system on a Windows 2012 server and some are browser-based components developed using ColdFusion and MySQL also on a Windows 2012 server. The Division’s website has also been developed and managed by the programmer and includes a public facing component of the database.
The Division is currently in the process of migrating and consolidating the Collections Management Database with the help of a consulting company that is providing the new software on the LAPM platform.
This position will maintain the current mixed environment system for a short time while the systems are migrated to the new platform. Once migration is completed duties will include the customization and maintenance of the new system, configuration of web and database servers, backup and tuning of database, and management of user privileges.
The developer will maintain and expand functionality of the Collections Management Database (including Biological Anthropology, Conservation, Integrated Management, Image Management and Thesaurus Management Systems); will maintain, upgrade and enhance the Division’s website (http://anthro.amnh.org/); will collaborate with other cultural institutions in sharing collection data through the web.
The developer will assist the Division staff and Web users in working with information systems.
The developer will be responsible for overseeing migration of the existing systems from Client/Server architecture (SQLWindows/SQLBase and ColdFusion) to the LAMP platform, working closely with the
consulting company providing the new software. Both Windows and Linux server knowledge are necessary for this transition as the new systems will be Linux based (Cent OS) while the old system is Windows based (Windows Server 2012).
Bachelor’s degree in related field.
5+ years of professional hands-on experience in working with the following programming tools:
– PHP (knowledge of PEAR, Symfony or other php frameworks is a plus)
– MySQL5 (including use of advanced functions, stored procedures and triggers)
– HTML, CSS, XML, JSON.
Experience in configuring of Apache (including SSL) and MySQL servers.
Knowledge of Linux and Windows servers.
Knowledge of ColdFusion is a plus.
The American Museum of Natural History is an Equal Opportunity/Affirmative Action Employer. The Museum does not discriminate with respect to employment, or admission or access to Museum facilities, programs or activities on the basis of race, creed, color, religion, age, disability, marital status, partnership status, gender, sex, sexual orientation, gender identity, gender expression, genetic information, pregnancy, alienage or citizenship status, current or former participation in the uniformed services, status as a veteran, or national or ethnic origin, or on account of any other basis prohibited by applicable City, State, or Federal law. Additional protections are afforded in employment based on arrest or conviction record, status as a victim of domestic violence, stalking and sex offenses, unemployment status, and credit history, in each case to the extent provided by law. If special accommodations are needed in applying for a position, please call the Office of Human Resources.