PostgreSQL DBA/Developer

 PostgreSQL DBA/Developer 
Remote

Purpose:

 We are seeking a skilled and motivated PostgreSQL Database Administrator / Developer to join our team supporting a 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. The ideal candidate brings enthusiasm for database technology, takes initiative, and continuously strives to improve performance, reliability, and data quality.

Technical Skills Required:

 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.