Database Engineer and Architect

agecareers; Philadelphia (Philadelphia County); On-site; USD 120,000 - 160,000; Full time

Job summary

AGE Solutions is seeking a Database Engineer and Architect to craft foundational data and database architectures for loading, integrating, and governing critical medical logistics information for U.S. government clients.

The role emphasizes hands-on Oracle SQL/PL/SQL with leadership in PostgreSQL migration, Informatica-based integration, API-enabled services, and containerized platforms in a modern data-engineering context.

Qualifications

• Minimum of 5 years of related experience in enterprise database and data-engineering.
• Hands-on SQL and database engineering experience, including Oracle SQL/PL/SQL.
• Experience designing conceptual, logical, and physical data architectures and translating business requirements into implementable solutions.

Responsibilities

• Analyze business problems and define database and data-architecture patterns (relational, dimensional, denormalized, integration, SOA).
• Develop and maintain data models and architecture artifacts; create ERDs and data models for implementation teams.
• Architect data integration solutions (Informatica) and establish API-driven data-access patterns; ensure lineage and governance.

Skills

SQL/PLSQL

Data modeling

Enterprise architecture

Tools

Informatica

PostgreSQL

CI/CD/containers

Job description

About Us

AGE Solutions is a premier technology and professional services company, providing in-depth consulting, advanced technology solutions, and essential services throughout the U.S. government, defense, and intelligence sectors. Prioritizing innovation and client-focused solutions, we assist major agencies in addressing intricate issues and ensuring a more secure future.

We are 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 requires hands-on Oracle SQL and PL/SQL credibility while leading the transition toward PostgreSQL, Informatica-based integration, API-enabled services, containerized platforms, enterprise information modeling, lineage, data quality, and modern engineering practices. Data, and information derived from it, is the lifeblood of the government and military medical supply chain, and you will support crucial customers and business needs while helping shape the future-state database and information architecture.

Responsibilities

• Analyze business problems and define appropriate 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.

Required Skills, Qualifications, and Experience

• Citizenship and Security Clearance:
  • Must be a U.S. citizen.
  • Must be able to achieve a NACLC clearance.
• Experience and Skills:
  • Minimum of 5 years 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, with demonstrated ability to architect solutions across multiple relational database technologies.
  • Demonstrated 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.
  • Demonstrated understanding of modern data architecture patterns including PostgreSQL, APIs/data services, containerization, CI/CD, metadata, lineage, and data quality.
  • Experience working with modeling