Lead Database Engineer

Yarmouth, MA - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Department:

Software Engineering

Job Summary

Description

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 both read and write operations.
Engine-Level Analysis: Possess a deep understanding of the database engines 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.

QUALIFICATIONS

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

DescriptionRESPONSIBILITIESPerformance 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 p...

Description

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 both read and write operations.
Engine-Level Analysis: Possess a deep understanding of the database engines 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.

QUALIFICATIONS

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

Key Skills

Databases
SQL
Database Development
Microsoft SQL Server
Database Design
Performance Tuning
NoSQL
MySQL
Postgresql
Database Administration
MongoDB
Oracle

Apply Now

About Company

Tyler Technologies

Tyler offers public sector software solutions designed specifically for the unique needs of state, local, and federal government organizations and school districts.

View Profile View Profile

AI AutoApply

Apply to 100+ jobs with one click