Overview
Skills
Job Details
Position: SQL Server Developer
Industry: Banking
Type: 12-month contract
Location: Charlotte, NC / Jersey City, NJ (3x hybrid)
Must haves:
- Senior level experience 10+ years of hands on work.
- Deep understanding of how SQL Server processes queries, manages memory, and handles I/O.
- Familiarity with execution plans, query processor architecture, and storage engine behavior.
- Query Optimization
- Ability to analyze and rewrite inefficient queries.
- Expertise in indexing strategies, including clustered, non-clustered, filtered, and columnstore indexes.
- Knowledge of INCLUDE columns and their impact on query performance.
- Statistics and Cardinality Estimation
- Understanding how SQL Server uses statistics for query planning.
- Experience with updating, creating, and managing statistics to improve estimator accuracy.
- Proficiency in diagnosing blocking, deadlocks, and transaction isolation levels.
- Ability to tune workloads for high concurrency without sacrificing performance.
Salary and Compensation:
The hourly rate for this position is between $70 - $75 per hour. Factors which may affect pay within this range may include geography/market, skills, education, experience, and other qualifications of the successful candidate.
Benefits:
The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan, life insurance, long-term disability insurance, short-term disability insurance, paid parking/public transportation, (paid time, paid sick and safe time, hours of paid vacation time, weeks of paid parental leave, paid holidays annually - AS Applicable).