Azure Database Administrator

K0Dehut; Cape Town; Remote; ZAR 600 000 - 900 000; Full time

Job summary

A technology firm is seeking a skilled Synapse Database Administrator to optimize their Azure Synapse Analytics environments. You will design database schemas, manage security measures, and develop ETL processes to ensure the performance and compliance of large-scale data operations. The ideal candidate will have proven experience in database administration, strong SQL skills, and the ability to collaborate effectively. This is a remote position based in Cape Town, South Africa.

Qualifications

• Proven experience as a Database Administrator.
• Strong understanding of SQL and database design.
• Experience with data integration tools.

Responsibilities

• Design and implement scalable database schemas.
• Manage security measures and configure access controls.
• Develop and optimize ETL processes.

Skills

Database Administration

Microsoft Azure Synapse Analytics

SQL

Data Integration

Data Security

Problem Solving

Collaboration

Tools

Azure Data Factory

Job description

Role Overview

Synapse Database Administrator Permanent, Remote. Our client is looking for a skilled Synapse Database Administrator to join their growing team. The ideal candidate will be responsible for managing, optimizing, and ensuring the performance and security of our Microsoft Azure Synapse Analytics environments. This role requires a detail-oriented and proactive professional capable of managing large-scale data operations while driving efficiency and compliance.

Key Responsibilities

• Design and implement scalable database schemas and ensure optimal performance as data volume grows.
• Manage security measures, including data masking, encryption, and access controls.
• Develop, maintain, and optimize ETL processes and integrate diverse data sources.
• Perform query performance tuning and monitor the system to handle complex analytical queries efficiently.
• Balance and manage Azure resources to optimize performance and cost.
• Implement and oversee backup procedures and disaster recovery strategies.
• Collaborate with cross-functional teams to support data-driven decision making.
• Provide technical support and training to internal teams.
• Ensure compliance with all relevant regulations and maintain detailed documentation.

Qualifications

• Proven experience as a Database Administrator, with Microsoft Azure Synapse Analytics.
• Strong understanding of SQL, database design, and performance tuning.
• Experience with Azure Data Factory or similar data integration tools.
• Knowledge of data security protocols and disaster recovery methods.
• Excellent problem-solving skills and the ability to work collaboratively.
• Strong communication and documentation skills.