Database Engineer and Architect at Agecareers · LumiJobs

Responsibilities

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.

Database Engineer and Architect

Responsibilities

Qualification

Required

Benefits

Company

Agecareers

More roles at Agecareers