Job Description:
DB2 on AS400 – Administrator – L3 level support
· DB2 on AS/400 – Administrator – L3 Level Support
· Expert Knowledge on SQL style tables, Index, Views and PK, FK creations using DDLs
· Expert Knowledge on Stored Procedures
· SQL Deployments, Journal management, SQL table design. Table reorganization process
· Provide technical support on database related issues.
· IBM I DB2/400 Performance monitoring using IBM I Doctor Job watcher and Performance Navigator
· Performance tuning of SQL queries, Scrip[ting database deployments.
· Automating and standardizing DBAs day to day tasks
Any Graduate