Overview
Hybrid
$120,000 - $140,000
Full Time
Skills
SQL
Azure
Devops
Job Details
RESPONSIBILITIES
- Monitor performance of database systems resources and query throughput
- Guide colleagues on database best practices.
- Monitor and maintain database storage resources.
- Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics.
- SQL Server Installation, Upgrades, Migrations and Configuration
- Install database software service packs and cumulative updates, as necessary.
- Maintain database documentation as required.
- Maintain and administer database security access.
- Perform database Ad-hoc backups and restores.
- Trouble shoot and resolve complex database related issues.
- Identify areas for improvement and implement it following best practices.
- Follow Change Management processes to implement database configuration changes (Azure DevOps)
- Follow Problem Management processes to troubleshoot and resolve recurring issues.
- Proactively monitor and respond to MSSQL database Alert.
- Continuous Integration and Deployment in Azure DevOps
- Experience with Microsoft Azure focused on the data solutions (Azure Data Factory / Azure Synapse / SQL database)
- Assist internal/external audit with reporting requirements.
- Develop scripts for consistent and secure execution of common tasks.
- Providing SQL expertise, proposing design recommendations, optimization performance improvements.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.