Platform Database Engineer Boston, MA​/Stevens Point, WI

Overview

Salary Range
: $75,000.00 To $ Annually

Who are we?

A strategic and trusted insurance partner, Berkshire Hathaway Specialty Insurance (BHSI), provides a broad range of commercial property, casualty and specialty insurance coverages and outstanding service to customers and brokers around the world. Part of Berkshire Hathaway’s insurance operations, we bring our solutions to market with our stellar brand name, top-rated balance sheet, and the expertise of our global team of professionals, who exude excellent capabilities and strong character.

We are a values-based organization where respect, integrity, excellence, collaboration, and passion define who we are and how we do business. We value diversity of backgrounds, experience, and perspectives and strive to foster an inclusive environment that enables all our team members to bring their best selves to work. We are one team committed to building a culture where every teammate has the opportunity to contribute and be recognized.

Want to be part of the team building the finest property, casualty and specialty lines insurance company in the world?

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.

• 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, Power Shell 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, Dev Ops).
• 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.

• 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, Maria
  
  DB, Postgre
  
  SQL, etc.
• Experience working with Enterprise Data Warehouse teams and Data Analytics teams preferred.

• A competitive…