Database Administrator (PostgreSQL & DB2)

Spero Technology • chicago, il, us • 3m ago

Primary Duties and Responsibilities: To perform this job successfully, an individual must be able to perform each primary duty satisfactorily.

Design, Implement, and Maintain PostgreSQL and DB2 Databases: Lead efforts in designing, implementing, and maintaining robust PostgreSQL and DB2 database systems, ensuring optimal performance and reliability.
Database Performance Management: Proactively manage and optimize PostgreSQL and DB2 performance, including tuning queries, managing disk usage, and ensuring high availability.
Database Access Support: Provide expert support in database access methods, particularly for PostgreSQL and DB2, ensuring secure and efficient data retrieval.
Consultation and Problem Resolution: Offer specialized consultation in database analysis, modeling, coding, and production problem resolution, with a focus on PostgreSQL and DB2 environments.
Backup, Recovery, and Maintenance: Develop and document comprehensive maintenance, backup, and recovery procedures for PostgreSQL and DB2 databases, ensuring data integrity and availability.
Disaster Recovery Participation: Actively participate in Disaster Recovery drills, ensuring PostgreSQL and DB2 databases are included in recovery plans and tests.
Primary On-Call Support: Serve as the primary on-call support for PostgreSQL and DB2 production issues, ensuring timely resolution of critical database problems.
Corporate Data Standards Support: Understand and enforce corporate data standards, particularly in PostgreSQL and DB2 implementations.
DBMS Standards and Evaluation: Recommend and assist with the implementation of new DBMS technologies, with a particular emphasis on PostgreSQL and DB2 standards and operational best practices.
Software Testing and Evaluation: Participate in testing and evaluating new PostgreSQL and DB2 software versions and release upgrades to ensure seamless integration and performance.
Support Business Initiatives: Provide expert support to business studies, proposal teams, and costing/feasibility studies with a focus on leveraging PostgreSQL and DB2 capabilities.
System Documentation: Prepare and maintain detailed system documentation for PostgreSQL and DB2 environments.
Metadata Management: Maintain and manage metadata repositories, ensuring accurate and up-to-date data models for PostgreSQL and DB2 systems.
Other duties as assigned.

Qualifications: The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the primary functions.

[Required] 3+ years' experience with PostgreSQL and DB2 LUW: Extensive hands-on experience managing, tuning, and troubleshooting PostgreSQL and DB2 databases, preferably in a Red Hat Linux environment.
[Required] Expertise in Database Development: Proficient in developing and maintaining complex applications that heavily utilize PostgreSQL and DB2 databases.
[Required] Strong SQL and Database Utility Skills: Proficient in SQL, stored procedures, triggers, and database utilities specifically for PostgreSQL and DB2.
[Required] Systems Analysis and Design: Well-versed in all phases of Systems Analysis and Design, with a focus on database-driven applications using PostgreSQL and DB2.
[Required] Database Modeling: Practiced in Entity/Relationship and Object modeling, with the ability to translate models into physical PostgreSQL and DB2 database designs.
[Required] Knowledge of Operating Systems and Access Methods: Proficient in all access methods of PostgreSQL and DB2, including a deep understanding of the underlying operating system access methods.
[Required] Understanding of Software Subsystems: Comprehensive understanding of software subsystems (DBMS, TP Managers, etc.) within a PostgreSQL and DB2 environment.
[Required] Initiative and Ownership: Demonstrates strong initiative, ownership, and a proactive approach to managing PostgreSQL and DB2 databases.
[Required] Sense of Urgency: Maintains a strong sense of urgency in managing PostgreSQL and DB2 systems, ensuring critical issues are addressed promptly.
[Required] Communication and Mentorship: Communicates openly and effectively, with a willingness to mentor others in PostgreSQL and DB2 database management.

Technical Skills:

[Required] 3+ years' experience with PostgreSQL and DB2 LUW: Proven track record of managing PostgreSQL and DB2 databases, particularly in a Linux environment.
[Required] SQL and Stored Procedure Proficiency: Skilled in writing and reviewing SQL, stored procedures, and triggers for PostgreSQL and DB2 databases.
[Preferred] 1+ year' Terraform, Ansible, Jenkins & CI/CD skills.
[Preferred] 1+ years' EDB Postgres & EDB Postgres Distributed experience.
[Preferred] Basic Java, Perl & Linux Shell script skills.
[Preferred] 1+ years' experience with SQL Server, DB2 on z/OS, and MySQL/MariaDB.
[Preferred] Experience with BMC tools for DB2 (Change/Catalog Manager, MainView, Log Master).
[Preferred] Basic JCL & REXX script skills.

Education and/or Experience:

[Required] Bachelor's degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business.
[Preferred] Related financial industry experience.

Certificates or Licenses: