What are the responsibilities and job description for the Database Developer position at Berkshire Hathaway Shoe Holdings?
Company Description
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.
• Participate in code reviews, sprint planning, and Agile/Scrum ceremonies.
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.