Tyler Technologies, Inc.
Senior Lead Database Engineer
Work with our innovative software solutions that help local government and school districts centralize data and connect their organizations. By working to develop and support our financial management solutions, you can help integrate our solutions with human resources, revenue management, tax billing, and asset management.
Location Yarmouth, Maine | Falmouth, Maine | Orono, Maine
Travel 0-5%
State-Specific Salary Range Disclosure Requirements Salary will generally fall between $83,524 - $142,729 before adjustment for geographic differences. Recruiter can confirm if position is incentive eligible.
Responsibilities
Performance Monitoring and Tuning: Monitor and analyze database performance metrics, system statistics, and OS-level resources to proactively identify and resolve performance bottlenecks.
Query Optimization: Use execution plan analysis to tune complex SQL queries and stored procedures, eliminating inefficiencies and improving application performance.
Indexing Strategy: Design, implement, and maintain effective indexing strategies to enhance query performance, balancing the impact on read and write operations.
Engine-Level Analysis: Possess a deep understanding of the database engine's architecture, buffer pools, memory management, and I/O handling to diagnose and troubleshoot core performance issues.
Resource Management: Analyze resource usage – CPU, memory, disk I/O – to identify contention and work with system administrators to resolve underlying infrastructure issues.
Proactive Issue Resolution: Investigate and resolve complex database-related incidents such as deadlocks and blocking, conducting root‑cause analysis to prevent recurrence.
Collaboration: Work closely with developers, system administrators, and other teams to provide expert guidance on schema design, query practices, and database configuration.
Capacity Planning: Perform capacity planning to ensure the database environment can scale with company growth and anticipate future resource needs.
Documentation: Maintain comprehensive documentation on performance standards, troubleshooting procedures, and tuning activities.
Qualifications
Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
5+ years of hands‑on experience in database performance analysis and tuning, with specific expertise in at least one major DBMS (SQL Server, PostgreSQL, or MySQL).
Expert-level proficiency in SQL, including advanced knowledge of execution plan interpretation and query optimization techniques.
Strong understanding of database internals and architecture, including transaction processing, locking, memory, and I/O handling.
Experience with performance monitoring tools and OS-level performance analysis.
Excellent analytical and problem‑solving skills, with a methodical approach to troubleshooting complex issues.
Exceptional communication and collaboration skills, with the ability to explain complex technical issues to both technical and non‑technical audiences.
Relevant industry certifications are a plus (e.g., AWS Certified Data Engineer).
Taking Care of You & Your Family Your health and well‑being are important to us. That’s why we invest in our team members by offering competitive benefits to support their health and financial wellness.
Apply Online Requisition Number: 2025-7784
Equal Opportunity Employer Tyler Technologies is proud to be an equal opportunity employer. All qualified applicants will receive consideration without regard to race, creed, gender, marital status, sexual orientation, citizenship status, age, disability, protected veteran status, or any other status protected under local, state, or federal laws. If you require reasonable accommodation for any part of the application or hiring process due to a disability, please submit your request by emailing jobs@tylertech.com or by calling 800.646.2633 ext. 791008. Please keep in mind these methods are reserved for individuals who require accommodation due to a disability.
#J-18808-Ljbffr
Location Yarmouth, Maine | Falmouth, Maine | Orono, Maine
Travel 0-5%
State-Specific Salary Range Disclosure Requirements Salary will generally fall between $83,524 - $142,729 before adjustment for geographic differences. Recruiter can confirm if position is incentive eligible.
Responsibilities
Performance Monitoring and Tuning: Monitor and analyze database performance metrics, system statistics, and OS-level resources to proactively identify and resolve performance bottlenecks.
Query Optimization: Use execution plan analysis to tune complex SQL queries and stored procedures, eliminating inefficiencies and improving application performance.
Indexing Strategy: Design, implement, and maintain effective indexing strategies to enhance query performance, balancing the impact on read and write operations.
Engine-Level Analysis: Possess a deep understanding of the database engine's architecture, buffer pools, memory management, and I/O handling to diagnose and troubleshoot core performance issues.
Resource Management: Analyze resource usage – CPU, memory, disk I/O – to identify contention and work with system administrators to resolve underlying infrastructure issues.
Proactive Issue Resolution: Investigate and resolve complex database-related incidents such as deadlocks and blocking, conducting root‑cause analysis to prevent recurrence.
Collaboration: Work closely with developers, system administrators, and other teams to provide expert guidance on schema design, query practices, and database configuration.
Capacity Planning: Perform capacity planning to ensure the database environment can scale with company growth and anticipate future resource needs.
Documentation: Maintain comprehensive documentation on performance standards, troubleshooting procedures, and tuning activities.
Qualifications
Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
5+ years of hands‑on experience in database performance analysis and tuning, with specific expertise in at least one major DBMS (SQL Server, PostgreSQL, or MySQL).
Expert-level proficiency in SQL, including advanced knowledge of execution plan interpretation and query optimization techniques.
Strong understanding of database internals and architecture, including transaction processing, locking, memory, and I/O handling.
Experience with performance monitoring tools and OS-level performance analysis.
Excellent analytical and problem‑solving skills, with a methodical approach to troubleshooting complex issues.
Exceptional communication and collaboration skills, with the ability to explain complex technical issues to both technical and non‑technical audiences.
Relevant industry certifications are a plus (e.g., AWS Certified Data Engineer).
Taking Care of You & Your Family Your health and well‑being are important to us. That’s why we invest in our team members by offering competitive benefits to support their health and financial wellness.
Apply Online Requisition Number: 2025-7784
Equal Opportunity Employer Tyler Technologies is proud to be an equal opportunity employer. All qualified applicants will receive consideration without regard to race, creed, gender, marital status, sexual orientation, citizenship status, age, disability, protected veteran status, or any other status protected under local, state, or federal laws. If you require reasonable accommodation for any part of the application or hiring process due to a disability, please submit your request by emailing jobs@tylertech.com or by calling 800.646.2633 ext. 791008. Please keep in mind these methods are reserved for individuals who require accommodation due to a disability.
#J-18808-Ljbffr