Premier FMCG: Senior Database Administrator

Job Description:

A career opportunity has arisen in the IT Department – Premier Corporate – Corporate. This position is responsible for the day-to-day maintenance, administration, support and tuning of a multi-server, multi-cloud environment.

Location: Johannesburg

Do not forget to register your cv on our database here REGISTER

Duties And Responsibilities

  • Software installation and Maintenance
  • A good understanding of install options vs requirements as set up by the requestor
  • Be able to maintain Database engine version, compatibility control and updates
  • A good understanding on Memory allocation / Lock page allocations and assignment based on availability and best practice
  • A fair knowledge of operating Windows server edition, Storage Spaces, and similar technologies.
  • Database Backup and Recovery
  • Database restoration to test servers on a regular basis
  • Additional backups for special event (IE, data changes and ERP check according to the Change control process and approvals)
  • Setup and maintain Daily (Incremental) / Weekly (full) and Hourly (Log) backups
  • Security and Authentication
  • Application security setup
  • A good understanding of Server roles, Schema security, user, and group security
ALSO APPLY FOR   Legal Aid SA: Admin Officer

Qualifications And Experience

  • MCSE
  • Developing Microsoft SQL Server Databases
  • Designing Database Solutions for SQL Server
  • Implementing Data Models and Reports with Microsoft SQL Server
  • Designing and implementing Business Intelligence Solutions with Microsoft SQL Server
  • Developing SQL Databases
  • Implementing a SQL Data Warehouse
  • Developing SQL Data Models
  • Implementing Azure Cosmos DB Solutions
ALSO APPLY FOR   Admin Clerks (x5)

Experience Requirements

  • A good knowledge of Azure data storage and on setting up and maintaining database schemas (Including Security roles and setups)
  • A good understanding of data Extraction, Transformation, Loading, Archiving, data compression and integrity
  • A good understanding of the requirements and workings of a Business Intelligence process and systems
  • A good understanding of T-SQL coding
  • A good understanding schema and data models including but not limited to Dimensions, Facts, slow moving and fast changing data
  • Data warehouse design, construction, and maintenance
  • Existing knowledge of Azure managed instances
  • Prior knowledge of, or willingness to learn, the Dynamics GP table structure
  • Report on user activity and access where required
  • Root cause analysis
  • Understand, and be able to assist with, Stored procedures, triggers and other SQL components
ALSO APPLY FOR   Government Post: Human Resources Clerk

How To Apply

Click Here To Apply…

Closing Date : 08 March 2022

PLEASE SHARE TO

Leave a Comment