Adventures,friends,love,life,art, IT geeks, photography

DBA Job Desc

1 Comment

here is, if you want be DBA in IT environment… :

in the world so many database, this is depend on what you needed πŸ™‚ from embedded till enterprise scalable, here we go some database :

Oracale, MSSQL, firebird MSDE,MYSQL,INFORMIX and so many again, you can ask to uncle google πŸ˜›

and the most commonly task of DBA is… πŸ™‚ i would you like to be aDBA database master, cause a lot of benefit you will get it… πŸ™‚

  1. Installation and Configuration
    • Software Installation
    • Hardware and Software Configuration
  2. Security
    • Network Security
    • System Auditing
  3. Operations
    • Backup and Restore
    • User Management
    • Other Routine Maintenance
  4. Service Levels
      1. System Monitor
      2. SQL Server Enterprise Manager
      3. Third-party RDBMS monitors
      4. Network monitors
      5. User surveys
      6. Tools for monitoring disk space usage
    • Performance Tuning and Monitoring
    • example
    • Sizing and Capacity Planning
  5. System Uptime
    • Planning and Scheduling of System Downtime
    • Disaster Recovery
  6. Documentation
    • Configuration Documentation
      • Hardware configuration
      • Software components
      • Database configuration
      • Software tuning
    • System Log
      • Observations
      • System changes
      • System failures
      • Backup and restore operations
      • Scheduled maintenance
    • Design Documentation
    • Operational Maintenance Plans
      • Disaster Recovery Plans
  7. Design and Development
    • Data Modeling and Analysis
    • Database Design
    • Stored Procedure Development
    • Application Development
    • Information Sharing
  8. Miscellaneous
    • Cluster Administration
    • Replication Administration
    • Help Desk
    • Purchasing Input
    • Capacity Monitoring
    • Capacity Monitoring

One thought on “DBA Job Desc

  1. embuh, opo iki. ora mudheng aku, Li…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s