Articles Comments

Oracle DBA & All IT » Database, DBA, Oracle » Oracle DBA Responsibilities & Skills

Oracle DBA Responsibilities & Skills

หลายคนคงสงสัยว่า DBA ทำหน้าที่และต้องมีทักษะอะไรบ้าง วันนี้เลยเอามาฝากกันค่ะ อย่างน้อยจะได้รู้คร่าวๆก่อนว่าอาชีพนี้จะต้องทำอะไรบ้าง สำหรับน้องๆที่อยากจะก้าวมาเป็น DBA ค่ะ จะได้เตรียมตัวให้พร้อม
 

Oracle 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 Oracle Databases.

(3) Performs ongoing tuning of the database instances.

(4) Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.

(5) Plans and implements backup and recovery of the Oracle database.

(6) Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.

(7) Implements and enforces security for all of the Oracle Databases.

(8) Performs database re-organisations as required to assist performance and ensure maximum uptime of the database.

(9) Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.

(10) Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.

(11) Provides technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact  for Oracle Corporation.

(12) Enforces and maintains database contraints to ensure integrity of the database.

(13) Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.

(14) Assists with impact analysis of any changes made to the database objects.

(15) Troubleshoots with  problems regarding the databases, applications and development tools.

(16) Create new database users as required.

(17) Manage sharing of resources amongst applications.

(18) The DBA has ultimate responsibility for the physical database design.

 

 The DBA should posses the following skills

(1) A good knowledge of the operating system(s)

(2) A good knowledge of physical database design

(3) Ability to perform both Oracle 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 Oracle tools.

(7) A good knowledge of Oracle security management.

(8) A good knowledge of how Oracle 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 Oracle 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.

ขออนุญาตไม่แปลเป็นไทยนะคะ เพราะแปลแล้วอาจจะเข้าใจยากกว่าก็เป็นได้ ^^

 เครดิต: http://www.cse.psu.edu/~groenvel/dba.html

.. Preview : 12453

Written by

บอกเล่าสิ่งที่พบเจอมาในการทำงาน ประสบการณ์การทำงานด้าน DBA ถ่ายทอดกันด้วยภาษาง่ายๆ บ้านๆ " ทุกอย่างไม่อยาก แต่... แค่ตั้งใจไม่พอ ต้องลงมือทำ และทำ GoodLuck " Fanpage: www.facebook.com/DBAor .. "Oracle Database Consultant " ..

Filed under: Database, DBA, Oracle · Tags: , , , , , , , , , , , ,

  • I certainly knew about a lot of this, but however, I still believed it turned out valuable. Great post!

  • A stitch in time saves nine.

  • As you make your bed so you must lie on it.

    • You have shed a ray of snuhsnie into the forum. Thanks!

  • ว้าวเจ๋งอ่ะ ขอบคุณเน้อ

  • Thank you i will keep these read after.

  • บทความดีมากๆเลยครับ ขอบคุณครับ

    • Phoenmenal breakdown of the topic, you should write for me too!

  • Great review! You actually overviewed some curious things on your blog. I came across it by using Google and I’ve got to admit that I already subscribed to the RSS feed, will be following you on my iphone 🙂

    • No more s***. All posts of this qualtiy from now on

    • Times are changing for the betetr if I can get this online!

    • Gee whiz, and I thoguht this would be hard to find out.

  • Nice review! This is exactly the type of article that needs to be shared around the web. Sad on the Yahoo for not positioning this article higher!

    • What a joy to find such clear thinking. Thanks for pstonig!

    • Do you have more great artiecls like this one?

  • Congrat!! thank you for post.

  • Thank you i like this information.

  • Four score and seven mniutes ago, I read a sweet article. Lol thanks

  • YMMD with that aesnwr! TX