GC only

S R International•Phoenix, AZ

7d•Hybrid

About The Position

This role involves preparing, defining, structuring, developing, implementing, and maintaining database objects. The position requires analyzing query performance, identifying bottlenecks, and implementing optimization techniques. It also includes defining and implementing interfaces to ensure seamless interaction between various applications and systems with the required database systems. The developer will create database structures, write and test SQL queries, and optimize database performance. Additionally, the role involves planning and developing test data to validate new or modified database applications, collaborating with business analysts and stakeholders to understand requirements and integrate database solutions, and building and implementing database systems that meet specific business requirements while ensuring data integrity and security. Troubleshooting and resolving database issues, and designing and implementing ETL pipelines using SSIS to integrate data from various sources are also key responsibilities. The role is responsible for various SQL jobs.

Requirements

2 years of progressively responsible programming experience or an equivalent combination of training and experience.
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
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

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.