DB2 Database Administrator at Judge Group

Hybrid work schedule only 2 days a week onsite!

Job Summary:

As part of a fast-paced, dynamic Information Technology team, you will support various database while collaborating closely with Network, Server and Application Development teams.

Essential Job Duties and Responsibilities:

DB2 Database Administrator

• Provide DB2 Mainframe z/OS database administration for all environments

• Introduction of new functionality of DB2 on z/OS

• Application support for changes and problems

• Production data updates

• Table definitions, design, and modifications

• Design/development of Triggers and Stored Procedures

• Configure and customize DB2 Tools (Admin Tool, Query Monitor, QMF)

• Monitoring of DB2 performance IBM tools and DB2 LUW

• DB2 connectivity direct data drivers, remote system connectivity

• DB2 Federated Database on AIX

• DB2 LUW on AIX

• SQL tuning

• Business Recovery

• Support for SMARTIS

• DB2 Bufferpool tuning

• Manage zParms

• Acceptance environment refresh with Production Data

• PCI Interviews

• Participate in on-call support rotation

• Ensure compliance to all relative security policies and procedures.

Knowledge, Skills, and Abilities:

• Advanced proficiency in Structured Query Language (SQL).

• In-depth knowledge of database technologies, architecture, and data security.

• Knowledge of best practices in database management.

• Advanced analytical, leadership, and problem-solving skills.

• Exceptional organizational skills and attention to detail.

• Excellent interpersonal and communication skills.

• Knowledge of DB2 z/OS, DB2 LUW, SQL Server, Oracle, REXX scripting a plus. General Company Requirements:

§ Maintains appropriate behavior consistent with company policy manual