Senior PostgreSQL DB Engineer — Terabyte-Scale Data

WarCollar Industries, LLC; Herndon (VA); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical insurance

PTO hours

Holidays & birthday

401k matching

Education reimbursement

Training days

Performance bonuses

Referral bonuses

Shutdown protection

Team events

Job summary

WarCollar Industries, LLC seeks an experienced Database Developer in Herndon, VA to design, develop, maintain, and optimize enterprise-scale databases for mission-focused analytics. You will translate data needs into reliable database solutions capable of handling terabytes of data and support analysts and stakeholders across multiple channels.

The role requires 7+ years of database management experience, strong PostgreSQL skills, and the ability to work onsite.

Qualifications

• Write, maintain, troubleshoot, and debug SQL stored procedures.
• Collaborate with analysts and stakeholders to translate data collection requirements into implementable database solutions.
• Develop and optimize SQL queries operating against terabytes of data.
• Design and maintain database tables with clear schemas, appropriate indexing, and logical partitioning.
• Analyze data sources for accuracy, prioritization, and applicability to mission requirements.
• Apply appropriate data logic and database development practices to support reliable and scalable solutions.
• Troubleshoot database issues and identify opportunities to improve performance, reliability, and accessibility.
• Collaborate effectively with technical teams and mission stakeholders across multiple communication channels.
• Support database operations within Linux-based environments.

Skills

SQL stored procedures

PostgreSQL

Query optimization

Schema design

Indexing

Partitioning

Data quality analysis

Database troubleshooting

Linux

Stakeholder collaboration

Big data handling

Job description

WarCollar Industries, LLC seeks an experienced Database Developer in Herndon, VA to design, develop, maintain, and optimize enterprise-scale databases for mission-focused analytics. You will translate data needs into reliable database solutions capable of handling terabytes of data and support analysts and stakeholders across multiple channels.

The role requires 7+ years of database management experience, strong PostgreSQL skills, and the ability to work onsite.