Job Description:Summary:The Database Engineer L3 will support high performing and highly available applications in the vRad core technology platform. The position is responsible for supporting the logical and physical aspects of vRad's SQL Server Clinical Applications OLTP environments.
Essential Duties and Responsibilities:- Design and implement complex and robust technical solutions that are scalable and manageable
- Write SQL statements for transactional data access, data definition and SQL Server administration
- Collaborate with local and remote team members to create high-performing, data-driven applications
- Create complex reports and queries using SQL Reporting Services and Analysis Services
- Use modern ETL techniques to integrate data from disparate systems
- Document deliverables so they can be supported by the team
- Operate and administer SQL Server instances in a high-availability environment
- Install and configure SQL Server components using best practices, including clustering and mirroring
- Design scalable storage layouts
- Monitor and identify issues in real time
- Triage and solve issues that affect the operation of highly available SQL Server instances, such as blocking and de-blocking and deadlocks
- Tune SQL statements as necessary
- Participate in after-hours support rotation
- Customize commercial products for integration with vRad's technology platform
- Assist with project planning to define scope and provide estimates
- Deliver functionality as promised, in the time estimated
- Follow vRad's change management processes when modifying production systems
- Stay up to date with emerging technologies and industry trends to provide guidance to technology decision makers
- Clarify and codify definitions in the corporate data dictionary
- Other duties as necessary to support vRad's success
Qualifications/Education:- Bachelor's Degree in a computer-related field or equivalent work experience
- Microsoft Database Administrator Certification (MCITP) preferred
- 5 - 7 years SQL Server experience in mid to large sized environments
- Experience managing and architecting SQL environments with very large OLTP databases (1 TB or more)
- Experienced and confident in using advanced T-SQL in creating and updating custom queries, stored procedures, tables, functions and more
- Experience with installing, configuring and managing SQL Server along with Microsoft High Availability technologies, including Failover Clustering, Database Mirroring, Log Shipping and Replication
- Must have in-depth knowledge and experience working with a variety of difference performance optimization techniques including index performance tuning, query plan analysis/usage, capturing and analyzing performance counters, code rewrites and more
- Experience in designing, implementing and monitoring common SQL maintenance plans and custom scripts
- Ability to manage SQL Server permissions
- Experience in authoring, editing, communicating and enforcing SQL Server standards and industry best practices
- Understanding of ETL design concepts
- Experience with change control management
- Must be comfortable working in a fast-paced multiple server environment
- Must be able to communicate with non-technical users
- Must be able to manage multiple requests at the same time
- Experience with SSAS, SSIS, SSRS preferable
- Knowledge of various industry regulations such as HIPAA, PCI, PHI, SOX and how they pertain to the database domain is a plus
- Experience with OLAP systems is a plus
Job Classification:Sedentary- Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently. A sedentary job involves sitting most of the time.
Pay Transparency:$115,000 - $125,000
About vRadvRad (Virtual Radiologic) is a national teleradiology practice made up of 500+ radiologists who help expand access to lifesaving care for millions of patients each year. We're also a leader in radiologist workflow technology, supporting hospitals and groups across the country with innovative imaging solutions.
Behind it all is a team that thrives in a casually professional, fast-paced, and collaborative environment. We take pride in what we do and in how we support each other, recognizing the extra effort it takes to deliver excellence every day.
At vRad, your work truly makes a difference. As a Top Workplace Award winner, we're known for our mission-driven culture, passion for innovation, and the energy our team brings to everything we do.
vRad is an equal opportunity employer and welcomes all qualified applicants. vRad is committed to being an inclusive, safe and welcoming environment where everyone has equal access and equitable resources to reach their full potential. Applicants will receive fair and impartial consideration without regard to race, sex, color, religion, national origin, age, disability, veteran status, genetic data, religion or other legally protected status.
For more information, visit ;br>
vRad participates in E-Verify.
