Apply on
Original
Simplified
Job Description
Job Description Company Description
Role: SQL Developer
Location: Torrance, CA
Duration: 12+ months
Contract Type: W2 only NO Corp to Corp applicants
- Designing and streamlining our data operations and maintaining our database to ensure peak performance.
- Understanding business strategy and cascades business intelligence needs to the database level.
- Database tables design based transactional and analytical requirements
- Create complex queries. Trouble shoot production issues affecting database issues, performance issues, and answer/investigate data issues
- Create/Maintain/Deploy SSIS packages
- Application Development and Production Support for multiple large projects
- Research and resolve production issues, troubleshooting of Mid-Tier MS SQL Server on-line and batch abends
- 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) may be required.
- Create and execute SQL statements and perform complex data analysis
- Create/Modify SQL Server code/packages including SSIS/Stored Procedures/Handle error conditions
Academic/Experience/Competency Requirements:
- BA/BS in Information Technology, Computer Science, related field or equivalent work experience.
- 5+ years of experience as SQL Developer
- Proficient with columnar databases and distributed SQL Query engine
- Database development experience using T-SQL, creating/updating stored procedures/creating/updating SQL Functions & Triggers
- Experience working with SQL XML on SQL Server 2019 or higher
- Experience working on Sql Server 2019 or higher
- Demonstrated experience in troubleshooting and resolving database problems
- Experience with full software development lifecycle and delivery using Agile
- Data analytical skills and ability to analyze large datasets is required.
- Advanced ability to utilize Sql traces and debugging tools for problem/issue resolution
- Advanced ability to analyze and model business functions, processes and information flow within or between systems
- Hands on experience working with SQL XML on SQL Server 2008 r2 or higher
- Hands on experience creating/updating/deploying SSIS packages
- Excellent analytical skills to understand the requirements and designing appropriate database schemas
Nice to Have
- 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 the Salesforce Service & Marketing cloud platform preferred
TenTek has been in business since 1989 and is recognized as a leading staffing provider of tech professionals to a growing client base.
Company Description
TenTek has been in business since 1989 and is recognized as a leading staffing provider of tech professionals to a growing client base.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job Similar Jobs