Sr. Database Developer

Cass-Information-Systems; Bridgeton (MO); On-site; USD 95,000 - 130,000; Full time

Benefits offered by this job

None

Job summary

Cass Information Systems, Inc. is seeking a Sr. Database Developer to design, build, and support SQL Server solutions across production and development environments in Bridgeton, MO.

You will mentor less experienced staff and collaborate with application teams to ensure data integrity and scalable performance. The role emphasizes data modeling, writing stored procedures, ETL integration, security controls, and performance tuning, with a focus on robust, maintainable database systems for

Qualifications

• 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.

Responsibilities

• 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

SQL Server

T-SQL

Stored procedures

Performance tuning

ETL pipelines

.NET

Entity Framework

Team Foundation Server (TFS)

SQL Server security

Data modeling

Education

Bachelor’s degree in computer science or related field or equivalent work experience

Tools

Microsoft SQL Server

Entity Framework

TFS

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.