Intermediate Database Administrator

Boardroom Appointments; Sandton; On-site; ZAR 350,000 - 520,000; Full time

Job summary

Boardroom Appointments is seeking an Intermediate Database Administrator in Sandton to manage data warehouse environments, install and test complex databases, and contribute to database design and security.

You will identify business requirements, document technical specs, back up data, and provide technical support under guidance from senior colleagues. Matric is required, MCSE in SQL 2016 is advantageous, with a minimum of four years in data warehousing. This is an on-site role.

Qualifications

• Minimum 4 years of experience in data warehouse management.
• MCSE in SQL 2016 is advantageous.

Responsibilities

• Identify business requirements.
• Collect business requirements using interviews, documents, workshops, and workflow analysis to express requirements for target user roles and goals.
• Create and review database specifications to ensure standards and data integrity.
• Install and test complex databases and related products to meet customer requirements.
• Implement and monitor information security measures such as firewalls or encryption.
• Create and maintain technical/user documentation and ensure data backups for instant recovery.
• Manage basic aspects of the data management system under guidance from seniors.
• Design distribution of database resources and provide physical modeling and tuning for performance.

Skills

Data warehouse management

Requirements gathering

Education

Matric

MCSE in SQL 2016 (advantageous)

Job description

About the job Intermediate Database Administrator

• Matric
• MCSE in SQL 2016 advantageous
• Minimum 4 year's experience in data warehouse management

Responsibilities:

• Business Requirements Identification
• Collect business requirements using a variety of methods such as interviews, document analysis, workshops, and workflow analysis to express the requirements in terms of target user roles and goals
• Database Specifications
• Contribute to the approval process for database specifications to ensure all agreed standards and protocols are followed and data integrity is preserved
• Install and test complex databases and associated products to ensure they are suitable for use and meet customer requirements
• Information Security
• Implement and provide input on the design of required security measures such as firewalls or message encryption, monitoring performance to notify security experts of any problems
• Documentation and Back up
• Create and maintain technical and/or user documentation to a high standard and back up files to ensure instant recovery if problems occur
• Data Management
• Manage basic aspects of the data management system with guidance from senior colleagues
• This includes being responsible for developing or operating basic elements of the data management systems to deliver prescribed outcomes
• Technical Database Support
• Design distribution of database resources and provide physical modeling and design services to tune database applications for optimum performance