Skip to content

Open nowPosted 7 hours ago

Database Engineer and Architect

AGE Solutions74 open roles

Where
Philadelphia, PA
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowDatabase Engineer and ArchitectAGE Solutions · Philadelphia, PA
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on AGE Solutions's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

12.7% of postings close within 7 days. Measured by our own scanner across the market. AGE Solutions postings stay open a median of 32 days.

Share of postings closed within
  1. 2.2%1 day
  2. 4.5%3 days
  3. 12.7%7 days
  4. 20.4%14 days
  5. 35.6%30 days
  6. 58.7%60 days
This job: posted 7 hours ago

AGE Solutions median: 32 days open

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 Northeast Philadelphia, PA. This is a hybrid role, requiring onsite support at the client facility each Wednesday. This on-site requirement could increase at the government’s discretion.

Work Environment and Physical Demand:

  • Work is primarily performed in a professional office environment, with potential for remote or hybrid work based on customer and contract requirements.
  • Requires regular use of computers, software applications, and communication tools to perform daily responsibilities.
  • May require collaboration with technical teams, project managers, government personnel, and other stakeholders in both virtual and in-person settings.
  • Must be able to work in a fast-paced environment, manage multiple priorities, and meet established project deadlines.
  • May require occasional travel to government or customer facilities based on project needs.
  • Primarily sedentary work, involving extended periods of sitting and working at a computer.
  • Frequent use of hands and fingers for typing, operating computers, and using standard office equipment.
  • Requires the ability to communicate effectively through verbal and written communication.
  • Must be able to read and review technical documentation, computer screens, and other work-related materials.
  • Occasionally requires standing, walking, bending, and reaching during normal office activities.
  • May occasionally require lifting or moving office equipment or materials weighing up to 15 pounds.
  • Must be able to perform the essential functions of the position, with or without reasonable accommodation.

The projected salary range for this position is $135,000+ annually. Final compensation will be determined based on factors including years of relevant experience, active security clearance level, certifications, technical skillset, contract requirements, and overall qualifications.

At AGE Solutions, we reward performance, invest in growth, and share success. Our benefits support the whole person, professionally, financially, and personally.

  • 26 Days Paid Leave: Includes vacation, sick, personal time, and holidays. You choose how to use it.
  • Performance Bonuses: Performance bonuses are awarded based on individual contributions and company-wide results, aligning recognition with impact.
  • 401(k) with Match: We match 3% of your contributions with immediate vesting.
  • Financial Protection: Company-paid life insurance up to $300K and options for additional coverage for you and your dependents.
  • Health Benefits: Multiple medical plans, dental, vision, FSA and HSA options to fit your needs.
  • Parental Leave: 15 days of fully paid leave for new parents, because family matters.
  • Military Differential Pay: We bridge the gap for employees on active duty, so they don’t take a financial hit while serving.
  • Professional Growth: Paid training and certifications, tuition reimbursement, and the tools and tech to get the job done right.
  • Shared Success: In the event of a company sale, our CEO has committed to returning 80% of net proceeds to employees. This ensures our team shares in the long term value they help create.

At AGE, you’ll do work that matters, supported by a company that delivers for its people.

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against AGE Solutions's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on AGE Solutions's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    AGE Solutions's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.