Database Administrator:

1. Database Administrator: An Investigation MaryAnne Sommer, Michael Praskavich, Stacy Konkiel and Amy Anderson

2. Why else would you want to be a Database Developer or Administrator? Because you: • Are a creative problem-solver. • Like puzzles. • Enjoy teamwork. • Communicate good. • Have a strong math/CS background.

3. How do you get ready? • You can’t. • Just kidding! Yes, you can! • College • Associate’s Degree • Bachelor’s Degree • Master’s Degree • Certification • Internships

4. What do Database Developers/Administrators Do? • Fix things. • Talk to computers. • Keep track of information stored on computers. • Remote database administration.

5. The Environmental Aspects of a Database • The database administrator is a person who is responsible for the environmental aspects of a database. • In general, the environmental aspects include: • Recoverability • Integrity • Availability • Security • Performance • Development and Testing Support

6. What's the work like? What is the development cycle? • Gather User Requirements • Storyboard Design • Build Database • Modify Database • Maintain Database

7. THE BOTTOM LINE. • How many jobs are there? • How much does it pay? • What are my chances of getting a job?

8. What about the future? • Growth--Though Not Necessarily Rapid • “Cyber Security” • Trade Literature to Keep Up With : • Journal of the American Society for Information Science and Technology (JASIST) • Network Computing • EContent • Information Today • Searcher • PC World

9. Professional Organizations The Institute for Certification of Computing Professionals (ICCP) – renews and updates necessary certifications Business Forms Management Association- Updates documents and database forms Help Desk Institute- Focuses on HCI and effective communication Computer Technology Industry Association- all the latest developments and future trends Institute of Configuration Management- the latest in database design The Metadata Professionals Organization (MPO)- networking with colleagues and peers The Data Management Association (DAMA International)- colleagues, peers, and data The Information Technology Association of America (ITAA)- information about the field and a connection to the academic research concerning it

10. Sample Entry Level Job • Job Title: Database Administrator • Location: Cincinnati, OH • Pay: $45,000 - $55,000 • Description: Provide primary and backup support to existing SYBASE and SQL Server databases. Provide 7 x 24 on-call support on a rotating basis for SYBASE and SQL Server databases. Provide proactive performance monitoring of databases ensuring service levels are met. Administrate change control of physical data structure for all environments. • Skills: SYBASE, SQL Server, UDB Oracle. -

11. Sample Job #2 • Database Administrator • Job Details Date SubmittedMonday, November 20, 2006Job TypeTechnical/Customer Service PositionsOrganizationRutgers, The State University of New Jersey (Public)Carnegie ClassDR EXT - Doctoral/Research Universities-ExtensiveState/ProvinceNew Jersey (Northeastern U.S.) For More Info http://uhr.rutgers.edu/jobpostings/aps/APSMain.asp Job Description Reporting to the Manager of the Data Management Team, provides technical leadership to staff and clients in the planning and implementation of projects requiring significant database expertise. Is responsible for the performance, configuration, and design of the database environment supporting ESS ERP (Oracle Financials) and decision support environments. Directs the analysis of software and determines the optimum configuration for interfaces between hardware, database management systems and application systems.

12. Sample Job #2 • Controls modifications or enhancements to systems software to ensure minimum impact on production systems under development. Recommends and enforces standards relating to use of system software. Responsible for the evaluation of systems and making recommendations for improvements to management.  Requires a bachelor's degree, preferably in Computer Science or Information Systems, or an equivalent combination of education and experience with a minimum of three years of progressive experience in a database administrative environment with emphasis on Oracle database management systems, specifically in an Oracle Financials (ERP) environment with experience as an APPS-DBA. Thorough knowledge of Data Warehouse design principles and relevant experience is also required. Certifications as an Oracle DBA (OCP) and/or IMS DBA is preferred. Reference Position#: 06-001350Applicants must apply online at: http://uhr.rutgers.edu/jobpostings/aps/APSMain.asp

13. References • http://en.wikipedia.org/wiki/Database_administrator • All text is available under the terms of the GNU Free Documentation License. (See Copyrights for details.) Wikipedia® is a registered trademark of the Wikimedia Foundation, Inc. • http://en.wikipedia.org/wiki/Remote_Database_Administration All text is available under the terms of the GNU Free Documentation License. (See Copyrights for details.) Wikipedia® is a registered trademark of the Wikimedia Foundation, Inc. This page was last modified 03:12, 30 June 2006.

14. References • http://www.nwcet.org/programs/cyberCareers/students/itcareercenter/dbadmin/ NWCET is a division of Bellevue Community College, and is partially funded by National Science Foundation grants. • http://www.bls.gov/k12/computers01.htm • http://www.tbmecdc.uh.edu/Download.esp • http://www.educause.edu/Browsejobs?1224? ID=12995

15. Any Questions? We Are Group One: MaryAnne Sommer,Michael Praskavich,Stacy Konkiel and Amy Anderson