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 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) Alteryx (nice-to-have) Medical, dental, and vision insurance are available to qualified candidates who meet eligibility requirements.