What are the responsibilities and job description for the DB2 DBA position at Intellibee?
Expert with DB2 tools who can assist in:
1) Identifying which indexes are needed on DB2 database, based on the code / SQL calls
2) Getting those indices created –hopefully with an automated tool.
3) Identify what doesn't have an index
4) Be able to identify all tables that are smaller than a threshold or tables/DBs rarely invoked (this set would also be typically nonfunctional tables)
5) Troubleshoot the performance issues