Senior Database Architect & Engineer (Oracle→PostgreSQL)

Age-Solutions; Philadelphia (Philadelphia County); Hybrid; USD 122,000 - 149,000; Full time

Benefits offered by this job

26 Days Paid Leave

401(k) with Match

Health Benefits

Job summary

AGE Solutions is seeking a Database Engineer and Architect to build foundational data architectures for the medical logistics domain, leveraging Oracle SQL/PL/SQL while steering toward PostgreSQL and Informatica-based integration. You will design enterprise data models, APIs, and data governance in a hybrid on-site role near Northeast Philadelphia.

The role requires US citizenship with NACLC clearance, strong SQL skills, and experience across data platforms and containerized environments.

Qualifications

• Minimum 5 years related experience in enterprise database/data-engineering roles.
• Hands-on Oracle SQL/PL/SQL with experience across multiple RDBMS technologies.
• Experience architecting conceptual/logical/physical data architectures and translating business requirements into solutions.
• Proficiency in ER modeling, data modeling, relational design, performance engineering, and complex SQL development.
• Experience with Informatica or similar ETL/ELT tools and data integration patterns.
• Understanding of PostgreSQL, APIs/data services, containerization, CI/CD, metadata, lineage, and data quality.
• Familiarity with enterprise data governance, stewardship, metadata management, and data lineage principles.
• Experience with Oracle-to-PostgreSQL modernization and data-access pattern definitions.
• Proficiency with modeling tools (ERwin) and data-platform technologies.
• Knowledge of DoD/government contracting environments and security considerations.

Responsibilities

• Define and implement database/data-architecture patterns for transactional, analytical, and enterprise-delivery needs.
• Lead enterprise data integration using Informatica and related technologies.
• Create ERDs and data models, translating business concepts into architectures and deliverables.
• Design API-driven data-access patterns reducing tight coupling between apps and databases.
• Develop and maintain SQL/PLSQL packages, procedures, functions, and DB objects.
• Ensure data designs trace to enterprise concepts, sources, and business rules.
• Establish data governance, lineage, metadata management, and quality standards.
• Assess legacy databases and define modernization strategies, including migrations to PostgreSQL.

Skills

Strong SQL/PLSQL

Data architecture

ETL/data integration

API/data services

PostgreSQL migration

Security clearance

Enterprise modeling

Tools

Oracle SQL Developer

Toad for Oracle

ERwin

Informatica

Git

Azure DevOps

Kubernetes

Job description

AGE Solutions is seeking a Database Engineer and Architect to build foundational data architectures for the medical logistics domain, leveraging Oracle SQL/PL/SQL while steering toward PostgreSQL and Informatica-based integration. You will design enterprise data models, APIs, and data governance in a hybrid on-site role near Northeast Philadelphia.

The role requires US citizenship with NACLC clearance, strong SQL skills, and experience across data platforms and containerized environments.