> Markdown version of [/jobs/ext/4367840-database-administrator-dba](https://www.wearedevelopers.com/jobs/ext/4367840-database-administrator-dba). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Database Administrator (DBA)

- **Company:** The Judge Group
- **Location:** Buffalo, NY, United States
- **Contract:** Permanent contract
- **Skills:** Cloud Computing, Profiling, Databases, Data Architecture, Data Cleansing, Data Infrastructure, Data Structures, Relational Databases, Database Schema, Database Storage Structures, Microsoft SQL Server, SQL Azure, SQL Databases, Transact-SQL, Enterprise Data Management, Data Processing, Enterprise Software Applications, Cloud Platform System, Snowflake, Data Strategy, Data Management, Alteryx
- **Published:** October 13, 2026
- **Apply:** https://www.thejobnetwork.com/job/ac4ba3cf-3d34-4760-b814-42ddfff2eccd/database-administrator-dba

## About the Role

· Senior-level database engineering experience.

· Strong SQL Server expertise.

· Advanced Transact-SQL (T-SQL) skills.

· Experience designing database schemas and relational database structures.

· Experience supporting large-scale applications and data environments.

· Strong understanding of data modeling concepts and reporting-oriented data structures.

· Ability to work collaboratively with architects, technology teams, and business stakeholders.

· Experience performing database cleanup, optimization, and modernization efforts.

Preferred Qualifications

· Experience with Snowflake.

· Experience with Azure SQL or cloud-based SQL platforms.

· Familiarity with Slowly Changing Dimensions (SCDs) and historical/trending data strategies.

· Alteryx experience for data wrangling, profiling, and transformation.

· Experience supporting enterprise data transformation initiatives.

· Banking or financial services experience (helpful but not required).

Technical Environment

Required Knowledge

· Relational database design

· Database schema development

· Data modeling

· T-SQL development

· Reporting and analytics data structures

· Data cleanup and transformation

· Trend and historical data management concepts

Tools Used

· Microsoft SQL Server (current environment)

· T-SQL

· Archer (Risk Management Platform)

· Snowflake (potential future-state platform)

· Azure SQL / Cloud SQL technologies (potential future-state platform)

## Description

This role supports a major Enterprise Risk Management transformation centered around the bank's Archer platform. The immediate need is not for a pure architect, but for a hands-on database professional who can help clean up and modernize a legacy data environment before broader enterprise transformation work begins.

The consultant will work alongside two other database-focused resources supporting the creation of an enterprise-wide risk data product. Initial efforts will focus on improving the current SQL Server environment, refining database structures, and preparing data for migration into a modern cloud-based architecture. As the transformation progresses, the individual will partner closely with the Enterprise Data Technology team as new data platforms and reporting capabilities are developed.

Key Responsibilities

· Analyze and remediate issues within the current on-prem SQL Server data environment.

· Design and refactor database schemas to support enterprise reporting and analytics.

· Perform significant data cleanup, normalization, and structural improvements.

· Support development of an enterprise-wide risk management data product.

· Collaborate with Enterprise Data Technology teams on future-state data architecture.

· Help define data structures that will support long-term reporting and trend analysis.

· Work with peers and project resources in a highly collaborative team environment.

· Provide technical input during migration planning from legacy databases to cloud-based platforms.