Be a qualified DBA

Time:2020-9-15

Role definition of Oracle DBA

Development DBA

  • Database installation
  • Database architecture design (Architecture and modeling)
  • Code development (stored procedure, SQL)

Operation and maintenance DBA

  • Daily monitoring of database
  • Troubleshooting
  • performance optimization
  • Data backup, disaster recovery
  • Database security planning

The integrity of DBA

Within the scope of their own responsibility

  • Make the database design more reasonable and prevent the performance or security risks caused by the design
  • More secure data
  • Better database performance
  • The daily management of database is more reasonable
  • The fault is found and handled in time

Database architecture design

Database architecture

  • Distributed or single library

Redundant instances

  • RAC or single

Database security and disaster tolerance

  • DG or streams or Rman

Space consideration, storage planning

  • ASM (automatic storage management) + San (storage area network)

Software life cycle and business (data) growth forecast

Database modeling

Entity, relation design E-R

  • surface
  • Indexes
  • Reference of primary and foreign keys

Database development — SQL and stored procedure

  • Is SQL variable bound
  • Performance problems of SQL statements
  • Table analysis method – analysis options, analysis frequency, etc
  • Performance parameters affecting SQL execution efficiency

<!–more–>

Operation and maintenance of database

Database monitoring

  • customized
  • Open source script + open source software
  • OEM+grid control
  • Third party software quest, etc

Data management and security

  • Backup strategy
  • Data retention, deletion policy
  • Partition, compression, read only table space
  • The most important issue is data security

Troubleshooting

  • Deep understanding of database
  • Oracle support (metalink, the official technical support site of Oracle, through which Oracle supports customers around the world)
  • asktom.oracle.com
  • www.itpub.net

Performance optimization of database

  • Deep understanding of business process
  • User perception oriented optimization
  • Establishment of performance baseline – CPU, I / O, sessions
  • Regular AWR (automatic workload repository, Oracle AWR) report analysis

Database security

  • Password management strategy (refined authorization mechanism)
  • Oracle’s security products DB vault and audit vault
  • Fine grained audit of Oracle (FGA)
  • data encryption
  • Operating system password management

Oracle learning ideas

Introduction > in depth Oracle > Oracle Performance Optimization Art > database design based on massive data


Remember to give me some compliments!

Carefully sorted out the various directions of the computer from the entry, advanced, actual combat video courses and e-books, according to the catalog reasonable classification, you can always find the learning materials you need, what are you waiting for? Pay attention to download now!!!

Be a qualified DBA

Never forget, there must be a response, friends help me point out a praise, thank you very much.

I am a professional bright brother, YY Senior Software Engineer, four years of work experience, refused salted fish strive to be the leading slash programmer.

Listen to me, more progress, a shuttle program life

If you are lucky enough to help you, please give me a “like” and give me a concern. If you can give me a comment and an encouragement, I will be very grateful.

List of articles by bright brother in the workplace:More articles

Be a qualified DBA

All my articles and answers have cooperation with the copyright protection platform. The copyright belongs to the workplace Liang brother. Without authorization, reprint must be prosecuted!