1, database application development (application development)
Besides the basic knowledge of SQL, you should be familiar with the development process, software engineering, various frameworks and development tools.
Database application development has the most opportunities and work in this direction.
2.datamodeler。
Besides the basic knowledge of SQL, I am very familiar with the principle of database. Data modeling is responsible for transforming users' demand for data into physical design and physical design of database. This direction has special positions in large companies (finance, insurance, research, software developers, etc.). ), it may also be undertaken by programmers in small and medium-sized companies.
3. Business-Business Intelligence
In order to obtain useful information from data mainly from the perspective of business applications and end users, which involves OLAP (on-line analytical processing), it is necessary to use reporting tools, such as SSRS, cognos, crystalreport or other software tools for data mining and statistics.
4, ETL development (ETLDeveloper)
Use ETL tools or write your own programs to import, export and transform data between different data sources. Generally, the databases you contact are very large, and the required data conversion is complicated, which is closely related to data warehouse and business intelligence. Some companies with large-scale database applications have special posts, and small and medium-sized companies may have programmers or DBA in charge of this work.
5. Data Architect
Mainly from the overall situation, the general direction of the database is formulated and controlled at the logical level, including long-term strategies such as data availability and expansibility, and the application development, modeling and DBA work of the database are coordinated. This direction has special positions in large companies (finance, insurance, research, software development, etc.). ), but small and medium-sized companies do not have this position, or developers and DBA are responsible.
6, database administrator (database-DBA)
Database installation, configuration, optimization, backup/recovery, monitoring, automation, etc. , auxiliary application development (some positions also require optimizing SQL, writing stored procedures and functions, etc. ). There are relatively few positions in this direction, but companies with a certain scale will still have such positions.
7, data warehouse expert (datawarehouse-DW)
Dealing with super-large-scale data, the storage, management and use of historical data are closely related to business intelligence. BI and DW are often placed in a big category, but I think DW pays more attention to the management and optimization of hardware and physical layer.
8. Storage Engineer
Responsible for providing data storage solutions, using various storage technologies to meet data access and storage needs, and has a close working relationship with DBA. Companies with strict requirements for high availability (such as communications, finance, data centers, etc.). ) there are usually such positions, and such positions are rare.
9. Performance Engineer Optimization Engineer
Specializing in database performance debugging and optimization, providing users with solutions to performance bottlenecks. There are also specialized performance optimization engineers who are responsible for providing technical support for their database products and key applications. Companies with strict requirements on database performance (such as the financial industry) may have such positions. Because it is highly targeted and even requires familiarity with various databases, there are few positions.
10, seniorDBA
On the basis of DBA, it also involves part of the work of the above three positions, including the following contents: familiar with the data of application system (layout, access mode, growth mode, storage requirements, etc. ). Very familiar with performance optimization, you can find and optimize bottlenecks from SQL to hardware I/O, network and other aspects. Relatively familiar with storage technology, it may replace part of the work of storage engineers, and very familiar with highly available technologies of databases (such as MSSQL cluster, ORACLERAC/FailSafe, IBM DPF, HADR, etc. ), and effectively expand large databases physically (such as table partition) or logically (such as database partition and union). Familiar with various data replication technologies, such as one-way, two-way and point-to-point replication technologies, to meet the application requirements. Establishment, testing and execution of disaster data recovery process. This position is generally only needed in very large-scale companies (such as finance, telecommunications, data centers, etc.) with very high requirements for databases. ), and such companies generally have an independent department or group responsible for the database. Such positions are rare.