Description:
Job Title: Senior SQL Developer
Location: Torrance, CA Onsite (4 days/week)
Contract Duration: 1 year with possible extension
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.
As a Senior SQL Developer, this person will perform the following tasks, but not limited to:
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 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
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 DevOps) and CI/CD pipelines
Experience with data modeling (OLTP and Data Warehouse concepts)
Required Qualifications:
Bachelor’s 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 production support and incident management in enterprise environments
Required Skills:
10+ years of hands-on SQL development experience in enterprise environments
Strong expertise in T-SQL programming and performance tuning
Experience supporting production systems with SLA-driven support models
Experience in Agile and/or Waterfall methodologies
Strong analytical and problem-solving skills
Nice to Have:
Experience in the Automotive Finance industry
Exposure to cloud platforms (AWS preferred)
Experience with reporting tools (SSRS, Power BI)
Never miss an opportunity! Create an alert based on the job you applied for.
