SQL/EDW Architect

Company: Symbiotic Consulting Group LLC
Location: Hollywood
Posted on: April 26, 2025

Job Description:

Responsibilities:

Making sure you fit the guidelines as an applicant for this role is essential, please read the below carefully.

Install, configure, upgrade, and patch MS SQL Server databases.
Resolve security violations on MSSQL servers/DB.
Perform regular database maintenance tasks, including backups, indexing, and integrity checks.
Design, implement, and regularly test disaster recovery plans to ensure minimal downtime on on-premises installations.
Manage and automate backup processes, ensuring data availability and integrity, using native and 3rd party backup tools like Rubrik, AWS Backup service, and S3.
Work closely with DW manager to ensure prioritization of corporate and departmental objectives and
Provide assistance to DW team members with issues needing technical expertise or complex systems and/or programming knowledge. Provide on-the-job training for new or less experienced team members.
Monitor database performance and proactively tune databases, optimizing SQL queries, indexes, and configurations.
Identify and resolve performance bottlenecks, ensuring high availability and fast response times.
Design, implement, and manage high-availability solutions, including SQL Server clustering, Always-On Availability Groups, and database mirroring.
Configure and monitor replication strategies such as transactional replication, merge replication, and log shipping to ensure data availability across environments.
Troubleshoot and resolve high availability and replication issues, minimizing downtime and data loss.

Required experience:

12+ years of experience with MSSQL database management
Excellent work experience in MSSQL database architecture and migration to AWS EC2
8+ years of design, development, and support experience within Microsoft SQL Server 2005 or later
8+ years of experience with BI Technology: SQL, SSRS, SSAS, SSIS, Power BI
5+ years of ETL or ELT development experience in the use of the Microsoft SQL Server Integration Services (SSIS) platform and/or Data Transformation Services (DTS)
Worked hands-on migrating stored procedures in MySql
T-SQL Coding: Write, optimize, and troubleshoot T-SQL queries, stored procedures, functions, triggers, and views to perform tasks such as data retrieval, data modification, and data manipulation.
Demonstrated SQL query creation, performance tuning, and troubleshooting experiences
Prior experience in moderate - large SQL Server environments required - database size exceeding 1TB, with table sizes in the 100's of millions of records or greater
Bachelor of Science degree in Computer Science or Information Systems

Keywords: Symbiotic Consulting Group LLC, Tamiami , SQL/EDW Architect, IT / Software / Systems , Hollywood, Florida