1 / 14

Information Retrieval

Job Title: Systems Database Administrator. Information Retrieval. L501: Fall 2004 Fawn Blackwell Penny Dillon Kathy Gerdink Liying Lin Robin White. Systems Database Administrator: Job Description.

mike_john
Download Presentation

Information Retrieval

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Job Title:Systems Database Administrator Information Retrieval L501: Fall 2004 Fawn Blackwell Penny Dillon Kathy Gerdink Liying Lin Robin White

  2. Systems Database Administrator: Job Description • Works with database management systems software and determines ways to organize, store, and extract data. • Identifies user requirements, sets up computer databases, and tests and coordinates modifications to the systems. • Ensures the performance of the system, understands the platform on which the database runs, and adds new users to the system. • Responsible for data integrity, backup systems, and database security. Beaureau of Labor Statistics (2004) “Coordinate changes to computer databases, test and implement the database applying knowledge of database management systems. May plan, coordinate, and implement security measures to safeguard computer databases.” http://www.careerplanner.com/Job-Descriptions/Database-Administrators.cfm

  3. Systems Database Administrator: Description of Work Updates Databases Intranet Maintenance Procedures Collaborative DB Design/Development Anticipate Change (Technology) Facilitates Data Access Recovery Plans User Needs Assessments Website Work w/ Programmers & Web Designers DB Security Company Liaison Archiving http://www.prospects.ac.uk/cms/ShowPage/Home_page/Explore_types_of_jobs/Types_of_Job/p!eipaL?idno=410&state=showocc

  4. Systems Database Administrator: Working Conditions • Offices or laboratories - often “corporate casual” • Usually work about 40 hours a week. (subject to company,etc) • Evening or weekend work to meet deadlines/solve problems - Telecommuting option • Long periods in front of a computer terminal - eyestrain, carpal tunnel syndrome or cumulative trauma disorder. • Team Meetings & Planning Meetings http://www.bls.gov/oco/ocos042.htm

  5. DB Programmer Webmaster Systems Database Administrator: Career Paths Career Preparation • Education: computer science (database theory & data modeling) and projects on current database software packages. • Consider: programming jobs that will reinforce database skills. • Internships. • Internet and intranetstraining- HTML, XML and TCP/IP etc. • Professional certifications - Oracle OCP & Microsoft MCDBA. Chief Information Officer / CIO Information Technology Director Information Systems Manager Systems Administrator Database Analyst http://www.dbajobs.com/

  6. Systems Database Administrator: Background/Experience(EXAMPLES) Programmer (entry) • Assoc. Degree in computer science • 2-4 years related experience • Strong verbal & written skills. • Communication skills - internal and external customers & suppliers. Database Analyst (entry) • Experience with Database Vendors (problem resolution). • DBMS installation, definition & storage • Monitoring & performance of DB • File structure- Relational, Object, Hierarchical. • Basic Database Skills & Administration. • Database Security, Backup & Recovery. Real programmers code in binary. http://www.dbajobs.com/

  7. Systems Database Administrator: Background/Experience(EXAMPLES) Database Programmer (mid) • Good problem solving skills • 2 - 5 years of experience • Java, SQL, Sybase, Perl Information Technology Director (exec/mgt) • Master’s degree in MIS or related field or equivalent • 10 years experience in IT management • Windows XP/2000 or NT Servers, UNIX, SQL, Visual Basic, WAN, LAN, Citrix, Lotus Notes • Application experience: DB Systems, office applications, development software, project management software, database and contact management software http://www.dbajobs.com/

  8. Systems Database Administrator: Courses at SLIS L545 Systems Analysis and Design L546 User-centered Database Design L548 Computer Programming for Information Mgmt. L571 Information Architecture for the Web L574 Communication in Electronic Environments L577 Design of Information Systems L578 User Interface Design for Information Systems L579 Information Visualization L641 Information Storage and Retrieval Theory L643 Evaluation of Information Systems L546--User-centered Database Design (3 cr.) “Concerned with a comprehensive view of the processes involved in developing formal access to information from a user-centered point of view. Considers various database models such as flat file, hierarchical, relational, and hypertext in terms of text, sound, numeric, image, and geographic data. Students will design and implement databases using several commercial database management systems.”

  9. Systems Database Administrator: Academic/Professional Resources-Journals • Annual Review of Information Science & Technology (ARIST) www.asis.org/Publications/ARIST/index.php • The Journal of the ACM (JACM) www.acm.org/jacm/ • InformationWeek www.informationweek.com • Journal of Database Management http://www.irma-international.org/ • Journal of Global Information Technology Management www.uncg.edu/bae/people/palvia/jgitm.htm

  10. Systems Database Administrator: Professional Organizations Association for Computing Machinery (ACM) www.acm.org Founded in 1947, ACM is an international scientific & educational organization dedicated to advancing the arts, sciences, and applications of information technology with over 75,000 members worldwide. Inc.: ACM Digital Library, Guide to Computing Literature (bibliographic citations), access to 450 Web-based IT Training courses & 395 online IT books, the Special Interest Group on Information Retrieval covers all aspects of information storage, retrieval, and dissemination. Assoc. of Information Technology Professionals (AITP) www.aitp.org The Association of Information Technology Professionals (AITP) offers opportunities for Information Technology (IT) leadership and education through partnerships with industry, government and academia. AITP provides quality IT related education, information on relevant IT issues and forums for networking with experienced peers and other IT professionals for nearly 9,000 members.

  11. Systems Database Administrator:Job Outlook • 68%~80% projected increase through 2012: computer systems design and related services, management of companies and enterprises, insurance carriers, Federal government, data processing, hosting & related services. • 90%~101% projected increase employment through 2012: internet service providers and web search, software publishers and employment services. Bureau of Labor Statistics, U.S. Department of Labor, Occupational Outlook Handbook, 2004-05 Edition, Computer Systems Analysts, Database, on the Internet at http://www.bls.gov/oco/ocos042.htm (visited November 18, 2004).

  12. Systems Database Administrator:Job Outlook Compensation (average starting salaries) • Median annual (2002): $55,480 • Lowest 10 percent (2002): < $30,750 • Middle 50 percent (2002): $40,550 - $75,100 • Highest 10 percent (2002): $92,910 Bureau of Labor Statistics, U.S. Department of Labor, Occupational Outlook Handbook, 2004-05 Edition, Computer Systems Analysts, Database, on the Internet at http://www.bls.gov/oco/ocos042.htm (visited November 18, 2004). $ $ http://content.salary.monster.com/ 2003 Avg. Salaries Database Administrators: $69,750 - $101,750 Robert Half International

  13. Systems Database Administrator:Helpful Websites • Center for Intelligent Information Retrieval http://ciir.cs.umass.edu/ • Association for Computing Machinery http://www.acm.org/ • I-Seek.com http://www.iseek.org/sv/13000.jsp?id=100057 • SearchDatabase.comhttp://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci782710,00.html • Developers.net http://www.developers.net/solution_content

  14. Job Title: Systems Database Administrator Information Retrieval Thank You L501: Fall 2004 Fawn Blackwell Penny Dillon Kathy Gerdink Liying Lin Robin White

More Related