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 & 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.
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.
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.
...Remote Patient Account Rep to support Puerto Rico residents and work from home. The role includes handling patient billing inquiries,... ...collaboration with guarantors and third parties.The position offers paid training, a team-oriented environment, opportunities for growth, and...
Avanos Medical seeks a Quality Engineer to ensure our respiratory, digestive, and pain management solutions meet the highest safety and performance standards. In this role, you will lead validation, verification, and risk management activities, support design control and...
...Job Description Benefits Manager (Consultant to Hire Role)\n Location: Downtown Manhattan, NYC \n Schedule: Hybrid - (In Office / Work From Home)\n \n About the Opportunity \n Our client, a premier nonprofit organization based in Downtown Manhattan, is...
...seeks qualified 911 Call Takers for duty in Ainsworth, Nebraska. You will answer emergency calls, verify locations, collect caller information, and document data for dispatch.Typical shifts may include nights and weekends; applicants should have a high school diploma or...
...KAG Energy, a division of Kenan Advantage Group, is currently hiring Owner Operator Truck Drivers in your area! Join KAG today to take advantage of great pay, competitive benefits packages, supportive terminal managers and great equipment! Currently hiring Owner...