What are the responsibilities and job description for the Database Developer position at Farm Credit?
**Hybrid work - Incumbent must work three days each week in the Omaha, NE office**
We are 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.
Key Responsibilities
- 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.
Education Requirements
- Bachelor's Degree, Computer Science, Engineering, MIS, or a closely related field preferred.
Years of Experience
- 4 years of experience, developing complex database systems for multi-tier, web-based and mobile technologies.
