The demand for seasoned DB2 experts is soaring as organizations modernize their data platforms, especially in mission‑critical public‑safety environments. This hybrid role with the Texas Department of Public Safety offers a unique chance to apply deep DB2 knowledge while enjoying flexible work arrangements. If you thrive on high‑availability databases and love solving complex performance puzzles, this contract could be your next big move.

Job Summary

We are seeking a Level‑3 Database Administrator specialized in DB2 to support the Texas Department of Public Safety. The role involves managing DB2 instances, handling licensing, performing performance tuning, and scripting routine tasks on AIX/UNIX/Linux servers. Work will be split between onsite collaboration and remote execution over a three‑month engagement with possible extension.

Top 3 Critical Skills Table

Interview Preparation

1. Explain the process of DB2 backup and recovery on AIX.
   What the interviewer is looking for: Understanding of offline vs online backups, use of db2 backup, db2 restore, and handling of transaction logs.
2. How do you manage DB2 licensing and Passport Advantage on a multi‑instance environment?
   What the interviewer is looking for: Familiarity with license files, db2licm, and procedures for updating/renewing licenses.
3. Describe a performance tuning scenario where you identified a bottleneck and resolved it.
   What the interviewer is looking for: Ability to use EXPLAIN, monitor tablespaces, adjust buffer pools, and quantify improvements.
4. What shell scripting techniques do you use to automate DB2 health checks?
   What the interviewer is looking for: Examples of cron jobs, db2pd, db2top, parsing output with awk/sed, and error handling.
5. How would you handle a DB2 instance migration from AIX to Linux?
   What the interviewer is looking for: Planning steps, data export/import strategies, compatibility considerations, and testing procedures.

Resume Optimization

• DB2 Administration
• DB2 Licensing
• IBM Passport Advantage
• AIX
• UNIX
• Linux
• Shell Scripting
• Performance Tuning
• Hybrid Work Model
• Texas Department of Public Safety
• Enterprise Database Environments
• High‑Availability Solutions

Application Strategy

When reaching out to the recruiter, send a concise email that opens with a friendly greeting, attaches your updated resume, and clearly maps your experience to the role. Highlight your 8+ years of DB2 administration, your hands‑on work with AIX/UNIX/Linux platforms, and specific projects where you automated tasks with shell scripts. Mention your familiarity with DB2 licensing and any experience supporting public‑sector or high‑security environments.

Career Roadmap