Skip to main content

This job has expired

SQL Expert

Employer
Berkshire Hathaway GUARD Insurance Company
Location
Wilkes Barre, Pennsylvania
Salary
Not Specified
Closing date
Sep 25, 2019

View more

Category
IT
Job Type
Not Specified
Career Level
Not Specified

Job Details

Overview

Berkshire Hathaway GUARD Insurance Companies is seeking a SQL Expert with a flair for code optimization and a passion for coaching other developers.

GUARD’s business is growing at a fantastic rate, and our technology team is growing as well! We are constantly adding more features to our in-house custom software package. We are looking for a SQL Expert who can examine T-SQL code and design, optimize it, and teach developers how to optimize for themselves and take their skills to the next level.

GUARD’s software is all developed by internal teams and runs on a strong, current technology platform that includes:

  • Microsoft SQL Server 2016 Enterprise
  • SQL Server Analysis Services
  • NET C# MVC
  • Microsoft IIS Web Server
Responsibilities

  • Have a deep and demonstrable knowledge of Microsoft SQL Server programming
  • Experience with large and rapidly growing databases is a plus
  • Be familiar with performance tools such as profiler or extended events sessions
  • Familiarity with performance measurement tools such as Solarwinds DPA or SQL Sentry
  • Be able to discuss the pros and cons of using different SQL Server engine features, such as constraints, foreign keys, etc
  • Be familiar with common table expressions and other advanced T-SQL programming constructs
  • Be prepared to discuss the pros and cons of using various SQL Server features, such as triggers, user defined functions, table valued functions, XML, isolation levels, and others
  • Be prepared to debate, defend, and measure the performance differences amongst different approaches in order to determine the best one
  • Demonstrate the ability to construct an efficient approach to query complex tables with hundreds of millions of rows
Qualifications

  • Reviewing existing code and either implementing changes or making recommendations for improvement
  • Consulting with developers in terms of table design, index creation, and writing efficient SQL code
  • Creating and documenting standards that can be guides for developers when writing SQL Code
  • Code review for new projects, to identify gaps in developer knowledge so as determine the best focus for your efforts
  • Doing all of the above clearly and tactfully, with an eye towards enhancing the system and skills of its developers
  • Data Warehousing and Business Intelligence Reporting
  • Redesign inefficient or outdated processes

Why join are team?

  • Paid holiday, vacation, and sick time
  • Competitive health care package (medical, dental, vision, etc.)
  • Award-winning “wellness” program
  • 401(k) and profit sharing plan
  • Longevity award (company-sponsored vacation after each five years of employment)
  • Tuition reimbursement
  • On-site training
  • A family friendly environment
  • Job postings for available positions and a practice of promoting from within the company
  • A business casual dress code
  • Several forums for employees to participate in a range of community-service activities.
  • Paid life insurance and disability coverage
  • Be part of Berkshire Hathaway, one of the world's most admired companies. We offer opportunities to advance your career!

Company

At Berkshire Hathaway GUARD Insurance Companies, we want you to find your career — not just a job that pays the bills.  We pride ourselves on the fact that our company consists of energetic, talented employees who thrive on challenge and have helped create a strong sense of community within our organization!

Our business is expanding, and we are looking for new employees to fill a variety of roles.  You may find your niche with us as well as growth opportunities that allow you to reach your full potential and make a difference.  Berkshire Hathaway GUARD is still small enough that individual efforts have a large impact on our success!

Take a moment to browse through our career site, learning about our excellent benefits package, unique culture, and dedication to community service.  Once you've familiarized yourself with our company, see the positions available with us.  We think you'll be pleased with the career path that awaits you.

Company info
Website

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert