Senior Database Engineer - Hybrid (MS SQL / .NET)

CGS Business Solutions; Irvine (CA); On-site; USD 140,000 - 155,000; Full time

Job summary

CGS Business Solutions is seeking a Senior Database Developer/Engineer to design, develop, integrate, and optimize enterprise databases supporting the Digital Mortgage ecosystem. You will collaborate with business leaders, vendors, and tech teams to deliver scalable, secure solutions.

You will analyze complex requirements, implement data integration via SSIS, REST, and Azure, and provide production support with after-hours on-call.

Qualifications

• Bachelor's Degree in Computer Science, MIS, or related field (or equivalent professional experience).
• 3–5 years with Microsoft SQL Server; complex queries, performance tuning; SSIS and data processing incl. JSON/XML.
• 3–5 years with .NET stack (.NET Framework/.NET Core, MVC, ASP.NET, C#); CI/CD in Azure DevOps or GitHub.
• 3–5 years with JSON/XML, JavaScript, RESTful APIs; Azure API management a plus.
• 3–5 years scripting; PowerShell preferred.
• Strong communication to explain technical issues to non-technical stakeholders.
• Willingness to on-call and work after-hours; fast-paced environment.
• 0–3 years Mortgage experience with Encompass, VESTA, MortgageBot, ImageFlow, Loan Vision.

Responsibilities

• Development: Analyze requirements and write scalable MS SQL and C# code.
• Data Forensics: Analyze schemas, reverse engineer systems, locate defects, and trace data lineage.
• Data Integration: Develop robust processes handling high data volumes via SSIS, REST APIs, and Azure integrations.
• Pipeline Management: Build and maintain automated data import/export and secure file transfers.
• Full-Stack Support: Troubleshoot across databases, application code, OS, and networks.
• Vendor Coordination: Work with third-party vendors to troubleshoot defects.
• DevOps & Testing: Maintain source control and automated tests in DevOps pipelines.
• Documentation: Create RCA reports, deployment logs, and technical manuals.
• Production Support: On-call support and daily DB monitoring to prevent bottlenecks.

Skills

MS SQL Server

C#.NET

Azure

REST APIs

JavaScript

PowerShell

CI/CD

DevOps

Education

Bachelor's Degree in Computer Science or MIS

Tools

SSIS

Azure DevOps

GitHub

Azure Data Factory

Microsoft Fabric

Job description

CGS Business Solutions is seeking a Senior Database Developer/Engineer to design, develop, integrate, and optimize enterprise databases supporting the Digital Mortgage ecosystem. You will collaborate with business leaders, vendors, and tech teams to deliver scalable, secure solutions.

You will analyze complex requirements, implement data integration via SSIS, REST, and Azure, and provide production support with after-hours on-call.