290 likes | 428 Views
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.
E N D
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
CIS 764 Database Systems Design diagrams from Computing Research News May 2004 Comp. Research Association http://www.cis.ksu.edu
CIS 764 Database Systems Design http://www.cis.ksu.edu
CIS 764 Database Systems Design http://www.cis.ksu.edu
CIS 764 Database Systems Design http://www.cis.ksu.edu
CIS 764 Database Systems Design http://www.cis.ksu.edu
CIS 764 Database Systems Design http://www.cis.ksu.edu
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
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
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
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
CIS 764 Database Systems Design • DB related skills: • sql fundamentals • DB2 programming • Not related to 764 . http://www.cis.ksu.edu
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
CIS 764 Database Systems Design What kinds of jobs go off-shore / out-sourcing? http://www.cis.ksu.edu
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
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
CIS 764 Database Systems Design Arch/ developer: BI, OLAP ; dotNet, visualization Ora: J2EE, WS+Axis, RDBMS Sr: J2EE, DB http://www.cis.ksu.edu
CIS 764 Database Systems Design Software Engr: * web+modeling: * design+implementation (3) * “be involved … “ http://www.cis.ksu.edu
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
CIS 764 Database Systems Design Developer: * design, implementation, tuning * full cycle (5) * reports & management * specify & model (2) * web http://www.cis.ksu.edu
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
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
CIS 764 Database Systems Design Technologies: languages: pl/sql 3 sql 3 javascript 2 C#, C+, Perl, Java http://www.cis.ksu.edu
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
CIS 764 Database Systems Design Question: Is 764 a DB Design course? Why / how? Not ? http://www.cis.ksu.edu
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
CIS 764 Database Systems Design Question: Is 764 a DB Design course? Missing: tuning, … http://www.cis.ksu.edu
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
CIS 764 Database Systems Design Blessings …. in the content of 764 in the breadth of the student presentations end. http://www.cis.ksu.edu