SQL Developer

Artificial Intelligence Technologies LLC; Columbus (OH); In loco; USD 80.000 - 110.000; Tempo pieno

Descrizione del lavoro

Artifintech is seeking an SQL Developer to design, develop, optimize, and maintain database solutions across enterprise apps and reporting. You will craft complex SQL queries, write stored procedures, and ensure data accuracy and availability.

The role requires strong experience with SQL Server, Oracle, PostgreSQL, or MySQL, plus input on ETL and data modeling. Collaboration with engineers and analysts is essential.

Competenze

• Proficient in SQL development and relational databases.
• Ability to write complex queries, joins, CTEs, and window functions.
• Experience with stored procedures, triggers, and views.
• Knowledge of multiple DB platforms: SQL Server, Oracle, PostgreSQL, MySQL.
• Experience with query optimization and performance tuning.
• Understanding of data modeling, normalization, and ETL.

Mansioni

• Develop and maintain complex SQL queries, stored procedures, and functions.
• Design and optimize database structures to support applications.
• Analyze execution plans and improve performance.
• Troubleshoot data issues and defects.
• Build and maintain ETL processes.
• Validate data integrity and support migrations.
• Collaborate with developers, analysts, and business teams.
• Maintain documentation and follow coding standards.

Conoscenze

SQL development

Relational databases

Query optimization

Data modeling

ETL processes

Data validation

Python scripting

PowerShell

Data analysis

Debugging

Formazione

Bachelor's degree in Computer Science or related field

Master's degree preferred

Certifications (MS SQL Server / Oracle / PostgreSQL)

Strumenti

Microsoft SQL Server

Oracle Database

PostgreSQL

MySQL

Tableau

Power BI

SSRS

Descrizione del lavoro

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization:

US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Position Description:

The SQL Developer will design, develop, optimize, and maintain database solutions to support enterprise applications and business reporting. This role involves writing complex SQL queries, developing stored procedures, managing database performance, and ensuring data accuracy, consistency, and availability.

Database Skills & Technical Requirements:

Strong hands-on experience with SQL development and relational database management systems.

Proficiency in writing complex SQL queries, joins, subqueries, CTEs, and window functions.

Experience with stored procedures, functions, triggers, and views.

Knowledge of database platforms such as Microsoft SQL Server, Oracle, PostgreSQL, or MySQL.

Experience with query optimization, execution plans, indexing, and performance tuning.

Understanding of database design, normalization, and data modeling concepts.

Familiarity with ETL processes, data integration, and data transformation.

Experience with database backup, recovery, and data validation procedures.

Knowledge of reporting tools such as Power BI, SSRS, or Tableau is preferred.

Familiarity with Python, PowerShell, or other scripting languages is an advantage.

Core Database Responsibilities:

Develop and maintain complex SQL queries, stored procedures, and database functions.

Design and optimize database structures to support application requirements.

Analyze query execution plans and improve database performance.

Troubleshoot database issues and resolve data-related defects.

Build and maintain data extraction, transformation, and loading processes.

Perform data validation, reconciliation, and integrity checks.

Support database migrations, upgrades, and application integrations.

Collaborate with developers, data analysts, and business teams to understand data requirements.

Maintain database documentation and follow established development standards.

Ensure data security, consistency, and reliability across database environments.

Experience & Professional Skills:

4+ years of experience in SQL development or database engineering.

Strong experience working with enterprise relational databases.

Demonstrated ability to develop complex queries and troubleshoot performance issues.

Understanding of database architecture and software development lifecycle practices.

Strong analytical, debugging, and problem-solving skills.

Ability to manage multiple development tasks and collaborate with technical teams.

Education & Preferred Certifications:

Bachelor's degree in Computer Science, Information Technology, Database Administration, or a related field.

Master's degree is preferred.

Microsoft SQL Server, Oracle Database, or PostgreSQL certifications are an advantage.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.