Database Engineer

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.