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

TECKpert LLC.; Tallahassee (FL); Vor Ort; USD 54.000 - 90.000; Vollzeit

Zusammenfassung

TECKpert LLC. is seeking a seasoned Mainframe DB2 Database Administrator to support a state transportation agency in Tallahassee, FL. This onsite role covers DB2 for z/OS, SQL Server, Oracle and GIS environments, with on-call rotation and potential contract extensions.

Candidates must be local or willing to relocate; sponsorship is not provided. The successful candidate will design, implement and optimize database schemas, support upgrades, and contribute to disaster recovery planning while

Qualifikationen

• Bachelor's or equivalent experience in computer science or related field
• 12 years of combined experience in database administration across DB2 for z/OS, SQL Server and Oracle
• Advanced knowledge of DB2 for z/OS administration, performance management and upgrades
• Experience with DB2 for z/OS catalog maintenance and disaster recovery planning
• Strong knowledge of JCL, COBOL, ISPF and z/OS tooling
• Experience with SQL, data modeling, and database design across multiple platforms
• Excellent written and verbal communication, collaboration and mentoring skills

Aufgaben

• Perform daily operations across DB2 for z/OS, SQL Server, Oracle and GIS environments
• Design and optimize database schemas to meet system requirements
• Conduct performance monitoring and tuning of database systems
• Develop and maintain database administration procedures and documentation
• Assist with upgrades, catalog maintenance and disaster recovery activities
• Provide guidance and training to junior staff and teammates
• Plan and coordinate infrastructure changes and testing

Kenntnisse

DB2 for z/OS

JCL

CICS

RACF

CA Gen

ISPF

Oracle

SQL Server

Disaster Recovery

Performance tuning

Ausbildung

Bachelor's Degree in Computer Science or Information Systems

Tools

DB2 for z/OS

ISPF

JCL

CA Gen

COBOL

Oracle

SQL Server

GIS

Jobbeschreibung

We are looking for a Mainframe DB2 Database Administrator to support our client based in Tallahassee, FL.

US BASED CANDIDATES ONLY.

Candidates must be located in Tallahassee, FL or the surrounding area, or be willing to relocate. This position is 100% onsite and teleworking is not authorized.

*No third parties and no sponsorship*

Who we are

Founded in 2009 and headquartered in beautiful Miami, FL, TECKpert is a tech consulting and staff augmentation firm. At TECKpert, we offer a contingent workforce built for any size digital transformation project. Experts in design, development, IT, analytics and marketing, provide innovative digital solutions to achieve success in our new economy. Our leaders identify the technical talent best suited to bolster our client's capabilities, across all industries, including, healthcare, government, finance, legal, real estate, and startups.

The Opportunity

TECKpert's client, a state transportation agency in Tallahassee, FL, is seeking an advanced level Database Administrator to join its database administration team within the Office of Information Technology. The DBA team is responsible for ensuring the application and processing architectures, data dictionaries, and database schemas meet the agency's standards for data requirements across DB2 for z/OS, SQL Server, Oracle and GIS platforms.

In this role you will assist in the design, development, amendment and optimization of database schemas to meet system requirements, develop database and warehousing designs across multiple platforms and computing environments, and work as part of a team to build an overall data architecture that supports the agency's needs and meets state security standards. This is a hands-on mainframe-centric position with daily operational responsibility, and it requires flexibility to work hours between 7:00 AM and 7:00 PM and/or Saturdays as part of a rotation or on-call schedule. The engagement runs through June 30, 2027 with possible renewal.

Job duties include, but are not limited to:

• 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 in 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 sub-system 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

Compensation and Term

This opportunity is for a full-time, contract position with possible extensions and pay commensurate with experience up to $65 per hour or $135,200 per year. Medical, dental, vision and life insurance available after 30 days of hire.

Qualifications you need

A successful candidate has the following experience:

• Bachelor's Degree in Computer Science, Information Systems, or other related field, or equivalent work experience
• 12 years of combined experience in database administration across DB2 for z/OS, SQL Server (2008R2, 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 sub-system 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 the technical requirements of 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 the ability to work effectively as part of a team

Preferred (not required)

• 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

Working with us

Working with TECKpert means more options. As new opportunities arise, you tell us what you think is a good fit for you. What industries interest you most? Do you prefer an on-location, 9-5? Or would you want a flexible schedule and remote work? We proudly offer a wide variety of roles. Many of our TECKperts enjoy coworking and skills training coupled with the stability of full-time employment. We believe TECKpert gives today's digital professionals an agile path to start and advance their career. All of our opportunities require at least 20 hours per week and can be one to twelve months in length. Choose the opportunity that matches your interest and desired cadence.