Sr Database Engineer
About The Position
The Database Engineer L3 supports high-performing and highly available applications in vRad’s core technology platform and is responsible for the logical and physical aspects of SQL Server Clinical Applications OLTP environments. The role designs, implements, operates, and administers SQL Server solutions in a high-availability environment, including scalable storage layouts and SQL Server components configured using best practices. It monitors systems, identifies issues in real time, and troubleshoots operational problems such as blocking, de-blocking, and deadlocks. The engineer collaborates with local and remote team members to build data-driven applications; develops transactional SQL, reports, and queries; uses ETL techniques to integrate data from disparate systems; and documents deliverables for team support. The role also supports project planning and estimates, follows change-management processes when modifying production systems, helps maintain the corporate data dictionary, and keeps current with technology and industry trends. Participation in an after-hours support rotation is required.
Requirements
- Bachelor’s degree in a computer-related field or equivalent work experience.
- 5–7 years of SQL Server experience in mid- to large-sized environments.
- Experience managing and architecting SQL environments with very large OLTP databases of 1 TB or more.
- Advanced T-SQL experience creating and updating custom queries, stored procedures, tables, and functions.
- Experience installing, configuring, and managing SQL Server and Microsoft high-availability technologies, including Failover Clustering, Database Mirroring, Log Shipping, and Replication.
- In-depth knowledge and experience with performance optimization techniques, including index tuning, query plan analysis and usage, capturing and analyzing performance counters, and code rewrites.
- Experience designing, implementing, and monitoring common SQL maintenance plans and custom scripts.
- Ability to manage SQL Server permissions.
- Experience authoring, editing, communicating, and enforcing SQL Server standards and industry best practices.
- Understanding of ETL design concepts.
- Experience with change-control management.
- Comfort working in a fast-paced, multiple-server environment.
- Ability to communicate with non-technical users.
- Ability to manage multiple requests simultaneously.
- Must participate in an after-hours support rotation.
Nice To Haves
- Microsoft Database Administrator Certification (MCITP).
- Experience with SSAS, SSIS, and SSRS.
- Knowledge of industry regulations such as HIPAA, PCI, PHI, and SOX as they pertain to databases.
- Experience with OLAP systems.
Responsibilities
- Design and implement complex, robust, scalable, and manageable technical solutions.
- 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 systems and identify issues in real time.
- Triage and resolve issues affecting highly available SQL Server instances, including blocking, de-blocking, and deadlocks.
- Tune SQL statements as necessary.
- Participate in an after-hours support rotation.
- Customize commercial products for integration with vRad’s technology platform.
- Assist with project planning by defining scope and providing estimates.
- Deliver functionality as promised and within estimated timelines.
- Follow vRad’s change-management processes when modifying production systems.
- Stay current with emerging technologies and industry trends and provide guidance to technology decision makers.
- Clarify and codify definitions in the corporate data dictionary.
- Perform other duties as necessary to support vRad’s success.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
