Azure SQL DBA

Azure SQL DBA100% Remote Azure SQL DBA opening for a healthcare client. We can do C2C – HOWEVER, the candidate must have a green card or US Citizen status. Notes: Seeking a Strong Azure SQL DBA - Must have Azure Data Factory (ADF) and Databricks experience/exposure.ElevatePFS – Azure SQL DBA Screening Questions:What is your experience working with Azure Data Factory and Azure DataBricks? How have you implemented CI/CD pipelines for database-related tasks in Azure, and what challenges have you faced?Can you describe your experience managing SQL Server databases in Azure? Specifically, how have you handled performance tuning, backup and recovery, monitoring, and security configurations in AzureYou are tasked with optimizing a SQL query that has performance issues. What steps would you take to identify bottlenecks and improve the query's performance, especially in a large-scale data environment?Describe your experience migrating on-premises SQL Server databases to Azure. What tools did you use, and what were the main challenges you encountered during the migration process?What strategies have you used to ensure high availability and disaster recovery for SQL Server databases in an Azure environment? Can you walk me through your approach to setting up Always On Availability Groups or other high availability configurations?The purpose of this position is to perform SQL Server Administration including: install/configure new SQL servers, deploy database change scripts provided by developers, perform all SQL server related IT tickets. The position is also responsible for SSRS,SSIS related administrative support and assist in troubleshooting errors, permission problems and change control. Tech Stack Requirements: Must have a strong Microsoft Tech stack SQL Server Azure SQL Azure Data Factory & Databricks Always On Availability GroupsEssential Duties And Responsibilities1. Database administration for MSSQL Server 2. Performance Tuning and Optimization using native monitoring and troubleshooting tools 3. Index creation, management, statistics 4. Automation, scripting, agent jobs 5. Availability Groups, Backups, and Restores 6. Propose technical solutions to business problems on a proactive basis 7. Other duties as assigned.