SQL Developer

Senior SQL Developer Location: Torrance, CA (Hybrid role 2 days office) 12 Plus Months Contract

Daily Tasks Performed: As a SQL Developer, this person will perform the following tasks, but not limited to:

• Application Development and Production Support for multiple large projects
• Research and resolve production issues, troubleshooting of Mid-Tier MS SQL Server online and batch issues
• Evaluate the daily and monthly batch process to improve performance and shorten the critical path window
• Perform Impact Analysis across multiple platforms and applications
• Deliver complete documentation for estimates, design and development
• On-call for production support during off-office hours (night and weekend).

What will this person be working on:

• Codes and performs unit and integration testing of software to ensure proper and efficient execution and adherence to business and technical requirements
• Codes, tests, and debugs new software or makes enhancements to existing software
• Writes programs according to specifications from higher level staff or business analysts
• 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
• 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
• Mentors and coaches less experienced staff
• Maximizes the efficiency of the various software systems by implementing, monitoring, testing and auditing new software programs
• 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, * Codes and performs unit and integration testing of software ensure proper and efficient execution and adherence to business and technical requirements
• Codes, tests, and debugs new software or makes enhancements to existing software
• Writes programs according to specifications from higher level staff or business analysts
• Develops technical documentation
• Resolves in a timely manner problems that arise with existing production applications to ensure efficient and proper functioning of application components.
• 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
• Mentors and coaches less experienced staff
• Maximizes the efficiency of the various software systems by implementing, monitoring, testing and auditing new software programs
• Analyses 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

• Must have strong experience using SQL technologies (stored procedure, views, DTS package, etc.)
• Experience in Automotive Finance industry preferred
• Business knowledge of financial services, Understanding of financial services automotive lending, Customer Service, Payment Processing, Taxes, End of Term and Extension processes, Collections, Delinquency Tracking, Repossession, Charge Off, Recovery, Bankruptcy, and Accounting.
• Familiarity with test practices and deliverables for unit testing
• Interpersonal style that fits the Company culture
• Knowledge of Salesforce Service & Marketing cloud platform is preferred

• Experience in working in Agile and Waterfall methodologies from impact analysis across multiple platforms and applications

• Deliver complete documentation for estimates, design and development
• On-call for production support during off-office hours (night and weekend)., * Must have strong experience using SQL technologies (stored procedure, views, DTS package, etc.)
• Experience in Automotive Finance industry preferred
• Business knowledge of financial services, understanding of financial services automotive lending, customer service, payment processing, taxes, end of term and extension processes, collections, delinquency tracking, repossession, charge off, recovery, bankruptcy, and accounting.
• Familiarity with test practices and deliverables for unit testing
• Interpersonal style that fits the Company culture
• Knowledge of Salesforce Service & Marketing cloud platform is preferred
• Experience in working in Agile and Waterfall methodologies.