Senior DBA: SQL, Postgres

General information

Press space or enter keys to toggle section visibility

17482

Position Level

Individual Contributor

Team

Technology Solutions & Svcs

Working Time

Full-Time

Position Type

Regular

Travel Requirements

5%

Workplace Type

Hybrid

Preferred Location

Allen, TX

Description & Requirements

Press space or enter keys to toggle section visibility At Jack Henry, we’re more than a technology company, we’re a force for good in financial services. We’re redefining how community banks and credit unions connect with the people they serve. Our mission is rooted in people inspired innovation, empowering financial institutions to deliver seamless, secure, and human centered experiences. We deliver cutting-edge solutions that are paving the way for the next generation of digital banking and payments, but our true impact begins with our associates.

If you're ready to help transform an industry and grow with a company that values purpose, collaboration, and excellence then we’d love to meet you. The Senior Database Engineer works independently to evaluate, design, code, optimize, and modify databases and database applications. This role models databases and develops tables, stored procedures, views, triggers, and other database objects. The Senior Engineer, Database, tunes databases for optimum performance and works closely with other developers to integrate databases with other applications.

This position may involve interface development to access databases and may require a limited amount of database administration.

This position offers a hybrid work schedule, with team members expected to work onsite at our Allen, TX office one day per week.

This position is ineligible for immigration sponsorship and support. Please do not apply if at any time you will need immigration support now or in the future (i.e., H-1B, PERM). All positions, regardless of location, may require an onsite interview or in-person onboarding requirement to verify your identity. What you’ll be responsible for:

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. Writes and reviews application code in the data access layer to ensure performance and security of database calls. Performs advanced troubleshooting across all application components, debug, fix code, deploy, and test the fixes Diagnoses and troubleshoots complex application problems and leverage tools and resources appropriately to identify solutions.

Resolves challenging problems in collaboration with others. Helps team members with questions and troubleshooting related to their SQL Server setups. Trains and mentors junior team members. Performs other duties as assigned. What you’ll need to have:

A minimum of 6 years of experience in database administration.

Experience writing SQL queries.

Proficiency Must be familiar with object-oriented programming. What would be nice for you to have:

Experience writing and optimizing complex queries.

Experience with performance tuning. Knowledge of payment systems and solutions. Strong communication, writing, and…