Job Announcement: ILS Developer/System Administrator The Public Library of Cincinnati & Hamilton County invites qualified applicants to apply for the following position. The position reports to the ILS Manager and is located within the Technology Operations division of the Library. ILS Developer/System Administrator
POSITION SUMMARY: The ILS Developer/System Administrator is responsible for the development and maintenance of custom scripts, reports, and applications using data from the Library's Integrated Library System (ILS). Position includes system administration of the Linux-based ILS servers. RESPONSIBILITIES (not all-inclusive) all of the duties listed below are essential job functions for which reasonable accommodations will be made. All job requirements listed indicate the minimum level of knowledge, skills and/or ability deemed necessary to perform the job proficiently. This job description is not to be construed as an exhaustive statement of duties, responsibilities or requirements. Employees may be required to perform any other job-related instructions as requested by their supervisor, subject to reasonable accommodations. ESSENTIAL FUNCTIONS: * Plans, develops, tests, and documents computer programs to support Library operations. * Develops scripts and queries for data loads, extractions, and display of patron, item, transaction, and bibliographic record data (stored in a PostgreSQL database). * Develops scripts to send data via email and ftp. * Customizes and configures discovery layer and other public catalog interfaces. * Confirms program operation by conducting tests and modifying program code, adapting the program to new requirements when necessary. * Controls database access and security; implements connections to third-party systems and APIs. * Monitors scripts and troubleshoots issues with Library data. * Identifies and resolves problems with integrated library system software, working with the software vendor when necessary. * Develops and implements maintenance procedures and daily runtime procedures. * Writes detailed documentation of procedures and report functionality. * Identifies the needs of staff and manages solutions in conjunction with team analysts and manager. * Learns new technologies on an ongoing basis including through self-study, discussion lists, professional workshops and conferences. * Regular and reliable attendance is required. MINIMUM QUALIFICATIONS: * Experience developing and maintaining scripts to automate tasks. * Experience using Perl or similar C-family scripting language. * Demonstrated experience developing custom SQL queries and reports. * Experience with Linux shell scripting. * Basic HTML/CSS/XML/JavaScript skills. * Experience using APIs to update databases. * Ability to create scripts to export data in various formats (XML, CSV, Excel, etc.). * Self-motivated for independent work. Strong ability to research and develop own solutions. * Demonstrated ability to troubleshoot issues with systems and data and to manage solutions. * Strong analytical skills to interpret user needs in order to extract and load appropriate data. * Good verbal and written communication skills. * Customer service focus. * Ability to work in a changing environment. PREFERRED QUALIFICATIONS: * Linux system administration experience including performing system back-ups and upgrades. * Knowledge of library data, including bibliographic record structures and core library operations, such as circulation, cataloging, and discovery. * Experience with database querying for an Integrated Library System (Innovative Interfaces Sierra preferred). * Experience with Classic .ASP or .NET framework. * Experience with other programming technologies such as Mojolicious, jQuery, Docker, and nginx. EDUCATION: Bachelor's Degree in Information Systems/Computer Science or an equivalent combination of education and experience. SPECIAL REQUIREMENTS * "On Call" 24 hours per day, 7 days per week for emergency response to production system problems. Job Location Cincinnati, Ohio, United States Position Type Full-Time/Regular Hours 40 hours per week Salary Grade J: $58,697.60 - $88,108.80 annual Interested applicants should apply online at http://www.cincinnatilibrary.org/info/currentopenings.html
