Senior SQL Database Architect & Mentor

Cass Information Systems, Inc.; Bridgeton, Northern (MO, KY); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Cass Information Systems, Inc. is seeking a Sr. Database Developer to design, implement, and optimize SQL Server solutions for both production and development environments. You will model data, write complex queries, and ensure data integrity while mentoring junior staff.

The role requires advanced knowledge of .NET, SQL Server, and TFS, with responsibilities spanning security, performance, and data integration within a fast-paced environment.

Qualifications

• Bachelor’s degree in computer science or related field or equivalent work experience.
• 5+ years of experience developing Windows and/or web-based SQL applications.

Responsibilities

• Designs, implements, and supports robust SQL server database solutions for production and development environments.
• Develops data models, schemas, and relationships to ensure data integrity and performance.
• Writes SQL queries, stored procedures, triggers, and functions for various needs including reporting.
• Monitors and optimizes database performance; resolves bottlenecks and issues.
• Implements security measures including access control, encryption, and auditing.
• Collaborates with application developers on data integration and ETL pipelines.

Skills

Self-sufficiency

Analytical skills

Communication skills

Deadline-driven

.NET

MS SQL Server

Stored procedures and T-SQL

Database tuning

Entity Framework

Education

Bachelor's degree in computer science

Equivalent work experience

Tools

.NET

TFS

Entity Framework

SQL Server Management Studio

SSIS/ETL

Job description

Cass Information Systems, Inc. is seeking a Sr. Database Developer to design, implement, and optimize SQL Server solutions for both production and development environments. You will model data, write complex queries, and ensure data integrity while mentoring junior staff.

The role requires advanced knowledge of .NET, SQL Server, and TFS, with responsibilities spanning security, performance, and data integration within a fast-paced environment.