Sign InSign Up
AGE Solutions

Database Engineer and Architect

AGE Solutions
Apply
14 days ago
Philadelphia, PA, USASenior

Responsibilities

  • Define relational, dimensional, denormalized, integration, service-oriented, transactional, analytical, semantic, and enterprise information-delivery architecture patterns.
  • Develop conceptual, logical, and physical data models, ERDs, architecture artifacts, and implementable data structures.
  • Translate business and technical requirements into SQL, database, integration, and data-service designs.
  • Architect Informatica-based data movement, transformation, orchestration, quality, and source-to-target mapping solutions.
  • Define API-driven and service-oriented data-access and integration patterns.
  • Design solutions for data lineage, change-impact analysis, data quality, metadata, stewardship, governance, security, and authoritative-source management.
  • Develop and maintain Oracle SQL and PL/SQL packages, procedures, functions, triggers, views, and related database objects.
  • Optimize database and data-engineering performance using indexes, constraints, partitions, sequences, query patterns, and integration workloads.
  • Assess Oracle and Microsoft SQL Server legacy implementations and define PostgreSQL migration and modernization strategies.
  • Establish database and data-engineering standards, design patterns, development practices, automated testing, and technical review processes.
  • Evaluate emerging database, integration, cloud, container, and data-platform technologies.
  • Support storage architecture, deployments, releases, testing, conversion, upgrades, production implementation, semantic modeling, and master/reference data strategies.

Requirements

  • U.S. citizenship and the ability to achieve a NACLC security clearance are required.
  • At least 5 years of related experience is required.
  • 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 and PL/SQL, across multiple relational database technologies.
  • Experience with conceptual, logical, and physical data architecture, ERDs, data modeling, relational design, performance engineering, and complex SQL development.
  • Experience architecting enterprise ETL and data-integration solutions using Informatica or comparable technologies.
  • Understanding of PostgreSQL, APIs and data services, containerization, CI/CD, metadata, lineage, and data quality.
  • Experience with ERwin or comparable enterprise modeling tools.
  • Knowledge of data governance, stewardship, metadata management, data quality, lineage, traceability, authoritative data sources, classification, and governance controls.
  • Hands-on PostgreSQL architecture, development, or Oracle-to-PostgreSQL modernization experience.
  • Experience defining API/service-oriented data-access and integration patterns and semantic or information models.
  • Experience establishing reusable database and data-engineering standards across development teams.
  • Familiarity with MinIO, PostgreSQL, Azure SQL, Amazon Aurora, Snowflake, Databricks, and comparable modern data platforms.
  • Experience defining modern .NET data-access patterns using Entity Framework and ORM approaches, including allocation of data-access, business-logic, and transaction responsibilities.
  • Exposure to Azure DevOps Server/TFS, Visual Studio, and Git.
  • Prior DoD or government contracting experience is required; military medical supply chain experience is a plus.
  • Experience with Azure DevOps or Jenkins, Microsoft Azure, Docker, Kubernetes, TFS, Jira, GitHub, GitLab, SonarQube, or Fortify is relevant.
  • Candidates must reside within commutable distance of Northeast Philadelphia, Pennsylvania.

Benefits

  • 26 days of paid leave covering vacation, sick, personal time, and holidays.
  • Performance bonuses based on individual and company-wide results.
  • 401(k) with a 3% company match and immediate vesting.
  • Company-paid life insurance up to $300,000, with additional coverage options.
  • Medical, dental, vision, FSA, and HSA plans.
  • 15 days of fully paid parental leave.
  • Military differential pay during active-duty service.
  • Paid training and certifications, tuition reimbursement, and work tools and technology.
  • Hybrid work with onsite client support each Wednesday; additional onsite work may be required at the government’s discretion, with occasional customer travel.
  • Professional office environment involving primarily sedentary computer work and possible remote or hybrid work based on customer and contract requirements.

Tech Stack

AzureDatabricksDockerGitInformaticaJenkinsKubernetesMicrosoft SQL Server.NETPostgreSQLSnowflakeSonarQubeSQLTensorFlow

Categories

Data Engineering
Contact me