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