Database Administrator II

As one of the leading writers of Federal Crop Insurance, AgriSompo North America combines industry experience, resources, capital and talent to deliver both traditional and innovative crop insurance and productivity tools to farmers, ranchers, insurers and agribusinesses in the United States. Our organization operates within a culture rooted in ethics, integrity and a belief that accountability, collaboration and agility are crucial to long-term success.

AgriSompo North America is a part of AgriSompo, Sompo International's global agriculture platform. This platform is an integrated underwriting, technology and distribution platform delivering innovate insurance and reinsurance solutions to agriculture partners worldwide. Sompo International, AgriSompo's parent company, is a global organization driven by its core values, a carrier that holds promise, trust and the commitment to protect. Through operating subsidiaries, Sompo International writes agriculture, casualty and other specialty, professional lines, property, marine/energy and aviation lines of insurance and catastrophe, property, casualty, professional lines and specialty lines of reinsurance.

As a leading provider of crop insurance and other agricultural risk management tools, we recognize that our success is derived directly from those whose contributions matter most: our people. AgriSompo North America has major offices in Lenexa, Kansas and Des Moines, Iowa as well as regional offices around the country. A shared commitment to integrity, accountability, collaboration and agility define our culture, and we strive to create exceptional value for our clients and shareholders and maintain AgriSompo North America as a desirable place to work.

Job Description

AgriSompo is seeking Application DBAs to maintain and enhance our custom-built crop insurance application. The system, called AgriNet, is considered one of the leading crop insurance applications in the industry. It supports all of the insurance functions including policy administration, quoting/rating, GIS mapping of cropland, claims, accounting, reporting and transmission of data to the U.S. Government. We have approximately 3,000 Agents and 900 employees using the system to support approximately 80k policy holders and 90m acres of farmland.

Duties & Responsibilities

• The application DBA role involves logical database design, reporting and the ongoing support and administration of databases pertaining to AgriSompo's business applications.
• The application DBA is responsible for writing and debugging complex SQL and understands the best ways to incorporate database requests into application programs.
• The Application DBA is deeply involved in requirements definition, design, development, deployment, maintenance and enhancement of applications working as part of the Application Development team, with specific focus on databases.
• Responsible for change management and performance tuning of the database landscape.
• The position will play a primary role in multiple projects including the modernization of the core Crop Insurance Application platform.
• Work with Technical Leads and Senior Engineers in defining, designing, building, managing, and maintaining technical solutions in accordance with the IT SDLC processes, standards and best practices.
• Ensure that functional and non-functional requirements are clearly understood, designed against, tested and documented for performing, reliable, scalable, portable and highly available applications
• Manage enhancements and the resolution of incidents in accordance with IT service delivery and support principles.

Qualifications Include

• Bachelor's degree in computer science, engineering or similar
• Minimum five years of professional experience as a SQL Server Application DBA with MS SQL Server 2012 and up
• Configuration and deployment experience for SSIS, SSRS and SSAS in online and data warehouse environments
• Strong knowledge of reporting services; Microsoft Reporting Services
• Strong knowledge of database design principles, database logical and physical design
• Highly competent in SQL database performance tuning, creation of right indexing strategy to meet data growth needs and performance monitoring and query optimization Strong SQL skills to provide code review and tuning feedback to the development team
• Strong knowledge of database administration, Software Development Life Cycle (SDLC), and systems analysis procedures
• Experience in application development tools (e.g. GIT, Visual Studio/Azure DevOps and source control), testing, and process and configuration management
• Effectively communicates and documents technical architecture and solutions to internal peer groups as well as other groups
• A team player with solid communication skills, excellent at problem solving, troubleshooting, and embracing new challenges
• Positive attitude and the ability to remain flexible in a dynamic environment
• Ability to manage time across multiple, simultaneous projects
• Must demonstrate the ability to work effectively as a member of a team, as well as the maturity to work independently.

Salary: $65,000 Actual compensation for this role will depend on several factors including the cost of living associated with your work location, your qualifications, skills, competencies, and relevant experience.

At Sompo International, we recognize that the talent, skills, and commitment of our employees drive our success. This is why we offer competitive, high-quality compensation and benefit programs to eligible employees.

Our compensation program is built on a foundation that promotes a pay-for-performance culture, resulting in higher incentive awards, on average, when the Company does well and lower incentive awards when the Company underperforms. The total compensation opportunity for all regular, full-time employees is a combination of base salary and incentives that gets adjusted upfront based on overall Company performance with final awards based on individual performance.

We continuously evaluate and update our benefit programs to ensure that our plans remain competitive and meet the needs of our employees and their dependents. Below is a summary of our current comprehensive U.S. benefit programs:

• Two medical plans to choose from, including a Traditional PPO & a Consumer Driven Health Plan with a Health Savings account providing a competitive employer contribution.
• Pharmacy benefits with mail order options.
• Dental benefits including orthodontia benefits for adults and children.
• Vision benefits.
• Health Care & Dependent Care Flexible Spending Accounts.
• Company-paid Life & AD&D benefits, including the option to purchase Supplemental life coverage for employee, spouse & children.
• Company-paid Disability benefits with very competitive salary continuation payments.
• 401(k) Retirement Savings Plan with competitive employer contributions.
• Competitive paid-time-off programs, including company-paid holidays.
• Competitive Parental Leave Benefits & Adoption Assistance program
• Employee Assistance Program
• Tax-Free Commuter Benefit
• Tuition Reimbursement & Professional Qualification benefits.

Sompo International is an equal-opportunity employer committed to a diverse workforce. M/F/D/V