SQL Developer Job Torrance area,California USA,Software Development

Duration:
Long-term Contract Opportunity with Multiple Years of Potential Extension

Visa Policy: C2C candidates will not be considered. We welcome H1B candidates who are open to an H1B transfer opportunity with us.

KEY RESPONSIBILITIES

This role requires strong ownership of end-to-end database solutions including design, development, deployment, and production support in a regulated and audit-compliant environment.

Senior SQL Developer Tasks

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

WHAT WILL THIS PERSON BE WORKING ON

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 inhouse personnel to diagnose and fix operational difficulty, as well as consulting, advising and training on specialized features and functions

Collaborates with Dev Ops teams to support CI/CD pipelines, version control, and automated deployment processes

Ensures all development activities comply with audit, security, and regulatory requirements.

WANTS

Strong hands-on experience with Microsoft SQL Server technologies, including T-SQL, SSIS, stored procedures, views, functions, triggers, and indexing strategies
Experience in Automotive Finance industry preferred
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
Self-starter with ability to work independently in a fast-paced production environment
Strong communication skills with ability to collaborate across business and technical teams
Ability to handle high-pressure production incidents and drive resolution to closure
Detail-oriented with focus on accuracy, auditability, and documentation
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 Dev Ops) and CI/CD pipelines
Experience with data modeling (OLTP and Data Warehouse concepts)

Required Qualifications

Bachelors degree in Computer Science, Information Systems, or related field (or equivalent experience)
7-10+ years of experience in SQL development and database engineering
Proven experience working in large-scale, high-volume transactional systems
Experience handling…