Azure Database Administrator (Synapse)

k0deHut; Cape Town; Remote; ZAR 600 000 - 750 000; Full time

Job summary

A technology solutions provider is seeking an experienced Azure Database Administrator to manage and optimize their Microsoft Azure Synapse Analytics environments. Key responsibilities include designing scalable databases, managing security measures, and providing technical support. The ideal candidate will have strong SQL skills, experience with Azure Data Factory, and a focus on compliance and efficiency.

Qualifications

• Proven experience as a Database Administrator, with Microsoft Azure Synapse Analytics.
• Strong understanding of SQL, database design, and performance tuning.
• Knowledge of data security protocols and disaster recovery methods.

Responsibilities

• Design and implement scalable database schemas.
• Manage security measures, including data masking, encryption, and access controls.
• Develop, maintain, and optimize ETL processes.

Skills

SQL

Database Design

Performance Tuning

Data Security Protocols

Problem-solving

Communication

Tools

Azure Data Factory

Job description

About the job Azure Database Administrator (Synapse)

Synapse Database Administrator

Permanent, Remote

Role Overview:

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.