PostgreSQL Database Administrator (Chicago)

Chicago 10 days agoFull-time External
Negotiable
• **Hybrid, 3 days onsite, 2 days remote*** • **We are unable to sponsor as this is a permanent full-time role*** A prestigious company is in need of a PostgreSQL Database Administrator. This DBA must have 7+ years of experience working with PostgreSQL, along with 3+ years of experience with Ansible, Terraform, Jenkins, CI/CD, etc. Responsibilities: • Assists with the design, implementation, and maintaining databases • Manage database performance and disk usage • Provides support in database access methods • Provides consultation support in database analysis, modeling, coding, and production problem resolution. • Develops maintenance, backup and recovery procedures and documentation • Participates in Disaster Recovery drills • Provides Primary On-Call Support for production problems • Understands and supports corporate data standards • Recommends and assists with new DBMS and operational standards. Qualifications: • Bachelors degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business • 7+ years experience with PostgreSQL (preferred EnterpriseDB (EDB) version) • 3+ year Terraform, Ansible, Jenkins & CI/CD skills • 3+ years experience with CTE(CipherTrust Transparent Encryption), Barman (EDB Backup and Recovery Manager) and AWS • 5+ years experience with DB2 LUW; preferably on Red Hat Linux • 1+ years experience with SQL Server • 1+ years experience with MySQL/MariaDB • 1+ years experience with DB2 in a z/OS environment • 3+ years experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years experience as an associate DBA • Well versed in all phases of Systems Analysis and Design • Experienced in two or more programming languages and two or more scripting languages • Practiced at Entity/Relationship or Object modeling and translation to physical database designs • Proficient in DML, DDL, and database utilities for at least two DBMS technologies • Proficient in all access methods of a DBMS as well as the underlying operating system access methods