Job title systems database administrator
Download
1 / 14

Information Retrieval - PowerPoint PPT Presentation


  • 314 Views
  • Updated On :

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Information Retrieval' - mike_john


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Job title systems database administrator l.jpg

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 l.jpg
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


Systems database administrator description of work l.jpg
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


Systems database administrator working conditions l.jpg
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


Systems database administrator career paths l.jpg

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/


Systems database administrator background experience examples l.jpg
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/


Systems database administrator background experience examples7 l.jpg
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/


Systems database administrator courses at slis l.jpg
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.”


Systems database administrator academic professional resources journals l.jpg
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


Systems database administrator professional organizations l.jpg
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.


Systems database administrator job outlook l.jpg
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).


Systems database administrator job outlook12 l.jpg
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


Systems database administrator helpful websites l.jpg
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


Job title systems database administrator14 l.jpg

Job Title: Systems Database Administrator

Information Retrieval

Thank You

L501: Fall 2004

Fawn Blackwell

Penny Dillon

Kathy Gerdink

Liying Lin

Robin White


ad