About this role
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 FunctionsDatabase 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.SkillsDatabase administrator, Db2, Sql, z/OS, database design, performance management, backups, table creation, stored procedures, Azure, Cloud, AI, CobolTop Skills DetailsDatabase administrator,Db2,Sql,z/OS,database design,performance management,backups,table creation,stored proceduresAdditional Skills & QualificationsIBM Certified Database Administrator, Db2 for z/OSMicrosoft SQL Server administration; Azure SQL Managed InstanceCOBOL, REXX, PythonAdvanced Db2: Data sharing and Parallel Sysplex; Db2 Connect and DDF tuning; Db2 stored proceduresEnterprise job scheduling (e.g., Stonebranch); Db2 performance monitoring toolsITIL Foundation; Agile delivery experienceExperience LevelEntry Level Job Type & LocationThis is a Contract to Hire position based out of Omaha, NE. Pay and BenefitsThe 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 TypeThis is a fully onsite position in Omaha,NE. Application DeadlineThis 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.