Database Developer

ImageTrend; Eagan (MN); Sur place; USD 90 000 - 120 000; Plein temps

Résumé du poste

ImageTrend, LLC. is seeking a Database Developer to enhance performance, security, and maintainability of product databases across SQL Server and Azure platforms.

You will partner with Development and DBA teams to review changes, optimize queries, and implement indexing strategies. The role involves incident response, backup/recovery, capacity planning, and automation, with opportunities to contribute to scalable database design and compliance efforts.

Qualifications

• Bachelor's degree in Information Technology, Computer Science, or related field.
• Proven experience as a Database Developer in enterprise/ SaaS environments.
• Advanced SQL proficiency with reviewing, troubleshooting, and tuning complex queries.
• Experience interpreting SQL Server execution plans and diagnosing bottlenecks (indexing, blocking, deadlocks, IO, CPU).
• Experience designing indexing strategies for transactional and analytical workloads.
• Experience with production database environments and cross-functional collaboration.
• Knowledge of database security, backups, disaster recovery, high availability, and compliance.
• Experience with Azure data platforms and monitoring/diagnostic tools.
• Experience ETL/ELT, data warehouses, lakehouse architectures, data lakes, and large datasets.
• Automation using PowerShell, T-SQL, CI/CD pipelines or scripting.
• Strong analytical and communication skills; ability to collaborate across teams.
• Willingness to travel up to 10%.

Responsabilités

• Review SQL queries, stored procedures, and deployment scripts before releases with emphasis on performance and scalability.
• Assess execution plans and analyze performance metrics and bottlenecks.
• Monitor query performance in production using approved tools to identify regressions and bottlenecks.
• Collaborate with developers and DBAs to tune queries and data-access patterns.
• Recommend and test indexing strategies balancing performance and maintenance.
• Provide database design guidance on tables, keys, constraints, and data types.
• Support performance testing and release readiness documentation.
• Coach developers on SQL best practices and execution plans.
• Monitor health, availability, security, and reliability of production and non-production DB environments.
• Administer SQL Server and Azure data platforms (Azure SQL MI/DB, Hyperscale, Databricks).
• Support backup, recovery, DR, HA, patching, and validation activities.
• Investigate incidents involving performance degradation, blocking, deadlocks, and data integrity issues.
• Automate maintenance, monitoring, and reporting processes.
• Maintain technical documentation on configurations and procedures.
• Ensure HIPAA-related controls and regulatory compliance.
• Participate in on-call rotation and travel as required.
• Perform additional duties as assigned.

Connaissances

Advanced SQL proficiency

Query plan interpretation

Written & verbal communication

Formation

Bachelor's degree in IT/CS

Outils

SQL Server

Azure SQL MI

Azure SQL Database

Azure SQL Hyperscale

Microsoft Fabric

Azure Databricks

Azure Data Factory

Azure Monitor

Log Analytics

Query Store

Description du poste

About Us:

ImageTrend, LLC. is dedicated to connecting life’s most important data in the healthcare and emergency response community. We deliver software solutions, data analytics and services for EMS, hospitals, community paramedicine (CP), critical care, fire, and preparedness to enable fully integrated patient-centric healthcare and public safety. Our commitment to innovation, its clients, and providing world-class implementation and support is unsurpassed. Based in Eagan, MN, ImageTrend combines business analysis, creative design and data driven architecture to offer scalable solutions and strategies for today and the future.

Employment at ImageTrend is not just about doing a job; it's about being a part of a community. We are top-notch talent, passionate about making a difference through the work we do together!

Description:

Under the direction of the Manager, Systems Engineering, the Database Developer is responsible for improving the performance, reliability, security, and maintainability of ImageTrend product databases. This role serves as a key partner to Development and DBA teams by proactively reviewing database changes prior to release, monitoring production database performance, optimizing queries and execution plans, and implementing effective indexing and database design strategies. The Database Developer helps ensure database environments are scalable, secure, recoverable, and operationally reliable while supporting continuous improvement through automation, documentation, monitoring, and best practices. This role also provides database administration and operational support, including incident response, maintenance, backup and recovery, compliance support, capacity planning, and platform optimization across SQL Server and Azure-based data platforms.

What You'll Do:

• Review SQL queries, stored procedures, schema changes, and database deployment scripts before application releases, with emphasis on performance, scalability, correctness, and operational risk
• Assess execution plans and analyze query performance using estimated and actual row counts, join strategies, statistics, parameter sensitivity, blocking risks, memory grants, I/O, and CPU utilization
• Monitor query performance across production environments using approved monitoring and observability tools to identify regressions, recurring bottlenecks, high-resource workloads, and opportunities for optimization
• Partner with developers and DBAs to rewrite and tune queries, improve data-access patterns, validate changes using representative workloads, and provide database-focused review and performance guidance
• Recommend, test, and implement indexing strategies in coordination with Development and DBA stakeholders while balancing performance, storage utilization, maintenance costs, and overall database efficiency
• Provide database design guidance related to tables, keys, constraints, partitioning, data types, indexing strategies, data distribution, and database development standards
• Support performance testing and post-release validation activities by documenting findings, recommendations, tradeoffs, performance baselines, and release-readiness criteria
• Coach developers on SQL development best practices, execution-plan interpretation, and database performance principles
• Monitor and maintain the health, availability, security, capacity, and reliability of production and non-production database environments
• Administer and support SQL Server and Azure data platforms, including Azure SQL Managed Instance, Azure SQL Database, Hyperscale, Microsoft Fabric, and Azure Databricks
• Support backup and recovery, disaster recovery, high availability, maintenance, patching, and recovery validation activities
• Investigate database incidents involving performance degradation, blocking, deadlocks, resource saturation, failed jobs, connectivity issues, storage concerns, and data integrity issues
• Support database recommendations with execution plans, monitoring data, testing results, workload evidence, and documented operational risk assessments
• Automate database maintenance, monitoring, validation, and reporting processes using approved tools and scripting technologies
• Maintain technical documentation related to database configurations, operational procedures, performance decisions, and recovery processes
• Support database security, access controls, encryption requirements, audit activities, compliance obligations, and HIPAA-related controls
• Contribute to capacity planning and cost optimization efforts related to database compute, storage, and platform resources
• Participate in an on-call rotation for critical database support and incident response after the initial training period and as required
• Travel to orientation, industry or company events, training opportunities, or other onsite meetings as required
• Perform additional duties or tasks as assigned

Requirements:

• Bachelor's degree in Information Technology, Computer Science, or a related field, or the equivalent combination of education and relevant experience
• Proven professional experience as a Database Developer or similar role supporting enterprise software, SaaS applications, cloud-based solutions, database administration, performance engineering, data integration, or related technology environments
• Advanced SQL proficiency with demonstrated experience reviewing, troubleshooting, optimizing, and tuning complex queries, stored procedures, and database workloads
• Hands-on experience interpreting SQL Server execution plans and diagnosing performance issues involving indexing, statistics, blocking, deadlocks, CPU, memory, storage, and I/O bottlenecks
• Experience designing, evaluating, and implementing indexing strategies for transactional and analytical workloads
• Experience supporting production database environments and partnering effectively with software development, infrastructure, operations, and database administration teams
• Proven working knowledge of database security, access controls, encryption, backup and recovery, disaster recovery, high-availability solutions, data integrity practices, and regulatory compliance requirements
• Proven experience with SQL Server, Azure SQL Managed Instance, Azure SQL Database, Azure SQL Hyperscale, Microsoft Fabric, Azure Databricks, Azure Data Factory, Azure Monitor, Log Analytics, Query Store, and related monitoring or diagnostic tools
• Experience supporting ETL/ELT processes, data warehouses, lakehouse architectures, data lakes, dimensional modeling, star-schema designs, and large-scale datasets
• Experience automating database administration, monitoring, maintenance, validation, and reporting processes using PowerShell, T-SQL, CI/CD pipelines, scripting languages, or related tools
• Strong ability to analyze information, troubleshoot issues, and identify effective solutions with attention to detail
• Effective written and verbal communication skills with the ability to share technical information and collaborate with team members across functions
• Strong organizational and time management skills with the ability to prioritize work, manage multiple assignments, and meet established deadlines
• Ability to maintain discretion when handling proprietary and confidential information
• Enthusiasm for learning and expanding knowledge or skills
• Strong work ethic, integrity, honesty, collaboration, and team orientation
• Ability to travel as required, up to 10%

This role can be performed 100% virtually anywhere in the US while following our Remote Work Policy. Deadline to apply is at least 3 days after the posting date listed.

Position Salary Range:

The annual base salary range for this full-time role is $90,000- $120,000 USD + bonus + benefits + perks + community gains. Within the range, individual pay is determined by job-related skills, education or training and other relevant qualifications.

ImageTrend is an equal opportunity employer and is committed to providing a workplace free from harassment and discrimination. We celebrate the unique differences of our employees because that is what drives curiosity, innovation, and the success of our business. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, gender identity or expression, age, marital status, veteran status, disability status, pregnancy, parental status, genetic information, political affiliation, or any other status protected by the laws or regulations in the locations where we operate. Accommodations are available for applicants with disabilities.

If you are unable to submit your application because of incompatible assistive technology or a disability, please contact us at 952-469-1589, and ImageTrend will reasonably accommodate qualified individuals with disabilities to the extent required by applicable law.

ImageTrend participates in the Electronic Employment Verification Program (E-Verify) to validate employee Form I-9 documentation. Please visit everify.gov to learn more.