• US Citizen

• Green Card

• W2-Permanent

• W2-Contract

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 11th Dec 2023

Working experience managing SQL server databases in Azure using Azure portal (performance and tuning, backup and recovery, monitoring, and security)
Working experience in migrating SQL server on-prem databases to Azure.
Working experience with setting up and maintaining SQL Server databases with high availability options.
Candidates need to have:

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.

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