application tools http://www.kods.net/ application tools Fri, 30 Jul 2010 04:02:50+0000 http://www.kods.net/ en Oracle DBA duties and daily work of analysis http://www.kods.net/oracle-dba-duties-and-daily-work-of-analysis/ http://www.kods.net/oracle-dba-duties-and-daily-work-of-analysis/#comments Wed, 27 Jan 2010 09:23:20+0000 kods.net http://www.kods.net/oracle-dba-duties-and-daily-work-of-analysis/ DBA duties and daily work duties:
1. Installation and upgrade the database server, and application tools to build and configure the network environment.

2. Familiar with the database system storage structure to predict future storage needs, develop a database storage solutions.

3. According to the application developer to design the system requirements to create a database storage structure.

4. According to the application developer to design the system requirements to create database objects

5. According to developer feedback, when necessary, modify the database structure

6. Manage database user to maintain the security of the database

7. Controlling and monitoring user access to the database access

8. Monitor and optimize database performance

9. To develop a database backup plan, disaster occurs to restore the database information

10. Backup and restore database

11. Contact database system manufacturers to track technical information

12. To solve the client links to the middle tier and server issues

13. To ensure a secure connection

Daily work:

1 to ensure that the server to normal working condition, all kinds of database status to normal

2 Check the adequacy of hard disk space

3 See database log, view the trace file, checking whether there is an error message

4 Check the validity of the backup

5 through the system's performance monitor server performance parameter monitor whether the decline in performance found in the database to find the cause and solution

6 Fill dba log

Week:

A control room for expansion of database objects

2 to decide whether to adjust storage parameters

3 on the system health check

4 Check to delete the data object does not make sense

5 check does not make sense to delete constraints and triggers

6 on the weekly backup to examine and handle

Monthly work:

1 Based on the above examination and to analyze whether it will affect the performance of the database is stored fragments exist

2 According to the historical data database performance to decide how to optimize performance

3 deal with a daily weekly and monthly backup

4 review the work and management plan for the next steps

Oracle DBA daily work summary

Oracle administrator should be as follows on the Oracle database system for regular monitoring:

1 day, running on the Oracle database, log files, backups, database space usage, system resource usage, it was discovered, and solve the problem.

2, weekly space for expansion of the database objects and data to monitor the growth of the database to do health checks, the state of the database objects for check-ups.

3, monthly tables and indexes etc. analyze, check the table of space debris, looking for a database performance tuning of the opportunity to conduct a database performance tuning, the next steps of space management plan. State of the Oracle database, conduct a comprehensive inspection.

Working day

1, confirm that all of the instance state of the normal log on to all the databases or instances, testing Oracle background process: # ps-ef | grep ora

2, check the file system used (the remaining space). If the file system free space is less than 20%, need to delete unused files to free up space. # df-k

3, check the log file and trace file record alert and trace errors in the file. 

cd $Oracle_BASE/oradata/<sid>/bdump
tail -f alert_<sid>.log



ORA_ find any new errors, record and resolve

4, checking the validity of the database backup of the day

Right RMAN backup, check the third-party backup tools, backup log to determine the success of the backup

On the EXPORT backup, check the exp log files to determine the success of the backup

For other backup, check the corresponding log file

5, check the status of the record data file is not "online" data file and do recovery. 



select file_name from dba_data_files where status="OFFLINE"

6, check the table space is being used 


select a.tablespace_name,round((total-free)/total,3)*100 pecent
from (select tablespace_name,sum(bytes) free from dba_free_space group by tablespace_name) a,
(select tablespace_name,sum(bytes) total from dba_data_files group by tablespace_name) b
where a.tablespace_name=b.tablespace_name



7, check the remainder of the table space 


select tablespace_name,sum(blocks) as free_blk,trunc(sum(bytes)/(1024*1024)) as free_m,
max(bytes)/(1024) as big_chunk_k,count(*) as num_chunks
from dba_free_space group by tablespace_name;



8, monitoring database performance

Run utlbstat.sql / utlestat.sql report generation system, or the collection of statistical data on the use of statspace

9, check the database performance, recording the database CPU use, IO, Buffer hit ratio, etc., use vmstat, iostat, glance, top

10, the daily handling of problems

The working week

1, the control room for expansion of the database objects, according to the inspection day this week to find room for expansion of the database objects quickly, and take appropriate measures.

Remove the historical data, expand the table space 


alter tablespace <name> add datafile '<file>' size <size>



Adjust the data object storage parameters for the next extent pct_increase

2, monitoring the growth of the amount of data

According to this week, the daily inspection record data to find growth in the number of database objects quickly and take appropriate measures

Remove the historical data, expand the table space 



alter tablespace <name> add datafile '<file>' size <size>



3, the system health check

Check the following: 


init<sid>.ora
controlfile
redo log file
archiveing
sort area size
tablespace(system,temporary,tablespace fragment)
datafiles(autoextend,location)
object(number of extent,next extent,index)
rollback segment
logging & tracing(alert.log,max_dump_file_size,sqlnet)



4, check the invalid database objects 



select owner,object_name,object_type from dba_objects where status='INVALID'



5, check the constraint does not work 



select owner,constraint_name,table_name,constraint_type,status from dba_constraints
where status='DISABLED' and constraint_type='p'



6, check the invalid trigger 


select owner,trigger_name,table_name,status from dba_triggers
where status='DISABLED'



Monthly work

1, Analyze tables / indexes / cluster

analyze table <name> estimate statistics sample 50 percent;

2, check the table of space debris

According to analysis of the database this month, a weekly inspection of debris, to find the appropriate solution

3, looking for opportunities for database performance tuning

Comparison of daily database performance monitoring and reporting, to determine whether it is necessary to adjust the database performance

4, database performance tuning, performance tuning, if necessary

5, the next steps of space management plan, based on weekly monitoring, space management for improved methods proposed



Original Address http://blog.sina.com.cn/s/blog_525394060100ffg7.html Published on: 2010-01-27, modified on: 2010-01-27 11:53 has been here 10 times, there have been comments 0 recommend Complaints

User Reviews
Comments
Related Posts
]]> http://www.kods.net/oracle-dba-duties-and-daily-work-of-analysis/ DBA duties and daily work http://www.kods.net/dba-duties-and-daily-work/ http://www.kods.net/dba-duties-and-daily-work/#comments Fri, 30 Oct 2009 12:30:36+0000 kods.net http://www.kods.net/dba-duties-and-daily-work/ DBA duties and daily work duties:

1. Installation and upgrade the database server, and application tools to build and configure the network environment.

2. Familiar with the database system storage structure to predict future storage needs, develop a database storage solutions.

3. According to the application developer to design the system requirements to create a database storage structure.

4. According to the application developer to design the system requirements to create database objects

5. According to developer feedback, when necessary, modify the database structure

6. Manage database user to maintain the security of the database

7. Controlling and monitoring user access to the database access

8. Monitor and optimize database performance

9. To develop a database backup plan, disaster occurs to restore the database information

10. Backup and restore database

11. Contact database system manufacturers to track technical information

12. To solve the client links to the middle tier and server issues

13. To ensure a secure connection

Daily work:

1 to ensure that the server to normal working condition, all kinds of database status to normal

2 Check the adequacy of hard disk space

3 See database log, view the trace file, checking whether there is an error message

4 Check the validity of the backup

5 through the system's performance monitor server performance parameter monitor whether the decline in performance found in the database to find the cause and solution

6 Fill dba log

Week:

A control room for expansion of database objects

2 to decide whether to adjust storage parameters

3 on the system health check

4 Check to delete the data object does not make sense

5 check does not make sense to delete constraints and triggers

6 on the weekly backup to examine and handle

Monthly work:

1 Based on the above examination and to analyze whether it will affect the performance of the database is stored fragments exist

2 According to the historical data database performance to decide how to optimize performance

3 deal with a daily weekly and monthly backup

4 review the work and management plan for the next steps

Oracle DBA daily work summary

Oracle administrator should be as follows on the Oracle database system for regular monitoring:

1 day, running on the Oracle database, log files, backups, database space usage, system resource usage, it was discovered, and solve the problem.

2, weekly space for expansion of the database objects and data to monitor the growth of the database to do health checks, the state of the database objects for check-ups.

3, monthly tables and indexes etc. analyze, check the table of space debris, looking for a database performance tuning of the opportunity to conduct a database performance tuning, the next steps of space management plan. State of the Oracle database, conduct a comprehensive inspection.

Working day

1, confirm that all of the instance state of the normal log on to all the databases or instances, testing Oracle background process: # ps-ef | grep ora

2, check the file system used (the remaining space). If the file system free space is less than 20%, need to delete unused files to free up space. # df-k

3, check the log file and trace file record alert and trace errors in the file. 

cd $Oracle_BASE/oradata/<sid>/bdump
tail -f alert_<sid>.log

ORA_ find any new errors, record and resolve

4, checking the validity of the database backup of the day

Right RMAN backup, check the third-party backup tools, backup log to determine the success of the backup

On the EXPORT backup, check the exp log files to determine the success of the backup

For other backup, check the corresponding log file

5, check the status of the record data file is not "online" data file and do recovery. 

select file_name from dba_data_files where status="OFFLINE"

6, check the table space is being used 

select a.tablespace_name,round((total-free)/total,3)*100 pecent
from (select tablespace_name,sum(bytes) free from dba_free_space group by tablespace_name) a,
(select tablespace_name,sum(bytes) total from dba_data_files group by tablespace_name) b
where a.tablespace_name=b.tablespace_name

7, check the remainder of the table space 

select tablespace_name,sum(blocks) as free_blk,trunc(sum(bytes)/(1024*1024)) as free_m,
max(bytes)/(1024) as big_chunk_k,count(*) as num_chunks
from dba_free_space group by tablespace_name;

8, monitoring database performance

Run utlbstat.sql / utlestat.sql report generation system, or the collection of statistical data on the use of statspace
Related Posts
]]> http://www.kods.net/dba-duties-and-daily-work/ DBA must have the personality characteristics of http://www.kods.net/dba-must-have-the-personality-characteristics-of/ http://www.kods.net/dba-must-have-the-personality-characteristics-of/#comments Thu, 18 Jun 2009 23:15:48+0000 kods.net http://www.kods.net/dba-must-have-the-personality-characteristics-of/ OCP classified into two categories, a class-oriented development, known as the DEV;
A class-oriented management, known as the DBA;

What is DBA

Database administrator, English is the Database Administrator, referred to as DBA. The position of different people mean different meanings. A small studio and a software development division of a high degree of detail compared to the large companies, DBA broader responsibilities than some. A company, whether it be software development and application of their own, or purchase third-party application software, as long as related to the database (the number does not involve the application of database software? Database is the soul of business and brain ah), will need to determine whether an employment or DBA. DBA to know What are the requirements for this position, the internal definition of the job or the future for those who will be crucial DBA. I have listed below some of the responsibilities of the DBA:

To install and upgrade the database server (such as Oracle, Microsoft SQL server), and application tools.
Database design system storage and storage needs for the future plans.
Once the developer has designed an application, we need to create a DBA database storage structures (tablespaces).
Once the developer has designed an application, the DBA needs to create database objects (tables, views, indexes).
According to feedback from developers, when necessary, modify the structure of the database.
The user registration database, maintain database security.
Database to ensure that the use of intellectual property rights in line with relevant laws and regulations.
Control and monitor user access to access the database.
Monitor and optimize database performance.
The development of database backup plans when disaster recovery of database information on the maintenance of appropriate media archive or backup data backup and restore database system database contact the manufacturer to track technical information.
Personality characteristics of DBA

Managers often ignore the fact that DBA's personality characteristics, they are only concerned about the technical capacity of DBA. In fact, the above-mentioned functions of each means: DBA needs to deal with a variety of personnel, these personnel may be vendors, users, developers or managers. This shows that: DBA must have the following personality characteristics:

Self-confidence tenacious willpower curiosity-driven attention to the details of self-experienced

Why are these personality characteristics are important?

I have several of his subordinates lack of self-confidence, they repeatedly asked me a number of micro-issues, they have no confidence to do even the smallest decision. They also lack the initiative work. This may be the primary DBA for the problem is not too large, but the senior DBA who, if they lack self-confidence, who they can rely on to help their decision? In the interview DBA, even if you can not answer a technical question, you have to show enough self-confidence. Is not the most deadly do not know the answer to that question, but do not know from where to get an answer.

Almost all of the database systems are constantly updated. But not all have the technical documentation updates. DBA for the good, the curiosity is essential. There is no curiosity and thirst for knowledge of the DBA is always the answer and wait for someone to tell them. And a strong thirst for knowledge of the DBA will install the latest version of the database system, and immediately began to search for that even subtle features and performance differences and enhance, to improve their work. A test when asked the inevitable question is: What are your references on-hand? How do you use them? There is no doubt that if you answer only the database files, or you did not even read them, your "stock market" will be greatly decreased. DBA will be driven by curiosity to understand the data dictionary (Data Dictionary), management tool (Tools), or other support package (Packages).

DBA often encounter difficult problem. The answer is the need to find a tenacious willpower, you can withstand the personality characteristics of tempering. I am often in a number of discussion groups or forums to see the DBA issues raised by these issues themselves are often the question can be solved, if they have a tenacious personality characteristics, and to seek answers to these questions.

Self-drive for each person is very important, especially for the DBA. DBA should be able to find ways to make the problem, rather than waiting for problems. Strong self-drive access to the DBA is often necessary to write or script (Script) to monitor the size of data table (Table Size), the use of table space (Tablespace Usage) and other projects, which, if neglected, they will encounter Trouble . DBA exam when they are often asked in the PL / SQL, SQL or SQL * PLUS experience, these problems will never prepare you need to have their own scripts to distinguish between those DBA.

Needless to say, and the user, that is, and programmers and managers to deal with, but also you experienced enough. A way that the DBA will not be a good thing for you to do only in the sector you the flames ignited hostility. Is such a sophisticated capabilities, you advise a person to go to House, ha ha, and finally the person with the feelings of desire to go. Very often, developers, managers, users, they will put forward the demand for no reason, DBA experienced guide need to amend their request, to persuade them. In the test, you can deal with it is that you experienced.
Finally, talk about attention to detail, this tendency is very important character. Attention to the details of the DBA have clean clothing and have their own schedule, candidates in the examination of the unit before the survey. Attention to detail are the DBA database-depth understanding of the core, and can understand the view, the relationship between tables.

The level of DBA

The DBA is not a strict hierarchy. In accordance with the master database, I simply divided into three levels: primary Primary, Intermediate Intermediate and Senior Senior.

DBA is also known as primary DBBS, is English abbreviation Database Baby Sitter. Primary DBA is often part-time, they are often at the same time as other programmers, or work. Junior DBA often write good CVs, and databases involved in a lot or work-related projects. However, these projects often or is: third-party software suppliers would have had to install and configure the database, they do some monitoring work. They can handle some simple questions, but most of the time of their application software to help suppliers. Junior DBA prefer a graphical tool for database management, or monitoring, they like Access this easy-to-use desktop database, and the experience of these small simple database application to large-scale database-related work.

DBA primary distinction is the best. Intermediate and senior DBA and DBA do not distinguish between very good. Their difference is the different experiences and personality characteristics, differences in ability. More mid-level DBA, they can do most of the work of senior DBA, including:

Database installation and management of the database configuration settings and security management authority to monitor and adjust performance backup and recovery solution to the problem of general

Intermediate DBA practitioners often about a year, some familiar with the operating system, database environment. DBA is due to the intermediate, Windows NT and Unix is very different. Intermediate DBA for more familiar with SQL, database Bought a few copies to buy their own books, and studied in depth. Intermediate DBA database programmers often at the same time, their work performance, stability, security, the pursuit is basically not very high, often with the senior DBA to do some routine work.

Senior DBA at home is very small. They bought a lot of database information in English may be asked a friend to buy from Amazon. Vis- à -vis their remuneration is concerned, the money to buy a small proportion is. Senior DBA is generally familiar with a variety of operating platforms of several large databases. They know a variety of different databases in different advantages and disadvantages, and in the database environment and database platform choices to make a decision. They are generally familiar with system architecture and database design and database optimization at various levels. Senior DBA with aides generally, they tend to make decisions and plans. Senior DBA is often in the banking, insurance, online transactions, such as stability, security, require relatively high performance of the key areas of business processes to show their talents.

In many cases, whether a database of experts is not very important certification. I know that many of the training database vendors to the city as long as you obtain the certificate. There are many commercial companies to provide training, quality of service they have both good and bad. Therefore, the certificate is not particularly meaningful.

Several popular database system

The most "easy" the database system-Microsoft SQL Server

If you intend to do a DBA, suggest that you select those who are more popular database system. This means that you will have more employment opportunities, exchange and training opportunities, and its own popular popular reasons, you can be a lot of worry. Of course, employment is also more competitive pressures. Introduction to the general choice of Microsoft SQL Server, it is very suitable for small and medium-sized enterprise database system, the readers are familiar with Access can easily use the initial Microsoft SQL Server, as a DBBS. J
Microsoft SQL Server 7.0 offers 5 user version of 1399 U.S. dollars, increased users, 127 U.S. dollars per user.

The most "difficult" database - A testimony Oracle

If you have access to Oracle, it was a good opportunity. Oracle is the most optimistic about the database vendor, because of its powerful features and configuration management capabilities available, Oracle DBA salaries in general than any other database administrator's salary is higher. Moreover, Oracle and medium-sized enterprises in the critical applications and more common. Oracle can run on Windows NT, Sun Solaris, Linux and other platforms. Many cases, ask you to not only familiar with the NT, but also you are familiar with Unix; and Oracle not friendly interface and the Oracle products into the information box may also be an obstacle.
Oracle 8i Standard Edition of Price, if running on Windows NT, incidental JServer and interMedia, support 5 concurrent users, Price is 3925 U.S. dollars per CPU. Increase in concurrent users, 785 U.S. dollars per user. Naming adding users, 392.5 U.S. dollars per user.

Database Systems-IBM UDB/DB2 aristocratic

30 years as a research database, IBM DB2 indeed be regarded as "the database system of nobility." Whether it is a small business systems, or a large banking system with the DB2 can sit back and relax. Recently introduced a new version of DB2 6.1, management and regulation tools for greater success and ease of use. DB2 can be run on Intel architecture can also be run on IBM's S/390 large computer. If your IBM machine industry particularly commendable, I suggest you learn from IBM DB2.

There are two versions of DB2: The Working Group and Enterprise editions. Working Group on the server version of 999 U.S. dollars each, plus 249 U.S. dollars for each concurrent user. The Enterprise Edition is a 12,500 U.S. dollars for each CPU, not limited to the number of concurrent users.

To Java-centric database-Sybase Adaptive Server Enterprise (ASE) 12.0

The upcoming release of Sybase ASE 12.0, direct-to-Java programmers. This Java-centric database system, for those who are ready to build a Java platform for enterprise applications business, will be the best option. ASE can not be called a database but a leader in the field, although compared with the previous version of it has improved a lot, and support multiple CPU and more complicated, there are a lot of new features. However, it seems that Sybase is no longer the scenery.

Worth looking forward to the Informix Centaur

Sometimes the "first" means that your opponent only needs to wait for a longer period of time to catch up with you. This is founded in 1997 faced by Informix. Informix is the first multimedia features will be added to the relational database system, one of the large database vendors. But now, IBM, Oracle, Sybase have this idea across. So, Informix had to seek new support to make their own databases from other vendors. Informix Centaur This is the goal. Informix Centaur combines the Informix Dynamic Server 7.3 object - relational database and the Informix Universal Data Option 9.1, is intended to better adaptation and multimedia support. Details, we will wait and see!

DBA salary

There are many factors that affect your pay as a DBA:

Your experience and ability of the DBA level determined by your database system you are familiar with the personality characteristics and potential

The table below shows the basic domestic DBA salary conditions, as well as a description of the DAB level and you are familiar with how the impact of the database system to pay DBA. Of course, this is only my personal knowledge, only a certain extent, on behalf of the industry average.

DBA junior level DBA salary database system (million) annual salary of mid-level DBA (million) annual salary of senior DBA (million)
Oracle 4 8 11
Microsoft SQL Server 3 5 8
IBM DB2 4 8 10
Sybase 3.5 6 8
Informix 4 7 1 0
Note: The annual 13-month calculation. In the tables for the average annual salary.
http://www.oradb.net/comm/database_001.htm

Standards are: excellent interpersonal skills, practical experience and theoretical knowledge database.

Excellent interpersonal skills: Oracle DBA and the IT industry often have the technical experts to deal with, so, he or she must be able to visit the Oracle database for all the developers or programmers clear explanation of the concept of Oracle. In some cases, Oracle DBA is a management staff, therefore, also asked him to participate in the strategic development plan, as well as database design, have excellent interpersonal skills. The majority of successful Oracle professionals are asked by the computer or bachelor's degree in information systems. For higher positions, such as Oracle DBA, many employers require a master's degree in computer science or by the MBA.

Practical experience: This is a new certificate with the OCP most worried about one thing. OCP has been a lot of work experience certificate is not the people are not complaining about OCP certificate would not have work experience, there is no work there would be no work experience. This is the talent market is a very difficult problem.

Database of theoretical knowledge: In addition to the requested OCP master technical knowledge, a successful professionals as well as Oracle databases and database design and software-related knowledge, including the standardization of database theory and the use of Unified Modeling Language (UML) of the surface to the object model, of course, there are other methods of database design knowledge, such as CORBA and J2EE. Well you may say that: OCP does not fully measure the actual level of a person (the most important thing is can not judge his work experience), he was just a person's access to non-IT industries to provide a method of the field of Oracle. Non-IT industry into the Oracle.

This article comes from CSDN blog, reprint, please indicate the source: http://blog.csdn.net/spfile/archive/2006/03/10/620930.aspx
Related Posts
]]> http://www.kods.net/dba-must-have-the-personality-characteristics-of/ You want to become a DBA of qualified you http://www.kods.net/you-want-to-become-a-dba-of-qualified-you/ http://www.kods.net/you-want-to-become-a-dba-of-qualified-you/#comments Thu, 18 Jun 2009 21:14:02+0000 kods.net http://www.kods.net/you-want-to-become-a-dba-of-qualified-you/ What is DBA

Database administrator, English is the Database Administrator, referred to as DBA. The position of different people mean different meanings. A small studio and a software development division of a high degree of detail compared to the large companies, DBA broader responsibilities than some. A company, whether it be software development and application of their own, or purchase third-party application software, as long as related to the database (the number does not involve the application of database software? Database is the soul of business and brain ah), will need to determine whether an employment or DBA. DBA to know What are the requirements for this position, the internal definition of the job or the future for those who will be crucial DBA. I have listed below some of the responsibilities of the DBA:

To install and upgrade the database server (such as Oracle, Microsoft SQL server), and application tools.

Database design system storage and storage needs for the future plans.

Once the developer has designed an application, we need to create a DBA database storage structures (tablespaces).

Once the developer has designed an application, the DBA needs to create database objects (tables, views, indexes).

According to feedback from developers, when necessary, modify the structure of the database.

The user registration database, maintain database security.

Database to ensure that the use of intellectual property rights in line with relevant laws and regulations.

Control and monitor user access to access the database.

Monitor and optimize database performance.

The development of database backup plans when disaster recovery of database information

Medium on the maintenance of proper archive or backup data

Database backup and recovery

Contact the manufacturer of the database system to track technical information.

Personality characteristics of DBA

Managers often ignore the fact that DBA's personality characteristics, they are only concerned about the technical capacity of DBA. In fact, the above-mentioned functions of each means: DBA needs to deal with a variety of personnel, these personnel may be vendors, users, developers or managers. This shows that: DBA must have the following personality characteristics:

Self-confidence / curiosity / tenacious willpower / sophisticated / self drive / attention to detail

Why are these personality characteristics are important?

I have several of his subordinates lack of self-confidence, they repeatedly asked me a number of micro-issues, they have no confidence to do even the smallest decision. They also lack the initiative work. This may be the primary DBA for the problem is not too large, but the senior DBA who, if they lack self-confidence, who they can rely on to help their decision? In the interview DBA, even if you can not answer a technical question, you have to show enough self-confidence. Is not the most deadly do not know the answer to that question, but do not know from where to get an answer.

Almost all of the database systems are constantly updated. But not all have the technical documentation updates. DBA for the good, the curiosity is essential. There is no curiosity and thirst for knowledge of the DBA is always the answer and wait for someone to tell them. And a strong thirst for knowledge of the DBA will install the latest version of the database system, and immediately began to search for that even subtle features and performance differences and enhance, to improve their work. A test when asked the inevitable question is: What are your references on-hand? How do you use them? There is no doubt that if you answer only the database files, or you did not even read them, your "stock market" will be greatly decreased. DBA will be driven by curiosity to understand the data dictionary (Data Dictionary), management tool (Tools), or other support package (Packages).

DBA often encounter difficult problem. The answer is the need to find a tenacious willpower, you can withstand the personality characteristics of tempering. I am often in a number of discussion groups or forums to see the DBA issues raised by these issues themselves are often the question can be solved, if they have a tenacious personality characteristics, and to seek answers to these questions.

Self-drive for each person is very important, especially for the DBA. DBA should be able to find ways to make the problem, rather than waiting for problems. Strong self-drive access to the DBA is often necessary to write or script (Script) to monitor the size of data table (Table Size), the use of table space (Tablespace Usage) and other projects, which, if neglected, they will encounter Trouble . DBA exam when they are often asked in the PL / SQL, SQL or SQL * PLUS experience, these problems will never prepare you need to have their own scripts to distinguish between those DBA.

Needless to say, and the user, that is, and programmers and managers to deal with, but also you experienced enough. A way that the DBA will not be a good thing for you to do only in the sector you the flames ignited hostility. Is such a sophisticated capabilities, you advise a person to go to House, ha ha, and finally the person with the feelings of desire to go. Very often, developers, managers, users, they will put forward the demand for no reason, DBA experienced guide need to amend their request, to persuade them. In the test, you can deal with it is that you experienced.

Finally, talk about attention to detail, this tendency is very important character. Attention to the details of the DBA have clean clothing and have their own schedule, candidates in the examination of the unit before the survey. Attention to detail are the DBA database-depth understanding of the core, and can understand the view, the relationship between tables.

The level of DBA

The DBA is not a strict hierarchy. In accordance with the master database, I simply divided into three levels: primary Primary, Intermediate Intermediate and Senior Senior.

DBA is also known as primary DBBS, is English abbreviation Database Baby Sitter. Primary DBA is often part-time, they are often at the same time as other programmers, or work. Junior DBA often write good CVs, and databases involved in a lot or work-related projects. However, these projects often or is: third-party software suppliers would have had to install and configure the database, they do some monitoring work. They can handle some simple questions, but most of the time of their application software to help suppliers. Junior DBA prefer a graphical tool for database management, or monitoring, they like Access this easy-to-use desktop database, and the experience of these small simple database application to large-scale database-related work.

DBA primary distinction is the best. Intermediate and senior DBA and DBA do not distinguish between very good. Their difference is the different experiences and personality characteristics, differences in ability. More mid-level DBA, they can do most of the work of senior DBA, including:

Database install / database configuration and management / permissions and security settings management / monitoring and performance tuning / backup and recovery / settlement of the issue of general

Intermediate DBA practitioners often about a year, some familiar with the operating system, database environment. DBA is due to the intermediate, Windows NT and Unix is very different. Intermediate DBA for more familiar with SQL, database Bought a few copies to buy their own books, and studied in depth. Intermediate DBA database programmers often at the same time, their work performance, stability, security, the pursuit is basically not very high, often with the senior DBA to do some routine work.

Senior DBA at home is very small. They bought a lot of database information in English may be asked a friend to buy from Amazon. Vis- à -vis their remuneration is concerned, the money to buy a small proportion is. Senior DBA is generally familiar with a variety of operating platforms of several large databases. They know a variety of different databases in different advantages and disadvantages, and in the database environment and database platform choices to make a decision. They are generally familiar with system architecture and database design and database optimization at various levels. Senior DBA with aides generally, they tend to make decisions and plans. Senior DBA is often in the banking, insurance, online transactions, such as stability, security, require relatively high performance of the key areas of business processes to show their talents.

In many cases, whether a database of experts is not very important certification. I know that many of the training database vendors to the city as long as you obtain the certificate. There are many commercial companies to provide training, quality of service they have both good and bad. Therefore, the certificate is not particularly meaningful.

This article comes from CSDN blog, reprint, please indicate the source: http://blog.csdn.net/Aceryt/archive/2007/06/03/1636017.aspx
Related Posts
]]> http://www.kods.net/you-want-to-become-a-dba-of-qualified-you/ What is a real DBA? http://www.kods.net/what-is-a-real-dba/ http://www.kods.net/what-is-a-real-dba/#comments Thu, 18 Jun 2009 08:16:37+0000 kods.net http://www.kods.net/what-is-a-real-dba/
DBA's main duties:

1: installation, upgrade ORACLE Server and application tools.

2: set up the system database to store and plan the future of storage systems.

3: design, planning and establishment of databases.

4: create a table space (TABLESPACE), monitoring and management of table space.

5: create database objects (tables, views, indexes), as well as their monitoring and management.

6: to change the structure of the database, application development is generally in accordance with the requirements of staff, sometimes under the system settings.

7: Monitoring and control of the user to connect to the database used to configure network connection.

8: create users and manage database security.

9: Database and SQL tuning of.

10: program and planning the database and how to restore the backup.

11: distributed database management, dynamic databases and back-up database replication.

12: Contact ORACLE obtain technical support.

As a real DBA, must have all of the above-mentioned knowledge and skills.

DBA should have the personality:

As a ORACLE DBA, database management in addition to solid technical skills, but also must have a unique personality. Work in the past, through the many contacts and understanding of the DBA, a DBA found personality, the impact of his work is great, on the one hand, a DBA must be the face of other people, such as providers, users, developers and a different boss, on the other hand, they are most important, most critical work is often a problem when the database at this time, they will have to withstand tremendous stress.

ORACLE DBA self-confidence is very important to always keep in mind, I do not know the answer to a question and do not know how to solve it, not the worst thing, and the worst thing is to not know how to find the answers and possible solutions to the problem method. Should have a strong curiosity in order to keep pace with the changing ORACLE, ORACLE I Just contact when ORACL6, and today is the ORACLE 9i, it is necessary to understand the changes every time. Tenacious, tenacity is equally important, is likely to sometimes second night 2 days can not be separated from your database. Smart witty, so that you keep the accumulation of work experience and problem-solving skills. To self-feeding, and motivated. As a ORACLE DBA, most of your spare time reading and ORACLE DBA related documents and reference books, as you want on this "pirate ship", it is necessary to do this mentally prepared in advance. Attention to detail, for each minor changes and problems have to be asked of why, and then leave no stone unturned to clear him.

How to become a real DBA:

To become a real DBA, two aspects of knowledge are indispensable, first,: very solid basic knowledge of databases, including the basic concepts and structures. To achieve this, the best way is to choose a really strong training company training, which is very abstract, ORACLE database and logic, and self-learning have a certain degree of difficulty. The second is experience - dealing with problems and solutions the ability to ask, it is necessary to achieve this, on the one hand, through long hours of work, was at work, it takes a long time, there is a better approach is experienced by the DBA really take in the real environment Chuan granted to you under this kind of work experience, which requires an experienced DBA, at the same time, there is a real application environment.

This article comes from CSDN blog, reprint, please indicate the source: http://blog.csdn.net/softj/archive/2005/10/04/494825.aspx
Related Posts
]]> http://www.kods.net/what-is-a-real-dba/ DBA more commonly used functions and SQL commands http://www.kods.net/dba-more-commonly-used-functions-and-sql-commands/ http://www.kods.net/dba-more-commonly-used-functions-and-sql-commands/#comments Thu, 18 Jun 2009 05:33:16+0000 kods.net http://www.kods.net/dba-more-commonly-used-functions-and-sql-commands/
To install and upgrade the database server (such as Oracle, Microsoft SQL server), and application tools.
Database design system storage and storage needs for the future plans.
Once the developer has designed an application, we need to create a DBA database storage structures (tablespaces).
Once the developer has designed an application, the DBA needs to create database objects (tables, views, indexes).
According to feedback from developers, when necessary, modify the structure of the database.
The user registration database, maintain database security.
Database to ensure that the use of intellectual property rights in line with relevant laws and regulations.
Control and monitor user access to access the database.
Monitor and optimize database performance.
The development of database backup plans when disaster recovery of database information on the maintenance of appropriate media archive or backup data backup and restore database system database contact the manufacturer to track technical information.

Best familiar with the Linux / Solaris operating system, Shell has a simple scripting ability

2. DBA personality characteristics:
Managers often ignore the fact that DBA's personality characteristics, they are only concerned about the technical capacity of DBA. In fact, the above-mentioned functions of each means: DBA needs to deal with a variety of personnel, these personnel may be vendors, users, developers or managers. This shows that: DBA must have the following personality characteristics:

1. Self-confidence 2. Curiosity 3. Tenacious willpower 4. Seasoned 5. Self-drive 6. Attention to detail

Why are these personality characteristics are important?

Almost all of the database systems are constantly updated. But not all have the technical documentation updates. DBA for the good, the curiosity is essential. There is no curiosity and thirst for knowledge of the DBA is always the answer and wait for someone to tell them. And a strong thirst for knowledge of the DBA will install the latest version of the database system, and immediately began to search for that even subtle features and performance differences and enhance, to improve their work. DBA often encounter difficult problem. The answer is the need to find a tenacious willpower, you can withstand the personality characteristics of tempering.

Self-drive for each person is very important, especially for the DBA. DBA should be able to find ways to make the problem, rather than waiting for problems. Needless to say, and the user, that is, and programmers and managers to deal with, but also you experienced enough. Very often, developers, managers, users, they will put forward the demand for no reason, DBA experienced guide need to amend their request, to persuade them. In the test, you can deal with it is that you experienced. Finally, talk about attention to detail, this tendency is very important character. Attention to the details of the DBA have clean clothing and have their own schedule, candidates in the examination of the unit before the survey. Attention to detail are the DBA database-depth understanding of the core, and can understand the view, the relationship between tables.

3.ORACLE the system:
As a good DBA, we should be able to skillfully master the ORACLE database management and operation. ORACLE divided into two blocks, one is the development of a management. Development is mainly writing stored procedures, triggers what, there is to use Oracle's Develop tools do form. Somewhat similar to those programmers, need to have strong logical thinking and creativity, personal feel that it would be more difficult; management is the need for oracle database have a deep understanding of the principle, and the ability to manipulate the overall situation and close thinking, greater responsibility, because a small error will be off down the entire database, which is relatively speaking, more attention to the experience of the latter.

3.1 Control of the physical structure of documents: includes the maintenance and integrity of the database to verify the necessary information.

Data files: data files.

Redo log files: the database containing records of the changes, so that failure of the event can enable data recovery. A database requires at least two redo log files.

Parameter files: the definition of the characteristics of Oracle routines, for example, it contains a number of SGA memory to adjust the size of the parameter structure.

Archiving documents: redo log files are offline copies of these copies may have failed from the media is essential in recovery.

Password file: Certification which users have permission to start and shut down Oracle routines.

Table 3.2 Logical Structure of Space: It is the basic logic of the database structure, a collection of a series of data files.

Paragraph: It is the object in the database space.

District: one-time set aside for the data of a large storage space.

Block: ORACLE basic storage unit, when in the establishment of the database specified.

3.3 Memory Allocation
SGA: is used to store database information memory area, the information sharing process for the database. Oracle server that contains data and control information, it is the presence in the Oracle server computer to the actual memory allocation, if the actual memory in virtual memory not enough to write further.

PGA: contains a single server process or a single background process data and control information sharing process with several PGA contrary SGA is used only by a process of regional, PGA allocation process in the creation of the termination of the recovery process

3.4 data write process of the background process: responsible for the change of the data from the database buffer cache to write data files.

Log write process: The redo log buffer to write the changes to online redo log files.

System Monitoring: Check the consistency of the database, if necessary, will be opened in the database to start the restoration of the database.

Process monitoring: the process responsible for a failure to clear Oracle resources.

Checkpoint process: responsible for the buffer cache when changes in the permanent record in the database, the update control files and data files in the database state information.

Archiving process: at each log switch when the log is full backup or archiving group.

Service process: the process of service users.

User process: the client is responsible for the user's SQL statement passed to the service process, and back from the server to query the data segment.

3.5 oracle routines:
oracle routines: Oracle routines by the SGA memory structure and the database used to manage the composition of the background process. Routines can only open and use a database.

3.6 SCN (System Change Number):
SCN (System Change Number): change its system, a system maintained by the serial number. When the system needs to be updated automatically when he is to maintain the system data consistency and an important symbol of the restoration of order.

4 DBA commonly used SQL command:
Table 4.1 Construction
create table table_name (
column1 datatype [not null] [not null primary key],
column2 datatype [not null],
...)

Modify Table 4.2
alter table table_name
add column column_name datatype

alter table table_name
add primary key (column_name)

alter table table_name
drop primary key (column_name)

4.3 build directory
create index index_name on table_name (column_name)

4.4 Delete information
delete from table_name
where conditions;

4.5 add information
insert into table_name (column1, column2 ,...)
values (value1, value2, ...)

insert into table_name (column1, column2 ,...)
select columnx, columny, ... from another_table

4.6 Inquiries
select column1, columns2, ...
from table_name

select *
from table_name
where column1 = xxx
[and column2> yyy] [or column3 <> zzz]

select column1, column2
from table_name
order by column2 [desc]

select *
from table1, table2
where table1.colum1 = table2.column1

select count (*)
from table_name
where column_name = xxx

select sum (column1)
from table_name

select column1, avg (column2)
from table_name
group by column1
having avg (column2)> xxx

select *
from table_name1
where exists (
select *
from table_name2
where conditions)

Table 4.7 update
update table_name
set column1 = 'xxx'
where conditoins;

Delete Table 4.8
drop table_name
drop index_name

5.dba treatment:

DBA Mody, depends on what city you are in Beijing. Experience in 1,2 years (6-8k) about 10k can be experienced, but no longer on the job only a few very small. Of course, wages will quite high. efforts ah! strive to improve their ah! for in the shortest possible time so that their wages raised to 10k. This is not a dream, only a later point of time, ah, do not pull that nonsense, or to study it! refueling together ah !!!

This article comes from CSDN blog, reprint, please indicate the source: http://blog.csdn.net/wyzxg/archive/2006/07/08/894076.aspx
Related Posts
]]> http://www.kods.net/dba-more-commonly-used-functions-and-sql-commands/ What is the database administrator [] http://www.kods.net/what-is-the-database-administrator/ http://www.kods.net/what-is-the-database-administrator/#comments Tue, 27 Jun 2006 08:44:55+0000 kods.net http://www.kods.net/what-is-the-database-administrator/ What is the database administrator rn

Database administrator, English is the Database Administrator, referred to as DBA. This post to different people means different meaning. A small software development studio and a division of a high degree of detail compared to large companies, DBA some of the responsibilities are much more broad. A company, whether it is developing its own application software, or purchase third-party applications, as long as related to the database (how many do not involve the application of the database software? Database is the soul of business and brain ah), it is necessary to determine whether hiring a or a few DBA. Know the position DBA What are the requirements for the definition of this position within the enterprise or for those DBA's future will be crucial.

rn

rn

Some DBA duties:

rn
Installing and upgrading the database server (such as Oracle, Microsoft SQL server), and application tools.
Database design, system storage programs and to develop future storage requirements planning.
Once the developer to design an application, you need DBA to create the database storage structures (tablespaces).
Once the developer to design an application, you need DBA to create the database objects (tables, views, indexes).
According to developer feedback, when necessary, modify the database structure.
Registration database of users, maintaining the database security.
Ensure that the database used in conformity with relevant laws and regulations of intellectual property rights.
Control and monitoring user access to the database access.
Monitor and optimize database performance.
Develop a database backup plan, disaster occurs on the database information to restore the appropriate medium to maintain an archive or backup data backup and restore database links database system manufacturers to track technical information.

rn
DBA's personality characteristics of

rn
Management personnel often ignore the DBA's personality characteristics, they are only concerned with the technical capacity of DBA. In fact, each of the above mentioned responsibilities mean: DBA needs to deal with a variety of personnel, these personnel may be vendors, users, developers or managers. This shows that: DBA must have the following personality characteristics:

rn
Confidence, curiosity, self-driven tough willpower sophisticated attention to detail

rn
Why are these personality characteristics are important?

rn
I had some lack of confidence in his subordinates, who repeatedly asked me some micromanager problems, they do not have confidence to do even the smallest decisions. They also lack of work initiative. This issue of junior DBA is probably not large, but for those senior DBA who, if they lack self-confidence and who they can rely on to help their decision? In the DBA interview, even if you can not answer a technical problem, you have to show enough self-confidence. The most deadly are not unaware of the answer, but do not know where to get an answer.

rn
Almost all of the database systems are continuously updated. But not all of the updates for technical documentation. For a good DBA, the curiosity is essential. Curiosity and thirst for knowledge of the DBA is not always wait for someone to tell them the answer. And a strong curiosity DBA will install the latest version of the database system, and immediately began to search for that even subtle differences in functionality and performance and enhanced, thus improving their work. Examination when an inevitable question asked is: What do you have references? How do you use them? There is no doubt that, if you answer only the database documentation, or you have not even read them, your "stock market" will be dropped significantly. DBA who will be driven by curiosity to understand the data dictionary (Data Dictionary), management tool (Tools), or other support packages (Packages).

rn
DBA often encounter difficult issues. The answer is tough to find a need for willpower, you can beat the personality to withstand. I am often in a number of discussion groups or forums to see the issue raised by DBA, which is often the questions themselves can be solved, if they have a tough personality and try to find the answer.

rn
Self-drive is very important for everyone, and especially to the DBA. DBA must be able to find ways to make a problem, rather than waiting for problems. Self-drive strong to the DBA is often necessary to obtain or to write their own scripts (Script) to monitor, including data table size (Table Size), the table space usage (Tablespace Usage) and other projects, which, if ignored, they will encounter Trouble . Examination when the DBA who is often asked about PL / SQL, SQL, or SQL * PLUS experience, these problems will never write you from the script before they need to distinguish those who DBA.

rn
Needless to say, and the user, that is, and programmers and managers to deal with, but also sophisticated enough to need you. The DBA will not be doing things a little would not do for you good in your department will ignite the fires of hostility. Is such a sophisticated capabilities, you advise someone to go to House, ha ha, this last desire of people with mood gone. In many cases, developers, managers, users, they will have no reason demand, DBA experienced guide who need to amend their request, to persuade them. In the examination, your response clearly explains you experienced.
Finally talk about attention to detail, this character is very important trend. Attention to detail of the DBA are clean clothes and have their own schedule, at the examination before the candidate's unit conducted a survey. DBA attention to detail are in-depth understanding of the database kernel, and can understand that view, the relationship between the tables.

rn
DBA level

rn
DBA level is not very strict. In accordance with the master database, I simply divided into three levels: primary Primary, Intermediate Intermediate and Advanced Senior.

rn
Junior DBA is also known as DBBS, is English Database Baby Sitter acronym. Junior DBA is often part-time, they are often the same time, a programmer, or the duties of other's work. Junior DBA tend to write a great resume, and databases involved in a number of related projects or work. However, these projects or the work tends to be: Third-party software vendors have already installed and configured the database, they confine itself to certain monitoring work. They can handle some simple problems, but most of the time they are to the application software vendor for help. Junior DBA prefer a graphical database management, or monitoring tools, they like Access desktop database such as easy to use, and to the experience of these small databases easily applied to large-scale database-related work.

rn
Junior DBA is the best distinction to make. Intermediate and senior DBA and the DBA is not very good distinction. Their difference is the different experiences and personality characteristics, ability differences. Intermediate DBA are more competent senior DBA that they can most of the work, including:

rn
Database administrative privileges to install the database configuration and setup and security management monitoring and performance tuning backup and restore to solve the problem in general

rn
Intermediate DBA is often a year or so practitioners are familiar with certain operating system environment database. Intermediate DBA is concerned because, Windows NT and Unix is a big difference. Intermediate DBA for SQL more familiar with their own databases to buy buy a few books, and in-depth study. Intermediate DBA often act as a database programmer at the same time, their work performance, stability, security, the pursuit is basically not very high, often in conjunction with Senior DBA to do some routine work.

rn
Senior DBA in the country is very small. They buy too many databases of information in English, may be asked a friend to buy from Amazon. Relative to their pay is concerned, there is little money to purchase books as a percentage. Senior DBA are generally familiar with many types of operating platforms of several large databases. They know a variety of different databases in different environments of the strengths and weaknesses, and can in the database platform and database environment the choice of decision-making. They are generally familiar with system architecture and database design, and can optimize the database at various levels. Senior DBA are generally equipped with assistants, they tend to make decisions and plans. Senior DBA is often in the banking, insurance, online trading on stability, security, performance, require higher processing areas of key business flourish.

rn
In many cases, whether the certificate to obtain a database of experts is not very important. I know that many database vendors as long as you went to the training will receive certificates. There are many companies that provide business-oriented training, the quality of service they have both good and bad. Therefore, the certificate is not a particular meaning.

rn
Several popular database system

rn
The most "easy"-Microsoft SQL Server database systems

rn
If you're going to do a DBA, I suggest you choose those who are now more popular database systems. This means that you will have more employment opportunities, exchanges and training opportunities, but also, popular reason to own the popular, you can worry so much. Of course, the job competition, the pressure is relatively large. The general entry chose Microsoft SQL Server, which is very suitable for small and medium enterprise database systems, readers are familiar with Access can easily be the initial use of Microsoft SQL Server, as a DBBS. J
Microsoft SQL Server 7.0 offers, five user version of 1399 U.S. dollars, increasing user, 127 U.S. dollars per user.

rn
The most "difficult" in the database - Oracle Wumianzhiwang

rn
If you have access to Oracle, That's a good opportunity. Oracle database is the most promising companies, because of its powerful and configurable, manageable capacity, Oracle DBA salaries in general than any other database administrators a higher salary. Moreover, Oracle's mission-critical applications in the medium and large enterprises are more common. Oracle can run on Windows NT, Sun Solaris, Linux and other platforms. In many cases require you to not only familiar with NT, but also you are familiar with Unix;, and Oracle is not a friendly interface and into the boxes of Oracle product information may also be an obstacle.
Oracle 8i Standard Edition of the offer, if running on Windows NT, with JServer and interMedia, support for 5 concurrent users, offer is 3925 U.S. dollars per CPU. Increase in concurrent users, 785 U.S. dollars per user. Increase in the naming of additional users, 392.5 U.S. dollars per user.

rn
Database system aristocratic-IBM UDB/DB2

rn
As a 30-year database, the results of research, IBM DB2 indeed be regarded as "noble database system." Whether small business systems, or of the banking system, with DB2 is allowed to rest easy. Recently launched a new version of DB2 6.1, management and regulation tools for greater excellence and ease of use. DB2 can be run on Intel architecture, you can also run on IBM's S/390 large-scale computer. If your machine industry IBM particular praise, I suggest you learn from IBM DB2.

rn
There are two versions of DB2: Workgroup Edition and Enterprise Edition. Workgroup Edition 999 U.S. dollars per server, plus 249 U.S. dollars per concurrent users. The Enterprise Edition is 12.5 thousand U.S. dollars per CPU, not limited to the number of concurrent users.

rn
Java-centric database-Sybase Adaptive Server Enterprise (ASE) 12.0

rn
The upcoming release of Sybase ASE 12.0, direct-to-Java programmers. This kind of Java-centric database system, for those prepared to Java platform for companies to build enterprise applications, will be the best choice. However, ASE can not be called a database, leader in the field, even though compared to its previous versions has been improved a lot, and supports multiple concurrent CPU and more, there are many new features. However, the landscape seems to have no longer Sybase.

rn
Is worth looking forward to Informix Centaur

rn
Sometimes the "first" only means that your opponents have to wait for a longer time to catch up with you. This is founded in 1997, faced by Informix. Informix is the first multimedia features will be added to the relational database system, a large database vendors. But now, IBM, Oracle, Sybase have already crossed this idea. Therefore, Informix had to seek new support to make themselves different from other database vendors. This is the Informix Centaur goal. Informix Centaur combines the Informix Dynamic Server 7.3 object - relational databases and Informix Universal Data Option 9.1, is intended to better adaptability and multimedia support. What are the details, we will wait and see!

rn
DBA salary

rn
There are many factors that affect your salary as a DBA:

rn
Your experience and ability determined by the DBA level database system you are familiar with your personality and potential of the
Related Posts
]]> http://www.kods.net/what-is-the-database-administrator/ Database Administrator DBA http://www.kods.net/database-administrator-dba/ http://www.kods.net/database-administrator-dba/#comments Sun, 15 May 2005 02:39:10+0000 kods.net http://www.kods.net/database-administrator-dba/ Database administrator DBA choose from zjcxc the Blog

Keywords: database administrator, DBA

What is a DBA database administrator DBA

Database administrator, English is the Database Administrator, referred to as DBA. This post to different people means different meaning. A small software development studio and a division of a high degree of detail compared to large companies, DBA some of the responsibilities are much more broad. A company, whether it is developing its own application software, or purchase third-party applications, as long as related to the database (how many do not involve the application of the database software? Database is the soul of business and brain ah), it is necessary to determine whether hiring a or a few DBA. Know the position DBA What are the requirements for the definition of this position within the enterprise or for those DBA's future will be crucial.

Some DBA duties:

Installing and upgrading the database server (such as Oracle, Microsoft SQL server), and application tools.
Database design, system storage programs and to develop future storage requirements planning.
Once the developer to design an application, you need DBA to create the database storage structures (tablespaces).
Once the developer to design an application, you need DBA to create the database objects (tables, views, indexes).
According to developer feedback, when necessary, modify the database structure.
Registration database of users, maintaining the database security.
Ensure that the database used in conformity with relevant laws and regulations of intellectual property rights.
Control and monitoring user access to the database access.
Monitor and optimize database performance.
Develop a database backup plan, disaster occurs on the database information to restore the appropriate medium to maintain an archive or backup data backup and restore database links database system manufacturers to track technical information.

DBA's personality characteristics of

Management personnel often ignore the DBA's personality characteristics, they are only concerned with the technical capacity of DBA. In fact, each of the above mentioned responsibilities mean: DBA needs to deal with a variety of personnel, these personnel may be vendors, users, developers or managers. This shows that: DBA must have the following personality characteristics:

Confidence, curiosity, self-driven tough willpower sophisticated attention to detail

Why are these personality characteristics are important?

I had some lack of confidence in his subordinates, who repeatedly asked me some micromanager problems, they do not have confidence to do even the smallest decisions. They also lack of work initiative. This issue of junior DBA is probably not large, but for those senior DBA who, if they lack self-confidence and who they can rely on to help their decision? In the DBA interview, even if you can not answer a technical problem, you have to show enough self-confidence. The most deadly are not unaware of the answer, but do not know where to get an answer.

Almost all of the database systems are continuously updated. But not all of the updates for technical documentation. For a good DBA, the curiosity is essential. Curiosity and thirst for knowledge of the DBA is not always wait for someone to tell them the answer. And a strong curiosity DBA will install the latest version of the database system, and immediately began to search for that even subtle differences in functionality and performance and enhanced, thus improving their work. Examination when an inevitable question asked is: What do you have references? How do you use them? There is no doubt that, if you answer only the database documentation, or you have not even read them, your "stock market" will be dropped significantly. DBA who will be driven by curiosity to understand the data dictionary (Data Dictionary), management tool (Tools), or other support packages (Packages).

DBA often encounter difficult issues. The answer is tough to find a need for willpower, you can beat the personality to withstand. I am often in a number of discussion groups or forums to see the issue raised by DBA, which is often the questions themselves can be solved, if they have a tough personality and try to find the answer.

Self-drive is very important for everyone, and especially to the DBA. DBA must be able to find ways to make a problem, rather than waiting for problems. Self-drive strong to the DBA is often necessary to obtain or to write their own scripts (Script) to monitor, including data table size (Table Size), the table space usage (Tablespace Usage) and other projects, which, if ignored, they will encounter Trouble . Examination when the DBA who is often asked about PL / SQL, SQL, or SQL * PLUS experience, these problems will never write you from the script before they need to distinguish those who DBA.

Needless to say, and the user, that is, and programmers and managers to deal with, but also sophisticated enough to need you. The DBA will not be doing things a little would not do for you good in your department will ignite the fires of hostility. Is such a sophisticated capabilities, you advise someone to go to House, ha ha, this last desire of people with mood gone. In many cases, developers, managers, users, they will have no reason demand, DBA experienced guide who need to amend their request, to persuade them. In the examination, your response clearly explains you experienced.
Finally talk about attention to detail, this character is very important trend. Attention to detail of the DBA are clean clothes and have their own schedule, at the examination before the candidate's unit conducted a survey. DBA attention to detail are in-depth understanding of the database kernel, and can understand that view, the relationship between the tables.

DBA level

DBA level is not very strict. In accordance with the master database, I simply divided into three levels: primary Primary, Intermediate Intermediate and Advanced Senior.

Junior DBA is also known as DBBS, is English Database Baby Sitter acronym. Junior DBA is often part-time, they are often the same time, a programmer, or the duties of other's work. Junior DBA tend to write a great resume, and databases involved in a number of related projects or work. However, these projects or the work tends to be: Third-party software vendors have already installed and configured the database, they confine itself to certain monitoring work. They can handle some simple problems, but most of the time they are to the application software vendor for help. Junior DBA prefer a graphical database management, or monitoring tools, they like Access desktop database such as easy to use, and to the experience of these small databases easily applied to large-scale database-related work.

Junior DBA is the best distinction to make. Intermediate and senior DBA and the DBA is not very good distinction. Their difference is the different experiences and personality characteristics, ability differences. Intermediate DBA are more competent senior DBA that they can most of the work, including:

Database administrative privileges to install the database configuration and setup and security management monitoring and performance tuning backup and restore to solve the problem in general

Intermediate DBA is often a year or so practitioners are familiar with certain operating system environment database. Intermediate DBA is concerned because, Windows NT and Unix is a big difference. Intermediate DBA for SQL more familiar with their own databases to buy buy a few books, and in-depth study. Intermediate DBA often act as a database programmer at the same time, their work performance, stability, security, the pursuit is basically not very high, often in conjunction with Senior DBA to do some routine work.

Senior DBA in the country is very small. They buy too many databases of information in English, may be asked a friend to buy from Amazon. Relative to their pay is concerned, there is little money to purchase books as a percentage. Senior DBA are generally familiar with many types of operating platforms of several large databases. They know a variety of different databases in different environments of the strengths and weaknesses, and can in the database platform and database environment the choice of decision-making. They are generally familiar with system architecture and database design, and can optimize the database at various levels. Senior DBA are generally equipped with assistants, they tend to make decisions and plans. Senior DBA is often in the banking, insurance, online trading on stability, security, performance, require higher processing areas of key business flourish.

In many cases, whether the certificate to obtain a database of experts is not very important. I know that many database vendors as long as you went to the training will receive certificates. There are many companies that provide business-oriented training, the quality of service they have both good and bad. Therefore, the certificate is not a particular meaning.

Several popular database system

The most "easy"-Microsoft SQL Server database systems

If you're going to do a DBA, I suggest you choose those who are now more popular database systems. This means that you will have more employment opportunities, exchanges and training opportunities, but also, popular reason to own the popular, you can worry so much. Of course, the job competition, the pressure is relatively large. The general entry chose Microsoft SQL Server, which is very suitable for small and medium enterprise database systems, readers are familiar with Access can easily be the initial use of Microsoft SQL Server, as a DBBS. J
Microsoft SQL Server 7.0 offers, five user version of 1399 U.S. dollars, increasing user, 127 U.S. dollars per user.

The most "difficult" in the database - Oracle Wumianzhiwang

If you have access to Oracle, That's a good opportunity. Oracle database is the most promising companies, because of its powerful and configurable, manageable capacity, Oracle DBA salaries in general than any other database administrators a higher salary. Moreover, Oracle's mission-critical applications in the medium and large enterprises are more common. Oracle can run on Windows NT, Sun Solaris, Linux and other platforms. In many cases require you to not only familiar with NT, but also you are familiar with Unix;, and Oracle is not a friendly interface and into the boxes of Oracle product information may also be an obstacle.
Oracle 8i Standard Edition of the offer, if running on Windows NT, with JServer and interMedia, support for 5 concurrent users, offer is 3925 U.S. dollars per CPU. Increase in concurrent users, 785 U.S. dollars per user. Increase in the naming of additional users, 392.5 U.S. dollars per user.

Database system aristocratic-IBM UDB/DB2

As a 30-year database, the results of research, IBM DB2 indeed be regarded as "noble database system." Whether small business systems, or of the banking system, with DB2 is allowed to rest easy. Recently launched a new version of DB2 6.1, management and regulation tools for greater excellence and ease of use. DB2 can be run on Intel architecture, you can also run on IBM's S/390 large-scale computer. If your machine industry IBM particular praise, I suggest you learn from IBM DB2.

There are two versions of DB2: Workgroup Edition and Enterprise Edition. Workgroup Edition 999 U.S. dollars per server, plus 249 U.S. dollars per concurrent users. The Enterprise Edition is 12.5 thousand U.S. dollars per CPU, not limited to the number of concurrent users.

Java-centric database-Sybase Adaptive Server Enterprise (ASE) 12.0

The upcoming release of Sybase ASE 12.0, direct-to-Java programmers. This kind of Java-centric database system, for those prepared to Java platform for companies to build enterprise applications, will be the best choice. However, ASE can not be called a database, leader in the field, even though compared to its previous versions has been improved a lot, and supports multiple concurrent CPU and more, there are many new features. However, the landscape seems to have no longer Sybase.

Is worth looking forward to Informix Centaur

Sometimes the "first" only means that your opponents have to wait for a longer time to catch up with you. This is founded in 1997, faced by Informix. Informix is the first multimedia features will be added to the relational database system, a large database vendors. But now, IBM, Oracle, Sybase have already crossed this idea. Therefore, Informix had to seek new support to make themselves different from other database vendors. This is the Informix Centaur goal. Informix Centaur combines the Informix Dynamic Server 7.3 object - relational databases and Informix Universal Data Option 9.1, is intended to better adaptability and multimedia support. What are the details, we will wait and see!

DBA salary

There are many factors that affect your salary as a DBA:

Your experience and ability determined by the DBA level database system you are familiar with your personality and potential of the

Author Blog: http://blog.csdn.net/zjcxc/
Related Posts
]]> http://www.kods.net/database-administrator-dba/