PostgreSQL Database Engineer

Posted:
10/23/2024, 3:12:00 AM

Location(s):
Georgia, United States ⋅ Alpharetta, Georgia, United States

Experience Level(s):
Senior

Field(s):
Data & Analytics ⋅ IT & Security ⋅ Software Engineering

Workplace Type:
Remote

Orion Innovation is a premier, award-winning, global business and technology services firm.  Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and engineering, with a unique combination of agility, scale, and maturity.  We work with a wide range of clients across many industries including financial services, professional services, telecommunications and media, consumer products, automotive, industrial automation, professional sports and entertainment, life sciences, ecommerce, and education.

Job Description:

The PostgreSQL Database Engineer will be part of a team of DBAs supporting other teams consisting of application developers, organizational Production and Dev Ops resources.  The engineer will be responsible for maintenance, implementation and performance of critical PostgreSQL RDBMSs hosted on local and remote Linux based servers.

The successful candidate will be responsible for database and code analysis, performance tuning, SQL and stored procedure development and testing.  As with any engineering position, creating and maintaining technical documentation will be performed.

Responsibilities: 

  • Manage PostgreSQL databases servers during multiple product lifecycle environments, from design to production systems.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
  • Assist developers with complex query tuning and reference refinement.
  • Research, Test and Recommend database structural and performance enhancements.
  • Share technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • Write PL SQL procedures when needed

Qualifications: 

  • 5+ years PostgreSQL, Oracle, or similar RDBMS products Administration experience.
  • 5+ years of experience with SQL and CLI interfaces such as PSQL and SQL*Plus.
  • 5+ years of experience with Linux or UNIX operation systems.
  • Experience with Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
  • Experience with backups, restores and recovery models.
  • Experience with range type table/index partitioning.
  • Experience with automatic queuing such as PGQ.
  • Experience with database stored procedure scripting languages such as PG/PLSQL or PLSQL.
  • Knowledge of Physical High Availability (HA) and Disaster Recovery (DR) methods.
  • Excellent written and verbal communication.
  • Ability to organize and plan work independently.
  • Ability to work in a rapidly changing environment.

Orion is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, citizenship status, disability status, genetic information, protected veteran status, or any other characteristic protected by law.

Candidate Privacy Policy

Orion Systems Integrators, LLC and its subsidiaries and its affiliates (collectively, “Orion,” “we” or “us”) are committed to protecting your privacy. This Candidate Privacy Policy (orioninc.com) (“Notice”) explains:

  • What information we collect during our application and recruitment process and why we collect it;
  • How we handle that information; and
  • How to access and update that information.

Your use of Orion services is governed by any applicable terms in this notice and our general Privacy Policy.