The Database Architect is a highly technical, hands-on role responsible for modernizing and redesigning Metrc’s large-scale production data platform. This position focuses on transforming a legacy Azure SQL Server environment into a modern, high-performance, scalable architecture, including strategic migration toward PostgreSQL where appropriate. The role directly impacts system scalability, performance, cost efficiency, and long-term data strategy. This is not a management role; it is a hands-on execution-focused position working directly within production systems.

KEY RESPONSIBILITIES

Core duties and responsibilities include the following. 

· 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.

May perform other additional duties and responsibilities as assigned.

QUALIFICATIONS- KNOWLEDGE, SKILLS, & ABILITIES

· 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.

PHYSICAL DEMANDS AND WORK ENVIRONMENT

In-office and remote positions

· Frequently required to sit

· Frequently required to talk or hear

· Continually utilize visual acuity to operate equipment, read technical information, and/or use a keyboard and mouse.

DITL

The above is intended to describe the general content of and requirements for the performance of this job. It is not to be construed as an exhaustive statement of duties, responsibilities, or physical requirements. Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Metrc is an Equal Opportunity Employer, and all qualified applicants and team members will be considered for employment and advancement without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, national origin, age, marital status, disability, genetic information, military or veteran status or any other characteristic protected by federal, state or local law.