Senior Database Consultant

Introduction:

As a Senior Database Consultant, you will be responsible for providing expert guidance and support in database design, data integration, and SQL tuning. You will play a key role in ensuring the high availability and performance of our database systems, as well as implementing disaster recovery solutions. Your expertise in data modeling and SQL optimization will be crucial in optimizing our database operations.

Responsibilities:

• Develop SQL Server databases and T-SQL code
• Design and implement database structures and data models
• Manage stored procedures, functions, and triggers
• Tune query performance and optimize execution plans
• Implement indexing strategies and SQL optimization techniques
• Utilize Query Store, DMVs, and Extended Events for monitoring and troubleshooting
• Identify and resolve blocking, deadlocks, and performance issues
• Implement High Availability and Disaster Recovery solutions

Requirements:

Required Skills:

• Data Integration
• Database Design
• Extract, Transform, Load (ETL)
• Disaster Recovery
• Data Modeling
• SQL Tuning
• Transact-SQL
• Microsoft SQL Server
• High Availability
• SQL Azure
• Stored Procedures
• Performance Tuning

Preferred Skills:

• Azure SQL
• SQL Server 2019/2022
• Experience with High Availability and Disaster Recovery solutions