What are the responsibilities and job description for the Database Developer position at AgreeYa Solutions?
Job Details
Job Title :: Database Developer
Job Location :: Phoenix, AZ
Job Description:
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 Required:
- 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.
Skills Preferred:
- Azure experience is a plus, .Net experience is a plus, GITHub experience is a plus.
Experience Required:
- 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.
Salary : $35 - $40