Database Design
Database Administration- Career Overview
On a day-to-day basis, database administrators work with database management software and are responsible for devising methods to organize, analyze, and present data. The first step is to evaluate end-user needs and then design, develop, and implement computer databases which will capture the needed information. It is often the case that database administrators are required to integrate data from old systems into the recently developed system. When needed, they may also test and modify database systems and provide troubleshooting for any problems that may arise. Database administrators ensure that the computer system meets performance expectations, understands the platform on which the system operates, and adds new users to the system.
Because many databases are connected to the Internet, database administrators must also coordinate "cyber-security" measures with network administrators. On occasion database administrators may become involved with Database Design but this function is usually the province of database designers or database analysts.
Database administrators work in comfortable office environments and usually work a 40 hour work week. However, according to the US Bureau of Labor Statistics (BLS), about 14 percent of database administrators worked more than 50 hours per week in 2008, including evenings and weekends. In addition, some database administrators may be on-call outside of regular work hours in order to help resolve computer issues.
There is no single way to prepare for a career as a Database Administrator, although a bachelor's degree in usually required. Some employers prefer candidates with graduate level study in a business-related discipline (e.g. MBA) with a specialization in Information Systems. MBS programs with a concentration in Information systems generally take two years of study beyond the bachelor's degree and include courses in finance, marketing, accounting, management, e-commerce, and systems design.
Lower-level positions may accept a 2 year degree in computer-related field offered by many community colleges and technical schools. Many of these programs are geared toward the needs of local, smaller employers that have less complex computer needs. These programs are more vocationally oriented that four year degree and graduate study.
Certification provides evidence of competence in the field. Many employers consider the possession of certifications as a standard entry requirement. You can obtain certification within a specific field of database management, such as Oracle Database Administration or Microsoft Certified Database Administrator.
Database administrators must be able to logical thinkers with the ability to work well with teams as much of the work is performed in conjunction with network administrators, programmers. The must also possess strong communication ability in order to educate end users with no computer background.
Database administrators may advance into managerial positions, such as Senior Database Administrator, Manager of Information Systems (MIS), up to Chief Technology Officer (CTO).
What follows is a list or work responsibilities that are specific to this career:
Confer with end-users to determine needs. Create and develop guidelines for software usage.
Monitor database performance
Train users on the system
Develop database protocols using flowcharts.
Write technical descriptions and user guides
Coordinate the maintenance of databases with network administrators
Coordinate the process for updating and improving database systems.
Work as part of the database development team. This is especially important when developing databases as there will be frequent interaction with network administrators.
By Lisa Ann Burke -
Information Technology Degree?
I'm interested in taking one of this degress and they offer the following Certs. I'm interested in knowing which are the best in terms of career life, career prospects, and/or salary.
Information Technology?Networks Administration
?CIW Web Foundations Associate
?CIW JavaScript Specialist
?CompTIA A+
?CompTIA Networks+
?CompTIA Project+
?CompTIA Security+
?Microsoft Certified Technology Specialist (MCTS): Windows 7 ? Configuration
?Microsoft Certified IT Professional (MCITP): Server Administrator
?Cisco Certified Entry Network Technician (CCENT)
Information Technology
?CIW Web Foundations Associate
?CIW Web Design Specialist
?CIW JavaScript Specialist
?CIW Database Design Specialist
?CompTIA A+
?CompTIA Networks+
?CompTIA Project+
?CompTIA Security+
?Microsoft Certified Technology Specialist (MCTS): Windows 7 - Configuration
Information Technology ? Databases
?CIW Web Foundations Associate
?CIW Web Design Specialist
?CIW JavaScript Specialist
?CIW Database Design Specialist
?CompTIA A+
?CompTIA Project+
?CompTIA Security+
?Microsoft Certified Technology Specialist (MCTS): Windows 7 ? Configuration
?Microsoft Certified IT Professional (MCITP): Database Developer (2008)
Information Technology?Networks Design & Management
?CIW Web Foundations Associate
?CIW JavaScript Specialist
?CompTIA A+
?CompTIA Networks+
?CompTIA Project+
?CompTIA Security+
?Microsoft Certified Technology Specialist (MCTS): Windows 7 ? Configuration
?Microsoft Certified IT Professional (MCITP): Enterprise Administrator
Information Technology- Software
?CIW Web Design Specialist
?CIW JavaScript Specialist
?CIW Database Design Specialist
?CIW Perl Specialist
?CIW Web Development Professional
?CompTIA A+
?CompTIA Project+
?CompTIA Security+
?Microsoft Certified Technology Specialist (MCTS): Windows 7 ? Configuration
?Oracle Certified Professional Java SE 6 Programmer
Get the answers...
Is the boss planning to eventually replace me?
My boss gave me a assignment to program an android device. Not knowing anything about android programming I could never finish the job as I am still learning. I only know visual basic properly and all visual basic projects have been done successfully on time. Its just that I know only visual basic properly and no other language really..
He gave me another assignment for web designing. I did it but the website looks standard. Now he is looking for a freelancer for web design to make it beautiful. I asked if I could call some company for web designing but he said he wanted a freelance programmer.
Now he gave me another assignment for gprs tracking. He says that a programmer will come and do the programming for gprs tracking of the vehicle in our company.
I am the only programmer in the small company since the last 5 years and I have managed all workloads in visual basic so far. Now I have come to know form the administrator not the boss that he is planning to keep one more programmer for visual basic. I don't really see the workload for visual basic programming increasing to need another programmer but the boss says that it is to help me out.
I don't see any heavy increase in workload that I cannot do so why is he planning to keep another programmer ? This will be the first time in the history of the company that there are two programmers for such a small company. Yes I must admit my skills are limited to just visual basic and database design and nothing else. That is the root of the problem.
I don't believe whats happening. Is it to eventually replace me ? I just cant see the workload increasing so much that two programmers are needed.
A similar thing happened with one accountant. He could do only some work so the boss brought another experienced accountant to help him and after two months said how he could pay for two accountants so the older accountant left.
Can anyone from the HR department advise me ?
Get the answers...
Database Design Introduction
Next page: Design Your Own T Shirt
Bookmark/Share This Page:
|
|
|
|
Database Design News
Reducing Server Power Consumption - Data Center Knowledge
 Data Center Knowledge | Reducing Server Power Consumption Data Center Knowledge Clemens Pfeiffer is the CTO of Power Assure and is a 25-year veteran of the software industry, where he has held leadership roles in process modeling and automation, software architecture and database design, and data center management and optimization ... |
Eldon FBLA members place at state - Lakenewsonline.com
Eldon FBLA members place at state Lakenewsonline.com ... Healthcare Administration; Morgan Varner, Ms. FB; Zach Shreve, Accounting 1; Sarah Hees, Database Design and Applications; and Gillian Brundin, Economics. Presented in the opening session of the conference were the Business Achievement Awards. |
Tuning an IBM DB2 for z/OS Application: I/O Constraints - Database Journal
Tuning an IBM DB2 for z/OS Application: I/O Constraints Database Journal In this case, we can take advantage of the availability of CPU cycles by two database design concepts called partitioning and parallelism. Partitioning is the splitting of a table into multiple physical files. The most common variation is called ... |
