Job description

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.

We are a growing company and currently seeking multiple 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 and 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:

• 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.

Job Type: Full-time

Pay: From $65,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Flexible schedule
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Parental leave
• Professional development assistance
• Referral program
• Tuition reimbursement
• Vision insurance

Schedule:

• Day shift

Supplemental pay types:

• Bonus pay

Education:

• Bachelor's (Preferred)

Work Location: Multiple Locations

colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.