Senior SQL Developer

Insight Talent Solutions | Cloud Recruiting And Custom Workforce Solutions Providers - Torrance, CA

Full-time - Senior

Hybrid - Torrance, CA

About the position

The Senior SQL Developer position involves application development and production support for multiple large projects, focusing on troubleshooting, performance evaluation, and documentation. The role requires collaboration with technical staff and mentoring of less experienced team members, ensuring efficient execution of software and adherence to business requirements.

Responsibilities

• Application Development and Production Support for multiple large projects
• Research and resolve production issues, troubleshooting of Mid-Tier MS SQLServer 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)
• 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 promptly 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 with 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 inhouse personnel to diagnose and fix operational difficulties, as well as consulting, advising, and training on specialized features and functions
• Follows established configuration/change control processes

Requirements

• Degree in Computer Science, Engineering or equivalent
• Strong experience using SQL technologies (stored procedure, views, DTS package, etc.)
• 8+ years of strong SQL Development experience
• Excellent understanding on T-SQL programming with Microsoft SQL Server
• Experience with SQL Server Reporting services and SQL Server Analysis Services
• Experience with modern relational databases is preferred
• Familiarity with ETL/ELT processes; knowledge of Informatica is a plus (Required 3 Years)
• Experience working in SSIS and SSRS
• Excellent organizational, interpersonal, presentation, and analytical skills
• Ability to perform comfortably in a fast-paced, deadline-oriented work environment
• Ability to successfully execute multiple complex tasks simultaneously
• Ability to work as a team member, as well as independently
• Team player with excellent written and oral communication skills
• 8+ years of experience in the design, development and implementation of SQL Server databases creating and maintaining T-SQL Procedures, functions, packages, and triggers
• Excellent organizational and time management skills; ability to work independently and solve problems
• Self-starter with the ability to identify what tasks need to be prioritized based on the impact(s) on the environment and team
• Experience in the Automotive Finance industry is 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
• Experience in working in Agile and Waterfall methodologies

Nice-to-haves

• Experience in the Automotive Finance industry is preferred
• Familiarity with ETL/ELT processes; knowledge of Informatica is a plus