Database Developer

This is a fully remote position, open to applicants in Minnesota.

📋 Description

• Enhance the performance, reliability, security, and maintainability of ImageTrend product databases.

• Evaluate SQL queries, stored procedures, schema modifications, and database deployment scripts prior to application releases.

• Analyze execution plans and assess query performance.

• Monitor production query performance to identify regressions, bottlenecks, and optimization opportunities.

• Collaborate with developers and DBAs to rewrite and optimize queries while improving data-access patterns.

• Suggest, test, and implement effective indexing strategies.

• Provide guidance on database design, including tables, keys, constraints, partitioning, data types, indexing, and data distribution.

• Assist in performance testing and conduct post-release validation.

• Mentor developers on SQL development and best practices for database performance.

• Oversee and maintain the health, availability, security, capacity, and reliability of both production and non-production databases.

• Administer and support SQL Server and Azure data platforms, including Azure SQL Managed Instance, Azure SQL Database, Hyperscale, Microsoft Fabric, and Azure Databricks.

• Facilitate backup and recovery, disaster recovery, high availability, maintenance, patching, and validation of recovery procedures.

• Investigate database incidents such as performance degradation, blocking, deadlocks, resource saturation, failed jobs, connectivity, storage, and data integrity issues.

• Automate database maintenance, monitoring, validation, and reporting processes.

• Maintain technical documentation covering database configurations, operational procedures, performance decisions, and recovery processes.

• Ensure database security, access controls, encryption, audits, compliance, and HIPAA-related controls are upheld.

• Contribute to database capacity planning and cost optimization efforts.

• Participate in an on-call rotation following the initial training period.

• Travel for orientation, industry or company events, training opportunities, or onsite meetings as necessary.

⛳️ Requirements

• Bachelor's degree in Information Technology, Computer Science, or a related field, or an equivalent combination of education and relevant experience.

• Demonstrated professional experience as a Database Developer or similar role within enterprise software, SaaS applications, cloud solutions, database administration, performance engineering, data integration, or related technology environments.

• Advanced proficiency in SQL, with experience in reviewing, troubleshooting, optimizing, and tuning complex queries, stored procedures, and database workloads.

• Experience in interpreting SQL Server execution plans and diagnosing performance issues related to indexing, statistics, blocking, deadlocks, CPU, memory, storage, and I/O bottlenecks.

• Background in designing, evaluating, and implementing indexing strategies for both transactional and analytical workloads.

• Experience supporting production database environments while collaborating with software development, infrastructure, operations, and database administration teams.

• Working knowledge of database security, access controls, encryption, backup and recovery, disaster recovery, high-availability solutions, data integrity practices, and regulatory compliance requirements.

• Familiarity 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 in supporting ETL/ELT processes, data warehouses, lakehouse architectures, data lakes, dimensional modeling, star-schema designs, and managing large-scale datasets.

• Proficiency in automating database administration, monitoring, maintenance, validation, and reporting using PowerShell, T-SQL, CI/CD pipelines, scripting languages, or related tools.

• Strong analytical, troubleshooting, organizational, and time management capabilities.

• Effective written and verbal communication skills.

• Ability to handle proprietary and confidential information with discretion.

• Eagerness to learn and enhance knowledge or skills.

• Strong work ethic, integrity, honesty, collaboration, and team orientation.

• Willingness to travel as needed, up to 10%.

🏝️ Benefits

• Bonus opportunities.

• Comprehensive benefits and perks.

• Contributions to community initiatives.

• Fully virtual/remote work environment.

• Travel for orientation, industry or company events, training opportunities, or other onsite meetings as needed.

• Reasonable accommodations available for applicants with disabilities.

• Commitment to an equal opportunity workplace free from harassment and discrimination.