Database Administrator

Database Engineer-Location Madison Wisconsin

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 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:

• Manage and monitor SQL Server databases to ensure optimal performance, availability, and security.
• Collaborate with developers, system administrators, and other stakeholders to ensure efficient and effective use of database resources.
• Collaborate with reporting teams to develop ETL pipelines to a data warehouse environment in Azure.
• Develop and maintain SSIS packages and other deliveries of data feeds to external sources.
• Implement and maintain database backup and recovery strategies to minimize data loss and downtime.
• Perform regular database maintenance tasks, such as index rebuilding, query optimization, and database tuning.
• Proactively identify and resolve database performance issues and bottlenecks.
• Develop and implement database security policies and procedures to protect sensitive data.
• Monitor and analyze database performance metrics and provide recommendations for improvement.
• Plan and execute database migration and upgrade projects in a high availability environment.
• Troubleshoot and resolve database-related problems in a timely manner.
• Document database configurations, procedures, and troubleshooting steps.

Education Requirement:

• Bachelor’s degree in computer science, information technology, or a related field. 
• Additional years of education and experience may be substituted for each other, as determined by Human Resources and hiring Manager. 

Required knowledge and skills:

• Minimum of 3 - 5 years installing, configuring, and administrating Microsoft SQL Server Databases.
• Minimum of 2 - 3 years developing, debugging, and maintaining SSIS packages.
•  Minimum of 2 - 3 years proficiency with writing complex SQL queries and stored procedures.
• A full understanding of relational database concepts and third normal form design.
•  Experience planning and implementing high availability and disaster recovery strategies.
• 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, knowledge and skills include:

• Experience architecting databases by analyzing existing data structures and modeling new schema designs.
• Experience in Azure and cloud microservices environments.
• Experience with Azure Data Factory and other cloud data integration tools.
• Experience with data warehouse architecture designs in a star schema.
• Experience working with SQL Server native XML functionality.

Physical Requirements and Work Environment:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform essential functions. 

While performing the duties of the job, the employee must be able to use a keyboard. They are regularly required to stand or walk, sit, talk, hear, and use their hands to finger, grasp, handle, or feel. The employee must occasionally climb, stoop, kneel, crouch, lift (10lbs), and have the ability to adjust vision for close vision work. This position does require prolonged sitting in front of a computer.

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.