Metrc

Database Architect

Metrc

contract

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

SeniorLead

Tech Stack

AzureCloudETLPostgresSQL

About the role

  • Evaluate and redesign heavily denormalized SQL Server database environments.
  • Architect solutions to separate historical data from real-time OLTP workloads.
  • Reduce table bloat and optimize large-scale tables for read/write performance.
  • Optimize indexing strategies, query performance, and access patterns across large datasets.
  • Assess and execute consolidation of approximately 30 independent database pods into a unified architecture.
  • Design and implement scalable multi-tenant database models.
  • Lead migration strategy from SQL Server to PostgreSQL where appropriate.
  • Work extensively within Azure environments, including Azure SQL Hyperscale.
  • Establish data lifecycle management practices and ETL/data movement strategies.
  • Operate directly in production systems, diagnosing and resolving complex technical challenges.
  • Lead modernization efforts through hands-on execution and technical example.

Requirements

  • 8+ years of hands-on database architecture experience in large-scale production environments.
  • Bachelor’s degree in computer science, Information Systems, Engineering, or related field or equivalent experience.
  • Deep expertise with SQL Server, including performance tuning and optimization.
  • Strong experience designing, implementing, or migrating to PostgreSQL.
  • Experience with Azure cloud services, including Azure SQL Hyperscale.
  • Proven success improving performance in legacy or heavily denormalized database systems.
  • Experience designing multi-tenant or consolidated database architectures.
  • Strong understanding of OLTP optimization and data lifecycle management.
  • Strong analytical and problem-solving skills.
  • Ability to work independently with high ownership and accountability.
  • Strong communication skills to collaborate with engineering and executive leadership.
  • Relevant cloud or database certifications (Microsoft, Azure, PostgreSQL) preferred.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQL ServerPostgreSQLdatabase architectureperformance tuningOLTP optimizationdata lifecycle managementETLmulti-tenant database modelsquery performance optimizationindexing strategies
Soft Skills
analytical skillsproblem-solving skillsindependenceownershipaccountabilitycommunication skillscollaborationleadership
Certifications
Microsoft certificationAzure certificationPostgreSQL certification