DBA is responsible for product upgrades, patches, access control, reviews, Server admin activities, Interface teams, Storage, performance, and maintaining database objects.
DB2 DBA responsibilities
- Responsible for DB/2 products in production and test environments.
- TMON monitoring tool, and the Platinum tools (RC Query, RC Migrator, Plan Analyzer, and Database Analyzer).
- Monitor DB/2 production servers for any problems.
- Apply upgrades to DB/2 in test and production.
- Installs and maintains software used for supporting and monitoring DB/2.
- Assist all development work on DB/2. Help in application development, designing and creating database objects, migrating from test to production, and implementing batch schedules with the appropriate DB2 utilities.
- Reviews for technical accuracy. It includes the enforcement of all modeling and naming standards.
- Do all structural changes to DB/2 databases.
- Works with the RACF team to ensure that proper security is in place for DB/2 data.
- Have good knowledge of MVS, ISPF, JCL, and CICS.
- Documenting vision for DB/2
- Share info to developers and operators on all components of DB/2 that are of interest through the Web, Infoshares, etc
- They correct potential problems in the DB2 environment. It includes nightly support for the batch environment.
- Server admin activities DB/2 resides: monitor disk space and the DB2 log, backups, and protect the integrity of the data.
- Provide help for all interfaces for DB2. These include Rochade, FOCUS, AMS Core software, and the gateway.
- Keep abreast of developments in the DB2 world through journals, the web, IBM Manuals, Blogs, etc.
The highest-paid admin is DB2 DBA, compared to other DBAs.
- DBA knowledge
- Realtime experience
- Certification in DB2 DBA
- You need to work at least 2 years as DBA before you get a certificate
- Two kinds of tests you need to take to qualify as DBA
- You should know Cobol/Java/C++
- Capability to resolve complex problems. Check out here to become a Certified DB2 DBA.