Role OverviewWe are seeking a skilled and motivated PostgreSQL Database Administrator / Developer to join our team supporting a federal government customer. This mid-level role sits at the intersection of database operations and application development, requiring a candidate who is equally comfortable writing advanced SQL, building robust procedural logic, supporting production systems, and working with spatial data using PostGIS.
What You Will Do
Maintain PostgreSQL instances across development, staging, and production environments. Monitor database health, disk usage, query performance, and resource utilization; take corrective action proactively in consultation with senior database personnel. Develop complex SQL queries, including CTEs, window functions, and analytical SQL to support application and reporting requirements.
Why It Might Be a Fit
The ideal candidate brings enthusiasm for database technology, takes initiative, and continuously strives to improve performance, reliability, and data quality.
Requirements
- 7+ years of hands-on PostgreSQL development and administration experience in production environments
- Bachelor's degree in Computer Science, Information Technology, GIS, Engineering, or related field (or equivalent experience)
- Strong proficiency in advanced SQL, including window functions, CTEs, subqueries, set operations, and analytical queries
- Solid PL/pgSQL development experience, including stored procedures, functions, triggers, and custom types
- Demonstrated PostGIS experience, including spatial schema design, geometry functions, spatial joins, and index optimization
- Experience with performance tuning, query plan analysis, indexing strategies, and server-side configuration
- Experience working in Linux/Unix environments and scripting in Bash, Python, or similar languages
- Familiarity with cloud-hosted PostgreSQL environments, including AWS RDS/Aurora PostgreSQL
- Experience with GDAL/OGR, QGIS, or other GIS tools supporting PostGIS workflows
- Working knowledge of containerization technologies such as Docker and Kubernetes, and infrastructure-as-code tools including Terraform and Ansible
- Familiarity with CI/CD practices, database migration frameworks such as Flyway and Liquibase, and version-controlled schema management
- Experience working in an Agile/Scrum environment
- U.S. Citizen or person with valid U.S. Work Visa who has lived in the U.S. for 3 or more years
- Strong communication skills with the ability to explain technical concepts to both technical and non-technical stakeholders
- Self-starter mindset with the ability to identify issues independently and drive them to resolution
Benefits
- medical
- dental
- vision
- short- and long-term disability insurance
- life insurance
- commuter benefit
- flexible spending account
- 401K
- paid holidays
- Paid Time Off (PTO)
]]>