Lighthouse Technology Services
SQL Developer
Lighthouse Technology Services, Charlotte, North Carolina, United States, 28245
*Remote Contract-to-Hire Opportunity*
Lighthouse Technology Services is partnering with our client to fill their SQL Developer position! This is a 6+ month contract-to-hire opportunity based in Charlotte, North Carolina, and is open to local and remote candidates. This role will be a W2 employee of Lighthouse Technology Services during the contract period.
What You'll Be Doing:
• 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-SQP 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.
What You'll Need to Have:
• 5+ years of enterprise software development experience with specifics in data warehousing or enterprise operational data marts.
• VERY strong T-SQL
• Ability to write complex stored procedures INDEPENDENTLY
• Database Development experience on a Microsoft C# platform
• Expertise with 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.
• Snowflake experienceknowledge preferred
• AWS Managed Database Experience preferred
• Agile SAFe 6 experience preferred
Pay Range :
$66-$71/hr +
Questions about any of our jobs? Email us at recruiting@lhtservices.com
View all of our open jobs here: jobs.lhtservices.com
Lighthouse Technology Services is partnering with our client to fill their SQL Developer position! This is a 6+ month contract-to-hire opportunity based in Charlotte, North Carolina, and is open to local and remote candidates. This role will be a W2 employee of Lighthouse Technology Services during the contract period.
What You'll Be Doing:
• 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-SQP 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.
What You'll Need to Have:
• 5+ years of enterprise software development experience with specifics in data warehousing or enterprise operational data marts.
• VERY strong T-SQL
• Ability to write complex stored procedures INDEPENDENTLY
• Database Development experience on a Microsoft C# platform
• Expertise with 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.
• Snowflake experienceknowledge preferred
• AWS Managed Database Experience preferred
• Agile SAFe 6 experience preferred
Pay Range :
$66-$71/hr +
Questions about any of our jobs? Email us at recruiting@lhtservices.com
View all of our open jobs here: jobs.lhtservices.com