Database Developer

Database Developer

Job Summary

The database developer will be responsible for development and maintenance of high performance database code that supports IPFS's software systems. You will work closely with the development and architecture teams to deliver quality database solutions to meet business objectives and maintain a positive end user experience. You will carry out database performance troubleshooting and tuning, as well as review objects as they are developed to ensure that they meet performance and functional requirements. You will become a subject matter expert on our data and processes. Database systems you design and maintain are required to be available and performant to meet Imperial PFS's business needs.

Essential Job Functions

Gain expertise in the IPFS Database Schema and domain data flows end to end from front end to Batch Processing

Work with the Software Engineering team to design new database objects (Stored procedures, functions, views, and tables)

Assist the Database Administrators and Development teams in writing complex SQL code and troubleshooting support incidents

Assist with the creation and maintenance of documentation of IPFS database systems

Perform code reviews on code submitted by the development teams

Proactively locate areas where there is an opportunity for performance improvement in our existing systems.

Work on highly complex projects with minimal supervision and proactively raise issues/concerns to management as needed

Provide 2nd and 3rd tier support of database systems as needed

Participate in on-call rotation as needed Experience in the following areas is required

5+ years experience with database development using SQL Server

Expert knowledge of ANSI Standard Transact-SQL and latest Transact-SQL query language enhancements.

Strong experience maintaining enterprise-level databases including optimization, indexing, troubleshooting performance issues, and tuning

Experience with delivering and supporting large, high-performance databases across multiple SQL Instances

Experience using query store and DMVs to identify issues and performance tuning opportunities

SQL Server SQL Agent and other Automation tools

Strong written and verbal communication skills

Experience with automated deploys and version control of SQL objects using SSDT. Experience in the following areas is a plus

Experience deploying and maintaining SQL databases in Azure

Bachelor's degree in Software Engineering, Computer Science, or similar field of study

Experience working with databases in Azure in a PaaS and/or IaaS environment.

Experience working with GIT version control systems and ADO.

Experience working with performance monitoring tools such as SolarWinds DPA and SQLSentry products

Experience developing and supporting SSRS and/or PowerBI reports