Senior Database Developer Engineer Hybrid Orange County CA

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 committed to helping you, as an esteemed IT Professional, find the next right step in your career. We match professionals like you to rewarding consulting or full-time opportunities in your area of expertise. We are currently seeking Technical Professionals who are searching for challenging and rewarding jobs for the following opportunity:

Our nationwide Mortgage customer is seeking a Senior Database Developer / Engineer responsible for the design, development, integration, support, and optimization of enterprise applications, databases, and technology solutions supporting the Digital Mortgage ecosystem. This role serves as a senior technical resource, partnering with business leaders, vendors, and technology teams to deliver scalable, secure, and reliable solutions that improve operational efficiency and business performance.

Duties and Responsibilities

• Development: Analyze complex business requirements and translate them into functional technical specifications. Write clean, scalable code (MS SQL and .NET C#) across multi-platforms under the guidance of senior technical architects.
• Data Forensics: Analyze database schemas and perform data forensics to reverse engineer existing systems, locate defects, and understand data lineage.
• Data Integration: Utilize advanced SQL knowledge to develop robust processes handling high volumes of data via native SSIS, REST APIs, and Azure integrations.
• Pipeline Management: Build and maintain automated frameworks for data import, data export, and secure file transfers.
• Full-Stack Support: Troubleshoot issues across different layers including databases, application code, operating systems, and server networks.
• Vendor Coordination: Work with third-party software vendors to troubleshoot and resolve application defects.
• DevOps & Testing: Maintain source code control within DevOps pipelines and write comprehensive automated testing scripts.
• Documentation: Create and update technical system manuals, root cause analysis (RCA) reports, and deployment logs.
• Production Support: Provide operational tier-3 application support and participate in an after-hours on-call for system support/upgrades. Perform daily database monitoring for server performance and utilization to address and prevent system bottlenecks.

Qualifications and Requirements

• Education: Bachelor's Degree in Computer Science, Management Information Systems, or a related technical field (equivalent professional experience).
• Database Skills: 3-5 years of advanced, hands-on experience with Microsoft SQL Server. Proven ability in writing complex queries, index optimization, and performance tuning. Mastery of backend database processing including triggers, service brokers, CLR functions/procedures, parsing and rendering JSON/XML data, and advanced SSIS package development. Experience with Azure SQL, Azure Data Factory, or Microsoft Fabric is highly preferred.
• Development Stack: 3-5 years of core experience with the Microsoft stack, specifically .NET Framework/.NET Core, .NET MVC, ASP.NET, SQL CLR, and C#. Strong familiarity maintaining source control, managing branching strategies, and configuring CI/CD deployment pipelines within Azure DevOps or GitHub.
• Web & Integration: 3-5 years hands-on experience with JSON and XML, JavaScript, Base64 encoding, and RESTful API integrations (Azure API management is a plus). Including experience troubleshooting event-based and distributed processes.
• Scripting: 3-5 years of experience using scripting language for task automation, PowerShell is preferred.
• Communication: Strong verbal and written communication skills to clearly explain technical issues to non-technical stakeholders.
• Work Ethic: A results-oriented individual who is a quick learner and thrives in a fast-paced environment. Take initiatives and collaborate with team members to resolve system issues.
• Flexibility: Ability to work after-hours and willingness to join an on-call support and system maintenance.
• Mortgage Experience: 0-3 years in the mortgage industry, supporting Loan Origination Systems Encompass, VESTA, MortgageBot or ancillary applications ImageFlow, Loan Vision. Some understanding of data workflows in mortgage loan origination, underwriting, compliance, or post-closing quality control.

About CGS Business Solutions:

CGS specializes in IT business solutions, staffing and consulting services. With a strong focus in IT Applications, Network Infrastructure, Information Security, and Engineering. CGS is an INC 5000 company and is honored to be selected as one of the Best IT Recruitment Firms in California. After five consecutive Fastest Growing Company titles, CGS continues to break into new markets across the USA. Companies are counting on CGS to attract and help retain these resource pools in order to gain a competitive advantage the rapidly changing business environments.

Compensation: $140,000-$155,000 per year