Database Administrator

Job Description

Job Description

TEKsystems DB2 DBA Opening !!!

Administers, secures, and tunes the company's IBM Db2 for z/OS databases supporting core policy, claims, and financial processing. Owns physical database design review, performance management, backup and recovery, and disaster recovery readiness for the Db2 subsystems. Provides secondary administration for Microsoft SQL Server and Azure SQL Managed Instance and supports the data pipelines that move mainframe data to the enterprise data warehouse. Treats documentation, cross-training, and knowledge transfer as core deliverables of the role.

Essential Functions

Database design and change management

Reviews and approves physical database designs (tablespaces, partitioning, indexing, referential integrity, compression) for new and changed applications.

Implements DDL and configuration changes through the ITIL change management process; maintains DDL, object inventory, and standards under version control.

Manages subsystem parameters (ZPARM), buffer pool configuration, and storage allocation.

Performance management

Monitors subsystem, thread, and application performance; establishes and tracks baselines.

Analyzes access paths using EXPLAIN and related tooling; identifies and remediates inefficient SQL in partnership with application and data engineering teams.

Schedules and tunes Db2 utilities (REORG, RUNSTATS, COPY, MODIFY, RECOVER) and maintains the utility calendar.

Backup, recovery, and availability

Owns the image copy strategy, active and archive log management, and point-in-time recovery procedures.

Executes and documents recovery tests on a defined cadence (HR/manager: state cadence, e.g., annually).

Participates in disaster recovery exercises and maintains the Db2 recovery runbooks.

Security and confidentiality

Administers Db2 authorization (GRANT/REVOKE, roles, RACF integration) under least-privilege principles.

Supports internal and external audit and regulatory data requests.

Handles confidential and regulated policyholder and financial data in accordance with company information security policies.

Integration and data movement

Supports the nightly Db2-to-SQL Server extract pipelines (unload utilities, SFTP, enterprise scheduler) in partnership with EDM Data Engineering.

Administers DDF/DRDA connectivity and distributed access for downstream consumers.

Advises on Db2 data structures consumed by warehouse, finance, and analytics teams.

Platform currency

Plans and executes Db2 version and function-level upgrades and PTF maintenance with Systems Programming.

Evaluates and recommends Db2 features and tooling that improve performance, availability, or operational efficiency.

Documentation, knowledge transfer, and mentoring

Maintains runbooks, standards, and architecture documentation for all administered subsystems.

Cross-trains at least one designated backup administrator on every critical procedure.

Mentors mainframe developers and data engineers on Db2 design and SQL efficiency.

Secondary platform support

Provides backup administration for Microsoft SQL Server and Azure SQL Managed Instance as assigned by the DBA team lead.

Operations

Participates in the DBA on-call rotation and scheduled off-hours maintenance windows.

Follows ITIL incident, problem, and change management practices.

Skills

Database administrator, Db2, Sql, z/OS, database design, performance management, backups, table creation, stored procedures, Azure, Cloud, AI, Cobol

Top Skills Details

Database administrator,Db2,Sql,z/OS,database design,performance management,backups,table creation,stored procedures

Additional Skills & Qualifications

IBM Certified Database Administrator, Db2 for z/OS

Microsoft SQL Server administration; Azure SQL Managed Instance

COBOL, REXX, Python

Advanced Db2: Data sharing and Parallel Sysplex; Db2 Connect and DDF tuning; Db2 stored procedures

Enterprise job scheduling (e.g., Stonebranch); Db2 performance monitoring tools

ITIL Foundation; Agile delivery experience

Experience Level

Entry Level

Job Type & Location

This is a Contract to Hire position based out of Omaha, NE.

Pay and Benefits

The pay range for this position is $10.00 - $12.00/hr.

Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a fully onsite position in Omaha,NE.

Application Deadline

This position is anticipated to close on Oct 2, 2026.

About TEKsystems

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems and TEKsystems Global Services

Were a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. Were a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. Were strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. Were building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.