Database Developer

at  Farm Credit Services of America

*HYBRID WORK- INCUMBENT MUST WORK THREE DAYS EACH WEEK IN THE OMAHA, NE OFFICE*

Farm Credit Services of America (FCSAmerica) is a great place to work. You see it in our people and the relationships they have with each other and our customers. Our passion and commitment to serving both rural America and each other is key to our success in the marketplace. That is why we seek highly motivated, positive-thinking people who foster honesty and integrity – the core values that guide how we work and treat others.
FCSAmerica is seeking a Database Developer who will review, evaluate, design, develop, implement and maintain company databases using industry leading database tools. Develop implementation documentation which may include data sources, data diagrams, and other data movement processes. Write code for database access, modifications, and constructions including stored procedures. Develop SQL queries in the creation of business applications and SQL reports from corporate data sources. Work closely with the Information Technology teammates and end-users to design and develop specifications, data dictionaries and access methods for optimum performance.

EDUCATION REQUIREMENTS

• Bachelors Degree Minimum in Computer Science, Engineering, MIS, or a closely related field

YEARS OF EXPERIENCE

• 4+ years of experience developing complex database systems for multi-tier, web-based and mobile technologies

CERTIFICATION AND TECHNICAL REQUIREMENTS

• Familiar with a variety of industry standards regarding Microsoft database development concepts, practices, and procedures.
• Proficiency with database development including the development of stored procedures, indexes, ActiveBatch jobs, SSIS packages and use of RedGate tools
• Proficiency with current and recent versions of SQL Server. Database development experience with Visual Studio a plus.
• Proficient in a Windows and Microsoft Office computing environment.
• Experience with cloud database technologies like Azure SQL or SQL Server on AWS
• Experience with Snowflake cloud data warehouse
• Exposure to NoSQL databases Neo4J, MongoDB, Redis

ABOUT US

Farm Credit Services of America (FCSAmerica), AgCountry Farm Credit Services (AgCountry), and Frontier Farm Credit are financial cooperatives operating under joint management. While each Association is owned by its local farmers and ranchers, the cooperatives pool their resources, experience, and talent to deliver affordable credit, crop insurance services, and financial services.
FCSAmerica serves rural communities and agriculture in Iowa, Nebraska, South Dakota, and Wyoming. AgCountry serves portions of North Dakota, Minnesota, and Wisconsin, and Frontier Farm Credit serves eastern Kansas. Together, we support nearly 82,000 producers and agribusinesses, meeting the needs of today’s agricultural industry with our combined 2600+ employees providing lending, risk management, technology, commodity marketing, and customer and employee education.
We have employment opportunities across our combined eight states. FCSAmerica is headquartered in Omaha, Nebraska, and has 48 local offices; AgCountry is headquartered in Fargo, ND and has 45 local offices; and Frontier Farm Credit is headquartered in Manhattan, KS and has six local offices.
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, age, marital status, national origin, disability status, protected veteran status, sexual orientation, gender identity or any other characteristic protected by law

• Database Design, Development and Deployment - Analyze, design and implement sound database schemas. Provide expertise in creating database tables, views, indexes, constraints, stored procedures, rules and other objects to optimize performance and enforce data integrity. Work with teammates to optimize continuous integration and deployment practices. Provide database related leadership to project teams and mentor team members on database technologies as needed.

• Data Movement - Implement plans and procedures that automate and improve the efficiency and effectiveness of data processes and analysis. Design and effectively implement Extract Transform Load (ETL) style operations using SQL Server Integration Services (SSIS). Manage and lead SSIS integration projects and mentor team members on the proper use and development of SSIS packages and workflows. Understand impacts of moving data across the enterprise.

• Testing - Work with software development project teams to develop and execute testing procedures for database enhancements and data corrections. Provide effective testing of new technology related to data management, storage, and retrieval.
• Technology and Processes – Experience with enterprise grade database platforms such as SQL Server, Snowflake, and Oracle. Knowledge and/or experience with source control tools such as Azure DevOps and database builds and deployment automation such as Flyway Desktop and Octopus Deploy. Experience with other programming languages, such as PowerShell or Python are also a plus.