Database Developer I

Summary

InterSources Inc is an IT consulting and technology services company. The Database Developer I will develop, implement, and maintain database objects and systems, optimize SQL query performance, build SSIS ETL pipelines, and resolve database issues while collaborating with business stakeholders.

Responsibilities

• Prepares, defines, structures, develops, implements, and maintains database objects
• Analyze query performance, identify bottlenecks, and implement optimization techniques
• Defines and implements interfaces to ensure that various applications and user-installed or vendor-developed systems interact with the required database systems
• Creates database structures, writing and testing SQL queries, and optimizing database performance
• Plans and develops test data to validate new or modified database applications
• Work with business analysts, and other stakeholders to understand requirements and integrate database solutions
• Build and implement database systems that meet specific business requirements ensuring data integrity and security, as well as troubleshooting and resolving database issues
• Design and implement ETL pipelines to integrate data from various sources using SSIS
• Responsible for various SQL jobs

Skills

• **Please ensure that your candidate's location is noted in the submittal. USC/GC candidates only
• * Strong understanding of SQL and DBMS like MySQL, PostgreSQL, or Oracle
• * Ability to design and model relational databases effectively
• * Skills in writing and optimizing SQL queries for performance
• * Ability to troubleshoot and resolve database-related issues
• * Ability to communicate technical information clearly and concisely to both technical and non-technical audiences
• * Ability to collaborate effectively with other developers and stakeholders
• * Strong ETL experience specifically with SSIS
• 2 years of progressively responsible programming experience or an equivalent combination of training and experience
• Education Required: Bachelor`s degree in Information Technology or Computer Science or equivalent experience
• * Azure experience is a plus
• * .Net experience is a plus
• * GITHub experience is a plus
• Local would be preferred, but we are willing to consider candidates out of state and make this a full-time remote position if they are the best fit

Qualifications

Must Haves

• **Please ensure that your candidate's location is noted in the submittal. USC/GC candidates only
• * Strong understanding of SQL and DBMS like MySQL, PostgreSQL, or Oracle
• * Ability to design and model relational databases effectively
• * Skills in writing and optimizing SQL queries for performance
• * Ability to troubleshoot and resolve database-related issues
• * Ability to communicate technical information clearly and concisely to both technical and non-technical audiences
• * Ability to collaborate effectively with other developers and stakeholders
• * Strong ETL experience specifically with SSIS
• 2 years of progressively responsible programming experience or an equivalent combination of training and experience
• Education Required: Bachelor`s degree in Information Technology or Computer Science or equivalent experience

Nice to Haves

• * Azure experience is a plus
• * .Net experience is a plus
• * GITHub experience is a plus
• Local would be preferred, but we are willing to consider candidates out of state and make this a full-time remote position if they are the best fit

Benefits

• Remote or hybrid work is possible for this role.
• This can be a full-time remote position for out-of-state candidates who are the best fit.