Database Developer

Berkshire Hathaway Shoe Holdings; Andover (MA); Presencial; USD 80.000 - 100.000; Jornada completa

Descripción de la vacante

Berkshire Hathaway Shoe Holdings seeks a skilled Database Developer in Andover, MA, to design and maintain relational databases using Microsoft SQL Server. The ideal candidate will have 2+ years of hands-on experience with T-SQL and C# development, ensuring robust application performance and data integrity.

The role emphasizes collaboration with development teams and optimization of database queries. A Bachelor's degree in computer science or a related field is essential.

Formación

• Minimum 2 years of experience with Microsoft SQL Server (2016 or later).
• Proficiency in T-SQL including complex joins and window functions.
• At least 2 years of experience with C# programming.

Responsabilidades

• Design and maintain relational databases using SQL Server.
• Write and optimize T-SQL queries and stored procedures.
• Collaborate with teams to integrate database logic into applications.

Conocimientos

Microsoft SQL Server

T-SQL

C#

OOP Principles

Database Normalization

Git

Problem Solving

Educación

Bachelor’s degree in computer science or related field

Herramientas

.NET Framework

Entity Framework

Azure SQL

ASP.NET Core

Descripción del empleo

Berkshire Hathaway Shoe Holdings is home to 18 diverse brands of shoes, standing out in the industry with state-of-the-art patented technologies. Driven by creativity and innovation, the company’s success is built on the dedication of a highly motivated team. We strive to continually deliver exceptional quality and style, making a lasting impact on the footwear market.

KEY RESPONSIBILITIES

• Design, develop, and maintain relational databases using Microsoft SQL Server.
• Write and optimize complex T‑SQL queries, stored procedures, views, triggers, and functions.
• Develop and maintain C# applications and services that interact with SQL Server databases.
• Apply object‑oriented design principles (encapsulation, inheritance, polymorphism) to build maintainable code.
• Collaborate with development teams to integrate backend database logic into application workflows.
• Monitor database performance and implement tuning strategies such as indexing, query optimization, and execution plan analysis.
• Perform data migrations, transformations, and ETL operations as needed.
• Troubleshoot and resolve database issues, data integrity problems, and performance bottlenecks.
• Create and maintain technical documentation, including data models, ERDs, and schema documentation.
• Ensure database security, access controls, and backup/recovery procedures are in place and up to date.

REQUIRED QUALIFICATIONS

• Minimum 2 years of experience working with Microsoft SQL Server (2016 or later).
• Proficiency in T‑SQL including complex joins, subqueries, CTEs, and window functions.
• At least 2 years of experience with an object‑oriented programming language, with strong preference for C#.
• Solid understanding of OOP principles and design patterns (e.g., MVC, Repository, Factory).
• Experience with .NET Framework or .NET Core for backend development.
• Familiarity with database normalization, schema design, and data modeling concepts.
• Understanding of database indexing strategies and query execution plans.
• Experience with version control systems such as Git.
• Strong analytical, problem‑solving, and debugging skills.
• Ability to work independently and as part of a collaborative development team.

PREFERRED QUALIFICATIONS

• Familiarity with Entity Framework or other ORM frameworks.
• Exposure to Azure SQL, Azure Data Factory, or other cloud database services.
• Knowledge of RESTful API development using ASP.NET Core or Web API.
• Experience with Agile/Scrum methodologies and tools such as Jira or Azure DevOps.
• Understanding of CI/CD pipelines and DevOps practices.
• Familiarity with PowerShell scripting for database automation tasks.
• Microsoft certifications (e.g., DP-300: Azure Database Administrator Associate) are a plus.

EDUCATION

• Bachelor’s degree in computer science, Information Technology, Information Systems, or a related field.