Full Stack Developer

JPS Tech Solutions

Florida

On-site

USD 90,000 - 140,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

JPS Tech Solutions Pvt Ltd is seeking an experienced Full Stack Developer to support enterprise applications in Child Care, Child Welfare, Medicaid, TANF, and SNAP programs. The role emphasizes backend development with Microsoft SQL Server (SSIS/SSRS) while also supporting ASP.NET and front-end functionality.

The ideal candidate will have strong SQL Server experience, database design, ETL, reporting, and C#/.NET application development, collaborating with front-end developers and business

Qualifications

  • Bachelor’s degree in Computer Science or related field.
  • 5 years of experience with Microsoft SQL Server 2012/2016/2019.
  • 5 years expert-level T-SQL development.
  • 5 years in database modeling and design.
  • 5 years of experience developing and maintaining SSIS packages and batch processes.
  • 5 years of experience developing and maintaining SSRS reports.
  • 5 years of experience optimizing SQL queries and maintaining data integrity.
  • 2 years of experience with C#, .NET Framework, and OO design.
  • 2 years of RESTful APIs and services.
  • 2 years of experience using LINQ.
  • 5 years of experience with Visual Studio 2012/2015/2017.
  • Experience creating database migration scripts using schema and data comparison tools.
  • Experience developing maintainable, testable code.
  • Experience troubleshooting ASP.NET applications.

Responsibilities

  • Design, develop, enhance, and maintain large transaction-processing and reporting databases.
  • Support modernization of legacy applications using current technologies.
  • Integrate in-house apps with enterprise and third-party solutions.
  • Design, create, and implement database systems based on requirements.
  • Develop and maintain SQL Server schemas, tables, and data dictionaries.
  • Translate business requirements into technical solutions and database models.
  • Develop, maintain, and troubleshoot T-SQL scripts, stored procedures, triggers, and DB objects.
  • Troubleshoot and optimize SQL queries and performance using profiling and tuning tools.
  • Develop, maintain ASP.NET applications, including front-end UI components (MVC preferred).
  • Develop and maintain RESTful APIs and services for integration.
  • Build, maintain, and deploy ETL packages with SSIS.
  • Develop, enhance, and troubleshoot SSRS reports.
  • Create and manage database migration scripts using tools.
  • Collaborate with front-end developers and business teams.
  • Test changes before staging and obtain user approval.
  • Follow procedures for code migration and post-production support.
  • Use TFS/Azure DevOps to manage source code and changes.
  • Perform troubleshooting and ongoing maintenance.
  • Apply best practices and cost-effective solutions.
  • Share knowledge and mentor other SQL developers when needed.

Skills

SQL Server
T-SQL
Database modeling
SSIS
SSRS
C#/.NET
RESTful APIs
LINQ
ASP.NET
MVC
Azure DevOps
Visual Studio
SQL Server Profiler
Performance Monitor
Execution plans

Education

Bachelor’s degree in Computer Science or related field

Tools

TFS
Visual Studio
Azure DevOps

Job description

Job Summary

We are seeking an experienced Full Stack Developer to support and enhance enterprise applications serving Child Care, Child Welfare, Medicaid, TANF, and SNAP programs. This role will primarily focus on backend development using Microsoft SQL Server, including SSIS and SSRS, while also supporting ASP.NET applications and front-end functionality. The ideal candidate will have strong experience in SQL Server development, database design, performance tuning, ETL processes, reporting, and C#/.NET application development. The candidate will collaborate with front-end developers and business stakeholders to translate requirements into effective technical solutions, troubleshoot application issues, and support system enhancements and modernization initiatives.

Key Responsibilities
  • Design, develop, enhance, and maintain large transaction-processing and reporting databases.
  • Support the modernization of legacy applications using current technologies and development practices.
  • Integrate in-house applications with enterprise and third-party solutions.
  • Design, create, and implement database systems based on business and end-user requirements.
  • Develop and maintain database schemas, tables, and data dictionaries using SQL Server 2012, 2016, and 2019.
  • Translate business requirements into technical solutions, application enhancements, and database models.
  • Develop and maintain efficient, documented T-SQL scripts, stored procedures, triggers, and database objects.
  • Troubleshoot and optimize SQL queries, stored procedures, and database performance using SQL Server Profiler, Performance Monitor, DBCC commands, Database Engine Tuning Advisor, and execution plans.
  • Recommend query, indexing, and database design improvements to enhance performance and maintain data integrity.
  • Develop, maintain, and troubleshoot ASP.NET applications, including front-end UI components; experience with MVC is highly preferred.
  • Develop and maintain RESTful APIs and services to support application integration.
  • Build, maintain, and deploy ETL packages and workflows using SQL Server Integration Services (SSIS).
  • Develop, enhance, and troubleshoot reports using SQL Server Reporting Services (SSRS).
  • Create and manage database migration scripts using schema and data comparison tools.
  • Collaborate with front-end developers and business teams to analyze requirements and design effective solutions.
  • Thoroughly test application and database changes before staging deployment and obtain appropriate user approval before production implementation.
  • Follow established procedures for code migration, deployment, and post-production support.
  • Use Team Foundation Server (TFS) and/or Azure DevOps to manage source code and development changes.
  • Perform application and database troubleshooting, performance tuning, and ongoing maintenance.
  • Research and apply development best practices, organizational policies, and cost-effective technical solutions.
  • Share technical knowledge and provide guidance to other SQL developers when required.
Required Qualifications
  • Bachelor’s degree in Computer Science or a related field, or equivalent relevant work experience.
  • 5 years of experience working with Microsoft SQL Server versions 2012, 2016, and 2019.
  • 5 years of expert-level T-SQL development experience.
  • 5 years of experience in database modeling and design.
  • 5 years of experience developing and maintaining SSIS packages and batch processes.
  • 5 years of experience developing and maintaining SSRS reports.
  • 5 years of experience optimizing SQL queries, improving database performance, and maintaining data integrity.
  • 2 years of experience with C#, .NET Framework, and object-oriented design and development.
  • 2 years of experience designing, developing, and maintaining RESTful APIs and services.
  • 2 years of experience using LINQ.
  • 5 years of experience with Microsoft Visual Studio versions 2012, 2015, and 2017.
  • Experience creating database migration scripts using schema and data comparison tools.
  • Experience developing efficient, consistent, maintainable, and testable code.
  • Experience troubleshooting and maintaining ASP.NET applications.
  • Ability to analyze business requirements and translate them into effective technical solutions.
  • Ability to work independently with evolving or minimal requirements and refine application functionality as requirements become clearer.
  • Understanding of infrastructure components and their dependencies, including servers, virtual systems, networks, databases, and web applications.
  • Strong analytical, troubleshooting, communication, and teamwork skills.
Desired Qualifications
  • Experience working with Microsoft Azure cloud services.
  • Experience using Power BI.
  • Experience with ASP.NET MVC application development.
  • Experience supporting legacy application modernization and enterprise system integrations.
Technical Skills
  • Database: Microsoft SQL Server 2012/2016/2019, T-SQL, database modeling, schema design, stored procedures, triggers, indexing, performance tuning.
  • ETL & Reporting: SSIS, SSRS, batch processing, report development, data migration.
  • Programming: C#, .NET Framework, object-oriented programming, LINQ.
  • Web Development: ASP.NET, MVC, RESTful APIs, front-end UI troubleshooting.
  • Development Tools: Visual Studio 2012/2015/2017, TFS, Azure DevOps.
  • Database Performance Tools: SQL Server Profiler, Performance Monitor, DBCC Commands, Database Engine Tuning Advisor, execution plans.
  • Cloud & Analytics: Microsoft Azure, Power BI.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior .NET/SQL Full-Stack Developer
Senior .NET/SQL Full-Stack Developer

Apollo Technology Solutions LLC • Des Moines (IA)

Remote
USD 90,000 - 130,000
Senior Full Stack Developer — SQL/ETL & .NET
Senior Full Stack Developer — SQL/ETL & .NET

JPS Tech Solutions • Florida

On-site
USD 90,000 - 140,000
Remote Senior .NET/SQL Full-Stack Engineer
Remote Senior .NET/SQL Full-Stack Engineer

Apollo Technology Solutions LLC • Des Moines (IA)

Remote
USD 90,000 - 130,000
Senior .NET/SQL Full-Stack Developer
Senior .NET/SQL Full-Stack Developer

Mbi Llc • Des Moines (IA)

Hybrid
USD 90,000 - 120,000
Full Stack Software Developer
Full Stack Software Developer

Base One Technologies • New York (NY)

On-site
USD 90,000 - 130,000
Senior Fullstack Developer
Senior Fullstack Developer

HROne • Cranberry Township

On-site
USD 90,000 - 130,000
Full Stack Developer
Full Stack Developer

Arcfield • King George (VA)

On-site
USD 85,000 - 120,000
Sr .Net Developer Full Stack Developer
Sr .Net Developer Full Stack Developer

SmartIMS Inc. • Wilmington (DE)

On-site
USD 120,000 - 180,000
.NET Full Stack Developer
.NET Full Stack Developer

Hrimoveisararaquara • Alhambra (CA)

Hybrid
USD 120,000 - 170,000
Full-Stack Microsoft Developer
Full-Stack Microsoft Developer

Healthy Pet LP • Ferndale (WA)

On-site
USD 100,000 - 150,000