Job Description
DB2 DBA for iSeries (IBM i / AS400), specializing in database performance tuning and optimization.
Technical Skills
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
Roles & 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
Nice to have
Hand on experience building monitoring tools and dashboards that helps understand database performance at-a-glance and send alerts for certain types of problems
Location
Preferred in Los Colinas, TX or Alpharetta, GA - Hybrid.
About NTT DATA Services:
NTT DATA Services is a recognized leader in IT and business services, including cloud, data and applications, headquartered in Texas. As part of NTT DATA, a $30 billion trusted global innovator with a combined global reach of over 80 countries, we help clients transform through business and technology consulting, industry and digital solutions, applications development and management, managed edge-to-cloud infrastructure services, BPO, systems integration and global data centers. We are committed to our clients' long‑term success. Visit nttdata.com or LinkedIn to learn more.
NTT DATA Services is an equal opportunity employer and considers all applicants without regard to race, color, religion, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other characteristic protected by law. We are committed to creating a diverse and inclusive environment for all employees. If you need assistance or an accommodation due to a disability, please inform your recruiter so that we may connect you with the appropriate team.
This position is eligible for company benefits that will depend on the nature of the role offered. Company benefits may include 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, and additional voluntary or legally required benefits.
#J-18808-Ljbffr
Technical Skills
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
Roles & 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
Nice to have
Hand on experience building monitoring tools and dashboards that helps understand database performance at-a-glance and send alerts for certain types of problems
Location
Preferred in Los Colinas, TX or Alpharetta, GA - Hybrid.
About NTT DATA Services:
NTT DATA Services is a recognized leader in IT and business services, including cloud, data and applications, headquartered in Texas. As part of NTT DATA, a $30 billion trusted global innovator with a combined global reach of over 80 countries, we help clients transform through business and technology consulting, industry and digital solutions, applications development and management, managed edge-to-cloud infrastructure services, BPO, systems integration and global data centers. We are committed to our clients' long‑term success. Visit nttdata.com or LinkedIn to learn more.
NTT DATA Services is an equal opportunity employer and considers all applicants without regard to race, color, religion, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other characteristic protected by law. We are committed to creating a diverse and inclusive environment for all employees. If you need assistance or an accommodation due to a disability, please inform your recruiter so that we may connect you with the appropriate team.
This position is eligible for company benefits that will depend on the nature of the role offered. Company benefits may include 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, and additional voluntary or legally required benefits.
#J-18808-Ljbffr