Platform Database Engineer

Overview

Berkshire Hathaway Specialty Insurance (BHSI) is a strategic and trusted insurance partner providing a broad range of commercial property, casualty and specialty insurance coverages and outstanding service to customers and brokers worldwide. We are a values-based organization where respect, integrity, excellence, collaboration, and passion define how we do business. We value diversity of backgrounds, experience, and perspectives and strive to foster an inclusive environment that enables all team members to contribute and be recognized.

We are one team building the finest property, casualty and specialty lines insurance company in the world.

Learn more about our unique culture and history.

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 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…