Lead SQL DBA w/ Postgres
Overview
In this Lead SQL DBA role you will design, implement, and optimize database solutions at scale. You will work closely with cross-functional teams to ensure robust performance and availability, focusing on PostgreSQL and legacy DB2 LUW environments. The position includes on-site collaboration in Chicago and a strong emphasis on automation and CI/CD practices. You will shape data platforms and drive reliability through structured maintenance and recovery procedures.
ResponsibilitiesDesign, implement, and maintain databases and database solutionsMonitor, tune, and manage database performance and disk usageSupport database access methods and provide consultation on analysis, modeling, coding, and production issue resolutionDevelop and document maintenance, backup, and recovery procedures
Key requirements3+ years developing/maintaining complex applications with a supported database technology or 3+ years as an associate DBAExperience in two or more programming languages and two or more scripting languagesEntity/Relationship or Object modeling experience translating to physical designsProficiency in DML, DDL, and database utilities for at least two DBMS7+ years PostgreSQL experience (EnterpriseDB preferred)3+ years Terraform, Ansible, Jenkins & CI/CD skills5+ years DB2 LUW experience (Red Hat Linux preferred)Bachelor’s DegreePostgreSQLEnterpriseDB (EDB) versionDB2 LUWTerraformAnsibleJenkins