Logo
Request Technology

DB2 LUW Postgre DBA

Request Technology, Chicago, Illinois, United States, 60290


***We are unable to sponsor for this permanent full-time role*****Position is bonus eligible***Prestigious Financial Institution is currently seeking a DB2 LUW Database Administrator with Postgre experience. Candidate will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance.Responsibilities:Assists with the design, implementation, and maintaining databasesManage database performance and disk usageProvides support in database access methodsProvides consultation support in database analysis, modeling, coding, and production problem resolution.Develops maintenance, backup and recovery procedures and documentationParticipates in Disaster Recovery drillsProvides Primary On-Call Support for production problemsUnderstands and supports corporate data standardsRecommends and assists with new DBMS and operational standards.Participates in testing and in evaluations of new software and software release upgradesSupports business studies, proposal teams and costing/feasibility studiesPrepares system documentationMaintains metadata repositoriesOther duties as assignedQualifications:[Required] 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[Required] Well versed in all phases of Systems Analysis and Design[Required] Experienced in two or more programming languages and two or more scripting languages[Required] Practiced at Entity/Relationship or Object modeling and translation to physical database designs[Required] Proficient in DML, DDL, and database utilities for at least two DBMS technologies[Required] Proficient in all access methods of a DBMS as well as the underlying operating system access methods[Required] Knowledge of hardware and operating system capabilities within one environment[Required] Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment[Required] Accepts ownership in assignments, team, and company and takes initiative outside immediate area of responsibility[Required] Speed / Sense of Urgency -Contributes additional effort when necessary to get the job done and to help others meet their objectives[Required] Seeks additional responsibility, shows initiative to learn every aspect of the job, and strives to become a mentor to others in area of expertise[Required] Communicates openly and effectively. Challenges established practices appropriately[Required] Ability to maintain composure under pressure and avoid defensive or irritated or reactions in challenging situationsTechnical Skills:[Required] 7+ years' experience with PostgreSQL[Required] 7+ years' experience with DB2 LUW; preferably on Red Hat Linux[Required] Proficient with coding and review of SQL, stored procedures, and triggers[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[Preferred] 1+ years' experience with DB2 in a z/OS environment[Preferred] 1+ years' experience with MySQL/MariaDB[Preferred] Experience with BMC tools for DB2 (Change/Catalog Manager, MainView, Log Master)[Preferred] Basic JCL & REXX script skills[Required] bachelor's degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business[Preferred] Related financial industry experiences[Preferred] PostgreSQL Professional Certification[Preferred] IBM Certified Database Administrator - DB2 for Linux UNIX and Windows