SQL Server Developer and DBA (W-2 Only)

SQL Developer & DBA / Charlotte NC Preferred / Remote is OK / Contract-To-Hire Responsibilities: Model, develop, and implement transactional, ETL staging, and analysis/reporting databases, data structures, and cubes to satisfy business and technical requirements. Develop enterprise level ETL processes that include process logging, data validation, and data integrity checks. Automate complex processes using SQL agent jobs, SQL Server Integration Services, etc. Ensure accuracy and integrity of data through the development of constraints and validation rules. Implement database performance monitoring and tuning. Manage SQL code in a source control system. Establish and enforce SQL development coding standards and best practices. Lead/participate in SQL code reviews. Deep knowledge and experience in SQL Server and T-SQL with respect to troubleshooting and optimizing queries and stored procedures. Provide technical mentoring and coaching for junior and mid-level database developers and data quality analysts. Qualifications: Overall 7+ years of enterprise software development experience with specifics in Data Warehousing or enterprise operational data marts. Database: MS SQL Server 2019. Working understanding of cloud development principles and software design patterns. Experience with CICD, Git, and ADO Pipelines Strong Experience with Scrum, Agile Process, Unit Testing using Test Driven Development. Continuous learner, process improver. Excellent time management skills and ability to work on concurrent assignments with different priorities. Excellent communications skills and ability to work collaboratively across several teams. Desired Skills: C# Development experience or EF Core exposure a plus Snowflake experienceknowledge a plus AWS Managed Database Experience a plus.