Sr. Database Developer

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

The Sr. Database Developer is responsible for developing and supporting SQL server database solutions within both the production and development environments. In addition, this position may provide training and mentorship to less experienced staff.

PRINCIPAL RESPONSIBILITIES AND DUTIES:

• Designs and implements robust, efficient, and scalable database solutions to support the company’s applications and data requirements.
• Develops and maintains data models, schemas, and relationships to ensure data integrity and optimal performance.
• Writes SQL queries, stored procedures, triggers, and functions to support various application needs and reporting requirements.
• Monitors and optimizes database performance, identifying and resolving bottlenecks and issues to ensure efficient data retrieval and storage.
• Implements and maintains database security measures, including access control, encryption, and auditing to safeguard sensitive data.
• Collaborates with application developers to design and implement efficient data integration processes and ETL pipelines.
• Other duties as needed or assigned.

SKILLS AND ABILITIES REQUIRED:

• Advanced level of self-sufficiency and initiative working on database projects.
• Advanced level of analytical, organizational, documentation, and communications skills.
• Ability to work in a dynamic, deadline oriented environment.
• Advanced level of knowledge of .NET and legacy applications that interact with SQL.
• Advanced level of knowledge of Microsoft SQL Server database development.
• Advanced level of knowledge of managing multiple MS SQL Server databases on large systems.
• Advance level of knowledge in monitoring and tuning databases.
• Advanced level of knowledge of Transactional SQL and stored procedures.
• Intermediate understanding of entity framework and team foundation server (TFS).

MINIMUM LEVEL OF PREPARATION AND TRAINING NORMALLY REQUIRED:

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

ABOUT OUR COMPANY

Cass Information Systems, Inc. (NASDAQ: CASS) is a leading provider of integrated information and payment management solutions. Cass enables enterprises to achieve visibility, control and efficiency in their supply chains, communication networks, facilities, and other operations. Disbursing over $94 billion annually on behalf of its clients, and with total assets of $2.5 billion, Cass is uniquely supported by Cass Commercial Bank. Founded in 1906 and a wholly-owned subsidiary, Cass Commercial Bank provides sophisticated financial exchange services to the parent organization and its clients. Cass is part of the Russell 2000®. More information is available at www.cassinfo.com .

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.