Enterprise Database Administrator (DBA)

Boston, MA

Insurance Carriers and Related Activities

About the position

Berkshire Hathaway Specialty Insurance (BHSI) has an exciting opportunity for an experienced Enterprise DBA. We are searching for qualified candidates based in Boston, MA or Stevens Point, Wisconsin. This position will require strong technical problem solving, organizational, and analytical skills. The ability to work, make decisions, and manage projects, both independently, and within a dynamic team environment, is crucial. The Enterprise DBA role supports a growing global organization and may require periodic night and weekend work. An initial technical screening followed by a formal interview process will take place once management expresses interest in a candidate.

Responsibilities

• Install, configure, and maintain database servers and processes, including monitoring system health and performance, to ensure high levels of security, performance, availability, and resilience.
• Design, develop, implement, and maintain processes using T-SQL, PowerShell, Azure Data Factory and SSIS.
• 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.
• Assist developers with 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.

Requirements

• Minimum of three (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.
• Five (5) or more years of hands-on working knowledge Azure and MS SQL Server.
• Hands-on working knowledge in MariaDB, MySQL and PostgreSQL databases desired.
• Experience working with Enterprise Data Warehouse teams and Data Analytics teams preferred.

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.