Database Administrator, Cornell Lab of Ornithology

The Cornell Lab of Ornithology is the world's leading resource for conservation, research, education, and citizen science focused on birds. The Lab is a vibrant unit within Cornell's College of Agriculture and Life Sciences (CALS), where twelve world-class, mission-driven programs are directed by full-time faculty and other renowned professionals. Lab staff teach undergraduate courses, advise graduate students, collect and disseminate world-famous digital resources on biodiversity, and engage with partner organizations and citizens around the world to conduct scientific research and conservation actions. Our management and staff are committed to the highest standards of ethics and excellence in all areas of our work, and our Board leadership includes faculty from Cornell and other universities, successful entrepreneurs and managers from the business and non-profit sectors, and conservation-minded citizens from the United States and beyond. The Information Science and Technology program currently manages one of the largest repositories for biodiversity data with over 300,000 active data contributors to eBird who submit almost 100 million observations of birds annually. These data have been used in more than 100 peer-reviewed publications that are shaping research in a diverse variety of fields including ornithology, ecology, human-computer interaction, computer science and statistics. Collaborations and data use extend to a broad range of entities from research initiatives in Information Science, other Lab of Ornithology programs, other departments at Cornell University, external academic institutions, governmental departments and agencies in the U.S. and abroad, NGOs and private companies.

Database Administrator
Database Administrator III - Band F
Lab of Ornithology, College of Agriculture and Life Sciences
Cornell University

The Information Science Program at the Lab of Ornithology is currently seeking a Database Administrator. Specific duties include:

Collaborate with a team of DBAs to direct and manage all aspects of database administration for all of the Lab of Ornithology's bird monitoring citizen-science projects.
Keep abreast of developing technologies and provide guidance and training to team members including transition to cloud-based system(s) when appropriate.
Oversee the planning and tracking of complex projects.
Design, configure, monitor, tune, and maintain large-scale, efficient, secure, and reliable complex integrated relational databases for the Lab.
Work with applications program developers to design and integrate new databases consistent with, and into, an existing flexible database design.
Support program developers, data analysts and researchers by writing efficient and accurate SQL queries to extract data for research, reporting, and website operations.
Become proficient at and perform regular backup and recovery operations for all databases.
Perform database capacity planning.
Design, implement, and manage a database security procedure and adhere to university policies.
Evaluate benefits/risks of enhancements and upgrades being considered for deployment.
Install and upgrade database software while minimizing impact on lab programs.
Troubleshoot and solve database performance and functionality issues.

Required Qualifications:

Bachelor's degree in Computer Science with 3-5 years' experience administering large databases in a production environment with Oracle and other SQL and NOSQL databases.
Strong understanding of variety of database platforms and advantages and disadvantages of each.
Working knowledge of the following Oracle programs, concepts and features: Oracle Data Guard, Oracle Recovery Manager, archivelog management, Oracle Enterprise Manager, SQL and system performance tuning, TKProf and extended SQL trace, Partitioning option, database replication, data warehousing and materialized views, PL/SQL.
Experience with configuration and management of Oracle Spatial.
Familiarity with biological taxonomic concepts.
Demonstrated experience in problem solving, critical thinking, and written and oral communication.
Must be able to work closely with a team and work independently.
Ability to help establish realistic goals and deliver work on schedule.
Experience writing application requirements, architecting applications, and documenting code.
Strong interpersonal skills.
Must feel comfortable with responsibility and adaptability.

Preferred Qualifications:

Interest and knowledge of birds, birding, conservation and big data science.
Experience managing database in the cloud with Amazon Cloud Computing Services, Oracle Managed Cloud Services, and/or Google Cloud Platform.

Applicants to provide cover letter, resume, contact information for 3 references.

When applying through our system, please remember to attach your application materials (resume/cover letter/CV) in either Microsoft Word or PDF. In the Experience section of your application, use the Paperclip icon to search for file(s) or use the 'Drop Files Here' box to manually drag document(s) into your application. For a more detailed description and instructions on how to create a profile online please click here as an external candidate or click here if you are an internal candidate

Visa Sponsorship is not available for this position; not eligible to apply.

Relocation assistance is not provided for this position.

University Job Title:
Database Administrator III
Level:
F
Pay Rate Type:
Salary
Company:
Contract College
Contact Name:
Sue Taggart
Number of Openings:
1
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.

Background check may be required.

More at: http://ebird.org/content/ebird/jobs/#DBA