Azure DBA

Position Title: Database Administrator – (Azure)

Skills Required

• 100% Azure, Postgres and Databricks experience needed

• Ability to work in a dynamic environment with changing requirements

• Good communication and presentation skills

• Working experience as a SQL Server database administrator in Azure

• Working experience creating and supporting Data Factory data pipelines, DataBricks workspaces, and security groups in Azure.

• Working experience using DevOps CI/CD in Azure.

• Review and rewrite high performance SQL queries using Joins, Cross Apply, Aggregate Queries, Merge, Pivot

• Migrate Stored Procedures, Functions and Views

• Review database designs to identify proper indexing and constraints

• Perform SQL query tuning and performance optimization on complex inefficient queries

• Provide guidance in the use of table variable, temporary table, CTE appropriately to deal with large datasets

• Analyze complex queries for any deadlock resulting due to conflicts

• Collaborate with other DBAs on database design and performance enhancements

• Debug existing code and troubleshoot for issues

• Keep up to date with the latest database features, techniques, and technologies.

• Support current business applications including the implementation of bug fixes as needed

• Able to multi-task and adapt to shifting priorities

• Able to meet deadlines set in project planning

• Effectively communicate progress through the project execution phase

• Follow industry and company standard coding practices

• Produce technical and application documentation

• Test database process for future enhancements and bug fixes

• Assist support analysts and developers with issues they are unable to resolve.

• Ensure customer satisfaction by meeting customer needs in a courteous and timely manner

• Understanding of backup and recovery

• Understanding of best practices for performing and tuning

• Worked in an environment with continuous integration/continuous deployment (CI/CD) pipeline in DevOps.

• Must have working experience managing SQL server databases in Azure using Azure portal (performance and tuning, backup and recovery, monitoring, and security)

• Must have working experience with setting up and maintaining SQL Server databases with high availability options.

• Must have Azure Cloud Experience, as well as no on prem – this is an Azure DBA

• Roles & Responsibilities:

• Work with a highly dynamic team focused towards Digital Transformation

• Understand the domain and business processes to successfully perform SQL Server database administration tasks (project or maintenance related) in Azure.

• Provide work status and coordinate with other Database administrators and developers.

• Manage customer deliverables and regularly report the status via Weekly/Monthly reviews