Database Engineer

Requisition Id 10809 

Overview:

The Environmental Sciences Division (ESD) of Oak Ridge National Laboratory (ORNL) has an opening for a Data Analyst in its Earth Sciences Informatics portfolio. The successful candidate will be involved with database development and applied data management activities that support software development for scientific data projects in the Earth, climate, and environmental sciences, such as the Atmospheric Radiation Measurement (ARM) Data Center.

Major Duties/Responsibilities:

You will work independently and/or as part of a team in conducting requirements analysis; metrics reporting; developing automated workflows; using scripting languages such as Python; working with open source tools; query development; creating documentation for developers, other operational team members, and program staff.

Specific responsibilities include:

• Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
• Develop monthly/quarterly reports based on ongoing operations
• Work to ensure efficiency of database code, integrity of data structures and quality of data content.
• Work with product managers to ensure database code meets requirements.
• Work to ensure database code is accurately documented.
• Participate as a member in Agile teams, and work with other team members to review user stories, estimate effort to build functionality supporting user stories, and participate in sprint reviews.
• Deliver ORNL's mission by aligning behaviors, priorities, and interactions with our core values of Impact, Integrity, Teamwork, Safety, and Service. Promote diversity, equity, inclusion, and accessibility by fostering a respectful workplace - in how we treat one another, work together, and measure success.

We are seeking a self-starter, willing to develop expertise in data preparation for archiving, discovery and distribution, with an emphasis on advanced database development using modern software architectures. The following skills and experience are desirable:

Basic Qualifications:

• A minimum of one year of experience with database scripts in the form of stored procedures, scripts, queries, views, triggers, etc.
• High School diploma is required

Preferred Qualifications:

• B.S. in Computer Science or Information Systems or related field is preferred.     
• Experience in database development experience and management of complex databases
• Experience with JSON and PostgreSQL support for JSON is preferred
• Experience with Postgraphile is preferred
• Ability to efficiently write database code without compromising data quality, privacy or security
• Knowledge of database design principles, query optimization, index management, integrity checks, and performance statistics
• Familiarity with python
• Able to handle multiple tasks in a fast paced environment
• Excellent verbal, written, and interpersonal communication skills
• Desire to learn and adopt new tools and technologies as required by the projects

This position will remain open for a minimum of 5 days after which it will close when a qualified candidate is identified and/or hired.

We accept Word (.doc, .docx), Adobe (unsecured .pdf), Rich Text Format (.rtf), and HTML (.htm, .html) up to 5MB in size. Resumes from third party vendors will not be accepted; these resumes will be deleted and the candidates submitted will not be considered for employment.

If you have trouble applying for a position, please email ORNLRecruiting@ornl.gov.

ORNL is an equal opportunity employer. All qualified applicants, including individuals with disabilities and protected veterans, are encouraged to apply.  UT-Battelle is an E-Verify employer.