Senior SQL Developer in Torrance, CA, 90501 Onsite (4 days/week)

Job Description

Job Description

(RK07)

Description:

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:

o   Lead application development and production support for multiple large-scale enterprise systems

o   Perform root cause analysis (RCA) of production issues and implement permanent fixes to improve system stability

o   Troubleshoot Mid-tier MS SQL Server online and batch processing issues, ensuring SLA adherence

o   Evaluate and optimize daily and monthly batch processes to improve performance and reduce critical path execution time

o   Design, develop, and implement database solutions with a focus on scalability, performance, and reliability

o   Perform impact analysis across multiple platforms and applications, ensuring downstream dependencies are understood

o   Ensure data integrity, reconciliation, and control mechanisms are in place for all critical data processes

o   Deliver complete and audit-compliant documentation for estimates, design, development, and testing artifacts

o   Automate monitoring, alerting, and operational processes to improve system reliability

o   Participate in on-call production support during off-office hours (night and weekend) and handle incidents based on defined SLAs

o   Follow and enforce change management, release, and SOX/audit compliance processes

What Will This Person Be Working On

o   Codes, designs, and performs unit, integration, and performance testing to ensure scalable and efficient execution aligned with business and technical requirements

o   Codes, tests, and debugs new software or makes enhancements to existing software

o   Develops and reviews programs and database objects based on business requirements and technical design specifications

o   Develops technical documentation

o   Resolves in a timely manner problems that arise with existing production applications to ensure the efficient and proper functioning of application components

o   Designs and implements scalable database structures, including data models (OLTP and dimensional models)

o   Collaborates with technical staff to learn and understand software problems

o   Generates a variety of complex and periodic reports and/or data through database management, data administration and data extraction techniques

o   Provides general system users and management with system analysis and feedback

o   Influences system design by identifying and recommending design and requirements needs for software enhancements

o   Performs advanced SQL performance tuning, including query optimization, indexing strategies, and execution plan analysis

o   Mentors and coaches less experienced staff

o   Maximizes the efficiency of the various software systems by implementing, monitoring, testing and auditing new software programs

o   Conducts code reviews and enforces development standards and best practices across the team

o   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

o   Follows established configuration/change control processes

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

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

Wants

o   Strong hands-on experience with Microsoft SQL Server technologies, including T-SQL, SSIS, stored procedures, views, functions, triggers, and indexing strategies

o   Experience in Automotive Finance industry preferred

o   Strong understanding of auto finance lifecycle ( loan origination, servicing, collections, accounting, end-of-term processing, and regulatory processes )

o   Familiarity with test practices and deliverables for unit testing

o   Self-starter with ability to work independently in a fast-paced production environment

o   Strong communication skills with ability to collaborate across business and technical teams

o   Ability to handle high-pressure production incidents and drive resolution to closure

o   Detail-oriented with focus on accuracy, auditability, and documentation

o   Knowledge of Salesforce Service & Marketing cloud platform is preferred

o   Experience in working in Agile and Waterfall methodologies.

o   Strong expertise in SQL performance tuning , query optimization , and database design

o   Experience with batch processing systems and performance optimization of large data volumes

o   Experience with version control systems (e.g., Git, Azure DevOps ) and CI/CD pipelines

o   Experience with data modelling (OLTP and Data Warehouse concepts)

Required Qualifications:

o   Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience)

o   7–10+ years of experience in SQL development and database engineering

o   Proven experience working in large-scale, high-volume transactional systems

o   Experience handling production support and incident management in enterprise environments

Required Skills:

o   10+ years of hands-on SQL development experience in enterprise environments

o   Strong expertise in T-SQL programming and performance tuning

o   Experience supporting production systems with SLA-driven support models

o   Experience in Agile and/or Waterfall methodologies

o   Strong analytical and problem-solving skills

Nice to Have:

o   Experience in the Automotive Finance industry

o   Exposure to cloud platforms (AWS preferred )

o   Experience with reporting tools ( SSRS, Power BI )

TechLink Systems is a national provider of staffing services with offices all over the USA as well as development and support centers globally. We are a MBE (NMSDC), WBE (WBENC), and WOSB certified minority business that has been awarded 2017 TAPFIN Premier Partner, 2016 Manpower Excellence Award, 2016 TAPFIN Elite Partner, are a Known Tier Supplier for Agile 1, and have been ranked as a Top Women and Minority Owned Company since 2004 by several businesses including Philadelphia Business Journal, Diversity Business, Inc 5000, Inc 500, San Francisco Business Times, Diversity2000, and Los Angeles Business Journal.

We serve the contract staffing, direct hire, staff augmentation, recruitment, HR management, and project outsourcing needs of clients nationwide. Striving to create personal relationships with clients, TechLink Systems becomes a virtual extension of clients’ own in-house capabilities to help achieve new levels of growth, productivity, and competitiveness.

Company Description

TechLink Systems is a national provider of staffing services with offices all over the USA as well as development and support centers globally. We are a MBE (NMSDC), WBE (WBENC), and WOSB certified minority business that has been awarded 2017 TAPFIN Premier Partner, 2016 Manpower Excellence Award, 2016 TAPFIN Elite Partner, are a Known Tier Supplier for Agile 1, and have been ranked as a Top Women and Minority Owned Company since 2004 by several businesses including Philadelphia Business Journal, Diversity Business, Inc 5000, Inc 500, San Francisco Business Times, Diversity2000, and Los Angeles Business Journal. \r\n\r\nWe serve the contract staffing, direct hire, staff augmentation, recruitment, HR management, and project outsourcing needs of clients nationwide. Striving to create personal relationships with clients, TechLink Systems becomes a virtual extension of clients’ own in-house capabilities to help achieve new levels of growth, productivity, and competitiveness.