Database Admin, IBMi

Job Description This employee is responsible for planning, designing, developing, and configuring database systems to meet business needs and requests.  The role is a mix of development and production DBA responsibilities.

Responsible for administration, capacity planning, engineering/design, performance monitoring, and optimization of the DB2 for I database platformshould be able to adapt to rapidly changing environments and technology JOB FUNCTIONS Supports the design and implementation of new database environments and redesign of existing systems to fulfill business needs

Monitors and evaluates performance of IBMi databases

Troubleshoots database performance issues

Manages database objects
Libraries, views, tables, stored procedures, triggers

Supports developers and testing team by maintaining test environments and configuring databases to development specifications

Works with application development teams to develop data models that support business processes

Ensures DB changes adhere to best practices

Reviews all proposed DB changes proposed by IBMi development team Creates technical support documentation for databases

Acts as a SME on IBMI database structure and environment

Job Requirements Education Bachelor 's Degree Required Work Experience
10+ years of IBMi/iSeries/AS400 experience Required7+ years of experience supporting DB2 for databases in an enterprise environment

Required

Experience working with enterprise applications Required Relevant certifications or training Preferred Knowledge, Skills, and Abilities 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 i 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 language (ILE/Free)
Strong analytic and problem-solving skills with attention to detail

Effective verbal and written communication

Preference given to someone hands-on experience using system performance tools such asJob Watcher, Collection Services, PEX Analyzer, or similar tools

Experience using Turnover, Aldon, or similar change management tools

Job Details Job Type: Full-time Category:
Information Technology