This role is responsible for developing relational database and related reporting solutions that support information systems by studying operations; designing, developing, and deploying solutions; supports and guides data modeling and data access strategies for the software development team.

Duties and responsibilities:

· Designing and coding database tables to store application data

· Enforce referential integrity and business constraints

· Working with application developers to create optimized stored procedures

· Identify and create indexes to improve database performance

· Tune existing T-SQL queries/stored procedures to improve performance

· Ensure that new database code meets company standards for readability, reliability, naming conventions, and performance

Qualifications:

· Bachelor’s degree in recognized program for information systems or computer science or equivalent experience required.

· 2+ years of SQL Server database development experience.

· Strong experience with SQL Server queries for all CRUD operations

· Comfortable with complex joins, nested subqueries, etc.

· Strong experience with stored procedure creation.

· Performance tuning/query refactoring a strong plus.

· Ability to provide quality customer service and teamwork while managing multiple tasks and projects under competing deadlines a must.

· Excellent verbal and written communication skills.

· Understanding of IT principles and an ability to communicate technical concepts effectively to a varied audience.

· Working with Azure and RedGate Tools

· Using Git as source control for backend code

· Understanding or working knowledge of DevOps process

· Working on an Agile/Scrum team

· General DBA knowledge (backups, restores, AlwaysOn, Job Scheduling, Alerting, etc.)

· Extraction, Transformation and Loading (ETL) (Microsoft SSIS)

· Report Development (Microsoft SSRS)

· Analytics / OLAP Cube Development (Microsoft SSAS and MDX)