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

Performance Bonuses

401(k) with Match

Health Benefits

Parental Leave

Military Differential Pay

Professional Growth

Shared Success

Job summary

AGE Solutions is seeking a Database Engineer and Architect to design foundational data architectures for loading, integrating, and governing medical logistics information. You will work hands-on with Oracle SQL/PL/SQL while guiding a transition toward PostgreSQL, Informatica-based integration, API-enabled services, containerized platforms, and mature data governance.

The role requires citizenship and NACLC clearance, with a hybrid work model and onsite Wednesdays near Northeast Philadelphia, PA.

Qualifications

• Hands-on Oracle SQL/PL/SQL development
• Experience with PostgreSQL modernization
• ETL/data-integration design using Informatica
• Proficiency in data modeling and ER diagrams
• Experience with APIs/data services and containerization

Responsibilities

• Analyze business problems and define database architecture patterns.
• Develop conceptual, logical, and physical data models and ERDs.
• Lead enterprise data integration using Informatica and data services.

Skills

Oracle SQL

PL/SQL

PostgreSQL

Informatica

Data modeling

ETL

APIs

Containerization

CI/CD

ERwin

Tools

Toad for Oracle

Oracle SQL Developer

Visual Studio

Azure DevOps

Job description

AGE Solutions is seeking a Database Engineer and Architect to design foundational data architectures for loading, integrating, and governing medical logistics information. You will work hands-on with Oracle SQL/PL/SQL while guiding a transition toward PostgreSQL, Informatica-based integration, API-enabled services, containerized platforms, and mature data governance.

The role requires citizenship and NACLC clearance, with a hybrid work model and onsite Wednesdays near Northeast Philadelphia, PA.