What are the responsibilities and job description for the Lead Database Administrator - PostgreSQL position at Request Technology, LLC?
Lead Database Administrator – PostgreSQL
Salary: Open Bonus
Location: Chicago, IL
Hybrid: 3 days onsite, 2 days remote
*We are unable to provide sponsorship for this role*
Qualifications
- Bachelor’s degree
- 7 years’ experience with PostgreSQL
- 3 years’ Terraform, Ansible, Jenkins & CI/CD skills
- Well versed in all phases of Systems Analysis and Design
- Experienced in two or more programming/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
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.
- Participates in testing and in evaluations of new software and software release upgrades