Senior DB2 LUW DBA & Data Architect

Anakim-Consulting-Inc; Springfield (VA); Hybrid; USD 125,000 - 135,000; Full time

Job summary

Anakim Consulting is seeking a Senior Db2 LUW Database Administrator (DBA) and Data Architect to lead enterprise Db2 LUW environments across Linux (RHEL) and IBM AIX. This role focuses on data modeling, upgrades, high availability, and automation while partnering with development teams to optimize SQL and support modernization.

Location is Ashburn, VA with local on-site work and occasional remote options. The ideal candidate has 12+ years of DBA experience, DHS suitability, and a BS in CS or

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related discipline.
• 12+ years of overall progressive hands-on experience designing, maintaining, and modernizing enterprise-scale database environments.
• 10+ years Db2 LUW administration experience on Linux (RHEL) and IBM AIX.
• Strong proficiency in SQL, Shell Scripting (Bash/KSH), Python or Ansible.

Responsibilities

• Architect, design, and manage enterprise Db2 LUW databases across Linux (RHEL) and IBM AIX.
• Lead major database software upgrades, fix pack installations, and schema migrations.
• Develop and maintain data models using Erwin or Visio.
• Provide daily production DBA support, troubleshoot database errors, and optimize queries.
• Design and test disaster recovery procedures and high-availability configurations.
• Participate in 24x7 on-call support for critical environments.

Skills

Db2 LUW administration

Data modeling

HADR/DR

Scripting/Automation

SQL tuning

ETL & data movement

Education

Bachelor's degree in CS/IS/Engineering

Tools

Erwin

Visio

IBM Db2 Performance Expert

db2top

Datadog

SolarWinds

Python

Ansible

Pacemaker/TSAMP

Job description

EOE Statement Anakim Consulting is an equal employment opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regards to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Description

Senior Db2 LUW DBA & Data Architect

Ashburn, VA 20598

Position Type: Full Time
Work Location: Local to Wash, DC Metro area
Remote: On-site with potential for some remote work
Security Access: Ability to obtain DHS Suitability

Position Summary

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).

Key Responsibilities

Database Architecture, Upgrades & Modernization

• 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).

Production Operations & Developer Enablement

• 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.

Performance Optimization & Automation

• 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.

Position Requirements

Basic Qualifications

• 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.

Technical Qualifications

12+ years of overall progressive hands-on experience designing, maintaining, and modernizing enterprise-scale database environments including:

• Database Platform:10+ years of hands-on Db2 LUW administration experience (v11.5, v12.1) on Linux (RHEL) and IBM AIX.
• Data Modeling: Proficiency in ERD/DFD creation, logical and physical database design using Erwin, Visio, or similar tools.
• High Availability & DR: Deep experience configuring and maintaining Db2 HADR, Pacemaker/TSAMP cluster management, and disaster recovery processes.
• Scripting & Automation: Strong proficiency in SQL, Shell Scripting (Bash/KSH), and modern automation scripting (Python or Ansible).
• Performance Tuning: Proven capability in SQL statement tuning, explain plan analysis, and database configuration optimization.
• ETL & Data Movement: Experience with data replication, bulk loading utilities, and database conversion projects.

Preferred Qualifications

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

Full-Time/Part-Time Full-Time

Salary Range This position offers a full time W2 salary plus eligibility to participate in the company's benefits program. We anticipate this position will be filled in the $125,000 - $135,000 annual salary range. The estimated salary range displayed in this posting is dependent upon position requirements, individual qualifications, education, experience, location, and other job related factors.

About the Organization

Anakim Consulting is a privately held small company that provides growth opportunities for employees. Come join our team!

This position is currently accepting applications.