Database Engineer (Hybrid/Fully Remote)

Details

Posted: 31-Mar-24

Location: Ithaca, New York

Type: Full-time

Salary: Open

Categories:

Staff/Administrative

Internal Number: 3-80421

Database Engineer (Hybrid/Fully Remote)

Join Our Team as a Database Engineer for the Lab of Ornithology at Cornell University!

If you're eager to make an impact and be part of a dynamic team, then we invite you to explore this exciting opportunity with us!

The College of Agriculture and Life Sciences at Cornell University embraces diversity and seeks candidates who will contribute to a climate that supports students, faculty, and staff of all identities and backgrounds. We strongly encourage individuals from underrepresented and/or marginalized identities to apply.

About The Department

The Cornell Lab of Ornithology is a globally recognized leader in technology, data management, and large-scale participatory science supporting birds and biodiversity conservation. We curate more than a petabyte of digital assets, nearly two 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.

The Cornell Lab is in an incredible growth phase and we rely on a team of high-performance engineers to navigate complex challenges to scale our data-driven tools and services for conservation communities in all corners of the globe.

The Lab engages millions of people a year through our innovative educational platforms and data-powered citizen science enterprises. We are committed to fostering a healthy workplace that values diverse perspectives and backgrounds as well as supporting growth and advancement opportunities. The Lab welcomes staff who are still learning in their careers and who are motivated to take on new challenges.

About The Opportunity

This role is part of our core engineering team and will develop and maintain database infrastructure and services that support numerous user-facing applications, including eBird, Merlin, Macaulay Library, Birds of the World, and BirdCast.

We are seeking a skilled and highly motivated full-time Database Engineer who will:

Design, implement, and maintain highly available large-scale cloud based production database infrastructure for the Cornell Lab of Ornithology (CLO). Participate actively in the design and evolution of CLO technical infrastructure and database platforms, including scalable, agile, cloud-based systems. Actively develop, monitor, and improve the performance and reliability of database systems, working closely with application developers and other technical staff to optimize database architecture and query design. Serve as a technical liaison supporting coordination and integration of application infrastructure to meet CLO strategic objectives. Stay current on database infrastructure and database development best practices and processes.

The engineering team is based at the Cornell Lab of Ornithology in Ithaca, NY. There is some flexibility on work location for this position which could either be located in Ithaca with a hybrid work arrangement or be fully remote.

What We Need

The successful candidate will have Bachelor's degree in computer science or related field with 5+ years experience or equivalent combination administering large relational databases in a 24x7 production environment that includes installing, configuring, monitoring, upgrading, and maintaining complex database systems. Experience in and/or demonstrated commitment to supporting diversity, equity, access, inclusion, and wellbeing.

• Extensive experience with managed database services such as Amazon RDS.
• In depth knowledge of relational DBMS theory, design, and technology.
• Exceptional SQL development and performance tuning skills.
• Experience writing database functions in a procedural language such as PL/pgSQL.
• Experience working with and supporting software developers including with schema design, query development, performance tuning, and optimization.
• Experience with source control management systems such as git.
• Experience designing, documenting, and implementing backup and recovery plans and database security policy.
• Ability to troubleshoot and solve database performance and functionality issues.
• Experience with proactive monitoring and problem solving to continuously improve database performance.
• Ability to work weekends or evenings when participating in the 24-7 on call duty rotation.

Preferably the successful candidate will also have the following;

• Advanced degree in computer science or related field.
• Experience administering PostgreSQL databases and expertise with PostgreSQL system metrics and optimization strategies.
• Experience with ETL architecture and implementation.
• Experience with Infrastructure as Code and with Terraform or similar IaC tooling.
• Experience with scheduling and automation tools such as Rundeck.
• Experience or familiarity with database migrations using tools like Flyway or Liquibase.
• Familiarity with the Linux command-line and experience with shell scripting.
• Experience working with data analysts and researchers including writing efficient and accurate SQL queries to extract data for research and reporting.
• Prior use and understanding of eBird, Merlin, BirdCast or other Cornell Lab tools and resources.
• Interest in birds, nature, conservation, and/or natural science.

Rewards and Benefits

No Visa Sponsorship is available for this position.

How to Apply:

You must submit both a Resume and Cover letter.

Cornell University is an innovative Ivy League university and a great place to work. Our inclusive community of scholars, students, and staff impart an uncommon sense of larger purpose and contribute creative ideas to further the university's mission of teaching, discovery, and engagement.

Diversity and Inclusion are a part of Cornell University's heritage. We are a recognized employer and educator valuing AA/EEO, Protected Veterans, and Individuals with Disabilities. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations.

University Job Title:

Database Administrator IV

Job Family:

Information Technology

Level:

G

Pay Rate Type:

Salary

Pay Range:

$105,889.00 - $129,419.00

Remote Option Availability:

Hybrid Remote

Company:

Contract College

Contact Name:

Denise Smith

Job Titles and Pay Ranges:

Non-Union Positions

Noted pay ranges reflect the potential pay opportunity for each job profile. The hiring rate of pay for the successful candidate will be determined considering the following criteria:

• Prior relevant work or industry experience

• Education level to the extent education is relevant to the position

• Unique applicable skills

• Academic Discipline (faculty pay ranges reflects 9-month annual salary)

Union Positions

Current Employees:

Online Submission Guidelines:

Employment Assistance:

Notice to Applicants:

EEO Statement:

Diversity and Inclusion are a part of Cornell University's heritage. We are a recognized employer and educator valuing AA/EEO, and we do not tolerate discrimination based on any protected characteristic, including race, ethnic or national origin, citizenship and immigration status, color, sex/gender, pregnancy or pregnancy-related conditions, age, creed, religion, actual or perceived disability (including persons associated with such a person), arrest and/or conviction record, military or veteran status, sexual orientation, gender expression and/or identity, an individual's genetic information, domestic violence victim status, familial status, marital status, or any other characteristic protected by applicable federal, state, or local law. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.

Cornell University embraces diversity and seeks candidates who will contribute to a climate that supports students, faculty, and staff to all identities and backgrounds. We encourage individuals from underrepresented and/or marginalized identities to apply.

2024-01-30