Lead DBA - PostgreSQL Database Administration

Chicago 22 hours agoFull-time External
902.1k - 1.1m / yr
Associate Principal, Database Administration - Postgres Postgre is the key to the job They really want somebody with devops experience Terraform ansible jenkins Dbd version is a huge plus SALARY: $130K - $160K PLUS 15% LOCATION: Chicago Hybrid 3 days onsite You are required to have 7 years postgre sql. 3 years terraform ansible Jenkins preferred. The key is postgre sql out of a large enterprise environment with automation in terraform and ansible Responsibilities: • To perform this job successfully, an individual must be able to perform each primary duty satisfactorily. • 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. • Participates in testing and in evaluations of new software and software release upgrades • Supports business studies, proposal teams and costing/feasibility studies • Prepares system documentation • Maintains metadata repositories Qualifications: • [Required] 7+ years’ experience with PostgreSQL (preferred EnterpriseDB (EDB) version) • [Required] 3+ year’ Terraform, Ansible, Jenkins & CI/CD skills • [Preferred] 3+ years’ experience with CTE(CipherTrust Transparent Encryption), Barman (EDB Backup and Recovery Manager) and AWS • [Preferred] 5+ years’ experience with DB2 LUW; preferably on Red Hat Linux • [Preferred] 1+ years’ experience with SQL Server • [Preferred] 1+ years’ experience with MySQL/MariaDB • [Preferred] 1+ years’ experience with DB2 in a z/OS environment Education and/or Experience: • [Required] bachelor’s degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business • [Preferred] Related financial industry experiences Certificates or Licenses: • [Preferred] PostgreSQL Professional Certification • [Preferred] IBM Certified Database Administrator - DB2 for Linux UNIX and Windows INDR Job Type: Full-time Pay: $130,000.00 - $160,000.00 per year Benefits: • 401(k) • Dental insurance • Health insurance • Paid time off • Vision insurance Work Location: Hybrid remote in Chicago, IL 60606