Senior Mainframe Database Administrator

Location: Onsite - Tallahassee, FL Experience Level: Senior/Lead Level (15+ Years)

Position Overview

The Senior Database Administrator will support the planning, design, administration, optimization, and maintenance of enterprise database environments across DB2 for z/OS, Oracle, SQL Server, and GIS platforms. This role is responsible for ensuring database architectures, schemas, data dictionaries, and processing environments align with departmental standards, security requirements, and enterprise data strategies.

The ideal candidate will possess deep expertise in DB2 for z/OS administration, strong mainframe experience, and advanced knowledge of database performance tuning, disaster recovery, infrastructure planning, and enterprise application support.

Key Responsibilities

Database Administration & Operations

• Perform daily database administration and operational support activities.

• Manage and support DB2 for z/OS, Oracle, SQL Server, and GIS databases.

• Monitor database health, availability, and performance.

• Troubleshoot and resolve complex database and infrastructure issues.

• Ensure database environments comply with AST security standards.

Database Design & Architecture

• Assist in designing, developing, and optimizing enterprise database architectures.

• Develop and maintain database schemas, data structures, and data dictionaries.

• Support enterprise data warehousing and database modernization initiatives.

• Participate in technical infrastructure planning and implementation efforts.

Performance Tuning & Optimization

• Monitor and optimize database performance across all supported platforms.

• Analyze database workloads and recommend tuning improvements.

• Utilize database monitoring tools to identify and resolve bottlenecks.

• Conduct SQL code reviews and performance assessments.

Mainframe Database Administration

• Administer and support DB2 for z/OS environments.

• Perform DB2 upgrades, catalog maintenance, and subsystem recovery activities.

• Support DB2 integration with enterprise applications.

• Manage point-in-time recovery, backup, and disaster recovery processes.

• Support JCL, RACF, CICS, ISPF, IOF, and z/OS infrastructure.

Documentation & Standards

• Develop and maintain database administration procedures and operational documentation.

• Establish standards, best practices, and quality assurance controls.

• Support change management and verification testing activities.

• Maintain technical documentation for production and disaster recovery environments.

Leadership & Knowledge Transfer

• Mentor and train junior database and technical staff.

• Provide technical leadership on database-related initiatives.

• Collaborate with application developers, analysts, project managers, and infrastructure teams.

• Support enterprise architecture and strategic planning initiatives.

Required Qualifications

• Bachelor's Degree in Computer Science, Information Systems, or related field, or equivalent experience.

• 15+ years of combined database administration experience.

• Expert-level experience with: 
• DB2 for z/OS

• Oracle 10g and above

• SQL Server 2008 R2 and above

• Strong experience in: 
• Database Design

• Database Administration

• Performance Tuning

• Disaster Recovery

• Database Security

• Infrastructure Planning

• Experience supporting enterprise production environments.

Required Technical Skills

DB2 for z/OS

• DB2 Administration

• DB2 Performance Management

• DB2 Catalog Maintenance

• DB2 Upgrades

• Subsystem Point-in-Time Recovery

• DB2 Monitoring Tools

• DB2 Application Integration

Mainframe Technologies

• z/OS

• JCL

• ISPF

• RACF

• CICS

• IOF

• AFOPER

• BJS

• CA GEN

• ASG Scheduler

• COBOL

• z/OS Exits

• Started Tasks Administration

Database Platforms

• Oracle Database Administration

• SQL Server Administration

• SSMS

• SSRS

• SSIS

• Database Monitoring & Tuning

Infrastructure & Cloud

• Windows Server Administration

• Azure Fundamentals

• Backup & Recovery

• Disaster Recovery Planning

• Change Management Testing

Preferred Qualifications

• Experience with FDOT Integrated Database Infrastructure.

• Experience supporting FDOT Financial Management systems.

• Knowledge of FDOT integrated application environments.

• Experience supporting GIS databases and spatial data solutions.

• Experience with enterprise data warehouse architectures.

• Experience supporting cloud-based database environments.

Core Skills

• DB2 for z/OS

• Oracle Database

• SQL Server

• Database Administration

• Mainframe Systems

• z/OS

• JCL

• RACF

• CICS

• COBOL

• CA GEN

• Performance Tuning

• Database Monitoring

• Disaster Recovery

• Backup & Recovery

• SQL Code Reviews

• SSMS

• SSRS

• SSIS

• Azure

• Infrastructure Planning

• Technical Leadership