[Hiring] DB2 Database Administrator @GoIntellects Inc.

Role Description

The Senior DB2 database administrator position requires in-depth knowledge of IBM DB2 database background using IBM Utilities and BMC tools.

• Support the DESTINY application team by optimizing database queries, stored procedures, packages, and triggers.
• Work closely with developers to integrate enhancements, fixes, and new functionalities aligned with business needs.
• Ensure application releases and data model changes are synchronized with database environments.
• Maintain data integrity through robust data validation, referential integrity, and error-handling practices.
• Enforce database security standards, user access controls, and audit requirements consistent with DC government policies.
• Support compliance with privacy and data protection rules applicable to DMV-related personal information.
• Use DB2 monitoring tools to proactively identify performance bottlenecks.
• Analyze SQL performance, query execution plans, and recommend optimizations.
• Tune databases, memory pools, indexes, and storage structures for improved system throughput.
• Support ongoing fixes, enhancements, and modernization efforts related to the DESTINY system.
• Collaborate with OCTO infrastructure teams on server performance, storage, and network connectivity affecting DB2.
• Implement schema modifications, table restructuring, indexing strategies, and partitioning as required.
• Provide technical knowledge and support to District agencies, personnel, and additional stakeholders.
• Perform other related duties as assigned.
• May coordinate activities of application developers.
• Able to identify best practices and standards for the use of the product.
• Deliver support and design for industry-specific applications that require integration with statewide systems or applications.
• Interact with executive level business users or technical experts.
• May function as a niche technical SME (Subject Matter Expert).

Qualifications

• Bachelor’s degree in Information Technology or related field or equivalent experience.

Requirements

• 15+ years of strong hands-on experience with IBM DB2 (LUW or z/OS depending on environment).
• Expertise in database design, data modeling, schema management, and SQL optimization.
• Knowledge of high-availability technologies (HADR, replication, failover, clustering).
• Experience supporting complex, transactional, high-volume systems (government or DMV systems ideal).
• Familiarity with ETL processes, Data Mining, Data Storage, Data warehousing.
• Knowledge of IBM batch jobs, and integration with enterprise applications.
• Strong troubleshooting, analytical, and performance tuning skills.

Benefits

• This is a remote position.