Get AS400 JobsGet AS400 Jobs

Remote IBMi/AS400/iSeries DB2 DBA


  • Rita Technology Services
  • 06/08/21
  • US
  • 00000
  • 95,000 - 120,000 / Yearly
  • Full-Time
Remote, USA
In this role, you will be responsible for planning, designing, developing, and configuring IBMi/AS400 DB2 database systems to meet business needs and requests. The role is a mix of development and production DBA responsibilities, you will be asked to split some time as a DBA and a Developer (65% DB2 DBA - 35% RPG Application Developer. You are responsible for administration, capacity planning, engineering/design, performance monitoring, and optimization for the DB2 for the IBMi/iSeries database platform.

You will be joining a $2.5B rapidly growing healthcare company employing 14,000 people and operating in 48 states. You will act as the SME on IBMi DB2 databases.

U.S. Citizens or Green Card holders only, please. We are unable to accept 3rd party candidates, or transfer a visa or provide sponsorship.

DUTIES & RESPONSIBILITIES:

Supports the design and implementation of new database environments and redesigns of existing systems to fulfill business needs
Monitors and evaluates the performance of IBMi databases
Troubleshoots database performance issues
Manages database objects Libraries, views, tables, stored procedures, and triggers
Supports developers and testing teams by maintaining test environments and configuring databases to development specifications
Work with application development teams to develop data models that support business processes.
Ensure DB changes adhere to best practices
Reviews all proposed database changes proposed by the IBMi development team
Creates technical support documentation for databases
Acts as Subject Matter Expert (SME) on IBMI database structure and environment
Will be asked to split some time as DBA and Developer (65% DB2 DBA - 35% Application Developer (RPG)
Diagnose application problems, including reviewing embedded SQL within RPG code.
There is an in-house code generating tool that is used to build some of our boilerplate database-level objects. This is written in RPG and is currently maintained by the DBA.

REQUIREMENTS:

Bachelors degree or equivalent experience
10+ years of IBMi/iSeries/AS400 experience
7+ years of experience supporting DB2 for databases in an enterprise environment.
Experience working with enterprise applications
Demonstrable experience with key relational database concepts such as database normalization, referential integrity, index strategy, and transaction isolation.
Expert knowledge of the DB2 for I SQL language.
Advanced knowledge of trigger concepts, methodologies, and implementation.
In-depth experience diagnosing and remediating DB2 for database performance issues using tools such as Plan Cache, Visual Explain, Index Advisor, Detailed Database Monitor, or similar tools.
Expert knowledge of modern RPG programming languages including ILE/Free
Experience diagnosing application problems, including reviewing embedded SQL with RPG code
Strong analytic and problem-solving skills with attention to detail.
Preference is given to candidates with hands-on experience using system performance tools such as Job Watcher, Collection Services, PEX Analyzer, or similar tools.
Experience using Turnover, Aldon, or similar change management tools

Link to apply: https://loxo.co/job/660650?t=1615164119289

Critical Need Jobs


Employer Information

Browse other AS400 Jobs

  1. Archaeologist

    Rancho Cordova, CA
    WHO WE ARE Michael Baker International is a leader in engineering, architecture, planning, environmental, construction and other c...
  2. Archeological Crew Chief

    Rapid City, SD
    Description: * Seeking an Experienced Crew Chief Archeologist to perform cultural monitoring work on various sites in the Black Hi...
  3. OSIsoft PI Historian

    Albuquerque, NM
    Ref ID: 02800-0011640687 Classification: Applications Architect Compensation: DOE This is a fulltime opportunity based in Albuq...
  4. As-Needed Field Archaeologist (Nor CA)

    Sacramento, CA
    HELIX Environmental Planning, Inc Description: HELIX Environmental Planning, Inc. (HELIX) , a growing, employee-owned California-...
  5. Medication Historian

    Albany, NY
    St. Peter's is seeking a Medication Historian for an evening position, 2pm-10pm. The Medication Historian conducts patient interv...
  6. Archaeologist - On Call

    Bellevue, WA
    Our People / Places Solutions business ... reinforces our drive to improve the lives of people everywhere and epitomizes the "wh...
  7. Senior Archaeologist

    HI United States, HI
    Archaeology Joint Base Pearl Harbor-Hickam, Hawaii Description SNA International, a world leader in forensics, biometrics, and i...
  8. Senior Archaeologist/Project Manager

    Reno, NV
    Logan Simpson currently seeks a regular full-time Senior Archaeologist/Project Manager to work in our Reno office. Salary rate ran...
  9. Archaeologist/Project Director

    Mesa, AZ
    EcoPlan welcomes motivated and qualified individuals to join our stellar team of professionals. We employ biologists, ecologists,...
  10. Senior Archaeologist (Senior Staff Scientist)

    Columbia, MD
    Senior Archaeologist (Senior Staff Scientist) See Terracon"s Safety Response to Covid-19 below Job Description General Responsi...