SQL Database Engineer
Company | OneMain Financial |
---|---|
Location | Salt Lake City, UT, USA |
Salary | $Not Provided – $Not Provided |
Type | Full-Time |
Degrees | Bachelor’s |
Experience Level | Senior |
Requirements
- 5 years of experience with Microsoft SQL Server and deep T-SQL expertise.
- Proven ability to develop complex database processes and business logic.
- Strong skills in query optimization, performance tuning, and execution plan analysis.
- Experience with SQL Server Enterprise features.
- Proficiency in managing and debugging SQL Server Agent jobs.
- Hands-on experience using Extended Events for performance diagnostics.
- Strong communication and collaboration skills.
Responsibilities
- Design and develop complex database processes and logic using advanced T-SQL.
- Write and maintain stored procedures, views, triggers, and functions to support application and reporting needs.
- Optimize queries and indexes for performance in high-transaction SQL Server environments.
- Leverage SQL Server Enterprise features such as partitioning, compression, and in-memory tables.
- Create, manage, and troubleshoot SQL Server Agent jobs and scheduled processes.
- Use Extended Events and other diagnostic tools to analyze and improve performance.
- Support and enhance reporting workflows integrated with Telerik.
- Implement CLR-based logic where needed to extend database capabilities.
- Collaborate with application developers and business analysts to integrate and align database solutions with business objectives.
Preferred Qualifications
- Experience with CLR integration.
- Familiarity with Telerik reporting tools or similar reporting environments.
- Experience in Auto Finance, Consumer Finance, Banking, or Accounting Technology.
- Interest in and ability to discuss technical concepts beyond own immediate work.
- Applies enthusiasm for continuous learning to improve contributions and maintains craftsman like approach to work and, generally, understands how own work fits into broader technical strategy.
- BS degree in a computer related field.
- Excellent communications.