How to become a DB2-DBA?

Highest paid resource is DB2 DBA. The question is, how will you grab it?

Summarized need focus in these areas:

  • DBA knowledge
  • Realtime experience
  • Certification in DB2 DBA

The main DB2 DBA responsibilities are:

  1. Responsible for DB/2 products in production and test environments.
  2. TMON monitoring tool, and the Platinum tools (RC Query, RC Migrator, Plan Analyzer, and Database Analyz er).
  3. Monitors DB/2 production servers for any problems.
  4. Apply upgrades to DB/2 in test and production.
  5. Installs and maintains software used for supporting and monitoring DB/2.
  6. Assists 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.
  7. Reviews for technical accuracy. This includes the enforcement of all modeling and naming standards.
  8. Do all structural changes to DB/2 databases.
  9. Works with RACF team to ensure that proper security is in place for DB/2 data.
  10. Good knowledge in MVS, ISPF, JCL and CICS.
  11. Documenting vision for DB/2
  12. Share info to developers and operators on all components of DB/2 that are of interest through the Web, Infoshares etc
  13. Correct potential problems in DB/2 environment. This includes nightly support for the batch environment.
  14. Server admin activities DB/2 resides: monitor disk space and the DB2 log, backups, protect the integrity of the data.
  15. Provide help for all interfaces for DB2. These include Rochade, FOCUS, AMS Core software, and the gateway.
  16. Keep abreast developments in the DB2 world through journals, web, IBM Manuals, Blogs etc

The highest paid Admin is DB2 DBA, compared to  other DBAs in the world.

Certification will give much fetching to become a 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

Go through here to become a Certified DB2 DBA.

I will give tutorials/materials to grab this opportunity in my next posts.

About these ads

Have Something to Say? Post Your Comment

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s