Database Engineer

The Cornell Lab of Ornithology is a globally recognized leader in technology, data management, and large-scale citizen science supporting birds and biodiversity conservation. We curate more than a petabyte of digital assets, one billion bird sightings, and leverage innovative big data analysis tools and machine learning to produce web applications and services to empower a global community of bird and nature enthusiasts, researchers, conservationists, and educators. We rely on a team of high-performance engineers to help navigate intriguing technical challenges to provide data-driven services, learning platforms, and science communications supporting biodiversity and conservation communities in all corners of the globe. This role will develop technical infrastructure and services that support numerous user-facing applications, including eBird, Merlin, Macaulay Library, Birds of the World, and BirdCast. Design, develop, and maintain complex database schemas, stored procedures, SQL queries and related database services for the Center for Avian Population Studies and Macaulay Library at the Cornell Lab of Ornithology (CLO). Participate actively in the design and evolution of our database infrastructure, including rearchitecting the data warehouse providing aggregated data for application and end-user needs. Work closely with application developers and other technical staff to design, test, and troubleshoot database structures and queries. Design, develop, and maintain scheduled jobs for data processing, monitoring, and alerting. Carry out and assist others with data migration, transformation, import, and export, including designing and implementing solutions to meet data reporting needs. Stay up to date on the latest database best practices, processes, and technologies. Contribute to the overall success of the engineering team.

The Cornell Lab of Ornithology is a globally recognized leader in technology, data management, and large-scale citizen science supporting birds and biodiversity conservation.