Role: Data Warehouse Specialist (Requiring a minimum of 1 day onsite in Rockville, MD)
Walking in the door candidates need to have experience spinning up a Datawarehouse after performing ETL proccesses to extract data from multiple sources and migrate it to a centeralized Azure SQL Database.
You will play a pivotal role in managing and optimizing our Azure SQL databases, ensuring the highest levels of performance, security, and availability.
Responsibilities:
Database Management: Oversee the design, implementation, and maintenance of Azure SQL databases, ensuring optimal performance and reliability.
Performance Tuning: Monitor and tune database performance to meet the needs of our applications and business processes.
Security: Implement and enforce security measures to protect sensitive data and comply with industry standards and regulations.
Backup and Recovery: Develop and manage backup and recovery strategies to safeguard data and ensure business continuity.
Troubleshooting: Diagnose and resolve database issues, including performance bottlenecks, connectivity problems, and query optimization.
Collaboration: Work closely with development teams to support database requirements, including schema design and query optimization.
Documentation: Maintain detailed documentation for database configurations, procedures, and best practices.
Upgrades and Patching: Manage database upgrades and patches, ensuring minimal disruption to services.
Automation: Implement automation solutions to streamline database management tasks and improve efficiency.
Qualifications:
Experience: Minimum of 5 years of experience as a SQL DBA and ETL with a strong focus on Azure SQL Database management.
Technical Skills: Proficiency in SQL Server, NoSQL, Azure SQL Database, and T-SQL. Experience with PowerShell scripting and Azure Data Factory is a plus.
Performance Tuning: Proven expertise in performance tuning, index management, and query optimization.
Security Knowledge: Strong understanding of database security best practices and compliance requirements.
Problem-Solving: Excellent analytical and problem-solving skills with the ability to troubleshoot complex database issues.
Communication: Strong verbal and written communication skills, with the ability to effectively collaborate with cross-functional teams.
Dynamic Team: Be part of a collaborative and forward-thinking team culture dedicated to making a positive impact.