Enterprise Database Administrator (DBA)

Berkshire Hathaway - Boston, MA

Full-time

Boston, MA

Insurance Carriers and Related Activities

About the position

Berkshire Hathaway Specialty Insurance (BHSI) is seeking an experienced Enterprise Database Administrator (DBA) to join our team. This role is pivotal in supporting our growing global organization, requiring a blend of strong technical problem-solving skills, organizational abilities, and analytical thinking. The Enterprise DBA will be responsible for installing, configuring, and maintaining database servers and processes, ensuring high levels of security, performance, availability, and resilience. This position will also involve designing, developing, implementing, and maintaining processes using T-SQL, PowerShell, Azure Data Factory, and SSIS. The DBA will need to respond promptly to database-related alerts, emails, and tickets, independently analyze and resolve issues in real-time, and maintain schema changes and scripts using version control tools like Visual Studio, TFS, and DevOps. Collaboration is key, as the DBA will work with geographically dispersed teams, including architects, business analysts, developers, and testers. The role also requires assisting developers with complex query tuning and schema refinement, following established team standards, and proactively identifying areas for improvement. In addition to technical responsibilities, the DBA will document and update processes and procedures, take ownership of assigned deliverables, and ensure that all assignments are completed accurately and within approved delivery schedules. The position may require off-hours support, including weekends and holidays, on rotation, and the DBA will be expected to perform scheduled maintenance and support release deployment activities. This role is ideal for someone who is committed to learning and growing within a dynamic team environment.

Responsibilities

• Install, configure, and maintain database servers and processes, ensuring 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 geographically dispersed teams, including architects, business analysts, developers, and testers.
• Assist developers with complex query tuning and schema refinement.
• Follow established team standards and recommend new or updated standards as needed.
• Document and update processes and procedures when appropriate.
• Take ownership of assigned deliverables and adjust to changes in priority.
• Develop accurate estimates of effort and timelines, ensuring assignments are completed within approved delivery schedules.
• Perform scheduled maintenance and support release deployment activities, including off-hours support.

Requirements

• Minimum of eight (8) years of MS SQL Server database administration experience, demonstrating knowledge of typical DBA tasks such as backups, restores, recovery models, patching, and disaster recovery.
• Experience in implementation, configuration, troubleshooting, and maintenance of database systems.
• Strong understanding of security, data, and schema standards and concepts.
• Proficiency in performance tuning and optimization, including indexes, index management, and statistics.
• Strong proficiency with T-SQL programming, including joins, views, stored procedures, and functions, as well as database design and optimization techniques.
• Hands-on working knowledge of OLTP, OLAP, ER Diagrams, Internal Engine, Index Tuning, Statistics, Execution Plans, SP Optimization, Partitioning, Normalization, and Denormalization.
• Five (5) or more years of hands-on working knowledge of Azure and MS SQL Server.
• Experience with MariaDB, MySQL, and PostgreSQL databases is desired.
• Experience working with Enterprise Data Warehouse teams and Data Analytics teams is preferred.

Nice-to-haves

• Experience with cloud-based database solutions.
• Familiarity with data analytics tools and methodologies.
• Knowledge of additional database management systems beyond MS SQL Server.

Benefits

• A competitive package and exciting growth opportunities for career-oriented teammates.
• A dynamic, action-oriented environment centered on doing the right thing for customers and stakeholders.
• A non-bureaucratic organization that embraces simplicity and emphasizes individual excellence in a team framework.