Database Architect-PostgreSQL-Provo, UT-Onsite

1 view
Skip to first unread message

David Miller

unread,
Sep 16, 2025, 10:35:52 AM (4 days ago) Sep 16
to

Role: Database Architect

Location: Provo, UT(Onsite from day 1)

Duration: 12+ months

 

Key Skills:

Main experience required in PostgreSQL and Neo4js graph database

 

Role Overview:

We are seeking a highly skilled Database Architect to lead the modernization of our Commissions Applications (V&G – Volumes & Genealogy). The current application leverages Oracle (CREW), and the front-end is being modernized from AngularJS to a React-based Progressive Web App (PWA).

The Database Architect will be responsible for evaluating and selecting the right target database platforms, designing schemas and data models, and ensuring a successful migration strategy. The role requires strong expertise across multiple database technologies and the ability to design for scalability, hierarchical data modeling, and performance optimization.

 

Key Responsibilities:

  • Assess the current Oracle (CREW) database and define a comprehensive migration strategy.
  • Evaluate and recommend the optimal target databases depending on use cases, including:
  • Relational – Oracle, PostgreSQL
  • NoSQL – DynamoDB
  • Graph – AWS Neptune, Neo4j
  • (Optional) Analytical/Warehousing – Redshift, Snowflake
  • Design schemas, data models, and indexing strategies that efficiently handle hierarchical/genealogy-style relationships.
  • Drive performance optimization, including query tuning, partitioning, caching strategies, and data distribution.
  • Define patterns for data ingestion, integration, and event-driven interactions between applications and databases.
  • Collaborate with application and engineering teams to ensure seamless integration with the modernized React PWA front-end.
  • Provide technical leadership to Database Engineers executing schema conversion, data migration, and optimization tasks.
  • Maintain architectural documentation, data dictionaries, and migration roadmaps.
  • Ensure all designs align with security, compliance, and governance standards.
  • Required Skills and Qualifications:
  • 10+ years of experience in database architecture and design, with significant expertise in Oracle.
  • Proven experience migrating from Oracle to other database platforms.
  • Strong hands-on expertise with multiple databases:
  • PostgreSQL (RDS/Aurora)
  • DynamoDB (NoSQL)
  • Graph databases – AWS Neptune, Neo4j
  • Deep knowledge of data modeling for hierarchical/relationship-heavy applications.
  • Expertise in database performance tuning and optimization.
  • Strong SQL skills with ability to analyze, refactor, and optimize complex queries.
  • Familiarity with Python or Node.js for scripting, automation, and migration support.

Nice to Have:

  • Familiarity with AWS services (RDS, Aurora, DynamoDB, Neptune, ElastiCache).
  • Exposure to data warehousing solutions (Amazon Redshift, Snowflake).
  • Experience with serverless/data pipelines (Lambda, EventBridge, Step Functions).
  • Background in commissioning/financial systems with genealogy-style hierarchical data.
  • AWS Certifications (Database Specialty, Solutions Architect – Professional).
Reply all
Reply to author
Forward
0 new messages