Database Administrator

We are looking for below position for our client please share the resume.

SQL Server (Azure)

Job Title: Azure Database Administrator
Location: Remote
Duration: 6 Months 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

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