PostgreSQL Database Engineer – Linux & Scripting

Erias Ventures, LLC; Maryland; On-site; USD 150,000 - 175,000; Full time

Benefits offered by this job

Above Market Hourly Pay

11% Roth or Traditional 401k with vest

Spot Bonuses for business growth

Professional Development Bonuses

Medical Coverage

Vision and Dental Coverage

Long Term Disability and Life

Wellness Reimbursement

Paid Time Off with Flexible Work S

Job summary

Erias Ventures is seeking a Database Engineer to design, implement, and optimize PostgreSQL schemas, indexes, and queries for scalable performance in a Linux environment. The role focuses on HA/replication, data management, and collaborating with developers on complex queries and stored procedures.

Responsibilities include monitoring with native tools and scripts, automating routine tasks with Bash/Python, and documenting architectures and best practices.

Qualifications

• Five years of DBE experience required; bachelor’s degree or five years substitute.
• Strong SQL skills and performance tuning
• Proficient in Linux/Unix and psql CLI
• Experience with replication, partitioning, backups
• Familiar with monitoring tools pg_stat_statements, Prometheus, Grafana

Responsibilities

• Design and optimize PostgreSQL schemas, indexes, and queries
• Monitor and tune database performance with native tools
• Implement high availability and replication strategies
• Collaborate to refine complex queries and stored procedures
• Automate routine tasks with Bash and Python
• Document architecture, processes, and best practices

Skills

SQL tuning

Linux/Unix

Replication & partitioning

Monitoring tools

Automation scripting

Education

Bachelor's degree in technical field

Tools

Docker

Kubernetes

AWS RDS

GCP Cloud SQL

Azure PostgreSQL

Terraform

Ansible

Oracle/MySQL

Job description

Erias Ventures is seeking a Database Engineer to design, implement, and optimize PostgreSQL schemas, indexes, and queries for scalable performance in a Linux environment. The role focuses on HA/replication, data management, and collaborating with developers on complex queries and stored procedures.

Responsibilities include monitoring with native tools and scripts, automating routine tasks with Bash/Python, and documenting architectures and best practices.