SYSTEMS ANALYST – Botswana Meat Commission

Job Purpose

Design and Implement Data procedures and complex queries to retrieve data for different needs of the organisation and Monitor and recommend changes if required to PL/SQL packages and provide stored procedures and design and develop various relational data base as per business need.

Principal Accountabilities

• Managing database security/integrity and keeping databases up to date

• Maintain source code sets and necessary technical documentation and assist the DBA’s in overall database maintenance.

• Monitoring performance and managing database parameters to ensure the database meets user requirement and provides fast response to Oracle EBS application users.

• Extract data for reporting purposes

• Write database documentations including procedures, and disaster recovery plans

• Develops and documents systems operations and manuals and procedures as outlined in the ISO quality system.

• Working with the business assigned Support Partner, develop customizations, and identify processes that could automated.

• Perform application configuration and administration.

• Trouble shooting and resolving reported application issues/queries and assisting users

• Develop, design, test and implement complex database programs using Oracle and third-party tools.

• Provide user training, support, and feedback.

Position Requirements

Education

Degree in Computer Science or related field. Oracle Certified Administration (OCSA), PL/SQL programming, Oracle reports & XML. OCI certified.

Experience

At least three (3) years relevant post qualification experience. Solid development experience with financial management systems including general ledger, budgeting, accounts payable, bank reconciliation and fixed assets.

 Knowledge and Skills

• Planning and Coordinating

• Innovative and pro-active

• Results focused and commitment

• Decisiveness and assertiveness

• Consultation and interpersonal skills

• Good communication skills

• Ability to use one or more development language (C++, PHP, HTML, etc