JOB TITLE: DB2 DBA
LOCATION: xxxxx
SUMMARY:
This position is responsible for the performance, integrity and security of a database. Additional role requirements are likely to include planning, development and troubleshooting. DBA roles are generally identified by the databases, the processes they administer and the capabilities of the database management system (DBMS) in use.
REQUIRED KNOWELEDGE, SKILLS AND EXPERIENCE:
(1) A good knowledge of the operating system(s)
(2) A good knowledge of physical database design
(3) Ability to perform both DB2 and also operating system performance monitoring and the necessary adjustments.
(4) Be able to provide a strategic database direction for the organisation.
(5) Excellent knowledge of Oracle backup and recovery scenarios.
(6) Good skills in all DB2 tools.
(7) A good knowledge of DB2 security management.
(8) A good knowledge of how DB2 acquires and manages resources.
(9) Sound knowledge of the applications at your site.
(10) Experience and knowledge in migrating code, database changes, data and menus through the various stages of the development life cycle.
(11) A good knowledge of the way DB2 enforces data integrity.
(12) A sound knowledge of both database and program code performance tuning.
(13) A DBA should possess a sound understanding of the business.
(14) A DBA should have sound communication skills with management, development teams,vendors,systems administrators and other related service providers
DB2 DBA RESPONSIBILITIES:
(1) Creates and maintains all databases required for development, testing, education and production usage.
(2) Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the DB2 Databases.
(3) Performs ongoing tuning of the database instances.
(4) Install new versions of the DB2 RDBMS and its tools and