What are the responsibilities and job description for the Database Administrator position at Confidentiel?
Job Title: Senior Database Administrator (DB2 for z/OS / Mainframe DBA)
Location: Tallahassee, Florida — Onsite
Experience: 12 years of combined database administration experience
Education: Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent work experience.
Job Summary
The ideal candidate will have advanced experience with IBM DB2 for z/OS, including database upgrades, catalog maintenance, subsystem recovery, performance monitoring, and application integration. Experience with Oracle, Microsoft SQL Server, mainframe technologies, and enterprise database environments is also required.
Key Responsibilities
Perform daily database administration, operational support, monitoring, and maintenance.
Design, develop, implement, and maintain database structures, schemas, and data architecture.
Administer and optimize IBM DB2 for z/OS databases.
Perform DB2 subsystem upgrades, catalog maintenance, and point-in-time recovery.
Monitor database performance and troubleshoot complex database issues.
Conduct SQL code reviews and optimize database queries.
Support Oracle and Microsoft SQL Server database environments.
Develop and maintain database administration procedures, standards, and technical documentation.
Support disaster recovery planning, infrastructure changes, and verification testing.
Work with mainframe technologies, including JCL, COBOL, CICS, ISPF, RACF, and z/OS utilities.
Support database integration with enterprise applications and infrastructure.
Assist in training and mentoring technical staff.
Ensure database security and compliance with applicable FDOT and state technology standards.
Required Technical Skills
IBM DB2 for z/OS database administration
DB2 performance tuning, monitoring, upgrades, catalog maintenance, and recovery
Mainframe z/OS environment
JCL and COBOL
CICS, ISPF, RACF, and mainframe utilities
Database performance management and troubleshooting
Oracle Database Administration
Microsoft SQL Server administration
SQL code review and optimization
Disaster recovery and infrastructure change management
Preferred Skills
CA GEN model management and application support
ASG Scheduler
IBI z/OS service support
AFOPER commands, IOF, BJS, and z/OS exits
SQL Server Management Studio (SSMS)
SQL Server Reporting Services (SSRS) and Integration Services (SSIS)
Windows Server and Azure
GIS database experience
FDOT integrated database infrastructure
FDOT Financial Management applications
Work Requirements
Onsite work in Tallahassee, Florida; telecommuting is not authorized.
Flexibility to work between 7:00 AM and 7:00 PM, including Saturdays or on-call rotations as required.
Strong communication, troubleshooting, documentation, teamwork, and mentoring skills.