Tyler Technologies Careers

Description

• 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 both read and write operations.
• Engine-Level Analysis: Possess a deep understanding of the database engine's architecture, including buffer pools, memory management, and I/O handling, to diagnose and troubleshoot core performance issues.
• Resource Management: Analyze resource usage, including CPU, memory, and disk I/O, to identify resource 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, while also conducting root-cause analysis to prevent recurrence.
• Collaboration: Work closely with application 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.

• 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 (e.g., 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 how the engine processes transactions, locks, and handles memory and I/O.
• 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.)