Database Administrator - Azure #11174

Summary: The Database Administrator (Azure) role involves managing SQL Server databases in a fully remote environment, focusing on Azure technologies, particularly Postgres and Databricks. The position requires collaboration with a dynamic team to support digital transformation initiatives and ensure high performance and security of database systems. Key responsibilities include database administration, performance tuning, and providing technical guidance to support analysts and developers. The ideal candidate will have extensive experience in Azure and a strong understanding of database management best practices.

Key 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
• 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 in migrating SQL server on-prem databases to Azure.
• Must have working experience with setting up and maintaining SQL Server databases with high availability options.
• all in Azure - no on prem

Key Skills:

• 100% Azure, Postgres and Databricks experience
• 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 in migrating SQL server on-prem databases to Azure.
• Must have working experience with setting up and maintaining SQL Server databases with high availability options.
• all in Azure - no on prem

Salary (Rate): £120,000 yearly

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT