Database Developer

ImageTrend•Eagan, MN

15h•Remote

About The Position

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! 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.

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%

Responsibilities

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