Database Engineer and Architect

Description

The company provides consulting, technology solutions and support services to U.S. government, defense and intelligence agencies, helping them handle complex problems and build more secure systems.

The team needs a database engineer and architect to design the core data and database structures used to load, integrate, manage, govern and maintain medical logistics information. Practical Oracle work in SQL and PL/SQL is essential, and you will lead the move toward PostgreSQL, Informatica integration, API-based services, containers and modern engineering methods. The data supports government and military medical supply chain customers, so your designs will shape how information is built and used going forward.

Responsibilities

• Study business problems and choose suitable database and data architecture patterns, such as relational, dimensional, denormalized, integration and service-based designs.
• Define architecture patterns for transactional, analytical, semantic, integration and enterprise information delivery.
• Build conceptual, logical and physical data models that turn business concepts, rules and relationships into structures and integration designs that can be implemented.
• Produce ERDs, data models and architecture documents with enterprise modeling tools so solution designs are clear to implementation teams.
• Turn business needs into long-term architecture and practical SQL, database, integration and data service designs that meet business and technical requirements.
• Keep data designs traceable to enterprise concepts, semantic definitions, authoritative sources, business rules and the information products that use them.
• Lead the architecture of enterprise data integration, including Informatica-based data movement, transformation, orchestration, quality and source-to-target mapping.
• Design API-driven and service-based data access and integration patterns that loosen direct coupling between applications and databases.
• Create designs that support end-to-end lineage, change-impact analysis, data quality, metadata, stewardship, governance, security and authoritative source management.
• Analyze complex datasets and build database solutions, including SQL, PL/SQL packages, procedures, functions, triggers, views and related objects.
• Improve performance through sound design of indexes, constraints, partitions, sequences, query patterns and integration workloads.
• Assess legacy Oracle and Microsoft SQL Server systems and plan modernization, including PostgreSQL migration, API enablement, newer integration patterns and containerized deployment.
• Set and enforce standards, design patterns, development practices, automated testing and technical and code review processes for database and data engineering.
• Assess emerging database, integration, cloud, container and data platform technologies and recommend adoption that fits enterprise architecture and modernization goals.
• Support data storage architecture, deployments, releases, testing, conversion, upgrades, production rollout, semantic modeling and authoritative, master and reference data strategies.

Requirements

• At least 5 years of related experience.
• Proven experience leading enterprise database and data engineering work, from business need and conceptual design through to implementation.
• Strong hands-on SQL and database engineering skills, including Oracle SQL and PL/SQL, and the ability to design across several relational database platforms.
• Demonstrated experience building conceptual, logical and physical data architectures and turning business information needs into working technical solutions.
• Skill in database design, ERDs, data modeling, relational design, performance tuning and complex SQL.
• Experience designing enterprise ETL and data integration solutions with Informatica or comparable enterprise integration tools.
• Working knowledge of modern data architecture, including PostgreSQL, APIs and data services, containers, CI/CD, metadata, lineage and data quality.
• Experience with modeling tools such as ERwin or comparable enterprise modeling software.
• Solid knowledge of enterprise data governance, including stewardship, metadata management, data quality, lineage and traceability, authoritative sources, information classification and governance-driven architecture controls.
• Hands-on experience with PostgreSQL architecture or development, or with moving Oracle systems to PostgreSQL.
• Experience defining API and service-based data access and integration patterns.
• Experience with semantic and information modeling, identifying authoritative sources, metadata management, lineage, traceability and change-impact analysis.
• Experience setting reusable database and data engineering standards and architecture patterns for development teams.
• Familiarity with modern data storage and platform architectures, such as object storage like MinIO and relational, cloud-native, distributed and analytical platforms like PostgreSQL, Azure SQL, Amazon Aurora, Snowflake, Databricks and comparable products, including their suitable use cases, integration patterns and tradeoffs.
• Experience defining architecture for modern.NET data access, including Entity Framework and ORM approaches, and deciding where data access, business logic and transactions belong across database, application, integration and service layers.
• Exposure to version control and development tools such as Azure DevOps Server, TFS, Visual Studio and Git.
• Prior work in a DoD or government contracting setting.
• Experience with CI/CD tools or concepts, such as Azure DevOps or Jenkins.
• Experience with DevOps and cloud services on an infrastructure-as-a-service provider, such as Microsoft Azure.
• Experience with containers, such as Docker or Kubernetes.
• Experience with configuration management and collaboration tools, such as TFS, Jira, GitHub or GitLab.
• Experience with static code analysis tools, such as SonarQube or Fortify.
• Military medical supply chain experience is a strong plus.
• Technical tools you should know include Oracle (SQL and PL/SQL), PostgreSQL and Microsoft SQL Server; Informatica or similar integration tools; ERwin or similar modeling tools; Toad for Oracle, Oracle SQL Developer and Visual Studio;.NET, Entity Framework, Entity Framework Core, LINQ and API-based data access; Azure DevOps Server 2022, Git and CI/CD; Docker, Kubernetes, APIs and services, and Microsoft Azure.

Conditions

You must be a U.S. citizen.

You must be able to obtain a NACLC clearance.

You must live within a commutable distance of Northeast Philadelphia, PA.

This is a hybrid role with onsite work at the client facility every Wednesday. The government may increase the onsite requirement at its discretion.

Most work is done in a professional office, with possible remote or hybrid arrangements depending on customer and contract needs.

The job is mainly desk-based, with long periods sitting at a computer and regular typing.

You will use computers, software and communication tools daily and work with technical staff, project managers, government personnel and other stakeholders, in person and virtually.

You must handle several priorities at once and meet set project deadlines in a busy setting.

Occasional travel to government or customer sites may be needed.

You may occasionally stand, walk, bend, reach, or lift or move office equipment or materials up to 15 pounds.

You must read technical documents and screens, and communicate clearly in writing and speech.

The projected salary is $135,000+ per year. Final pay depends on relevant experience, active security clearance level, certifications, technical skills, contract requirements and overall qualifications.

Benefits

• 26 days of paid leave covering vacation, sick time, personal time and holidays, which you can use as you choose.
• Performance bonuses based on individual contributions and company-wide results.
• 401(k) with a 3% company match that vests immediately.
• Company-paid life insurance up to $300K, plus options for extra coverage for you and your dependents.
• Multiple medical plans, dental, vision, FSA and HSA options.
• 15 days of fully paid parental leave for new parents.
• Military differential pay that makes up the gap for employees on active duty.
• Paid training and certifications, tuition reimbursement, and the tools and technology needed to do the job well.
• Shared success: if the company is sold, the CEO has committed to returning 80% of net proceeds to employees.