Remote SQL Developer/DBA

$124,800 - $135,200/Yr

INSPYR Solutions - Charlotte, NC

Full-time - Mid Level

Remote - Charlotte, NC

Administrative and Support Services

About the position

The Remote SQL Developer/DBA role involves modeling, developing, and implementing databases and data structures to meet business and technical requirements. This position focuses on creating enterprise-level ETL processes, ensuring data integrity, and optimizing database performance. The role also includes mentoring junior developers and participating in code reviews, making it essential for candidates to have strong SQL Server expertise and experience in data warehousing.

Responsibilities

• Model, develop, and implement transactional, ETL staging, and analysis/reporting databases.
• Develop enterprise level ETL processes including process logging, data validation, and data integrity checks.
• Automate complex processes using SQL agent jobs and SQL Server Integration Services.
• 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.
• Provide technical mentoring and coaching for junior and mid-level database developers and data quality analysts.

Requirements

• Bachelor's Degree in Computer Science, CIS, or related field (or equivalent work experience).
• 5+ years of enterprise software development experience, specifically in data warehousing or operational data marts.
• Deep knowledge and experience in SQL Server and T-SQL, particularly in troubleshooting and optimizing queries and stored procedures.
• Experience with CI/CD, Git, and ADO Pipelines.
• Strong experience with Scrum, Agile Process, and Unit Testing using Test Driven Development.
• Excellent time management skills and ability to work on concurrent assignments with different priorities.
• Excellent communication skills and ability to work collaboratively across several teams.

Nice-to-haves

• C# Development experience or EFCore exposure.
• Snowflake experience/knowledge.
• AWS Managed Database Experience.

Benefits

• Comprehensive medical benefits
• Competitive pay
• 401(k) retirement plan