Jack Henry & Associates is seeking a Mid-Level SQL Server Database Developer to join our team. In this role, you will work on a team that develops and administers a high-availability SQL Server cluster that supports data persistence, reporting, and business logic for our product suite. Our team develops critical transactional databases serving the banking industry. As a member of this team, you will participate across the software development lifecycle including database design and development.

MINIMUM QUALIFICATIONS

• Bachelor’s degree.


• Minimum of 2 years of development experience.


• Must have experience with SQL Server.


• Must be a U.S. Citizen and be able to clear a federal background check.

PREFERRED QUALIFICATIONS

• Experience writing and optimizing complex queries


• Experience designing relational databases.


• Experience with performance tuning.


• Knowledge of payment systems and solutions.


• Strong communication, writing, and editing skills needed to transfer information to individuals involved in the development process. 

ESSENTIAL FUNCTIONS

• Writes and reviews stored procedures, functions, and other programmable objects for high-volume transaction processing systems.


• Participates on scrum teams as the SQL expert, helping to move features through the software development lifecycle.


• Tunes queries for optimal performance by closely examining execution plan and ensuring appropriate indexing.


• Participates in design meetings and recommend optimal performing database designs.


• Writes and maintains tSQLt unit tests.


• Ensures accurate history in version control systems (git/TFS) and writes documentation as necessary.


• Monitors and maintains database CI/CD devops tooling and ensures accuracy of update/rollback scripts for database deployments.


• Writes and reviews C# code in the data access layer (ADO.NET) to ensure performance and security of RPC calls.