What are the responsibilities and job description for the Database Developer position at MidFirst Bank - Default?
Position Overview
We are seeking a skilled Database Developer to join our team. The ideal candidate will be responsible for designing and implementing database objects such as tables, views, and stored procedures, as well as developing SSIS packages for data import processes. Experience working with EBCDIC file formats is a strong plus.
Key Responsibilities
- Design, create, and maintain database tables, views, and indexes in Microsoft SQL Server.
- Develop and optimize SSIS packages for importing and transforming data from various sources.
- Ensure data integrity and consistency during ETL processes.
- Collaborate with business analysts and application developers to understand data requirements.
- Troubleshoot and resolve issues related to data imports and database performance.
- Document database structures, processes, and workflows.
- Work with multiple data sources, including EBCDIC file sources, for data import.
Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
- 2 years of experience in SQL Server development.
- Strong proficiency in T-SQL for creating tables, views, and stored procedures.
- Hands-on experience with SSIS for ETL processes.
- Familiarity with EBCDIC file formats and mainframe data sources is a plus.
- Knowledge of data modeling and database design principles.
- Excellent problem-solving and communication skills.
Preferred Skills
- Experience with performance tuning and query optimization.
- Understanding of data warehousing concepts.
- Self-driven with the ability to work independently as well as in a team environment.
- Strong analytical and problem-solving abilities.
- Excellent communication skills for cross-team collaboration.
- Ability to prioritize tasks and manage multiple projects effectively.
- Attention to detail and commitment to data accuracy.
- Adaptability in a fast-paced environment.
- Team-oriented mindset with a proactive approach.
* Must reside within the market area to be considered.
*Position requires a minimum of 3 years of relevant US based experience.
#LI-DNI