SQL Database Developer II

Job Description

Job Description

Job Title :   SQL Database Developer 2

Department :   Information Technology

Reports To :    Development Lead

FLSA :  Exempt

Hours per Week :  37.5

Status :  Full-Time

Grade :  12

Position Summary

The SQL Database Developer II is responsible for the design, development, testing, implementation and support of Microsoft SQL-based relational databases and the suite of MSBA Applications. These databases are used to collect and analyze data gathered through the MSBA’s custom web applications that are both internal and client-facing. This position is also responsible for developing and supporting complex data sets utilizing various reporting platforms.

This position will ensure that data is available to all users and administer the database systems through security, backup and recovery, tuning, automation and disaster recovery planning and testing for MSBA database environments. Working with the IT team, the SQL Database Developer II will participate in the full development life cycle to meet the business objectives of the MSBA.

Essential Functions and Responsibilities

• Design, develop, test, and implement changes and enhancements to current and developing SQL Databases as required
• Develop an understanding of MSBA business processes and workflows to align database architecture with such processes and workflows.
• Support business and client users of the web application through “back-end” database problem solving and troubleshooting of various complex issues as they arise
• Work with Web development team to design and develop application business and data layers.
• Write and maintain comprehensive documentation, including database dependencies, database inventory, basic database troubleshooting, and daily database operations documents.
• Maintain and optimize the databases, data sources and Query server performance, including migrating new changes from online databases to the query database server
• Design and implement new tables to store data and related performance monitoring
• Design appropriate indexes for new tables, and analyze existing indexes for improvement
• Code stored procedures of high complexity to meet business requirements
• Work to implement and maintain SSRS reports ensuring they are of the highest data and visual quality
• Oversee database performance issues and guide optimizations in systems design
• Implement physical data model and data access layer
• Deliver work products that meet specifications, are free of defects, and have excellent performance
• Cultivate and maintain strong relationships with co-workers and project teams
• Support development and ongoing maintenance of MSBA Applications
• Keep up to date with database development best practices
• Support the operational strategies and priorities of the MSBA.
• Perform other duties as assigned

Required Education, Experience, and Skills

Preferred Education, Experience, and Skills

This job description is intended to be general and will evolve over time.  The description is subject to periodic updating. At management’s discretion, the employee may be assigned different or additional duties from time to time.