NO SPONSORSHIP

Associate Principal, Database Administration - DB2/LUW

SALARY: $125K - $135K PLUS 15% BONUS

LOCATION: CHICAGO, IL

HYBRID 3 DAYS ONSITE AND 2 DAYS REMOTE

Looking for a candidate with 7 years DB2 LUW on Red Hat linux and windows. 7 years postgre SQL SQL stored procedures to monitor and tune databases for application performance. backup and recovery DR drills provides primary on call support for production problems

This role 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.

Primary Duties and 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, modelling, 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:

• 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
• Well versed in all phases of Systems Analysis and Design
• Experienced in two or more programming/Scripting languages
• Practiced at Entity/Relationship or Object modelling 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 method
• Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment
• 7+ years' experience with PostgreSQL
  7+ years' experience with DB2 LUW; preferably on Red Hat Linux
• Proficient with coding and review of SQL, stored procedures, and triggers
• bachelor's degree