Senior Full Stack Developer (.NET / SQL Server / Test Automation)

Lancesoft; West Sacramento (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

Lancesoft in West Sacramento is seeking a Senior Full Stack Developer to design, develop, test, and support enterprise web applications using C#, ASP.NET, and SQL Server. You will collaborate with cross-functional teams across the SDLC and contribute to automation and quality assurance initiatives.

Ideal candidates have 8+ years in software development with strong SQL Server and test automation experience, plus solid knowledge of MVC, JavaScript, and development best practices.

Qualifications

• 8+ years in application development using C#, ASP.NET, and MVC.
• 8+ years with Microsoft SQL Server and data modeling.
• 5+ years in test automation and QA tooling.
• Experience with SDLC processes and defect tracking.

Responsibilities

• Design, develop, and maintain enterprise web applications.
• Build scalable solutions using C#, ASP.NET, MVC, and JavaScript.
• Develop and optimize SQL Server databases and queries.
• Create automated test scripts and testing frameworks.
• Collaborate with cross-functional teams throughout SDLC.

Skills

C#

ASP.NET

.NET Framework

MVC

JavaScript

jQuery

HTML

XML

Education

Bachelor's Degree in Computer Science, Information Technology, Engineering, or related field

Tools

JIRA

Client ALM

Bugzilla

JAMA

Job description

Senior Full Stack Developer (.NET / SQL Server / Test Automation) Job Overview We are seeking a highly skilled Senior Full Stack Developer with strong expertise in Microsoft technologies, SQL Server development, and test automation. The ideal candidate will be responsible for designing, developing, testing, enhancing, and supporting enterprise web applications while collaborating with cross-functional teams throughout the Software Development Life Cycle (SDLC). This role requires a combination of hands-on software development, database development, automated testing, defect management, and business requirements analysis experience.

Key Responsibilities

• Design, develop, enhance, and maintain enterprise-level web applications.
• Build scalable solutions using C#, ASP.NET, .NET Framework, MVC, JavaScript, jQuery, HTML, and XML.
• Develop and optimize SQL Server databases, stored procedures, views, functions, and complex queries.
• Analyze business and technical requirements and translate them into technical solutions.
• Participate in application architecture, design reviews, code reviews, and SDLC activities.
• Develop, execute, and maintain automated test scripts and regression testing frameworks.
• Create reusable automation libraries and testing utilities.
• Perform functional, regression, integration, and performance testing.
• Execute data validation and reporting activities.
• Identify, troubleshoot, and resolve software defects through root cause analysis.
• Utilize defect tracking and test management tools such as JIRA, Client ALM, Bugzilla, or similar platforms.
• Prepare and maintain technical documentation, software design documents, test plans, and test strategies.
• Support deployment activities, production releases, and post-production issue resolution.
• Collaborate with business, technical, and QA teams to ensure successful project delivery.

Required Qualifications

Application Development

• 8+ years of experience with: C# ASP.NET .NET Framework MVC Architecture Object-Oriented Programming (OOP) JavaScript jQuery HTML XML

Database Development

• 8+ years of experience with Microsoft SQL Server.
• Expertise in: Stored Procedures Complex SQL Queries Data Modeling Database Design Data Validation Reporting Joins, Grouping, and Sorting Logic

Test Automation

• 5+ years of experience developing automated test solutions.
• Experience creating: Automation Frameworks Regression Test Suites Shared Automation Libraries Automated Validation Processes
• Experience using Java, Python, Shell Scripting, or similar technologies for automation.

Quality Assurance & Testing

• 5+ years of experience in: Functional Testing Regression Testing Integration Testing Performance Testing Test Planning Test Strategy Development Test Case Design Test Result Analysis Defect Management
• 5+ years of experience using: JIRA Client ALM Bugzilla JAMA Similar defect management platforms

Documentation & Analysis

• Experience creating and maintaining: Test Plans Test Strategies Test Specifications Technical Documentation Requirements Documentation
• Strong analytical and problem-solving skills.
• Experience gathering and documenting business and functional requirements.

Preferred Qualifications

• Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related technical field.
• Advanced Microsoft SQL Server expertise, including: T-SQL Triggers Views User Defined Functions (UDFs) Performance Tuning
• Experience with parallel and automated testing methodologies.
• Experience supporting large-scale enterprise, financial, pension, insurance, or government applications.
• Knowledge of Agile and DevOps methodologies.
• Excellent written and verbal communication skills.
• Ability to work independently and within cross-functional teams.