Job Description
Job Description
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