- 相关推荐
Database Administrator Resume
数据库管理员（Database Administrator，简称DBA），是从事管理和维护数据库管理系统(DBMS)的相关工作人员的统称，属于运维工程师的一个分支，主要负责业务数据库从设计、测试到部署交付的全生命周期管理。以下是小编整理的Database Administrator Resume，希望能够帮助到大家。
Database Administrator Resume
A database administrator resume (like almost anyone working in a highly technical field) will use a different format than a standard business resume.
Areas that are likely to remain similar include;
An introductory profile,
A keyword summary,
A reverse chronological listing of employment and
Education.
Browsing through free sample resumes and sample databaseadministrator resumes will help give you a feel for the common threadsbetween these and a more standard resume.
Whats different for technical fields?Information that will be different for those in technical positions includes the information listed up front, which can include all:
Hardware,
Software,
Programming capabilities,
Any specific consulting work,
Larger projects.
How this information is presented can vary greatly - remember, youare trying to place the most emphasis on your most relevant experienceand skills. Review the free sample database administrator resumesgiven below to get an idea of the various ways in which to best presenttechnical information.
As with all resumes, the most important information should be listed near the top.A recent college graduate will be more likely to list education first,while a seasoned professional will likely list education last.
Hints and tipsWhile the standard rules of "what not to do" apply to all resumes,such as avoiding spelling and grammatical errors, writing in the thirdperson, or creating an objective solely based on the applicantswishes, some areas of concern do exist for those in technical fields.
First of all, your expertise needs to be obvious from the beginning. There is no point in burying your computer skills at the end of the resume when you are applying for a position in the computer science industry.
This does not mean, that you should bombard the reader with a bunch of technical jargonthat will only make sense to the most experienced computer technician.You never know who will be reading your resume, whether it is a personfrom human resources, a senior management person in programming, or acomputer searching for keywords. Make sure you explain your coreskills using the most appropriate language - a good idea is to use thejob advertisement to guide you...
The idea is to present your information in such a manner that you include as many keywords as possible (many books exist on this topic and provide comprehensive lists too large for this venue) while making sure a person who is not familiar with your field can get a general idea of what you are capable of .
If you have a high level of technical experience, you may wantto consider creating two resumes: one for human resources, and one forprofessionals in your industry.
Main responsibilities
Narrowly defined
In general, a database administrator is a person responsible for managing and maintaining a database server. A database administrator is responsible for comprehensive management and control of the database system, including basic tasks such as database installation, monitoring, backup, and recovery. The main responsibilities of a database administrator include the following:
Design database design, including fields, tables, and key fields; How resources are used on auxiliary storage devices, how to add and files and records, and how to discover and remedy losses.
2. Monitor the warning logs of the monitoring database and regularly backup and them. Monitor the daily session status of the database. Fragment and remaining tablespace monitoring, timely understanding of tablespace expansion and remaining space distribution. Monitor the modification of objects. Regularly list all changing objects for installing and upgrading database servers (such as Oracle MicrosoftSQLserver）， And application tools. Design a storage plan for the database system and develop a plan for future storage requirements. Develop a database backup plan to recover database information in the event of a disaster. Maintain archive or backup data on appropriate media. Backup and restore databases. Contact the manufacturer of the database system and track technical information.
3. Backup is crucial for monitoring and managing database backup. The backup strategy for the database should be changed according to actual requirements, and the daily backup of data should be monitored.
4. Password modification: Standardize the management of database users and regularly modify the passwords of important users such as administrators. For each project, a user should be established. DBA should communicate with the corresponding project management personnel or programmers to determine how to establish the corresponding database underlying model, and finally have the DBA manage, establish, and maintain it uniformly. Any changes to database objects should be handled by the DBA according to the requirements.
5. SQL statement: A requirement for the writing standards of SQL statements. If an SQL statement is not written well, it can have a significant impact on the database. So, every programmer or corresponding staff member should strictly follow the "SQL Writing Standards" when writing corresponding SQL statements, and finally have a DBA check before they can officially run.
6. End user service and coordination: The database administrator specifies user access permissions and allocates resources to different user groups. If different users are in conflict with each other, database administrators should be able to coordinate users to optimize scheduling.
7. Database security: Database administrators can set different access permissions for different database management system users to protect the database from unauthorized access and damage. For example, allowing one type of user to only retrieve data, while another type of user may have the authority to data and records.
Generalized
However, in a broad sense, the responsibilities of a DBA are much greater, covering the entire lifecycle of a product from requirement design, testing, to delivery and deployment. During this process, not only are they responsible for building and maintaining a database management system, but they also need to participate in the early stage of database design, mid-term database testing, and later stage database capacity management and performance optimization.
For startups, DBA work may be undertaken by operations engineers, from applying for domain names to server deployment, configuring network devices, deploying operating systems, installing databases, designing and deploying monitoring, preventing vulnerabilities and attacks, and so on. However, large companies have increasingly high requirements for DBA work, and the responsibilities of DBA work can be seen from various dimensions.
Product lifecycle dimensions
DBA is responsible for the full lifecycle management of business databases from design, testing, to deployment and delivery. The responsibilities of each stage include:
1. Before product release
At this stage, the responsibility of a DBA is database access, mainly including:
1) Familiar with the business of the product;
2) Product database design review: including the evaluation of the rationality of the architecture, whether the storage capacity and performance meet the requirements, whether caching is needed, whether redundant backup is needed, etc. At the same time, it is necessary to provide reasonable suggestions for the database schema design to ensure that the product can meet the basic requirements for online release and stable operation;
3) Resource assessment, including required server resources, network resources, and resource distribution, while ensuring the rationality of product resource budget applications and controlling service costs;
4) Resources in place, prepare the applied server and basic environment/domain name in place.
2. Product release
At this stage, the DBA is responsible for the specific work of database publishing, installing, deploying, and initializing the specific database, and providing services to the public. Upgrading an online database also falls within the scope of release. At this time, product releases generally need to ensure online release and complete database upgrades without interrupting external services. For large and complex changes, there is also a situation where the service is suspended and re provided after the release is completed, but this situation requires DBAs to avoid it through technical means as much as possible.
3. Product operation and maintenance
The focus of this stage of work includes:
1) Monitoring: Real time monitoring of the running status of database services, including database sessions, database logs, data file fragments, tablespace monitoring, user access monitoring, etc., to detect abnormal operation and resource consumption of database services at any time; Output important daily database service operation reports to evaluate the overall operation status of database services and identify database risks;
2) Backup: Develop and implement a database backup plan, recover database information in the event of a disaster, and maintain archive or backup data on appropriate media. The backup strategy for the database should be changed according to actual requirements, and the daily backup of data should be monitored.
3) Security audit: Specify different access permissions for different database management system users to protect the database from unauthorized access and damage. For example, allowing one type of user to only retrieve data, while another type of user may have the authority to data and records.
4) Fault handling: Promptly handle any abnormalities that occur in the database service, and try to avoid the escalation or even termination of the service as much as possible. Prior to this, DBAs needed to develop contingency plans for various service anomalies, such as computer room/network failures, program bugs, etc. When problems occurred, they could automatically or manually execute the contingency plans to achieve the goal of stopping losses.
5) Capacity management: including resource assessment, expansion, data center migration, traffic scheduling, and other planning and specific implementation after the expansion of database scale.
4. Database performance optimization
The most important aspect of providing external services for a product is the user experience, where the availability and response speed of the product are crucial. And how to support products with the most reasonable resources to provide high availability and high-speed user experience is also an important responsibility of DBA.
【Database Administrator Resume】相关文章：