Database Developer

Apply today for an opportunity to join one of North America's top insurance premium financing companies!Great companies have great teams.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.Since1977Over 650Associates29LocationsEmployee BenefitsAt the OfficeBased on your location, we offer parking and commuter benefits programs to help make your commute a little easier.Insurance BenefitsOur insurance benefits include medical, prescription, dental, voluntary vision, voluntary life/dependent life, group term life, and AD&D.Our wellness program, WellWorks, 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.Work Life BalanceWe offer paid vacation time and paid personal leave, in addition to company-paid holidays.Preparing for Your FutureIPFS offers a 401(k) with a company match to help set you up for a financially successful future.Company CultureOur 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 FunctionsGain expertise in the IPFS Database Schema and domain data flows end to end from front end to Batch ProcessingWork 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 incidentsAssist with the creation and maintenance of documentation of IPFS database systemsPerform code reviews on code submitted by the development teamsProactively 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 neededProvide 2 nd and 3 rd tier support of database systems as neededParticipate in on-call rotation as neededExperience in the following areas is required5+ years experience with database development using SQL ServerExpert 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 tuningExperience with delivering and supporting large, high-performance databases across multiple SQL InstancesExperience using query store and DMVs to identify issues and performance tuning opportunitiesSQL Server SQL Agent and other Automation toolsStrong written and verbal communication skillsExperience with automated deploys and version control of SQL objects using SSDT.Experience in the following areas is a plusExperience deploying and maintaining SQL databases in AzureBachelor's degree in Software Engineering, Computer Science, or similar field of studyExperience 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 productsExperience developing and supporting SSRS and/or PowerBI reportsJ-18808-Ljbffr