IBM iSeries / AS-400 Database Administrator / Engineer

Overview

Remote
Depends on Experience
Contract - Independent
Contract - W2
Contract - 6 Month(s)
10% Travel

Skills

IBMi
DB2
DB2 for i
SQL
iSeries
AS-400

Job Details

Role: IBM iSeries / AS-400 Database Administrator / Engineer

Location: Fully remote EST Time

Duration: 6 months contract to hire

 

Responsibilities:

  • Act as the primary contact and lead support associate for multiple critical components of the platform and help resolve customer issues in a timely manner
  • Collaborate with platform product owners and play a critical role in end-to-end Operations Management of Application/Data Platform as a Service
  • Collaborate with technical/business leaders and platform product owners to acquire and understand requirements / acceptance criteria and provide platform stability
  • Participate in capacity planning, disaster recovery and high availability planning
  • Recommend observability standards and enable platform observability through logging and monitoring
  • Triage production issues and work with multiple teams to perform problem analysis
  • Run through query review workflow
  • Identify poorly running processes in production - CPU, plan cache analysis
  • Execute data fixes
  • Help with overnight DB deploys
  • Perform on-going research to explore new features, versions, and related technologies, and provide recommendations to enhance our offerings
  • Document standard run books and operating procedures and assign/review tasks from junior and offshore associate engineers
  • Participate in conducting new hire interviews
  • Work closely with the project team and report clearly and accurately to management
  • Build and maintain stable working relationships internally
  • Other duties as assigned

 

Qualifications:

  • Bachelor s degree in Computer Science/Computer Engineering or equivalent years of software development/system administration experience required
  • 8-10 years of industry experience with knowledge of IBMi server and DB2 for i administration and programming languages required
  • 5+ years of hands-on DBA experience working with DB2 for i
  • 3+ years of experience with relational database (RDBMS) and OLTP/OLAP concepts
  • Basic IBMi navigation - ACS, Schemas, Run SQL, plan cache, calling a program, stored procedure, creating UDF, etc.
  • Experience with IBM ACS tools like Run SQL, Schemas, Visual Explain
  • Experience with IBM performance tools like iDoctor and Performance Navigator
  • Experience with IBMi change management s/w like Implementer and MDCMS (Midrange Dynamics)
  • Writing complex SQL queries that use joins, sub-selects, with statements
  • Demonstrated ability to support and administer high volume and high velocity application/data environments
  • Strong experience with relational database (DB2 for i, aka DB2/400) administration
  • Experience with build management and continuous integration tools preferred
  • Understanding of DevOps concepts, Agile/Scrum, CI/CD, Git
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.