Note: The job is a remote job and is open to candidates in USA. CGS Business Solutions connects IT professionals with consulting and full-time opportunities. The company is seeking a Senior Database Developer / Engineer to design, develop, integrate, support, and optimize enterprise applications and databases for a Digital Mortgage ecosystem, including data integration, pipeline management, troubleshooting, testing, documentation, and production support.
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
Skills
- Bachelor's Degree in Computer Science, Management Information Systems, or a related technical field (equivalent professional experience)
- 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
- 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
- 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
- 3-5 years of experience using scripting language for task automation, PowerShell is preferred
- Strong verbal and written communication skills to clearly explain technical issues to non-technical stakeholders
- 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
- Ability to work after-hours and willingness to join an on-call support and system maintenance
- 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
- California, United States
- Colorado, United States
- Experience with Azure SQL, Azure Data Factory, or Microsoft Fabric is highly preferred
- PowerShell is preferred
Benefits
- Remote (California & Colorado only)
Company Overview