Senior Database Engineer

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

📋 Description

• Provide support for high-performing and highly available applications within the vRad core technology platform.

• Assist with both the logical and physical aspects of vRad’s SQL Server Clinical Applications OLTP environments.

• Design and implement sophisticated, scalable, robust, and manageable technical solutions.

• Write SQL statements for accessing transactional data, defining data, and administering SQL Server.

• Collaborate with both local and remote team members to develop high-performing, data-driven applications.

• Generate complex reports and queries utilizing SQL Reporting Services and Analysis Services.

• Employ modern ETL techniques to assimilate data from various systems.

• Document deliverables to support the team effectively.

• Operate and manage SQL Server instances in a high-availability setting.

• Install and configure SQL Server components, incorporating clustering and mirroring.

• Design scalable storage architectures.

• Monitor and detect issues in real-time.

• Triage and resolve challenges affecting highly available SQL Server instances, including blocking, de-blocking, and deadlocks.

• Optimize SQL statements for performance.

• Engage in after-hours support rotation.

• Customize commercial products for seamless integration with vRad’s technology platform.

• Assist in project planning, defining scope, and providing estimates.

• Deliver functionality within the estimated timelines.

• Adhere to vRad’s change management protocols for production systems.

• Stay updated with emerging technologies and industry trends, advising technology decision-makers accordingly.

• Clarify and codify definitions within the corporate data dictionary.

• Execute other duties necessary to support vRad’s success.

⛳️ Requirements

• Bachelor’s Degree in a computer-related discipline or equivalent work experience.

• 5–7 years of SQL Server experience in mid- to large-sized environments.

• Experience in managing and architecting SQL environments with very large OLTP databases (1 TB or more).

• Advanced T-SQL skills for creating and updating custom queries, stored procedures, tables, and functions.

• Proficient in installing, configuring, and managing SQL Server and Microsoft High Availability technologies, including Failover Clustering, Database Mirroring, Log Shipping, and Replication.

• Comprehensive knowledge of performance optimization techniques, such as index performance tuning, query plan analysis/usage, performance counter analysis, and code rewrites.

• Experience in designing, implementing, and monitoring SQL maintenance plans and custom scripts.

• Ability to manage SQL Server permissions effectively.

• Experience in authoring, editing, communicating, and enforcing SQL Server standards and industry best practices.

• Understanding of ETL design principles.

• Familiarity with change control management processes.

• Comfortable working in a fast-paced, multi-server environment.

• Strong ability to communicate with non-technical users.

• Capable of managing multiple requests simultaneously.

• Experience with SSAS, SSIS, and SSRS is preferred.

• Microsoft Database Administrator Certification (MCITP) is preferred.

• Knowledge of HIPAA, PCI, PHI, and SOX regulations as they relate to databases is a plus.

• Experience with OLAP systems is an added advantage.

🏝️ Benefits

• After-hours support rotation.

• Sedentary work classification (up to 10 pounds of force occasionally).

• Equal opportunity and inclusive, safe, and welcoming workplace.

• Fair and impartial consideration regardless of legally protected status.