1 / 29

CIS 764 Database Systems Design

CIS 764 Database Systems Design. L15. Jobs … and jobs related to 764 general trends report of jobs homework relationship to 764. CIS 764 Database Systems Design.

eitan
Download Presentation

CIS 764 Database Systems Design

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. CIS 764 Database Systems Design L15. Jobs … and jobs related to 764 general trends report of jobs homework relationship to 764 http://www.cis.ksu.edu

  2. CIS 764 Database Systems Design diagrams from Computing Research News May 2004 Comp. Research Association http://www.cis.ksu.edu

  3. CIS 764 Database Systems Design http://www.cis.ksu.edu

  4. CIS 764 Database Systems Design http://www.cis.ksu.edu

  5. CIS 764 Database Systems Design http://www.cis.ksu.edu

  6. CIS 764 Database Systems Design http://www.cis.ksu.edu

  7. CIS 764 Database Systems Design http://www.cis.ksu.edu

  8. CIS 764 Database Systems Design http://www.cnn.com/2006/US/Careers/01/26/cb.top.jobs.pay/index.html From Bureau of Labor Statistics 1. Computer systems software engineer --------------- $81,140 2. Computer applications software engineer --------- $76,310 3. Biomedical engineer --------------------------------------- $70,520 4. Physician assistant ----------------------------------------- $69,250 5. Environmental engineer --------------------------------- $67,620 6. Computer systems analyst ----------------------------- $67,520 7. Database administrator ----------------------------------- $61,950 8. Physical therapist ------------------------------------------ $61,560 9. Network systems / data communication analyst -- $61,250 10. Hydrologist --------------------------------------------------- $60,880 http://www.cis.ksu.edu

  9. CIS 764 Database Systems Design Brainbench, Global Skills Report, 2006 industry’s largest ISO 9001-2000 library of job skills tests. 600 tests for skills certifications http://www.cis.ksu.edu

  10. CIS 764 Database Systems Design Rank 2006 Rank 2005% Change 1 U.S. 1 - 18% 2 India 2 + 47% 3 Russian 3 - 21% 4 Ukraine 5 + 14% 5 Romania 4 - 18% 6 UK 7 - 7% 7 Canada 6 - 27% 8 Belarus 11 + 49% 9 Philippines 9 - 4% 10 Bulgaria 8 - 30% http://www.cis.ksu.edu

  11. CIS 764 Database Systems Design Kinds of skills tests: C# Software testing C++ .net framework tech support asp.net RDBMS concepts Project management Java Linux administration http://www.cis.ksu.edu

  12. CIS 764 Database Systems Design • DB related skills: • sql fundamentals • DB2 programming • Not related to 764 . http://www.cis.ksu.edu

  13. CIS 764 Database Systems Design • U.S. skill base in decline: • Drop in enrollments • (and drop in female enrollments: • 1985 .. 50% , 2006 .. 5% ) • Retirements • Cut in foreign visa H-1B visas • http://en.wikipedia.org/wiki/H-1B_visa • but (?) many job ads are “fake”: • http://blog.oregonlive.com/atwork/2007/06/h1b_visa_video_prompts_more_im.html • “Our goal is clearly not to find a qualified and interested U.S. worker.” http://www.cis.ksu.edu

  14. CIS 764 Database Systems Design What kinds of jobs go off-shore / out-sourcing? http://www.cis.ksu.edu

  15. CIS 764 Database Systems Design Your jobs reviews: 12 done at week 7 12 done at week 8 2 no read permission Following report ignored the following: no specified required experience no job title no specified technology (e.g. J2ee , dotNet, sql, ..) not DB related (e.g. just “software development”) http://www.cis.ksu.edu

  16. CIS 764 Database Systems Design Titles: Evangelist 0 Architect 0 Architect / developer 3 MS .. MS + 10 Software Engineer 7 BS .. BS + 10 ($ 72K) DBA 7 BS .. BS + 10 ($ 90K) Developer 13 BS .. BS + 8 $ 63K – 100K Other ( business admin, lead, consultant, sys. engr) Modifiers: Senior, Lead, TechnologyX - http://www.cis.ksu.edu

  17. CIS 764 Database Systems Design Arch/ developer: BI, OLAP ; dotNet, visualization Ora: J2EE, WS+Axis, RDBMS Sr: J2EE, DB http://www.cis.ksu.edu

  18. CIS 764 Database Systems Design Software Engr: * web+modeling: * design+implementation (3) * “be involved … “ http://www.cis.ksu.edu

  19. CIS 764 Database Systems Design DBA: * reporting * support & modeling * full life cycle * analysis, design, implementation * support, design, tuning * design, development http://www.cis.ksu.edu

  20. CIS 764 Database Systems Design Developer: * design, implementation, tuning * full cycle (5) * reports & management * specify & model (2) * web http://www.cis.ksu.edu

  21. CIS 764 Database Systems Design Concept Technologies: modeling 4+ web, RDBMS, tuning, recovery 3 each BI, DW 2 each others: visualization, OLAP, WS, CRM http://www.cis.ksu.edu

  22. CIS 764 Database Systems Design Technologies: Frameworks: J2EE 11 dotNet 7 Spring 3 Ruby 2 DB: Oracle 11 sqlServer 7 mySQL, Postgres, DB2 http://www.cis.ksu.edu

  23. CIS 764 Database Systems Design Technologies: languages: pl/sql 3 sql 3 javascript 2 C#, C+, Perl, Java http://www.cis.ksu.edu

  24. CIS 764 Database Systems Design Technologies: unix 3 , linux Hibernate Flash JSP, JSF, Ajax , Axis , ADF , Ora Forms Tomcat, WebSphere JDeveloper, Eclipse http://www.cis.ksu.edu

  25. CIS 764 Database Systems Design Question: Is 764 a DB Design course? Why / how? Not ? http://www.cis.ksu.edu

  26. CIS 764 Database Systems Design Question: Is 764 a DB Design course? Object-relational mapping: puts the “DB” design at the “object-design” level puts queries at the object-query level (or EJB-query) Good software engineering: puts analysis and design at the object (UML) level (not ER level, not table level) http://www.cis.ksu.edu

  27. CIS 764 Database Systems Design Question: Is 764 a DB Design course? Missing: tuning, … http://www.cis.ksu.edu

  28. CIS 764 Database Systems Design Relation of ~ DB courses: app-DB-SE (764) --------- DB theory (761) | \ | \ web (726) DM (864) (?? Tuning, DBA support, very large DBs ) http://www.cis.ksu.edu

  29. CIS 764 Database Systems Design Blessings …. in the content of 764 in the breadth of the student presentations end. http://www.cis.ksu.edu

More Related