Senior SQL & Postgres Database Engineer (Hybrid)

Jack Henry & Associates, Inc.; Allen (TX); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Jack Henry & Associates, Inc. is seeking a Senior Database Engineer to independently evaluate, design, code, and optimize databases and applications.

You will develop tables, stored procedures, views, and other database objects, tuning for peak performance while collaborating with developers to integrate databases with applications. The role involves limited database administration and a hybrid work schedule, with onsite presence in Allen, TX one day per week.

Qualifications

• Minimum of 6 years of experience in database administration.
• Familiar with object-oriented programming.

Responsibilities

• 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 unit tests.
• Writes and maintains library of query performance tests (baselines).
• 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.

Skills

Database administration

Object-oriented programming

GoLang

Job description

Jack Henry & Associates, Inc. is seeking a Senior Database Engineer to independently evaluate, design, code, and optimize databases and applications.

You will develop tables, stored procedures, views, and other database objects, tuning for peak performance while collaborating with developers to integrate databases with applications. The role involves limited database administration and a hybrid work schedule, with onsite presence in Allen, TX one day per week.