SQL Expert

Guard Insurance Group Wilkes Barre , PA 18701

Posted 2 months ago


Berkshire Hathaway GUARD Insurance Companies is seeking an 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


  • 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


  • 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 our team?

  • Paid holiday, vacation, and sick time

  • Competitive health care package (medical, dental, vision, etc.)

  • 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!

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Brow Waxing Expert

Ulta Salon, Cosmetics & Fragrance, Inc.

Posted 3 months ago

VIEW JOBS 4/7/2020 12:00:00 AM 2020-07-06T00:00 Ulta Beauty takes great pride in continually searching for passionate beauty lovers, with unique qualities and skills, to join our team. We invite you to submit your application as we may have positions open now or in the near future, depending on current business needs. General Summary The Brow Waxing Expert (Esthetician / Cosmetologist) is responsible for demonstrating and selling Benefit products and performing short services including eyebrow and facial waxing and brow tinting. The Arch Expert is also responsible for maintaining State Board compliant areas, and keeping accurate and complete records. Providing excellent customer service, achieving all waxing service and product goals as well as following all Benefit and Ulta Beauty guidelines is also expected. Must be 18 years to apply with an active and valid esthetics or cosmetology license as required by law. Use your skills, experience, & talents to be part of something BEAUTIFUL! As a Brow Waxing Expert you will… * Provide excellent customer service at all times to all Ulta Beauty guests whether at the boutique or in other parts of the store as the business dictates. * Achieve personal/boutique sales and service goals. * Demonstrate, recommend and sell Benefit products. * Perform short services, including but not limited to, eyebrow and facial waxing, tweezing and eyebrow tinting. Actively recommends additional services when appropriate. * Use appointment book or system to book for return services, makeup lessons, and for events. * Convert 60% of service customers into Benefit product sales. * Follow all safety, sanitation and hygienic procedures before, during and after services; ensure board compliance at all times. * Create and maintain a partnership with prestige consultants and salon professionals to promote teamwork and a high level of customer service. * Notify General Manager of supply needs to ensure necessary items are on hand at all times. * Assist in all in store operational processes. * Ensure prestige department and boutique standards are adhered to at all times. * Accurately follow all company time keeping procedures. * Attend mandatory Benefit training parties and team meetings. Experience we are looking for… * Cosmetology / Esthetics license. * Experience in make-up application; eyebrow and facial waxing, tweezing and eyebrow tinting is preferred but not required. * Proficiency with use of equipment needed to perform technical work. Developed communication skills. * Ability to work independently and as part of a team. * Ability to build and maintain strong customer relationships. Other * On a regular basis, requires the ability to walk. * On a regular basis, requires the ability to reach with hands and arms. * On a regular basis, requires the ability to stand for a minimum of 4 hours. * On a regular basis, requires the ability to lift and/or move 50 lbs. * On an occasional basis, requires the ability to climb a ladder and balance. * On a frequent basis, requires the ability to stoop, kneel and crouch. For positions located in San Francisco: pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. Requirements Ulta Salon, Cosmetics & Fragrance, Inc. Wilkes Barre PA

SQL Expert

Guard Insurance Group