Database Developer

Apply today for an opportunity to join one of North America’s top insurance premium financing companies!

What started in 1977 as a small, local office offering premium financing has grown to over 650 associates and 29 locations across North America. In all we say and do, we work towards our mission of providing solutions, resources, and premium financing for the insurance industry.

We work hard to deliver on our corporate mission statement by empowering and encouraging our associates to provide great products and an unparalleled level of service.

Since

1977

Over 650

Associates

29

Locations

Based on your location, we offer parking and commuter benefits programs to help make your commute a little easier.

Our insurance benefits include medical, prescription, dental, voluntary vision, voluntary life/dependent life, group term life, and AD&D.

Our wellness program, Well Works, combined with our Employee Assistance Program (for confidential support), provides support for short and long-term health goals, and any bumps along the way. We also offer gym membership subsidies to support health and fitness goals.

We offer paid vacation time and paid personal leave, in addition to company-paid holidays.

IPFS offers a 401(k) with a company match to help set you up for a financially successful future.

Our associates are the foundation of our company. We strive to make our workplace a great place for everyone. IPFS sponsors company lunches, corporate outings, and even the occasional ice cream truck!

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 2 nd and 3 rd 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 Solar Winds DPA and SQLSentry products
• Experience developing and supporting SSRS and/or Power
  
  BI reports