Enterprise Database Administrator (DBA)

Job Description

Job Description

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?

Learn more about our unique culture and history.

Job Opportunity :

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.

Duties & 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.

Qualifications, Skills and Experience :

• 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
• MariaDB, PostgreSQL, etc.
• Hands-on working knowledge in MariaDB, MySQL and PostgreSQL databases desired
• Experience working with Enterprise Data Warehouse teams and Data Analytics teams preferred

BHSI Offers :

• 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

NOTE : Compensation will be commensurate with experience. This job description is not intended to be all-inclusive. Team Member may perform other related duties as negotiated to meet the ongoing needs of the organization.