{"schemaVersion":"jobsearcher.job.v1","id":"5ebfb0c07220e427e248de90","url":"https://jobsearcher.com/jobs/5ebfb0c07220e427e248de90","canonicalUrl":"https://jobsearcher.com/jobs/5ebfb0c07220e427e248de90","title":"SQL Developer","description":"Location: Remote Timings: 2pm to 11pmExperience: 10+ yearsOpenings: 01Notice: immediateJob Description – SQL Server Developer.We are seeking a highly skilled Senior SQL Server Developer with deep expertise in database design, complex query development, and performance optimization. The ideal candidate will have strong technical problem-solving abilities and hands-on experience with payroll-related calculations and systems.Key Responsibilities:Database Development: Design, develop, and maintain complex SQL Server databases, stored procedures, functions, views, and triggers.Complex Query Writing: Write and optimize complex T-SQL queries, including joins, aggregations, window functions, CTEs, dynamic SQL, and query performance tuning.Stored Procedure Development: Build, debug, and optimize large, enterprise-scale stored procedures with a focus on performance and reliability.Problem Solving: Analyze and resolve critical database issues, including performance bottlenecks, deadlocks, data integrity issues, and production incidents.Payroll Domain Knowledge: Develop and support payroll calculation logic, including wage calculations, deductions, overtime, taxes, bonuses, and timesheet/payroll integrations.Performance Tuning: Optimize query execution plans, indexing strategies, and database performance for high-volume transactional systems.Data Integrity & Security: Implement robust transaction handling, error handling, data validation, and security best practices.Collaboration: Work closely with application developers, DBAs, business analysts, and payroll/HR stakeholders to deliver accurate and efficient data solutions.Code Reviews & Mentoring: Conduct code reviews, mentor junior developers, and enforce best practices for database development.Required Skills & Experience:10+ years of professional experience in SQL Server development.Strong proficiency in T-SQL, including stored procedures, functions, triggers, views, and complex queries.Proven experience writing and optimizing complex SQL queries for large datasets.Deep understanding of SQL Server internals: indexing, execution plans, query optimization, and performance tuning.Demonstrated ability to solve critical technical problems under pressure.Hands-on experience with payroll calculations and/or payroll systems.Experience with SQL Server 2016/2017/2019/2022/ Azure SQL MIStrong understanding of transaction management, concurrency, and error handling.Experience using AI-assisted development tools (e.g., GitHub Copilot, ChatGPT, SQL-specific AI assistants) to write, optimize, and review SQL code.","company":"Artech","rawCompany":"artech","city":"Portland","state":"ME","isRemote":false,"isActive":false,"createdAt":"2026-09-17T08:08:01.089Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1251.00","title":"Computer Programmers","slug":"computer-programmers"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"SQL Developer","description":"Location: Remote Timings: 2pm to 11pmExperience: 10+ yearsOpenings: 01Notice: immediateJob Description – SQL Server Developer.We are seeking a highly skilled Senior SQL Server Developer with deep expertise in database design, complex query development, and performance optimization. The ideal candidate will have strong technical problem-solving abilities and hands-on experience with payroll-related calculations and systems.Key Responsibilities:Database Development: Design, develop, and maintain complex SQL Server databases, stored procedures, functions, views, and triggers.Complex Query Writing: Write and optimize complex T-SQL queries, including joins, aggregations, window functions, CTEs, dynamic SQL, and query performance tuning.Stored Procedure Development: Build, debug, and optimize large, enterprise-scale stored procedures with a focus on performance and reliability.Problem Solving: Analyze and resolve critical database issues, including performance bottlenecks, deadlocks, data integrity issues, and production incidents.Payroll Domain Knowledge: Develop and support payroll calculation logic, including wage calculations, deductions, overtime, taxes, bonuses, and timesheet/payroll integrations.Performance Tuning: Optimize query execution plans, indexing strategies, and database performance for high-volume transactional systems.Data Integrity & Security: Implement robust transaction handling, error handling, data validation, and security best practices.Collaboration: Work closely with application developers, DBAs, business analysts, and payroll/HR stakeholders to deliver accurate and efficient data solutions.Code Reviews & Mentoring: Conduct code reviews, mentor junior developers, and enforce best practices for database development.Required Skills & Experience:10+ years of professional experience in SQL Server development.Strong proficiency in T-SQL, including stored procedures, functions, triggers, views, and complex queries.Proven experience writing and optimizing complex SQL queries for large datasets.Deep understanding of SQL Server internals: indexing, execution plans, query optimization, and performance tuning.Demonstrated ability to solve critical technical problems under pressure.Hands-on experience with payroll calculations and/or payroll systems.Experience with SQL Server 2016/2017/2019/2022/ Azure SQL MIStrong understanding of transaction management, concurrency, and error handling.Experience using AI-assisted development tools (e.g., GitHub Copilot, ChatGPT, SQL-specific AI assistants) to write, optimize, and review SQL code.","datePosted":"2026-09-17T08:08:01.089Z","dateModified":"2026-09-17T08:08:01.089Z","hiringOrganization":{"@type":"Organization","name":"Artech","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Portland","addressRegion":"ME","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"5ebfb0c07220e427e248de90"},"url":"https://jobsearcher.com/jobs/5ebfb0c07220e427e248de90"}}