Database Administrator/Developer

Play. Practice. Perform. It's the guiding principle for everything we do. Over 9 million musicians choose Musicnotes as their sheet music source. Whether they’re a professional musician, a music educator, a casual pianist, or a music student, we strive to provide an unparalleled sheet music experience.

As the world leader in downloadable sheet music, we offer the best selection of 100% officially licensed and legal arrangements, covering all major instruments for musicians of every skill level. Musicnotes.com recently passed the milestone of over 65 million sheet music downloads to date, and it has been recognized as one of the Top 500 Retail Web Sites every year since 2006.

Founded in 1998 with offices in Madison, Wisconsin and Nashville, Tennessee Musicnotes.com is the world’s largest e-commerce sheet music retailer and publisher, providing 500,000 pieces of officially licensed digital sheet music to over 9 million customers around the globe.

Position Summary

The Database Administrator/Developer is primarily responsible for maintaining and growing Musicnotes data systems. The person in this position works within cross-functional teams in a DevOps, scrum-oriented framework. A typical day may include work on long term projects alone or in teams, responding to bug fix requests and rapidly turning around requests for data export and import.

This job description reflects management’s assignment of essential functions of the job; it does not restrict the tasks that may be assigned.

Essential duties and responsibilities

1. Work within cross-functional teams in a DevOps Scrum framework development environment.

2. Participate in planning and development of new and migrating old internal data systems utilizing .Net and SQL Server technologies.

3. Participate in planning and implementation of HA/DR solutions for data and commerce systems.

4. Working with Azure SQL databases and hybrid cloud database systems.

• Experience modeling data for transactional and reporting systems.

6. Utilize SSIS for ETL of data from internal and external sources.

7. Optimize the performance of database systems.

8. Manage security for SQL Server databases.

9. Work with application developers to build and maintain a development environment.

10. Maintain legacy schema and code with an eye towards strategic refactoring of schema and processes.

11. Work with Product Owners and stakeholders to identify needs and solutions for reporting and self-service BI

12. Document procedures.

13. Turn around ad-hoc data processing requests quickly.

• Participate in the ongoing development and improvement of department operations and procedures.
• Provide an excellent level of customer service to both internal and external customers.
• Works the amount of time required for the position and works extra as needed.

Education Requirement:

· Minimum of a bachelor’s degree in information technology with data and data structures.

• Additional years of education and experience may be substituted for each other, as determined by Human Resources and the hiring Manager.

Knowledge and Skills:

· Full understanding of relational database concepts

· Minimum of 3 – 5 years installing, configuring, and administrating Microsoft SQL Databases.

· 2-3 years experience working with SQL Server Integration Services for ETL processing and data extraction for export.

· Understanding how SQL Server interacts and functions with the underlying Windows OS.

· Experience working with SQL Server native XML functionality.

· Experience planning and implementing DR/HA strategies.

· Experience working within a DevOps Scrum framework.

· Excellent problem-solving skills and an ability to “look outside the box.”

• Excellent organization and time management skills
• Excellent written and verbal communication skills
• Strong attention to detail
• Ability to work well with others in a team environment.
• Ability to read, write and speak English well is a requirement for this position.

Preferred, but not required, skills include:

· Experience with Database Architecture, analyzing existing data structures and modeling new schema designs.

· Experience in Azure and Cloud-based Microservices environment.

In exchange for your talents, we offer you competitive pay and a full benefits package, including medical, dental, vision, and supplemental plans, holiday and paid time off, and a 401k plan with a match to secure your future.

Our work schedule is a hybrid one, where you will work four days in the office and one day from home. We have created a music-inspired environment to make the work more enjoyable. This opportunity is located in Madison, WI.

Job Type: Full-time

Benefits:

• 401(k) matching
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance

Work Location: In person