FOR IMMEDIATE DETAILS about this position, please feel free to contact EITHER of US and REFERENCE the JOB#:

MICHELL CASEY: (949) 860-4715 or MCasey@calance.com
TRENT CASEY: (949) 558-4246 or TCasey@calance.com

=======================================================
- - We will NOT accept 3rd Party (C2C) Contractors - -
=======================================================

JOB DETAILS:
Position: Sr. SQL Developer
JOB REF#: 44806 - JIH5JP00004489
Duration: 12+ Months (On-Going Contract)
Location: HYBRID - Torrance, CA 90501
Pay Rate: $70.50 per hour (W2 Only)

HYBRID: Must work ONSITE MON-THUR each week (LOCAL CANDIDATES)

HIRING REQUIREMENTS:
- - NOT accepting any 3rd Party C2C/C2H candidates for any reason- -
- - NOT accepting candidates who live more than 45 miles from Torrance- -
- - NOT accepting candidates willing to relocate (LOCAL CANDIDATES Only)- -

Sr. SQL Developer will have strong ownership of end-to-end database solutions including design, development, deployment, and production support in a regulated and audit-compliant environment.

RESPONSIBILITIES INCLUDE:
Lead application development and production support for multiple large-scale enterprise systems
Perform root cause analysis (RCA) of production issues and implement permanent fixes to improve system stability
Troubleshoot Mid-tier MS SQL Server online and batch processing issues, ensuring SLA adherence
Evaluate and optimize daily and monthly batch processes to improve performance and reduce critical path execution time
Design, develop, and implement database solutions with a focus on scalability, performance, and reliability
Perform impact analysis across multiple platforms and applications, ensuring downstream dependencies are understood
Ensure data integrity, reconciliation, and control mechanisms are in place for all critical data processes
Deliver complete and audit-compliant documentation for estimates, design, development, and testing artifacts
Automate monitoring, alerting, and operational processes to improve system reliability
Participate in on-call production support during off-office hours (night and weekend) and handle incidents based on defined SLAs
Follow and enforce change management, release, and SOX/audit compliance processes

DAILY TASKS:
Codes, designs, and performs unit, integration, and performance testing to ensure scalable and efficient execution aligned with business and technical requirements
Codes, tests, and debugs new software or makes enhancements to existing software
Develops and reviews programs and database objects based on business requirements and technical design specifications
Develops technical documentation
Resolves in a timely manner problems that arise with existing production applications to ensure the efficient and proper functioning of application components
Designs and implements scalable database structures, including data models (OLTP and dimensional models)
Collaborates with technical staff to learn and understand software problems
Generates a variety of complex and periodic reports and/or data through database management, data administration and data extraction techniques
Provides general system users and management with system analysis and feedback
Influences system design by identifying and recommending design and requirements needs for software enhancements
Performs advanced SQL performance tuning, including query optimization, indexing strategies, and execution plan analysis
Mentors and coaches less experienced staff
Maximizes the efficiency of the various software systems by implementing, monitoring, testing and auditing new software programs
Conducts code reviews and enforces development standards and best practices across the team
Analyzes and resolves computer related problems by coordinating with in house personnel to diagnose and fix operational difficulty, as well as consulting, advising and training on specialized features and functions
Follows established configuration/change control processes
Collaborates with DevOps teams to support CI/CD pipelines, version control, and automated deployment processes
Ensures all development activities comply with audit, security, and regulatory requirements

REQUIRED SKILLS/EXPERIENCE:
10+ years of hands-on SQL development experience in enterprise environments
7+ years of experience in SQL development and database engineering
Strong expertise in T-SQL programming and performance tuning
Experience supporting production systems with SLA-driven support models
Proven experience working in large-scale, high-volume transactional systems
Experience handling production support and incident management in enterprise environments
Experience in Agile and/or Waterfall methodologies
Strong analytical and problem-solving skills
Strong communication skills with ability to collaborate across business and technical teams
Detail-oriented with focus on accuracy, audit ability, and documentation
EDUCATION: Bachelor s degree in Computer Science, Information Systems, or related field (or equivalent experience)

Preferred Skills:
Strong hands-on experience with Microsoft SQL Server technologies, including T-SQL, SSIS, stored procedures, views, functions, triggers, and indexing strategies
Strong understanding of auto finance lifecycle (loan origination, servicing, collections, accounting, end-of-term processing, and regulatory processes)
Familiarity with test practices and deliverables for unit testing
Knowledge of Salesforce Service & Marketing cloud platform is preferred
Experience in working in Agile and Waterfall methodologies.
Strong expertise in SQL performance tuning, query optimization, and database design
Experience with batch processing systems and performance optimization of large data volumes
Experience with version control systems (e.g., GIT, Azure DevOps) and CI/CD pipelines
Experience with data modeling (OLTP and Data Warehouse concepts)

DESIRED SKILLS:
Experience in the Automotive Finance industry
Exposure to cloud platforms (AWS preferred)
Experience with reporting tools (SSRS, Power BI)

==========================================
==========================================

Calance Consultant Benefits Offerings:

• EPO/PPO Medical Plans
• HMO/PPO Dental programs

- Vision - VSP (Vision Plan Summary)

• 401K Retirement vesting program (VOYA)
• Paid Bi-Weekly/Direct Deposit
• Flex Spending Plan
• Voluntary Life, AD&D, STD or LTD plans