Get the skills towards a career in Database Administration and Big Data Predictive Analytics

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