本文发表在 rolia.net 枫下论坛BY CAREER CRUISING
Database Developer
NOC Code: 2172
1.Job Description
With the advent of the computer age, most paper-based filing systems have been replaced by sophisticated, powerful, globally accessible databases. Today, a single computer database can replace a room full of filing cabinets.
Databases can store all kinds of information. For example, a library database can hold contact information on every library member, details of books in stock and when they抮e due for return. A database is a more efficient filing system than a paper-based system and it makes it more difficult to lose a file. Databases are designed, installed, updated, maintained and repaired by database developers.
There are two main types of databases. The most basic type of database is a flat-file where all the information is stored together in a single table. Flat-files are easy to create, but they have their limitations. Relational databases are more powerful but also more complicated to configure.
When creating a new database, developers will go through several stages before even turning on a computer. First, the developer sits down with the client (a person or company he or she is developing the database for) and finds out the purpose of the database, who will use it, and what information needs to be stored and retrieved.
Then the developer works out how the database will fit together and suggests a format that will meet the client抯 needs, for example, a basic flat-file or a relational database. If the client agrees to the suggestions, the developer codes the database, calculates the amount of memory needed, tests and corrects errors, and imports the data that will be stored in the database. If the client requests any changes, the developer will have to incorporate them.
Developers often work as part of a team. Members of the team may specialize in different areas. For example, database architects usually work directly with the clients. Programmers work on the coding and technical aspects of the database.
2.Working Conditions
Database developers work inside offices in front of computers. They may work alone but are often part of a project team. Travelling to meet with clients may be required.
The job is not physically demanding, but database developers may suffer from back and neck strain from spending long hours at the computer. Taking regular breaks and doing stretching exercises can help prevent this.
Database developers usually work full-time and have a regular five-day, 40-hour week. However, overtime may be required to meet deadlines and finish projects.
3.Earnings
Database developers can work on staff for any organization, such as a retail store, government agency, university or financial institution, which requires databases as part of its operation. Others may work on a freelance contract basis, going from project to project.
Entry-level programming positions pay from $30,000 to $45,000 a year. Database developers with several years of experience can earn $45,000 to $100,000 a year. Project managers can earn over $100,000 a year.
4.Education
Education & Training
A bachelor's degree in computer programming, systems engineering or a related area is usually required to enter this field.
However, some database developers receive their training at community colleges or private training schools. A master's degree is helpful for advancement.
Related College & University Programs
Database Development and Administration
Computer Programming
Computer Systems Analysis
Systems Science and Engineering
Computer Science
Computer Engineering
Software Engineering
Other Suggested Qualifications
You should have a logical mind, but also have creative ability. As technology develops and clients demand more powerful databases, the developer抯 job also becomes more complex.
Related Subjects
Math
English
Computers
Design
Architecture
Statistics
Computer science
5.Career Path
LEVEL 1 Programmer
EARNINGS $30,000 to $45,000 a year
REQUIREMENTS ?Undergraduate degree or diploma in computer science
RESPONSIBILITIES Developing code that will support an application.
LEVEL 2 Database Developer (Programmer/Analyst/Architect)
EARNINGS $45,000 to $100,000 a year
REQUIREMENTS ?Two years of experience as a programmer
?Data modeling courses (for database architects)
RESPONSIBILITIES Developing code; writing specifications for code development; designing and building systems; ensuring the database remains reliable over time; performing administrative duties.
LEVEL 3 Project Manager
EARNINGS $50,000 to $120,000 a year
REQUIREMENTS ?Knowledge of lifecycle in programming
?Time tracking skills
RESPONSIBILITIES Managing all aspects of a project; keeping everything on time and within budget.
6.Related Jobs
Business Systems Analyst
Computer Engineer
Computer Network Specialist
Computer Programmer
Computer Support Person
Data Entry Clerk
GIS Specialist
Project Manager
Technical Sales Representative
Web Developer
Webmaster
7.Resources
Software Human Resource Council
http://www.shrc.ca
DiscoverIT.org: Software Career Discovery Centre
http://www.discoverit.org
DB2 Magazine
http://www.db2mag.com
Association for Computing Machinery
http://www.acm.org
Institute for Certification of Computer Professionals
http://www.iccp.org
Microsoft certification program information
http://www.microsoft.com/trainingandservices/default.asp
Association for Women in Computing
http://www.awc-hq.org
Virtual Computer Library ?Links to Computer Magazines
http://www.utexas.edu/computer/vcl/journals.html
Job Futures:
Computer Systems Analysts
http://jobfutures.ca/noc/2162.shtml更多精彩文章及讨论，请光临枫下论坛 rolia.net
Database Developer
NOC Code: 2172
1.Job Description
With the advent of the computer age, most paper-based filing systems have been replaced by sophisticated, powerful, globally accessible databases. Today, a single computer database can replace a room full of filing cabinets.
Databases can store all kinds of information. For example, a library database can hold contact information on every library member, details of books in stock and when they抮e due for return. A database is a more efficient filing system than a paper-based system and it makes it more difficult to lose a file. Databases are designed, installed, updated, maintained and repaired by database developers.
There are two main types of databases. The most basic type of database is a flat-file where all the information is stored together in a single table. Flat-files are easy to create, but they have their limitations. Relational databases are more powerful but also more complicated to configure.
When creating a new database, developers will go through several stages before even turning on a computer. First, the developer sits down with the client (a person or company he or she is developing the database for) and finds out the purpose of the database, who will use it, and what information needs to be stored and retrieved.
Then the developer works out how the database will fit together and suggests a format that will meet the client抯 needs, for example, a basic flat-file or a relational database. If the client agrees to the suggestions, the developer codes the database, calculates the amount of memory needed, tests and corrects errors, and imports the data that will be stored in the database. If the client requests any changes, the developer will have to incorporate them.
Developers often work as part of a team. Members of the team may specialize in different areas. For example, database architects usually work directly with the clients. Programmers work on the coding and technical aspects of the database.
2.Working Conditions
Database developers work inside offices in front of computers. They may work alone but are often part of a project team. Travelling to meet with clients may be required.
The job is not physically demanding, but database developers may suffer from back and neck strain from spending long hours at the computer. Taking regular breaks and doing stretching exercises can help prevent this.
Database developers usually work full-time and have a regular five-day, 40-hour week. However, overtime may be required to meet deadlines and finish projects.
3.Earnings
Database developers can work on staff for any organization, such as a retail store, government agency, university or financial institution, which requires databases as part of its operation. Others may work on a freelance contract basis, going from project to project.
Entry-level programming positions pay from $30,000 to $45,000 a year. Database developers with several years of experience can earn $45,000 to $100,000 a year. Project managers can earn over $100,000 a year.
4.Education
Education & Training
A bachelor's degree in computer programming, systems engineering or a related area is usually required to enter this field.
However, some database developers receive their training at community colleges or private training schools. A master's degree is helpful for advancement.
Related College & University Programs
Database Development and Administration
Computer Programming
Computer Systems Analysis
Systems Science and Engineering
Computer Science
Computer Engineering
Software Engineering
Other Suggested Qualifications
You should have a logical mind, but also have creative ability. As technology develops and clients demand more powerful databases, the developer抯 job also becomes more complex.
Related Subjects
Math
English
Computers
Design
Architecture
Statistics
Computer science
5.Career Path
LEVEL 1 Programmer
EARNINGS $30,000 to $45,000 a year
REQUIREMENTS ?Undergraduate degree or diploma in computer science
RESPONSIBILITIES Developing code that will support an application.
LEVEL 2 Database Developer (Programmer/Analyst/Architect)
EARNINGS $45,000 to $100,000 a year
REQUIREMENTS ?Two years of experience as a programmer
?Data modeling courses (for database architects)
RESPONSIBILITIES Developing code; writing specifications for code development; designing and building systems; ensuring the database remains reliable over time; performing administrative duties.
LEVEL 3 Project Manager
EARNINGS $50,000 to $120,000 a year
REQUIREMENTS ?Knowledge of lifecycle in programming
?Time tracking skills
RESPONSIBILITIES Managing all aspects of a project; keeping everything on time and within budget.
6.Related Jobs
Business Systems Analyst
Computer Engineer
Computer Network Specialist
Computer Programmer
Computer Support Person
Data Entry Clerk
GIS Specialist
Project Manager
Technical Sales Representative
Web Developer
Webmaster
7.Resources
Software Human Resource Council
http://www.shrc.ca
DiscoverIT.org: Software Career Discovery Centre
http://www.discoverit.org
DB2 Magazine
http://www.db2mag.com
Association for Computing Machinery
http://www.acm.org
Institute for Certification of Computer Professionals
http://www.iccp.org
Microsoft certification program information
http://www.microsoft.com/trainingandservices/default.asp
Association for Women in Computing
http://www.awc-hq.org
Virtual Computer Library ?Links to Computer Magazines
http://www.utexas.edu/computer/vcl/journals.html
Job Futures:
Computer Systems Analysts
http://jobfutures.ca/noc/2162.shtml更多精彩文章及讨论，请光临枫下论坛 rolia.net