DATA AND ANALYTICS ENGINEER – CAPE TOWN – WESTERN CAPE

Tych Business Solutions; Cape Town; On-site; ZAR 600 000 - 800 000; Full time

Job summary

A data management firm in Cape Town is seeking a professional to manage databases and oversee Qlik applications. The ideal candidate will have 7 years of experience in data management and analytics, with strong skills in database administration, performance tuning, and Qlik Sense. This role involves ensuring data security and compliance while optimizing overall database performance.

Qualifications

• 7 years experience of data and analytics.
• Experience with database performance tuning and management.
• Proficient in configuring and managing data connections.

Responsibilities

• Manage licenses, tokens, and access types.
• Optimize database performance and ensure security.
• Administer Qlik Sense applications and monitor environments.

Skills

Data management

Database administration

Performance tuning

Problem diagnosis

Qlik Sense administration

Education

Tertiary qualification

Tools

Microsoft Azure

Qlik Sense

QlikView

Job description

Qualifications

• Matric and a tertiary qualification
• 7 years experience of data and analytics

Responsibilities

• Manage licenses.
• Manage tokens and access types.
• Configure nodes.
• Manage data connections.
• Manage content security (can define security rules)
• Manage task and triggers.
• Synchronize users

Database Managed Services

• Database administration: Ensure database remains efficient and secure.
• Fine tune of configurations, optimises resource allocation, ensure and implements best practices.
• Database performance tuning and management: Performance tuning and management for optimized data operations e.g. scalability and efficiency.
• Ensures peak performance through continuous monitoring.
• Continuous Service Improvement.
• Proactive approach to database management by continually evaluating performance and security through monitoring, trending topics to
• Trouble shooting and problem diagnosis to resolve issues logged via support system.
• Backup and Recovery: Ensuring the recovery of the data during system failures. Automated backups and recovery processes.
• Database storage: Continuous monitoring of storage as well as scale storage requirements
• Database security: Ensures data remain confidential and compliant including masking techniques, encryption and access controls.
• Infrastructure support: 24hr support to resolve issues by doing proactive monitoring and problem resolution.
• Database upgrade and migration: Plan and execute upgrades and migration of data. Ensure patches and updates are applied timeously to remain relevant.
• Integration with Microsoft Azure: Monitoring and troubleshooting data pipelines.

Qlikview and Qliksense Services

• Install, configure and upgrade Qlik Sense application.
• Manage migration of QLIK objects between Development, QA and Production environments
• Analyse Windows event logs and Qlik Sense server log files to troubleshoot and solve issues.
• Provide Qlik Sense administration services via Management Console: managing licenses, setting up permission, designing folder structure and scheduling tasks for publishing purposes.
• Administer and maintain access to Qlik Sense Management Console
• Performance and scalability: Monitor proactively the environment.
• Liaise and with Qlik team to troubleshoot new features and provide operational support.
• Backup and recovery: Ensure backup and recovery of environment.
• Regular checks on compliance like user access controls or any vulnerability scans on environment
• Provide technical guidance to developers.
• Support Nprinting configuration and set-up.
• Perform upgrades to the environment for new software updates. Therefore, plan and execute software upgrades.
• Collaborate with developers to ensure optimal solution implementation.
• Collaborate with infrastructure and architecture teams to ensure optimal infrastructure environment.
• Decommissioning the environment when new environments are established. Plan and execute.