Senior Database Developer​/Legacy Maintainer

We are seeking an experienced Database Developer to maintain and enhance our legacy agricultural management application (Meta Farms). This role requires a strong database development background with the ability to work with legacy .NET Framework applications. The ideal candidate will have experience maintaining complex, business-critical systems and the ability to quickly understand domain-specific business logic.

Meta Farms is a comprehensive agricultural production management system used by swine production operations. The application manages sow operations, feed management, finishing operations, sales, and integrates with various third-party systems. The system has been in production for over 20 years and contains extensive business logic embedded in both the database layer and application code.

Primary Focus:
Database Development (70-80% of role)

• Stored Procedure Development & Maintenance
  • Design, develop, and maintain complex stored procedures (1,000+ existing procedures)
  • Optimize existing stored procedures for performance
  • Debug and troubleshoot database performance issues
  • Handle complex business logic within SQL Server
• Database Schema Management
  • Create and modify database tables, views, and functions
  • Manage database migrations and schema changes
  • Maintain referential integrity across complex data models
  • Work with SQL Server Database Projects (.sqlproj)
• Data Analysis & Reporting
  • Write complex queries for business reporting needs
  • Create and maintain database views for reporting
  • Understand and maintain existing database architecture

Excel Report Development (15-20% of role)

• Excel Report Generation
• Develop and maintain Excel reports using Soft Artisans Office Writer/Excel Writer
• Create data-bound Excel templates with complex formatting
• Generate reports for various business modules:
  Sow, Finish
• Handle report customization and parameter-driven reporting

Application Maintenance (10-15% of role)

• Maintain ASP.NET Web Forms applications
• Debug and fix issues in existing codebase
• Work with legacy ASMX web services
• Understand and maintain  components

• Maintain and enhance .NET 6+ REST APIs
• Work with Entity Framework Core
• Integrate with third-party systems

• Database Development (REQUIRED - Primary Skill)
  • 5+ years of experience with SQL Server stored procedure development
  • Experience with complex database queries, views, and functions
  • Strong understanding of database performance optimization
  • Experience with SQL Server Database Projects and schema management
• 3+ years of experience with .NET Framework 4.x (preferably 4.8)
• Experience with ASP.NET Web Forms
• Understanding of legacy application architecture patterns
• Ability to work with older codebases and technologies
• Excel Report Development
• Experience generating Excel reports programmatically
• Familiarity with Excel template-based reporting
• Understanding of data binding and Excel formatting
• General Development Skills
• Strong debugging and troubleshooting abilities
• Experience with version control (Git)
• Ability to read and understand complex, legacy code
• Strong problem-solving skills

• Experience with .NET 6+ and modern C# features
• Experience with REST API development
• Experience with Entity Framework Core
• Knowledge of agricultural or livestock management systems
• Experience with third-party integrations
• Experience with background services and scheduled jobs
• Understanding of dependency injection and modern .NET patterns

Compensation: $80,000 – $95,000 annually

Placement within the range is determined by relevant experience, demonstrated technical capability, and internal equity considerations.