Senior Database Administrator

ASSYST, Inc.; Tallahassee (FL); On-site; USD 120,000 - 180,000; Full time

Job summary

ASSYST is seeking a Senior Database Administrator (DBA) with 15+ years of experience to support database design, administration, performance tuning, and operational activities across multiple platforms. The role requires deep expertise in DB2 for z/OS, Oracle, and SQL Server, with strong experience in z/OS environments, recovery, and infrastructure support.

The ideal candidate will perform daily administration for DB2, Oracle, SQL Server, and GIS environments; design schemas; monitor and tune

Qualifications

• 15+ years of combined database administration experience.
• Strong expertise in: DB2 for z/OS, Oracle 10g+, SQL Server 2008 R2/2012.
• Advanced knowledge of DB2 for z/OS administration, performance management, upgrades, catalog maintenance, and recovery.
• Strong knowledge of JCL, z/OS, ISPF, CICS, RACF, COBOL, and ASG Scheduler.
• Experience with DB2 and z/OS monitoring tools.
• Experience with SSMS, SSRS, SSIS, Windows Server, and Azure.
• Knowledge of CA GEN, IBI z/OS, AFOPER, IOF, z/OS EXITs, and BJS.
• Knowledge of disaster recovery and infrastructure change management.
• Strong SQL, troubleshooting, documentation, communication, and collaboration skills.
• Experience with integrated database/application environments is a plus.

Responsibilities

• Perform daily database administration and operational support for DB2, Oracle, SQL Server, and GIS environments.
• Design, implement, maintain, and optimize database structures and schemas.
• Monitor and tune database performance and troubleshoot database-related issues.
• Support DB2 for z/OS upgrades, catalog maintenance, application integration, and point-in-time recovery.
• Develop and maintain database administration procedures and technical documentation.
• Perform SQL code reviews and support database optimization.
• Support infrastructure implementation, change management, verification testing, and disaster recovery activities.
• Utilize database and z/OS monitoring tools to identify and resolve performance issues.
• Collaborate with technical teams on data architecture and application integration.
• Provide training and mentoring to other technical staff.

Skills

15+ years exp

DB2 for z/OS

Oracle 10g+

SQL Server 2008 R2/2012

JCL

z/OS

ISPF

CICS

RACF

COBOL

ASG Scheduler

DB2 monitoring tools

SSMS/SSRS/SSIS

Windows Server

Azure

Tools

CA GEN

IBI z/OS

AFOPER

IOF

z/OS EXITs

BJS

Job description

ASSYST is seeking a Senior Database Administrator (DBA) with 15+ years of database administration experience to support database design, administration, performance tuning, optimization, and operational activities across multiple platforms. The ideal candidate will have strong expertise in DB2 for z/OS, Oracle, and Microsoft SQL Server, along with extensive experience in z/OS environments, database architecture, monitoring, recovery, and infrastructure support.

• Perform daily database administration and operational support for DB2, Oracle, SQL Server, and GIS environments.
• Design, implement, maintain, and optimize database structures and schemas.
• Monitor and tune database performance and troubleshoot database-related issues.
• Support DB2 for z/OS upgrades, catalog maintenance, application integration, and point-in-time recovery.
• Develop and maintain database administration procedures and technical documentation.
• Perform SQL code reviews and support database optimization.
• Support infrastructure implementation, change management, verification testing, and disaster recovery activities.
• Utilize database and z/OS monitoring tools to identify and resolve performance issues.
• Collaborate with technical teams on data architecture and application integration.
• Provide training and mentoring to other technical staff.

Required Skills

• 15+ years of combined database administration experience.
• Strong expertise in:
  • DB2 for z/OS
  • Oracle 10g+
  • Microsoft SQL Server 2008 R2/2012
• Advanced knowledge of DB2 for z/OS administration, performance management, upgrades, catalog maintenance, and recovery.
• Strong knowledge of JCL, z/OS, ISPF, CICS, RACF, COBOL, and ASG Scheduler.
• Experience with DB2 and z/OS monitoring tools.
• Experience with SSMS, SSRS, SSIS, Windows Server, and Azure.
• Knowledge of CA GEN, IBI z/OS, AFOPER, IOF, z/OS EXITs, and BJS.
• Knowledge of disaster recovery and infrastructure change management.
• Strong SQL, troubleshooting, documentation, communication, and collaboration skills.
• Experience with integrated database/application environments is a plus.

ASSYST is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law.