Database Developer

ImageTrend; United States; À distance; USD 90 000 - 120 000; Plein temps

Résumé du poste

ImageTrend, LLC. is seeking a Database Developer to improve performance, reliability, and security of product databases across SQL Server and Azure platforms. You will collaborate with Development/DBA teams to review changes, monitor production performance, and implement effective indexing and design strategies.

The role emphasizes automation, documentation, capacity planning, and on-call support while ensuring HIPAA-related controls and regulatory compliance.

Qualifications

• Bachelor's degree or equivalent in information technology, computer science, or related field.
• Advanced SQL proficiency with experience reviewing, troubleshooting, optimizing, and tuning complex queries.
• Hands-on experience interpreting SQL Server execution plans and diagnosing performance issues.
• Experience designing indexing strategies for transactional and analytical workloads.
• Experience supporting production database environments and collaborating with cross-functional teams.
• Knowledge of database security, backup/recovery, and regulatory compliance.

Responsabilités

• Review SQL queries, stored procedures, and deployment scripts before releases, focusing on performance and scalability.
• Assess execution plans and analyze query performance for bottlenecks.
• Monitor production query performance and identify regressions and high-resource workloads.
• Collaborate with developers/DBAs to rewrite/tune queries and improve data access patterns.
• Implement indexing strategies balancing performance and maintenance costs.
• Provide database design guidance on tables, keys, constraints, and partitioning.
• Automate maintenance, monitoring, and reporting using scripting/tools.
• Maintain documentation for configurations, procedures, and recovery processes.

Connaissances

Advanced SQL

Query optimization

SQL Server

Azure SQL

Performance tuning

Data security

Formation

Bachelor's degree

Information Technology

Computer Science

Outils

PowerShell

CI/CD pipelines

Azure Monitor

Azure Databricks

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.

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.