Senior DBA: SQL, Postgres

17482

Team

Technology Solutions & Svcs

Working Time

Full-Time

Position Type

Regular

Travel Requirements

5%

Workplace Type

Hybrid

Preferred Location

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.

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

• A minimum of 6 years of experience in database administration.
• Must be familiar with object-oriented programming.

• Experience writing and optimizing complex queries.
• Experience with performance tuning.
• Knowledge of payment systems and solutions.
• Strong communication, writing, and diagramming skills.
• Experience with Go Lang

If you got this far, we hope you're feeling excited about this opportunity. Even if you don't feel you meet every single requirement on this posting, we still encourage you to apply. We’re looking for passionate, driven…