Senior DB2 LUW DBA & Data Architect

Anakim Consulting•Springfield, VA

2d•Hybrid

About The Position

Anakim Consulting is hiring a Senior Db2 LUW Database Administrator (DBA) and Data Architect to support enterprise database infrastructure across Linux (RHEL) and IBM AIX platforms. In this role, you will lead logical and physical data modeling, drive major version upgrades (including Db2 v12.1.x rollouts), manage high-availability (HADR) configurations, and automate database operations. You will also partner closely with application development teams to troubleshoot complex SQL queries, optimize performance, and assist in decommissioning legacy tooling (such as Informatica PowerCenter).

Requirements

U.S. citizenship (no dual citizenship).
Current DHS Suitability for CBP Access or ability to obtain Public Trust access.
Availability to support an on-site schedule in Ashburn, VA.
Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related discipline.
10+ years of hands-on Db2 LUW administration experience (v11.5, v12.1) on Linux (RHEL) and IBM AIX.
Proficiency in ERD/DFD creation, logical and physical database design using Erwin, Visio, or similar tools.
Deep experience configuring and maintaining Db2 HADR, Pacemaker/TSAMP cluster management, and disaster recovery processes.
Strong proficiency in SQL, Shell Scripting (Bash/KSH), and modern automation scripting (Python or Ansible).
Proven capability in SQL statement tuning, explain plan analysis, and database configuration optimization.
Experience with data replication, bulk loading utilities, and database conversion projects.

Nice To Haves

Current or recent Entry on Duty (EOD) access.
Hands-on experience with Informatica PowerCenter administration or decommissioning workflows.
Exposure to IBM Cloud Pak for Data, AWS/Azure hosted Db2 instances, Docker, or Kubernetes container environments.
Familiarity with IBM Mainframe environments (Db2 on z/OS, MVS, JCL, COBOL, IMS) to support legacy data interface points or migration projects.

Responsibilities

Architect, design, and manage enterprise Db2 LUW databases (v11.5 / v12.1) across RHEL and AIX environments.
Lead major database software upgrades, fix pack installations, and schema migrations.
Develop and maintain logical/physical data models using Erwin or Microsoft Visio.
Manage infrastructure lifecycle projects, including assisting with the migration or decommissioning of legacy middleware and ETL tools (e.g., Informatica PowerCenter).
Provide daily production DBA support, database maintenance, object creation, and release deployment.
Partner with application development teams to troubleshoot database errors, optimize application queries, and set up non-production sandbox environments.
Design, test, and maintain disaster recovery (DR) procedures, high-availability HADR pairs, and backup/restore strategy.
Participate in rotational 24x7 on-call technical support for critical enterprise production environments.
Perform SQL tuning, index optimization, and database manager parameter configuration.
Utilize modern performance monitoring tools (e.g., IBM Db2 Performance Expert, db2top, Datadog, SolarWinds) to proactively resolve system bottlenecks.
Build automation scripts using Python, Bash, or Ansible to streamline routine DBA maintenance, monitoring, and deployments.