Mainframe DB2 Database Administrator (DB2 z/OS, Oracle, SQL Server)

TECKpert•Tallahassee, FL

1d•$135,000 - $135,200•Onsite

About The Position

TECKpert's client, a state transportation agency in Tallahassee, Florida, is seeking an advanced-level Database Administrator for its Office of Information Technology database administration team. The team ensures application and processing architectures, data dictionaries, and database schemas meet agency data requirements and standards across DB2 for z/OS, SQL Server, Oracle, and GIS platforms. This hands-on, mainframe-centric role supports daily database operations and administration. The successful candidate will help design, develop, amend, and optimize database schemas; develop database and warehousing designs across platforms and computing environments; and contribute to an overall data architecture that meets agency needs and state security standards. The position is 100% onsite in Tallahassee, Florida, with teleworking not authorized. Candidates must be based in Tallahassee or the surrounding area, or be willing to relocate. The role may require work hours between 7:00 a.m. and 7:00 p.m. and/or Saturdays as part of a rotation or on-call schedule. The engagement runs through June 30, 2027, with possible renewal.

Requirements

Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent work experience.
12 years of combined database administration experience across DB2 for z/OS, SQL Server (2008 R2, 2012, and later), and Oracle (10g and above).
Advanced knowledge of DB2 for z/OS application integration, performance management, and database administration.
Advanced knowledge of upgrading DB2 for z/OS.
Advanced knowledge of DB2 for z/OS catalog maintenance.
Advanced knowledge of DB2 for z/OS subsystem point-in-time recovery.
Advanced knowledge of JCL.
In-depth knowledge of the z/OS integrated platform.
In-depth knowledge of CA Gen model management and application object support.
In-depth knowledge of ISPF.
In-depth knowledge of the ASG Scheduler.
In-depth knowledge of COBOL.
In-depth knowledge of the use and interpretation of DB2 for z/OS database monitoring tools.
In-depth knowledge of the use and interpretation of z/OS software monitoring tools.
In-depth knowledge of technical infrastructure implementation planning and coordination.
Solid working knowledge of z/OS started task creation and management.
Solid working knowledge of IBI z/OS service support.
Solid working knowledge of AFOPER commands.
Solid working knowledge of RACF.
Solid working knowledge of CICS.
Solid working knowledge of IOF.
Solid working knowledge of technical requirements for disaster recovery.
Solid working knowledge of Oracle application integration, performance management, and database administration.
Solid working knowledge of MSSQL application integration, performance management, and database administration.
Solid working knowledge of verification testing techniques for infrastructure change management.
Strong written and verbal communication skills, customer service orientation, sound decision-making, and ability to work effectively as part of a team.
Must be based in Tallahassee, Florida, or the surrounding area, or be willing to relocate.
Must be able to work onsite; teleworking is not authorized.

Nice To Haves

Working knowledge of z/OS EXITs.
Working knowledge of BJS.
Working knowledge of Windows Servers.
Working knowledge of SSMS, SSRS, and SSIS.
Working knowledge of Azure.
Experience with GIS databases.
Experience with an integrated state agency database infrastructure and financial management applications.
Prior experience supporting Florida state government or other public sector mainframe environments.
Experience mentoring and training technical staff.

Responsibilities

Perform daily operational and database administration activities across DB2 for z/OS, SQL Server, Oracle, and GIS database environments.
Plan, design, implement, and support database structures to meet system requirements.
Assist with the design, development, amendment, and optimization of database schemas.
Conduct database performance monitoring and tuning.
Develop and maintain database administration procedures and documentation.
Perform SQL code reviews.
Support DB2 for z/OS upgrades, catalog maintenance, and subsystem point-in-time recovery.
Plan and coordinate technical infrastructure implementations and perform verification testing for infrastructure change management.
Support disaster recovery planning and execution for database platforms.
Assist with training and mentoring other technical staff.
Perform other database or infrastructure activities as requested.