Senior Azure Data Platform Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Oversee and administer Azure SQL Managed Instance and Azure SQL databases within production settings.

• Conduct performance tuning of databases, which includes developing indexing strategies, analyzing query plans, and optimizing workloads.

• Identify and resolve issues related to locking, blocking, and concurrency.

• Establish and manage database security protocols, user access, and role-based permissions.

• Maintain comprehensive backup, recovery, and high availability practices.

• Design, construct, and sustain ADF pipelines for both batch and incremental data loading.

• Manage ADF environments, which includes monitoring, scheduling, and addressing failures.

• Diagnose pipeline failures, integration challenges, and performance bottlenecks.

• Assume full ownership of data loading procedures, from ingestion to validation.

• Spearhead initiatives to stabilize, standardize, and enhance existing pipelines.

• Create and maintain automation solutions using Python and/or PowerShell.

⛳️ Requirements

• A minimum of 7 years of experience in database administration, data engineering, or data platform operations.

• Extensive hands-on knowledge of Azure SQL Managed Instance and Azure SQL Database.

• Proficiency in Azure Data Factory, including pipeline development and administration.

• Strong background in SQL query optimization and performance tuning.

• Demonstrated capability to diagnose and address locking/blocking issues, data pipeline failures, and performance bottlenecks.

• Experience in managing database user access and security administration.

• Practical experience with Python and/or PowerShell scripting.

• Familiarity with Azure DevOps (ADO) for code and deployment management.

• Excellent analytical skills with the ability to interpret logs and troubleshoot data processes.

• Capability to work autonomously in complex, high-pressure situations.

🏝️ Benefits

• Ongoing training opportunities.

• Competitive benefits package.