MSSQL Lead Developer/Architect

Droisys; Irving (TX); Hybrid; USD 80,000 - 100,000; Full time

Job summary

A leading technology firm located in Irving, TX is looking for a Mid-Senior level professional to develop, optimize, and maintain database systems using T-SQL and ETL processes. The ideal candidate will ensure database performance and data integrity while collaborating with various teams. This role offers a hybrid work model and is part of a contract position.

Qualifications

• Design, develop, and optimize T-SQL queries, stored procedures, functions, and views.
• Develop and maintain ETL processes using SSIS or other tools.
• Perform data modeling, normalization, and schema design.
• Monitor and improve database performance, including indexing and query optimization.
• Ensure data integrity and implement data quality checks.
• Collaborate with cross-functional teams to understand business requirements.
• Support reporting and analytics needs using SSRS or Power BI.
• Maintain documentation for database structures and procedures.

Skills

T-SQL queries

ETL processes

Data modeling

Schema design

Database performance optimization

Data quality checks

Reporting using SSRS

Power BI

Job description

Droisys is an innovation technology company focused on helping companies accelerate their digital initiatives from strategy and planning through execution. We leverage deep technical expertise, Agile methodologies, and data-driven intelligence to modernize systems of engagement and simplify human/tech interaction.

Amazing things happen when we work in environments where everyone feels a true sense of belonging and when candidates have the requisite skills and opportunities to succeed. At Droisys, we invest in our talent and support career growth, and we are always on the lookout for amazing talent who can contribute to our growth by delivering top results for our clients. Join us to challenge yourself and accomplish work that matters.

Irving, TX (Hybrid Weekly 3 days)

Job Summary: The ideal candidate will be responsible for designing, developing, and maintaining MSSQL Server databases and ensuring their performance, availability, and security. You will work closely with business analysts, data architects, and application developers to support data-driven decision-making.

Skills and Requirements:

• Design, develop, and optimize T-SQL queries, stored procedures, functions, and views.
• Develop and maintain ETL processes using SSIS or other tools.
• Perform data modeling, normalization, and schema design.
• Monitor and improve database performance, including indexing and query optimization.
• Ensure data integrity and implement data quality checks.
• Collaborate with cross‑functional teams to understand business requirements and translate them into technical solutions.
• Support reporting and analytics needs using SSRS or Power BI.
• Maintain documentation for database structures, processes, and procedures.
• Participate in code reviews, testing, and deployment activities.

Droisys is an equal opportunity employer. We do not discriminate based on race, religion, color, national origin, gender, gender expression, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by law. Droisys believes in diversity, inclusion, and belonging, and we are committed to fostering a diverse work

Seniority level

• Mid‑Senior level

Employment type

• Contract

Job function

• Information Technology

Industries

• IT Services and IT Consulting