Momento USA is a global technology consulting, talent acquisition, and creative development firm that addresses clients' most pressing needs and challenges. We are currently looking for a SQL Server Developer +

AI Job Title:

SQL Server Developer +

AI Location:

Oxnard, CA (Onsite)

Duration:

12+ months Job 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 MI Strong 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.

Subia Khan DESK:

,

EXT:

1032 w: e: 440 Benigno Blvd, Unit#A 2nd Floor. Bellmawr, NJ 08031

Interstate Business Park Note:

Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.