Platform Database Engineer

Berkshire Hathaway Specialty Insurance•Stevens Point, WI

8h•$75,000 - $110,000

About The Position

Berkshire Hathaway Specialty Insurance (BHSI) is seeking an experienced Platform Database Engineer in Boston, MA or Stevens Point, WI. The role requires strong technical, organizational, and analytical skills, plus the ability to manage projects independently and in teams. Supporting a global organization, this position may involve occasional night and weekend work. Candidates will complete a technical screening and formal interviews if selected by management.

Requirements

Minimum of 8 years of MS SQL Server database administration experience, demonstrating experience/knowledge of typical DBA tasks, including: Backups, restores, recovery models, patching, disaster recovery. Implementation, configuration, troubleshooting, maintenance. Security, data and schema standards and concepts. Performance Tuning & Optimization, indexes, index management, and statistics.
Strong proficiency with T-SQL programming (joins, views, stored procedures, functions, etc.), database design and optimization techniques.
Proficient on OLTP / OLAP / ER Diagrams / Internal Engine / Index Tuning / Statistics / Execution Plans / SP Optimization / Partitioning / Normalization / Denormalization.
5 or more years of hands-on working knowledge Azure and MS SQL Server, MariaDB, PostgreSQL, etc.

Nice To Haves

Experience working with Enterprise Data Warehouse teams and Data Analytics teams preferred.

Responsibilities

Install, configure, and maintain database instances and management processes, including monitoring system health and performance metrics, to ensure high levels of security, performance, availability, and resilience.
Design, develop, implement, and maintain processes using T-SQL, SQL, PowerShell and Azure Data Factory.
Define and Implement data access controls and monitoring.
Respond promptly to and resolve database-related alerts, emails, and tickets.
Independently analyze, solve, and correct issues in real-time, providing end-to-end problem resolution.
Maintain schema changes and scripts using version control (Visual Studio, TFS, DevOps).
Work with teams that are geographically dispersed and comprised of all disciplines, such as architects, business analysts, developers and testers.
Educate teams on best practices and provide guidance on complex query tuning and schema refinement.
Follow established team standards. For any gap, recommend new or updated standards. Be proactive in identifying areas of improvement.
Document and update processes and procedures when appropriate.
Take ownership, support, and follow through on assigned deliverables, adjusting well to changes in priority.
Develop accurate estimates of effort and timelines. Ensure that all assignments are completed accurately and within approved delivery schedules.
Demonstrate a willingness and commitment to learn.
Perform scheduled maintenance and support release deployment activities, including off-hours.
At times provide off-hours support, including weekends and holidays, on rotation.
Other duties may be assigned, directed or requested.

Benefits

A competitive package and exciting growth opportunities for career-oriented teammates.
A dynamic, action oriented, and thoughtful environment centered on always doing the right thing for our customers, teammates, and our other stakeholders.
A purposely non-bureaucratic organization that embraces simplicity over complexity and emphasizes individual excellence in a team framework.
Benefits that support your life and well-being, which include:
Comprehensive Health, Dental and Vision benefits
Disability Insurance (both short-term and long-term)
Life Insurance (for you and your family)
Accidental Death & Dismemberment Insurance (for you and your family)
Flexible Spending Accounts
Health Reimbursement Account
Employee Assistance Program
Retirement Savings 401(k) Plan with Company Match
Generous holiday and Paid Time Off
Tuition Reimbursement
Paid Parental Leave