Metrc

Metrc is the most trusted and experienced provider of cannabis regulatory systems.

Database Architect

Database AdministratorDatabase AdministratorContractRemoteTeam 51-200Since 2013H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

8 days ago

Salary

Not specified

Bachelor Degree8 yrs expExperience acceptedEnglishAzureCloudETLPostgre SQLSQL

Job Description

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

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

Related Categories

Related Job Pages

More Database Administrator Jobs

SQL Server Database Administrator

RESPEC

Achieving the impossible. Transforming our clients' visions into reality.

Database Administrator8 days ago
Full TimeRemoteTeam 201-500H1B Sponsor

SQL Server DBA maintaining and developing stored-procedure–centric applications

SQL
New Mexico
Database Administrator8 days ago
Full TimeRemoteTeam 201-500

ASRC Federal Vistronix is actively seeking an ETL Datastage/SQL Administrator with strong IBM Datastage experience, including Datastage administration, and SQL Server DBA skills. The candidate must be proficient in administering IBM DataStage environments, managing ETL workflows,...

IBM DataStageSQL ServerETLLinuxWindowsJiraServiceNow
United States

Database Admin Specialist Advisor

NTT DATA

NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers and application services. Our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D.

Database Administrator8 days ago
Full TimeRemoteTeam 10,001

This role involves hands-on administration, maintenance, and support for both SharePoint 2016 On-Premise Operations and SharePoint Online environments, requiring management of hybrid architectures, performance tuning, and disaster recovery procedures. Key duties include administering farm topologies, managing site collections and permissions, configuring hybrid connectivity, and implementing compliance features within Microsoft 365.

United States
$100K - $233K / year
Database Administrator8 days ago
Full TimeRemoteTeam 501-1,000

The SQL Server DBA will maintain, enhance, and develop a long-lifespan, stored-procedure-centric application, focusing on expert query tuning, stored procedure development, and SSRS reporting. This role involves translating complex client requirements into technical tasks while supporting a normalized, multi-module environment.

United States