Database Engineer and Architect

AGE Solutions • Philadelphia, PA

1d • $135,000 • Hybrid

About The Position

AGE Solutions is seeking a Database Engineer and Architect to create foundational data and database architectures for loading, integrating, managing, executing, governing, and maintaining critical medical logistics information. The role combines hands-on Oracle SQL and PL/SQL engineering with technical leadership in modernizing toward PostgreSQL, Informatica-based integration, API-enabled services, containerized platforms, enterprise information modeling, data lineage, data quality, and modern engineering practices. The position supports government and military medical supply chain customers and helps shape future-state database and information architecture.

The role involves defining database, data-engineering, integration, and service-oriented architecture patterns; developing conceptual, logical, and physical data models; translating business requirements into implementable database and data-service designs; and keeping designs traceable to enterprise concepts, semantic definitions, authoritative sources, business rules, and information products. It also provides technical leadership for Informatica-based integration and establishes approaches for lineage, metadata, governance, quality, security, and authoritative-source management.

The successful candidate will assess legacy Oracle and Microsoft SQL Server implementations and define modernization strategies, including PostgreSQL migration, API/service enablement, modern integration patterns, and containerized deployment. The role supports database and data-platform architecture, deployments, releases, testing, conversion, upgrades, production implementation, semantic modeling, and authoritative, master, and reference data strategies. Candidates must reside within commuting distance of Northeast Philadelphia, Pennsylvania. The role is hybrid, with onsite client support each Wednesday; onsite requirements may increase at the government’s discretion. Work is primarily in a professional office environment, with potential remote or hybrid work depending on customer and contract requirements and occasional travel based on project needs.

Requirements

• Must be a U.S. citizen.
• Must be able to achieve a NACLC clearance.
• Minimum of 5 years of related experience.
• Demonstrated experience leading and architecting enterprise database and data-engineering solutions from business need and conceptual design through implementation.
• Strong hands-on SQL and database engineering experience, including Oracle SQL/PL/SQL, and ability to architect solutions across multiple relational database technologies.
• Experience designing conceptual, logical, and physical data architectures and translating business information requirements into implementable technical solutions.
• Proficiency in database design and architecture, ERDs, data modeling, relational design, performance engineering, and complex SQL development.
• Experience architecting enterprise ETL/data-integration solutions using Informatica or comparable enterprise integration technologies.
• Understanding of modern data architecture patterns including PostgreSQL, APIs/data services, containerization, CI/CD, metadata, lineage, and data quality.
• Experience with ERwin or comparable enterprise modeling technologies.
• Knowledge of enterprise data governance principles, standards, and practices, including stewardship, metadata management, data quality, lineage and traceability, authoritative data sources, information classification, and governance-driven architecture controls.
• Hands-on PostgreSQL architecture, development, or Oracle-to-PostgreSQL modernization experience.
• Experience defining API/service-oriented data-access and integration patterns.
• Experience with semantic/information modeling, authoritative-source identification, metadata management, lineage, traceability, and change-impact analysis.
• Experience establishing reusable database/data-engineering standards and architecture patterns across development teams.
• Familiarity with data-storage and data-platform architectures, including object storage such as MinIO and platforms such as PostgreSQL, Azure SQL, Amazon Aurora, Snowflake, and Databricks, with understanding of architectural use cases, integration patterns, and tradeoffs.
• Experience defining architecture patterns for modern .NET data access, including Entity Framework and ORM-based approaches, and guiding the placement of data access, business logic, and transaction responsibilities across database, application, integration, and service layers.
• Exposure to version control systems and development platforms such as Azure DevOps Server/TFS, Visual Studio, and Git.
• Technical knowledge of Oracle (SQL, PL/SQL), PostgreSQL, and Microsoft SQL Server.
• Technical knowledge of Informatica and related enterprise ETL/data-integration technologies.
• Technical knowledge of ERwin and related enterprise modeling technologies.
• Technical knowledge of Toad for Oracle, Oracle SQL Developer, and Visual Studio.
• Technical knowledge of .NET, Entity Framework/Entity Framework Core, LINQ, APIs, and service-oriented data-access patterns.
• Technical knowledge of Azure DevOps Server 2022, Git, and CI/CD.
• Technical knowledge of Docker, Kubernetes, APIs/services, and Microsoft Azure.
• Must reside within commuting distance of Northeast Philadelphia, Pennsylvania.
• Must be able to perform the essential functions of the position, with or without reasonable accommodation.

Nice To Haves

• Prior experience in a DoD or government contracting environment.
• Military Medical Supply Chain experience.
• Experience with CI/CD concepts or tools such as Azure DevOps or Jenkins.
• Experience with DevOps/cloud services using an infrastructure-as-a-service provider such as Microsoft Azure.
• Experience with containerization technologies such as Docker or Kubernetes.
• Experience with configuration management and collaboration tools such as TFS, Jira, GitHub, or GitLab.
• Experience with static code analysis tools such as SonarQube or Fortify.

Responsibilities

• Analyze business problems and define suitable database and data architecture patterns, including relational, dimensional, denormalized, integration, and service-oriented approaches.
• Define database and data-engineering architecture patterns for transactional, analytical, semantic, integration, and enterprise information-delivery needs.
• Develop and maintain conceptual, logical, and physical data models, translating business concepts, rules, and relationships into implementable data structures and integration designs.
• Create ERDs, data models, and architecture artifacts using enterprise modeling techniques and tools to communicate solution designs and support implementation teams.
• Translate business needs into long-term architecture solutions and actionable SQL, database, integration, and data-service designs that meet business and technical requirements.
• Ensure logical and physical data designs remain traceable to enterprise concepts, semantic definitions, authoritative sources, business rules, and consuming information products.
• Architect enterprise data integration solutions and provide technical leadership for Informatica-based data movement, transformation, orchestration, quality, and source-to-target mapping.
• Define API-driven and service-oriented data-access and integration patterns that reduce tightly coupled application-to-database dependencies.
• Design solutions enabling end-to-end lineage, change-impact analysis, data quality, metadata, stewardship, governance, security, and authoritative-source management.
• Analyze complex datasets and develop database solutions, SQL, PL/SQL packages, procedures, functions, triggers, views, and related database objects as needed.
• Optimize database and data-engineering performance through effective design of indexes, constraints, partitions, sequences, query patterns, and integration workloads.
• Assess legacy Oracle and Microsoft SQL Server implementations and define modernization strategies, including PostgreSQL migration, API/service enablement, modern integration patterns, and containerized deployment.
• Establish and enforce database and data-engineering standards, design patterns, development practices, automated testing, and technical/code review processes.
• Evaluate emerging databases, integration, cloud, container, and data-platform technologies and recommend adoption aligned with enterprise architecture and modernization goals.
• Support data-storage architecture, deployments, releases, testing, conversion, upgrades, production implementation, semantic modeling, and authoritative/master/reference data strategies.

Benefits

• 26 days of paid leave, including vacation, sick, personal time, and holidays.
• Performance bonuses based on individual contributions and company-wide results.
• 401(k) with a 3% company match and immediate vesting.
• Company-paid life insurance up to $300,000, with options for additional coverage for employees and dependents.
• Multiple medical plans, dental insurance, vision insurance, and FSA and HSA options.
• 15 days of fully paid parental leave for new parents.
• Military differential pay for employees on active duty.
• Paid training and certifications, tuition reimbursement, and tools and technology for the job.
• The CEO has committed to returning 80% of net proceeds to employees in the event of a company sale.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed