DBA 2 0 Is Dead Long Live DBA

DBA 2. 0 Is Dead. Long Live DBA 3. 0! Jim Czuprynski Zero Defect Computing, Inc.

My Credentials • 35+ years of database-centric IT experience • Oracle DBA since 2001 • Oracle 9 i, 10 g, 11 g, 12 c OCP • Oracle ACE Director • 100+ articles on databasejournal. com and IOUG SELECT • Co-author of 2+ Oracle books (new book: Fall 2017) • Oracle-centric blog (Generally, It Depends) • Regular speaker at Oracle Open. World, IOUG COLLABORATE, Hotsos Symposium, and Regional OUGs

Our Agenda: Five Key Trends for 2017 ØCloud: Caveat Nuba Emptor ØPredictive Analytics: So If You See My Downeaster, Alexa ØSecurity: 2017 - Year of the Levee (Lest Darkness Fall) ØData vs. Belief: Will Booleanists Trump Post-Truthiness?

#1: Oracle Cloud Is Here. Get Used To It. Oracle Cloud has definitely arrived and will likely become a consummate player in the Cloud Oracle Cloud implementations grew by 82% in FY 2016 marketspace • • Cloud is part of an inevitable, unstoppable shift from CAPEX to OPEX This time around, business units - not IT - are driving the change Who holds the PKI keys to securing your data kingdom? Don’t neglect the cost of paying for data upload vs. paying only on download Oracle came to the Cloud late … but never forget: “What counts is getting there best, not getting there first. ”

Know Your Cloud Provider (Or It Might Just Know You) Some missing logos: Credit:

Future of DBAs : Fury Road, or Tomorrowland? Does Cloud Imply Dystopia? • Agile development means business units will pick the best database for the job • DBAs will no longer be necessary – pick your DB, click a few times, and voila! A new Dev. Ops environment! … or Utopia? • At last, DBAs will be free to do what we’re supposed to be doing: helping to build better applications and systems • Application code is not getting any better (more on this later)

#2: Big Data, Io. T, and Analytics Big Data, the Internet of Things (Io. T), and Analytics have arrived for real … and human civilization is already impacted tremendously Some amazing statistics to consider: • Big Data: 4. 4 Zetta. Bytes in 2013, 44 Zetta. Bytes by 2020 • Io. T: 25 billion devices in 2015, 50 billion by 2020 • Analytics: Data is useless without interpretation and context • External tables for JSON (12. 1) and HIVE (12. 2) • CREATE ANALYTIC VIEW in 12. 2 for fast DW/DSS schema creation • If you’ve got the robotics, you’ve got the venture capital! • 1970 s: Machinery automation • 1990 s: Factory automation • 2010 s: Human automation (AI / Robotics)

“Alexa Ordered Me a Dollhouse. ” Artificial Intelligence (AI) is showing promise at long last … • 1997: IBM Deep Blue defeats Garry Kasparov • 2011: IBM Watson wins $1 M on Jeopardy! • 2016: Google AI beats Go master Lee Sedol … but practical AI is still in its infancy, so like any infant - there will be teething pain. News anchor sets off Alexa devices around San Diego ordering unwanted dollhouses - CW 6 San Diego, January 5, 2017 [D]uring CW 6 in the morning … Jim Patton and Lynda Martin were talking about a child who accidentally bought a dollhouse and four pounds of cookies. “I love the little girl, saying ‘Alexa ordered me a dollhouse, ’” said Patton. As soon as Patton said that, viewers all over San Diego started complaining their [Amazon Echo] devices had tried to order doll houses.

#3: Security: Finally At the Forefront Application and Database Security has at last come to the fore … and perhaps just in time 2016 was the Year of the Breach. . . • Ransomware attacks on the rise, especially against health care providers • Even Cloud computing providers were hacked (Sage in U. K. ) • DDOS attacks spawned from Io. T devices (baby monitors!? !) … so 2017 must become the Year of the Levee • Security must become a forethought instead of an afterthought • Bring Your Own Device (BYOD) is both wonderful … and frightening! • Almost every successful breach results from a lack of imagination • Io. T devices must be made secure before our home’s intelligent smoke detectors that can talk to our home’s intelligent windows

No More Into the Breach! Application and Database Security has at last come to the fore … and perhaps just in time DBAs have always been at the forefront of data security • Provide honest risk assessment of not securing data • “Software in silicon” makes securing data intra-CPU simpler than ever • Exadata handles decryption of data within storage cells, thus improving query performance dramatically Why not just encrypt everything. . . then make it public? • With Oracle 12 c. R 2 there’s no need to take tablespaces offline to encrypt data anymore! • Improved redaction policies and deployment • Application Containers in Multitenant

#4: Data Has Replaced “Gut Instinct” Like it or not, “Well, that’s just common sense!” is finally being replaced by “Please show Predictive Analytics are already social change in real time medriving your data. ” • • Air Travel: Predicting flight delays due to maintenance via real-time Io. T data Transportation: Uber’s surge pricing strategies Education: Ensuring college students nearing crisis points don’t drop out Gaming: Casinos monitor EMGs to offer incentives to exhausted gamblers

The Signal and the Noise Nothing is so firmly believed as what we least know. - Montaigne Recent data trends with profound impact: • Brookings Institution: 472 counties (15%) that voted Democratic in 2016 presidential election were responsible for 64% of US GDP • NASA: 2014 – 2016 climate science data shows hottest years on record • EPI: American manufacturing output is at near-record high, but employing onethird fewer workers than in 1984 Are we in a “post-truth” era? • 2009 vs. 2017 presidential inauguration attendance • Debate on accuracy of unemployment rates • Flat-Earther rapper B. o. B vs. astrophysicist Neil de. Grasse Tyson

#5: Outsourcing, Shifting to Insourcing These … but estimates relatively are recent anecdotal databased has shown on personal there are observation, horrific skills interviews, gaps among and discussions resourceswith from+2000 some. Oracle of the DBA moststudents popular between offshoring 2005 -2015 destinations. . Database Complexity vs. Candidate Sufficiency < 18% of Engineers Employable for Software Engineering Jobs - 2016 Engineers National Employability Report, Aspiring Minds 12 c Suitability ratings (employability) for various IT jobs: • Software Engineer – IT Services: 17. 91% 11 g • Startup Ready – IT Services: 3. 84% • Software Engineer – IT Product: 10 g 3. 67% 8 i 9 i < 25% of Graduates Have Adequate Verbal English Skills - 2016 National Spoken English Skills (SES) Report, Aspiring Minds Of the 600, 000 engineers that graduate annually, only 2. 9% of candidates have spoken English skills (SES) for high-end jobs in corporate sales / business consulting. Around of the engineers not have SES 1999 2001 2003 … 2005 200775% 2009 2011 2013 do 2015 2017 required for any job in knowledge economy. Complexity Sufficiency

Mounting Pressure Against H-1 B Visa Abuse The political and social backlash against outsourcing high-technology jobs in recent years may indicate a trend towards insourcing instead. Pink Slips at Disney. But First, Training Foreign Replacements. - New York Times, June 3, 2015 Laid-Off Americans, Required to Zip Lips on Way Out, Grow Bolder “I just couldn’t believe they could fly people in to sit at our desks and take - Infosys, New Times, June 11, Proposal 2016 worker, Tata Hit by U. S. to Restrict Skilledin. Visas over our. York jobs exactly, ” said one former an American his 40 s who American corporations are 6, under new scrutiny from federal lawmakers after - Bloomberg, January 2017 remains unemployed since his last day at Disney on Jan. 30. “It was so Indian Technology Workers Worry About a Job Threat: Technology well-publicized episodes in the companies laid off workers humiliating to is train somebody else to over your job. I American still can’treplace grasp it. ” [HR 170] … designed to which address atake loophole that lets employers U. S. NYT, June 25, 2017 and gave the to foreigners on temporary visas. … American workers withjobs skilled foreign workers on temporary H-1 B visas. While thewho Pune, - Last month, Sudhakar Choudari took the company bus … to the lost jobs rules to. India global outsourcing companies haveprogram been largely silent. current require heavy users of the H-1 B to attest that. Until U. S. workers suburban offices of the Tech Mahindra. … Then a manager took him a Congress IT worker who trained H-1 B-holding replacement aims for recently. Now some by of workers whounless were displaced are starting tointo won’t be displaced H-1 B workers, the H-1 B workers have aspeak master’s conference room and asked himprohibiting to resign. “It was a terrible scenetheir for me, ” said Mr. out, despite severance agreements criticizing NYT, May 2017 degree or are being 19, paid at least $60, 000, them newlyfrom proposed bill would raise the Choudari, 41, who had been with the company for 11 years and most recently former employers. Craig Diangelo was anand IT worker at the Northeast Utilities Connecticut until he salary threshold to $100, 000, eliminate master’s degreeinexception. maintained software for his a British client. … “I have an 11 -year-old-child. Myabout wife 200 completed training H-1 B-visa-holding replacement. He was one of is notwho working. How to in pay 2014 the home loans? ” lost their jobs after two India-based IT offshore outsourcing firms took over their work at what is now called Eversource. … Now, Diangelo is running for Congress. offering up a first-hand perspective on IT outsourcing that resonates with many other workers in his state.

Summary: Disrupt, or Be Disrupted. ØOracle Cloud: Let’s get there best, not first. ØBig Data + Io. T + Analytics: Here, & doing humanity good. ØSecurity: Must be forethought rather than afterthought. ØData vs. Gut Instinct: Trust your data,

Thank You For Your Kind Attention! If you have any technical questions, feel free to: ØE-mail me at jczuprynski@zerodefectcomputing. com ØFollow my blog (Generally, It Depends): http: //jimczuprynski. wordpress. com ØFollow me on Twitter (@Jim. The. Why. Guy) @Jim. The. Why. Guy ØConnect with me on Linked. In: https: //www. linkedin. com/in/jczuprynski