SQL Developer

Cloud Analytics Technologies, LLC; Columbus (OH); In loco; USD 90.000 - 120.000; Tempo pieno

Descrizione del lavoro

Cloud Analytics Technologies, LLC in Columbus, OH is seeking a SQL Developer to design, develop, and maintain database solutions supporting enterprise applications and reporting. You will write complex SQL, develop stored procedures, and monitor performance to ensure data accuracy and availability.

Candidates should have 4+ years of SQL experience with relational databases (SQL Server, Oracle, PostgreSQL or MySQL), strong query optimization skills, and familiarity with ETL and data modeling.

Competenze

• 4+ years of experience in SQL development or database engineering.
• Experience with enterprise relational databases.
• Ability to develop complex queries and troubleshoot performance.
• Knowledge of database design, normalization, and data modeling concepts.
• Familiarity with ETL processes, data integration, and data transformation.

Mansioni

• 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.

Conoscenze

SQL development

Query optimization

ETL processes

Data modeling concepts

Data validation

Scripting (Python/PowerShell)

Data security and reliability

Analytical problem-solving

Collaboration with tech teams

Formazione

Bachelor's degree in Computer Science / IT / Database Administration

Master's degree preferred

SQL Server / Oracle / PostgreSQL certifications advantageous

Strumenti

Microsoft SQL Server

Oracle Database

PostgreSQL

MySQL

Power BI

SSRS / Tableau

Python

PowerShell

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.

Some of our Business Ventures - Knowledge Analytics

Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: