Database Engineer

Description:

The Environmental Sciences Division (ESD) of Oak Ridge National Laboratory (ORNL) has an opening for a Database Engineer in its Earth Sciences Informatics portfolio. You 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 research, develop, and operations of database technologies, conducting requirements analysis; developing automated workflows; using scripting languages such as Python; knowledge of Linux command-line interface; working with open source tools; database relationships and query development; ability to work with distributed and diversified teams on various data flow processes; ability to multitask; create 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.
• Work with front end developers to define simple yet powerful APIs.
• 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.
• Work to maintain Postgraphile environment.
• 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.

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:

• High School diploma and 10 years of experience is required or BS degree and eight years of experience or MS degree and seven years of experience
• M.S. or B.S. in Computer Science or Information Systems or related field is preferred.
• Minimum of five years of database development experience and management of complex databases
• Knowledge of SQL, PL/pgSQL, including stored procedures, functions, triggers, and views
• Knowledge of JSON and PostgreSQL support for JSON
• Ability to efficiently write database code without compromising data quality, privacy or security
• Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
• Familiarity with python
• Able to handle multiple tasks in a fast paced environment
• Excellent verbal, written, and interpersonal communication skills
• Ability to evaluate alternative solutions and/or workarounds
• Desire to learn and adopt new tools and technologies as required by the projects