Senior Mainframe Database Administrator

SMART TECH SKILLS LLC
  • Tallahassee, Florida, FL
  • Full-time
5 days ago

Job Description




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

Numbers & Facts

LocationTallahassee, Florida, FL
Job TypeFull-time

Skills

  • Administrative Proceduresunmatched
  • Best Practicesunmatched
  • Change Managementunmatched
  • Cloud Computingunmatched
  • Cobol Programming Languageunmatched
  • Code Reviewsunmatched
  • Computer Scienceunmatched
  • Data Recoveryunmatched
  • Data Structuresunmatched
  • Data Warehousingunmatched
  • Database Administrationunmatched
  • Database Analysisunmatched
  • Database Architectureunmatched
  • Database Designunmatched
  • Database Optimizationunmatched
  • Database Programmingunmatched
  • Database Technologyunmatched
  • Disaster Recoveryunmatched
  • Documentationunmatched
  • Enterprise Application Integration (EAI)unmatched
  • Enterprise Applicationsunmatched
  • Enterprise Architectureunmatched
  • Enterprise Protectionunmatched
  • Financial Managementunmatched
  • Financial Systemsunmatched
  • Geographic Information Systems (GIS)unmatched
  • IBM CICS (Customer Information Control System)unmatched
  • IBM DB2unmatched
  • IBM TSO/ISPFunmatched
  • IBM z-OS Operating Systemunmatched
  • Identify Issuesunmatched
  • Information Technology & Information Systemsunmatched
  • Information/Data Security (InfoSec)unmatched
  • JCL (Job Control Language)unmatched
  • Mainframe Computerunmatched
  • Mentoringunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft SQL Server DBA (Database Administration)unmatched
  • Microsoft Windows Azureunmatched
  • Microsoft Windows Serverunmatched
  • Microsoft Windows System Administrationunmatched
  • Multiplatform/Cross-Platformunmatched
  • Operational Supportunmatched
  • Operations Processesunmatched
  • Oracle DBA (Database Administrator)unmatched
  • Oracle Databaseunmatched
  • Oracle Database 10gunmatched
  • Performance Analysisunmatched
  • Performance Managementunmatched
  • Performance Reviewsunmatched
  • Performance Tuning/Optimizationunmatched
  • Production Supportunmatched
  • Production Systemsunmatched
  • Project/Program Managementunmatched
  • Quality Assuranceunmatched
  • RACF (Resource Access Control Facility)unmatched
  • SQL (Structured Query Language)unmatched
  • SQL Server Integration Services (SSIS)unmatched
  • SQL Server Reporting Services (SSRS)unmatched
  • Security Complianceunmatched
  • Software Administrationunmatched
  • Software Developmentunmatched
  • Spatial Dataunmatched
  • Strategic Planningunmatched
  • Systems Administration/Managementunmatched
  • Technical Leadershipunmatched
  • Technical Writingunmatched
  • Testingunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder