Database Administrator

apartmentH&S Labour Brokers placeJohannesburg calendar_month 
BASIC JOB DESCRIPTION
Install, upgrade, and manage database
  • Install and maintain the performance of database servers.
  • Responsible for maintaining the integrity and performance of the Funds databases
  • Manage database access.
  • Performance tuning of database systems.
  • Install, upgrade, and manage database applications.
  • Diagnose and troubleshoot database errors.
  • Recommend and implement emerging database technologies.
  • Design and implement data extraction and transformation programmes and support with data mining on an as needs basis
  • Create and manage database reports, visualizations, and dashboards.
  • Create automation for repeating database tasks.
  • Be available for on-call support as needed.
Maintain data standards and ensure data remains consistent across database
  • Establish the needs of users and monitor user access and security
  • Monitor performance and manage parameters in order to provide fast responses to front-end users
  • Map out the conceptual design for a planned database
  • Consider both back-end organisation of data and front-end accessibility for end-users
  • Refine the logical design so that it can be translated into a specific data model
  • Further refining the physical design to meet system storage requirements
  • Install and test new versions of the database management system (DBMS)
  • Maintain data standards, including adherence to the Data Protection Act
  • Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
  • Informing end users of changes in databases and train them to utilize systems effectively
Ensure that storage and archiving procedures are functioning correctly
  • Ensure that data is stored securely and optimally by controlling access permissions and privileges
  • Develop, manage and test back-up and recovery plans
  • Work closely with IT project managers, database and business analysts
  • Communicate regularly with technical, applications and operational staff to ensure database integrity and security
  • Commission and install new applications and customise existing applications in order to make them fit for purpose
  • Manage the security and disaster recovery aspects of the database.
REQUIRED MINIMUM WORK EXPERIENCE AND QUALIFICATIONS
  • Relevant Diploma in computer science, computer software/computer systems engineering or related discipline.
  • Database Administration certification (advantageous)
  • At least 3 years job-related experience, preferably within an IT environment.
  • Experience with financial/investment systems advantageous
  • Business awareness and understanding of business requirements of IT
  • An understanding of information legislation, such as the Data Protection Act
  • In-depth knowledge of the application environment
  • Extensive knowledge of business practices and processes
  • Knowledge of developing IT related business plan and motivation
  • Commercial knowledge (budgeting, procurement etc.)
  • Project lifecycle (SDLC) knowledge
  • Knowledge of Cobit and /or ITIL
  • Experience with Linux and Windows Server environments
  • Extensive experience with design, implementation and utilisation of database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
  • Business Acumen
  • Presentation skills
  • Excel Intermediate
  • Understanding and knowledge of Microsoft Applications
thumb_up_altRecommended

Payroll Clerk

apartmentNetwork RecruitmentplaceJohannesburg
My client is looking for a Payroll Clerk to join their Shared Services Centre and play a key role in processing and maintaining payroll data with precision and professionalism. This role is based in Springs, Johannesburg East. Key Responsibilities...
electric_boltImmediate start

Internal Sales Assistant

apartmentE&D RecruitersplaceJohannesburg
Mechanical Internal Sales Assistant (Bulk Materials Handling) Randburg Minimum requirements and experience required:  •  Mechanical Diploma  •  1 2 years of relevant working experience  •  Bulk materials handling exposure  •  A solid technical background...
local_fire_departmentUrgent

Administrative Clerk

apartmentMarvel Placement ConsultantsplaceJohannesburg
Minimum Requirements:  •  Matric (Grade 12) or equivalent qualification.  •  At least 6 months to 1 year of experience in an administrative or data capturing role (internship or work experience acceptable).  •  Basic knowledge of Microsoft Excel (e.g.,...