PostgreSQL Database Engineer (Remote)

Requisition Id 14385 

Annual Salary Range:$$130,000.00 -$$160,000.00 

Work-Site Type: Remote 

 

ORNL offers a flexible work environment that supports both the organization and the employee.  In addition, this position is considered remote-eligible for ORNL in pre-approved locations.  Remote-eligibility is not a continued guarantee and could be subject to change based on evolving organizational needs.

 

Note about pay range:

Please note that the pay range information is a general guideline only. Many factors are taken into consideration when setting starting pay. Salary for this position will be commensurate with the final candidate’s qualifications and experience, including skills, knowledge, relevant education, certifications, plus also aligned with the internal peer group. It is not typical for an individual to be offered a salary at or near the top of the range for a position. Link to benefits. https://jobs.ornl.gov/content/Benefits/?locale=en_US

 

­­Overview:  

We’re hiring a PostgreSQL Database Engineer! This position resides in the Research & Development group of the Software Engineering Group in the Application Development division of the Information Technology Services Directorate at Oak Ridge National Laboratory (ORNL).

 

The Research & Development group focuses on engineering the next generation of high-quality scientific software. Our group innovates and inspires the next generation of cutting-edge scientific software, thus enabling Oak Ridge National Laboratory (ORNL) to host the world’s premier scientific software engineering group and transform science with software-defined solutions that are reliable, usable, and trustworthy.

 

Major Duties/Responsibilities: 

 

• Database Development & Maintenance:
  • Design, implement, and maintain complex PostgreSQL databases and schemas.
  • Write and optimize SQL queries, stored procedures, triggers, and functions.
  • Ensure data integrity, consistency, and security within the database environment.
  • Perform regular database tuning to improve performance and ensure efficient execution of queries.
  • Develop and manage database migrations, version control, and backup strategies.

 

• Data Analysis & Reporting:
  • Develop efficient data models for application requirements and reporting.
  • Assist in analyzing, querying, and visualizing large datasets for actionable insights.
  • Implement and maintain data pipelines, ETL processes, and batch jobs for data movement.

 

• Collaboration & Documentation:
  • Collaborate with backend developers, data engineers, and other stakeholders to integrate PostgreSQL with application architectures.
  • Provide technical support for troubleshooting database-related issues.
  • Write clear and comprehensive documentation for database design, queries, and best practices.
  • Conduct code reviews and share knowledge with team members.

 

• Database Security & Compliance: