SIGN IN
DB2 DBA for iSeries jobs in United States
info-icon
This job has closed.
company-logo

NTT DATA North America · 21 hours ago

DB2 DBA for iSeries

NTT DATA North America is a recognized leader in IT and business services, and they are seeking a DB2 DBA for iSeries specializing in database performance tuning and optimization. The role involves analyzing database usage patterns, diagnosing performance issues, and collaborating with teams for monitoring and best practices documentation.
Cloud ComputingConsultingMarketingInformation TechnologyDigital MarketingInformation ServicesIT Management
check
H1B Sponsor Likelynote

Responsibilities

Review current database usage patterns to identify anti-patterns and potential performance issues
Analyze execution plans, wait time and resource metrics, and top N queries without performing query rewrites
Identify index gaps, inefficient indexing, and CPU, memory, I/O, and bufferpool configuration issues
Diagnose and resolve database performance, availability, and stability issues
Establish baselines to validate tuning and provide clear, actionable recommendations to application teams
Collaborate with tools team for monitoring
Documentation and implementation of best practices
Knowledge transfer of common tools, processes, and issue resolution

Qualification

DB2 for iSeriesDatabase performance tuningSQL tuningIBM i architectureQuery optimization

Required

8+ years of experience with DB2 for iSeries (IBM i/ AS400)
Proven expertise in database performance tuning and optimization
Advanced knowledge of SQL tuning, query optimization, and execution plans
Solid understanding of IBM i architecture, storage, and workload management
Review current database usage patterns to identify anti-patterns and potential performance issues
Analyze execution plans, wait time and resource metrics, and top N queries without performing query rewrites
Identify index gaps, inefficient indexing, and CPU, memory, I/O, and bufferpool configuration issues
Diagnose and resolve database performance, availability, and stability issues
Establish baselines to validate tuning and provide clear, actionable recommendations to application teams
Collaborate with tools team for monitoring
Documentation and implementation of best practices
Knowledge transfer of common tools, processes, and issue resolution

Preferred

Hand on experience building monitoring tools and dashboards that helps understand database performance at-a-glance and send alerts for certain types of problems

Benefits

Medical, dental, and vision insurance
Flexible spending or health savings account
Life, and AD&D insurance
Short-and long-term disability coverage
Paid time off
Employee assistance
Participation in a 401k program with company match
Additional voluntary or legally required benefits

Company

NTT DATA North America

company-logo
NTT DATA, Inc. is a trusted global innovator of business and technology services.

H1B Sponsorship

NTT DATA North America has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (144)
2024 (182)
2023 (257)
2022 (871)
2021 (809)
2020 (1266)

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
John Barr
Vice President - Insurance Strategy
linkedin
Company data provided by crunchbase