Azure DBA

Azure DBA

Remote

6 month contract

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