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