hirly

Agecareers

Database Engineer and Architect

Philadelphia, PA

hirly Pro

Get in front of the people hiring at Agecareers

  • Reach the hiring manager at Agecareers on LinkedIn, from your own account
  • hirly applies to this job for you, with unlimited applications
  • A resume and cover letter written for this job, unlimited
  • The hiring manager and recruiter at Agecareers, with contact details
Get Pro for this job →

$49 a month · ₹1,999 for 30 days in India · cancel any time

See how you match this job — and similar ones. Free.

Upload your resume and hirly scores it against this role at Agecareers first, then against similar open jobs, and shows where you fit and why.

PDF or DOCX, up to 12MB. No sign-up to see your matches.

Get past the screening software and onto a recruiter's desk

hirly rewrites your resume for this job — matching the keywords and skills in the posting, moving your most relevant experience to the top, and writing a cover letter to fit. About 30 seconds.

  • Keywords matched to this posting
  • Fit score before you apply
  • Cover letter included

Matched against 2.8M live jobs from 220,000+ employers in 200+ countries.

Tailor my resume for this job →

Apply from your AI assistant

Connect hirly to Claude or ChatGPT and ask it to apply to this job. hirly tailors your resume, fills the employer’s form and asks before sending.

Some employer sites stop an application at a CAPTCHA or sign-in and hand it back with a link. Applying needs a paid plan. Works with any assistant that supports MCP.

hirly's read of this role

Seniority
Mid level
Country
US
Work mode
Remote-friendly
First seen by hirly
29 Oct 2026

Derived automatically from the posting. Upload your resume above to see how the role scores against it.

the posting

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 Include:

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 tools such as ERwin or comparable enterprise modeling technologies.

Demonstrated knowledge of enterprise data governance principles, standards, and practices, including data 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 modern data-storage and data-platform architectures, including object storage such as MinIO, and modern relational, cloud-native, distributed, and analytical platforms such as PostgreSQL, Azure SQL, Amazon Aurora, Snowflake, Databricks, and comparable enterprise technologies, with an understanding of appropriate architectural use cases, integration patterns, and tradeoffs.

Experience defining architecture patterns for modern .NET data access, including Entity Framework and object-relational mapping (ORM)-based approaches, and guiding the appropriate 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.

Prior experience in a DoD or government contracting environment.

Military Medical Supply Chain experience is a big plus.

Experience with CI/CD concepts or tools (e.g., Azure DevOps, Jenkins).

Experience with DevOps/cloud services using an infrastructure-as-a-service provider (e.g., Microsoft Azure).

Experience with containerization technologies (e.g., Docker, Kubernetes).

Experience with configuration management and collaboration tools (e.g., TFS, Jira, GitHub, GitLab).

Experience with static code analysis tools (e.g., SonarQube, Fortify).

Technical Knowledge:

Database & Data Platforms: Oracle (SQL, PL/SQL), PostgreSQL, Microsoft SQL Server

Data Integration: Informatica and related enterprise ETL/data integration technologies

Data Modeling: ERwin and related enterprise modeling technologies

Development & Database Tools: Toad for Oracle, Oracle SQL Developer, Visual Studio

Application Data Access: .NET, Entity Framework / Entity Framework Core, LINQ, APIs and service-oriented data-access patterns

DevSecOps & Version Control: Azure DevOps Server 2022, Git, CI/CD

Modern Platform Technologies: Docker, Kubernetes, APIs/services, Microsoft Azure

Location:

Candidates must reside within a commutable distance of Nort

Original posting on Agecareers's site ↗

Listed on hirly, a job board. hirly is not the employer: Agecareers is hiring for this role.

Browse similar roles

Want this one?

Upload your resume and hirly rewrites it for this job and writes the cover letter — in about thirty seconds, before you sign up.

Tailor my resume for this job