Database Engineer

The Database Engineer (.NET Developer) provides senior-level application development and database engineering support to SSA’s Data Strategy and Enablement (DSAE) Data Administration team. The primary focus is designing and developing applications for the Data Administration Standard Suite (DASS) portal, with current emphasis on implementing security measures and architecting authentication flows using OpenID Connect. The role also supports database engineering activities including schema design, data modeling, and query optimization across enterprise data standards, reference data architecture, and Global Reference Tables (GRTs).

Design Tasks:

· Design, develop, and maintain applications for the Data Administration Standard Suite (DASS) portal using .NET, .NET Core, C#, Blazor, JavaScript, HTML, and CSS.

· Design and architect authentication flows for the DASS portal using OpenID Connect and related identity and access management standards, in alignment with SSA’s security requirements.

· Implement security measures across DASS portal components, including secure authentication, authorization, session management, and integration with SSA’s identity and access infrastructure.

· Develop, test, and maintain software supporting Data Administration infrastructure and tools, including DASS portal services, supporting APIs, and related backend components.

· Modernize legacy Visual Basic for Applications (VBA) code and Excel macros by reading, interpreting, and migrating existing logic into maintainable C# .NET Core solutions.

· Apply modern system design principles including Domain-Driven Design (DDD), Event-Driven Architecture, and Service-Oriented Architecture to align Data Administration solutions with SSA’s IT Framework.

· Apply Test-Driven Development (TDD) practices throughout the application and database development lifecycle, leveraging automated testing frameworks such as Selenium where applicable.

· Provide DevOps support leveraging Azure DevOps and CI/CD pipelines to enable efficient build, release, and deployment workflows for DASS and related Data Administration tools.

· Provide database engineering support for DASS and related Data Administration applications, including database schema design and development across PostgreSQL, SQL Server, DB2, and Oracle.

· Perform logical and physical data modeling activities using Erwin (V12.5.2 and later) and Hackolade in support of DASS, Reference Data Architecture, and Global Reference Tables (GRTs).

· Write and optimize LINQ and SQL queries to improve application performance and database efficiency for DASS and related solutions.

· Conduct data analysis, data profiling, and quality assessments to identify issues, improvement opportunities, and recommendations across enterprise datasets.

· Support batch processing in distributed computing environments, including job orchestration and workflow development.

· Provide recommendations on Open File Formats including JSON, XML, Avro, Kafka, and MongoDB, and on code metadata schemas.

· Conduct requirements elicitation, analysis, and technical writing for planning, design, and project documentation related to DASS and Data Administration tools.

· Communicate and collaborate with stakeholders across SSA components in a blended developer and database engineering capacity, moving fluidly between application development, security design, database engineering, analysis, and communication responsibilities.

· Develop technical documents, status reports, and presentations to fulfill work order objectives.

Do you have a Associate’s degree?, · Bachelor’s degree in Computer Science, Information Systems, Data Management, or related technical field; Associate’s degree with 7+ years of relevant experience may substitute for the bachelor’s degree requirement.

· Minimum 7+ years of relevant experience in application development, database engineering, or enterprise data management.

· Strong experience with C#, .NET, .NET Core, Blazor, JavaScript, HTML, and CSS in a senior developer capacity.

· Demonstrated experience designing and architecting authentication flows using OpenID Connect and related identity and access management standards.

· Demonstrated experience implementing security measures within enterprise web applications, including secure authentication, authorization, and session management.

· Experience designing, developing, and maintaining .NET-based portals, internal applications, or enterprise tools in a federal or large enterprise environment.

· Experience modernizing and migrating legacy VBA and Excel macro code to C# .NET Core.

· Experience applying Domain-Driven Design, Event-Driven Architecture, and Service-Oriented Architecture principles.

· Experience applying Test-Driven Development (TDD) practices; familiarity with Selenium or similar automated testing frameworks preferred.

· Experience with Azure DevOps and CI/CD pipeline development.

· Experience with database schema design and development across PostgreSQL, SQL Server, DB2, and Oracle.

· Experience with logical and physical data modeling using Erwin (V12.5.2 and later) and Hackolade.

· Experience writing and optimizing LINQ and SQL queries for performance and database efficiency.

· Experience with batch processing in distributed computing environments.

· Familiarity with Open File Formats including JSON, XML, Avro, Kafka, and MongoDB.

· Experience with web server management and configuration in enterprise environments.

· Experience with Microsoft Office Suite (including advanced Excel), Visio, Confluence, and SharePoint.

· Strong technical writing, problem-solving, and analytical skills with the ability to translate business needs into technical solutions.

· Strong interpersonal and communication skills, both written and verbal, with the ability to develop executive-level communications and presentations.

· Familiarity with federal IT environments preferred.

Must be able to obtain and maintain a Public Trust.