Provides day to day administration of databases, which includes monitoring and tuning, SQL optimization, resolving SQL errors and failures, auditing activities, and resource utilization.
Work with application development teams to migrate older dynamic SQL from Java/C++ applications into functions and stored procedures calls.
Reviewing and debugging complex SQL and understanding the best ways to incorporate database requests into application programs
Work with the infrastructure team for backup/recovery issues, capacity planning and enforcing mechanisms for securing data from inappropriate access or data loss.
Provide technical assistance to the information management team, as appropriate. Solve issues, research technologies, and help develop strategies to improve information management processes.
Bachelors degree in Computer Science/Engineering, or 5 years relevant work experience.
Prior experience on the IBM i (formerly known AS/400 and iSeries) DB2 platform highly desirable.
Knowledgeable of database design concepts as it relates to DB2 database optimization and tuning.
Strong SQL development skills; capable of developing complex SQL scripts, functions and stored procedures.
Possess good understanding of the Java/C++ programming languages.
iseries, sql, as400, db2, java, c++, IBM
Interactive Resources LLC