Senior Lead Software Engineer - Database & Performance

Apply Online

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

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.

Apply Online

Requisition Number:2025-7784