Database Engineer and Architect

The role

The Database Engineer and Architect will create foundational data and database architectures for medical logistics information. This role involves leading transitions toward PostgreSQL, Informatica-based integration, and modern engineering practices.

What you will do

• Analyze business problems and define database and data architecture patterns.
• Define database and data-engineering architecture patterns for various needs.
• Develop and maintain conceptual, logical, and physical data models.
• Create ERDs, data models, and architecture artifacts.
• Translate business needs into long-term architecture solutions and actionable designs.
• Ensure logical and physical data designs remain traceable to enterprise concepts.
• Architect enterprise data integration solutions and provide technical leadership for Informatica-based movement.
• Define API-driven and service-oriented data-access and integration patterns.
• Design solutions enabling lineage, data quality, and governance.
• Analyze complex datasets and develop database solutions, SQL, and PL/SQL packages.

Required qualifications

• Must be a U.S. citizen.
• Must be able to achieve a NACLC clearance.
• Minimum of 5 years related experience.
• Experience leading and architecting enterprise database and data-engineering solutions.
• Strong hands-on SQL and database engineering experience, including Oracle SQL/PL/SQL.
• Experience designing conceptual, logical, and physical data architectures.
• Proficiency in database design, architecture, ERDs, data modeling, and performance engineering.
• Experience architecting enterprise ETL/data-integration solutions using Informatica or comparable technologies.
• Understanding of modern data architecture patterns including PostgreSQL, APIs, containerization, CI/CD, metadata, lineage, and data quality.
• Experience working with modeling tools such as ERwin or comparable technologies.
• Knowledge of enterprise data governance principles, standards, and practices.
• Hands-on PostgreSQL architecture, development, or Oracle-to-PostgreSQL modernization experience.

Nice to have

• 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).

Benefits

• 26 Days Paid Leave: Includes vacation, sick, personal time, and holidays.
• Performance Bonuses.
• 401(k) with Match: 3% match with immediate vesting.
• Company-paid life insurance up to $300K.
• Multiple medical plans, dental, vision, FSA and HSA options.
• 15 days of fully paid parental leave.
• Military Differential Pay.
• Paid training and certifications.
• Tuition reimbursement.
• CEO commitment to return 80% of net proceeds to employees in the event of a company sale.

Before you apply

• Must be a U.S. citizen.
• Must be able to achieve a NACLC clearance.
• Candidates must reside within a commutable distance of Northeast Philadelphia, PA.

About the company

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.