Database Administration and Big Data Predictive Analytics

Database Administration and Big Data Predictive Analytics

The Database Administration and Big Data Predictive Analytics diploma program will prepare and enable students to manage, maintain big data — large, complex, and unstructured data — and better realize and unlock its value. As the Internet, mobile technology, and user habits and demands continue to evolve, resulting in the mass accumulation of data, more businesses are increasingly accepting and using this data in all forms and sizes as part of their critical decision-making processes. As such, students will learn tools and techniques to organize, analyze, capture, curate, search, share, store, transfer, visualize, query, and update big data, to meet this and other growing demands for the effective use of big data.

Program duration: 60 weeks
Class Schedule: Mon - Fri

Program Notes

Program fees include student manuals and all other course materials. Financial assistance may be available to those who qualify.

Graduation requirements: In order to obtain a diploma, students must obtain an overall average of 75% or better, with no final course mark below 60%.

Career Opportunities

Careers in database administration and big data predictive analytics are increasingly growing. They include, but are not limited to:

• Systems Administrator
• Database Administrator
• Information Resource Analyst
• Data Warehouse Analyst
• SAP HANA Consultant/Analyst
• Business Intelligence Consultant/Analyst
• BO/ETL Consultant/Analyst

These and similar career paths can be realized through the employment with businesses and organizations in a variety of industries, not limited to just the IT industry.

Duties & Responsibilities

In this area, duties and responsibilities may include, but are not limited to the following:

• Day-to-day support of Oracle and SQL databases
• Implementation and modeling with in-memory databases such as SAP HANA or Hadoop
• Build, configure, and administer production and development databases
• Provide technical assistance to development and production application teams
• Provide on-call support for critical applications
• Evaluate, implement, and maintain new projects and solutions
• Investigate and troubleshoot critical technical problems;
• Ensure timely and appropriate generation, collection, dissemination, and storage of project information
• Design, develop, and maintain large and complex universes of data per reporting and dashboard requirements in BOBJ 4x
• Build complex reports using web intelligence
• Develop and maintain OLAP Universes based on SAP NetWeaver BI Infocubes/BEx Queries, and Relational Universes based on Oracle/SQL Server
• Extensively utilize BI Web Services, BICS connections, and Query Design features to implement comprehensive dashboard solutions using Dashboards 4x
• Use SAP BI 4x product suite (BI Launch Pad, Information Design Tool, BICS connection, Multi source connection, SBO Analysis, Dashboards, Design Studio, etc.) in designing complex reporting for management
• Performance-tune running reports and universes
• Build queries using SAP BEx Query Designer
• Build complex analysis and container components for SAP Design Studio
• Deploying on mobile devices (ex: iPhone, iPad, etc.)

Admissions Requirements

• Grade 12 or equivalent or Mature Student status. Courses are open to any applicant who possesses a good command of the English language and is able to follow instructions.
• An admissions interview will be administered to determine if the applicant has the required interest, motivation, and entry-level skills to take this program.
• Students must attend the required hours and times per week per the course schedule.

Required Skills and Personal Attributes

• Strong technical background in computing and data work
• Excellent analytical and technical problem solving skills
• Excellent English communication skills (written and oral)
• Good knowledge of database architectures
• Collaborative team player with a positive self-motivated can-do attitude
• Self-motivated
• Detail-oriented
• Ability to effectively manage time and stress

Competencies Upon Completion Core Courses

• Identify, gather, and implement requirements
• Configuration of HANA in full implementation cycle from blue printing to realization and go-live
• Develop and document SAP functional, business requirements specifications
• Develop and document interface requirements
• Develop functional, business, and system interface or capability interaction
• Gather and analyze information to establish the technical needs of a system or project
• Design methods and procedures for computer systems, and sub-systems of larger systems
• Develop and maintain functional standards for the functional framework Document and develop forms, manuals, programs, data files, and procedures
• Provide advice, analysis, configuration, implementation, integration, problem resolution, and unit testing for SAP HANA and Hadoop
• Configure and maintain HANA or Business Suite HANA
• Create Attribute, Analytic and Calculation views and use them in various reports.
• Develop complex business reporting and analytics models using SAP BW, BO, HANA and Hadoop
• Understanding of relevant SAP infrastructure modeling and analytics tools
• SAP HANA modeling and reporting experience at the SPS12 level or beyond
• In depth knowledge of HANA memory management and data modeling – especially as it relates to maintaining a high level of responsiveness for end users
• Business Objects experience at the 4.x level and with all BOBJ premises-based, server-side items
• Experience implementing, managing and maintaining code promotion processes and environments including development, QA, staging, pre-production and production for both HANA and BOBJ
• Administering HANA and BOBJ tools
• Work with SAP on Linux
• Proficiency in SAP Lumira, Fiori, and Predictive Analytics