Database Administrator IV

Location: Buffalo, NY Salary: $60.00 USD Hourly - $65.00 USD Hourly Description:
Job Title: Database Administrator
Location: Buffalo, NY 14203 (Hybrid - 4 Days/Week)
Duration: 12+ Months Contract
Additional Logistics

• Strong preference for Buffalo-area candidates.
• Open to considering relocation candidates.
• Remote hiring may be considered later if local market is insufficient.

Position Overview
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.

Required Qualifications

• 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

1. Relational database design
2. Database schema development
3. Data modeling
4. T-SQL development
5. Reporting and analytics data structures
6. Data cleanup and transformation
7. Trend and historical data management concepts

Tools Used

1. Microsoft SQL Server (current environment)
2. T-SQL
3. Archer (Risk Management Platform)
4. Snowflake (potential future-state platform)
5. Azure SQL / Cloud SQL technologies (potential future-state platform)
6. Alteryx (nice-to-have)

Medical, dental, and vision insurance are available to qualified candidates who meet eligibility requirements.
By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.
Contact:
This job and many more are available through The Judge Group. Please apply with us today!