drjobs Database Engineer

Database Engineer

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Ithaca, NY - USA

Monthly Salary drjobs

$ 95071 - 110487

Vacancy

1 Vacancy

Job Description

Database Engineer (Hybrid)

*No Visa Sponsorship is available for this position.


About the Cornell Lab of Ornithology

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.

The Opportunity

Are you a tech-savvy problem solver who loves birds databases and SQL development We are looking for a database engineer to help build the next generation of bird conservation tools! In this role youll: Design develop and maintain complex database infrastructure SQL code and ETL pipelines that support bird research conservation and public engagement. Shape our technical future by helping to build scalable cloud-based platforms. Collaborate across teams to integrate and optimize our database infrastructure creating and supporting seamless high-performance systems.

The primary responsibilities include:

  • 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.

While position responsibilities vary every member of our community is expected to foster a culture of belonging and a psychologically healthy work environment by communicating across differences; being cooperative collaborative open and welcoming; showing respect compassion and empathy; engaging and supporting others regardless of background or perspective; speaking up when others are being excluded or treated inappropriately; and supporting work/life integration of oneself and others.

What We Need

Required Qualifications:

  • Bachelors degree in computer science or related field or equivalent combination of education and experience.
  • Three (3) plus years of relevant experience working with large relational databases in a 24x7 production environment and collaborating with a team of engineers.
  • Exceptional SQL development and query performance tuning skills.
  • Experience with relational database table design.
  • Experience writing database functions in a procedural language such as PL/pgSQL.
  • Experience with ETL architecture and implementation.
  • Experience with cloud infrastructure services from major vendors (e.g. AWS Azure).
  • Experience with container orchestration systems(e.g. Kubernetes Docker).
  • Experience with continuous integration deployment and automation technology such as Jenkins.
  • Experience using collaborative source code versioning with Git.
  • Proven experience documenting and testing code.
  • Ability to troubleshoot and solve database performance and functionality issues in a production environment.
  • Strong problem-solving and critical thinking skills and excellent written and oral communication skills.
  • Ability to work both independently and collaboratively and to build working relationships to solve problems and achieve common goals in a multidisciplinary environment.
  • Ability to establish realistic goals and deliver work on schedule handle multiple concurrent tasks and priorities and adapt to changing priorities situations and demands.
  • High level of integrity and dependability with a strong sense of urgency and results-orientation and an ability to exercise sound judgment in decision making and in accomplishing tasks that are urgent or of a sensitive or confidential nature.
  • Ability to work weekends or evenings when participating in the 24x7 on call duty rotation.

If you have all those things great! We have a few more things that we would prefer you to have but its ok if you dont.

Preferred Qualifications:

  • Advanced degree in computer science or related field.
  • Experience writing complex SQL and procedures for PostgreSQL databases and PostGIS.
  • Experience with NoSQL databases.
  • Familiarity with the Linux command-line and experience with shell scripting.
  • Experience managing large volumes of data for replication warehousing and archival storage.
  • Experience with highly available high volume transactional web applications.
  • 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.
  • Experience using project management tools such as Jira.
  • Prior use and understanding of eBird Merlin BirdCast or other Cornell Lab tools and resources.
  • Interest in birds nature conservation and/or natural science.

Application Information:

  • A Cover Letter and Resume are required for further consideration for this position. When applying through our system please remember to attach your application materials (Cover Letter and Resume) in PDF format.
  • Visa Sponsorship of any kind is not available for this position.
  • This position requires working on-campus three (3) days per week.

What We Offer

Rewards and Benefits

University Job Title:

Software Engineer III

Job Family:

Information Technology

Level:

F

Pay Rate Type:

Salary

Pay Range:

$95071.00 - $110487.00

Remote Option Availability:

Hybrid

Company:

Contract College

Contact Name:

Maria Avila

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

To learn more about Cornells non-union staff job titles and pay ranges see Career Navigator.

Union Positions

The hiring rate of pay for the successful candidate will be determined in accordance with the rates in the respective collective bargaining agreement. To learn more about Cornells union wages see Union Pay Rates.

Current Employees:

If you currently work at Cornell University please exit this website and log in to Workday using your Net ID and password. Select the Career icon on your Home dashboard to view jobs at Cornell.

Online Submission Guidelines:

Most positions at Cornell will require you to apply online and submit both a resume/CV and cover letter. You can upload documents either by dragging and dropping them into the dropbox or by using the upload icon on the application page. For more detailed instructions on how to apply to a job at Cornell visit How We Hire on the HR website.

Employment Assistance:

For general questions about the position or the application process please contact the Recruiter listed in the job posting or email .

If you require an accommodation for a disability in order to complete an employment application or to participate in the recruiting process you are encouraged to contact Cornell Universitys Office of Institutional Equity and Title IX at voice or email at .

Applicants that do not have internet access are encouraged to visit your local library or local Department of Labor. You may also request an appointment to use a dedicated workstation in the Office of Talent Attraction and Recruitment at the Ithaca campus by emailing .

Notice to Applicants:

Please read the required Notice to Applicants statement by clicking here. This notice contains important information about applying for a position at Cornell as well as some of your rights and responsibilities as an applicant.

EEO Statement:

Cornellwelcomes students faculty and staff with diverse backgrounds from across the globe to pursue world-class education and career opportunities to further the founding principle of ... any person ... any study. No person shall be denied employment on the basis of any legally protected status or subjected to prohibited discrimination involving but not limited to such factors as race ethnic or national origin citizenship and immigration status color sex 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 individuals genetic information domestic violence victim status familial status marital status or any other characteristic protected by applicable federal state or local law.

Cornell University embraces diversity in its workforce and seeksjob candidates who will contribute to a climate that supports students faculty and staff of all identities and backgrounds. Wehire based on merit andencourage people from historically underrepresented and/or marginalized identities to with federal law Cornell engages in affirmative action in employment for qualified protected veterans as defined in the Vietnam Era Veterans Readjustment Assistance Act (VEVRRA) and qualified individuals with disabilities under Section 503 of the Rehabilitation Act. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.

Employment Type

Full-Time

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.