Azure Database Administrator - SQL Server (remote)
Database Administrator – SQL Server – Azure Job Title: Database Administrator Location: Remote Duration: 6 month contract for hire or long term contract Skills Required: • 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. • Must have Azure Cloud Experience, as well as On premises SQL server experience - (70-80% Azure / 20-30% On Premises) 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