Sql Developer

Moder Solutions; United States; Remote; USD 90,000 - 140,000; Full time

Job summary

Moder Solutions is seeking an experienced SQL Developer to join our remote team. The role requires 8+ years of hands-on SQL development, with strong expertise in stored procedures, data analysis, data mapping, and performance tuning.

You will read, analyze, and troubleshoot complex SQL code, support project teams and clients, and collaborate with stakeholders to ensure data integrity and efficient database operations.

Qualifications

• 8+ years of hands-on SQL development experience.
• Strong expertise in SQL queries, stored procedures, functions, views, and triggers.
• Experience with SQL Server, Oracle, PostgreSQL, or MySQL.
• Ability to read and troubleshoot complex SQL code and data mappings.
• Excellent communication and client management skills.

Responsibilities

• Develop, test, and maintain complex SQL queries, Stored Procedures, Functions, Views, and Triggers.
• Read, analyze, and troubleshoot complex SQL code and database logic.
• Perform data analysis, validation, cleansing, and quality checks.
• Design and maintain database structures supporting business applications and reporting.
• Perform query optimization and database performance tuning.
• Analyze requirements and create accurate source-to-target data mappings.
• Support ETL, data migration, and data integration activities.
• Troubleshoot database and data-related issues and provide timely solutions.
• Work closely with application developers, Business Analysts, project teams, clients, and other stakeholders.
• Document SQL logic, database designs, data mappings, and technical specifications.
• Ensure data accuracy, integrity, security, and compliance with organizational standards.

Skills

SQL Development

Stored Procedures

Data Analysis

Data Mapping

Query Optimization

ETL

SSMS/SSIS/SSRS

Git

RDBMS: SQL Server/Oracle/PostgreSQL/My

Education

Bachelor's degree in Computer Science or related field

Tools

SSMS

SSIS

SSRS

Power BI

Git

Job description

SQL Developer

Job Details

• Job Title: SQL Developer
• Experience: 8+ Years
• Work Mode: Remote

Job Summary

We are looking for an experienced SQL Developer with strong expertise in SQL programming, Stored Procedures, data analysis, data mapping, and database performance tuning.

The ideal candidate should be comfortable working with complex SQL, supporting project teams, and collaborating with clients and stakeholders. Strong communication and client management skills are important for this role.

Key Responsibilities

• Develop, test, and maintain complex SQL queries, Stored Procedures, Functions, Views, and Triggers.
• Read, analyze, and troubleshoot complex SQL code and database logic.
• Perform data analysis, validation, cleansing, and quality checks.
• Design and maintain database structures supporting business applications and reporting.
• Perform query optimization and database performance tuning.
• Analyze requirements and create accurate source-to-target data mappings.
• Support ETL, data migration, and data integration activities.
• Troubleshoot database and data-related issues and provide timely solutions.
• Work closely with application developers, Business Analysts, project teams, clients, and other stakeholders.
• Assist with database-related project activities, production support, and application deployments.
• Document SQL logic, database designs, data mappings, and technical specifications.
• Ensure data accuracy, integrity, security, and compliance with organizational standards.

Required Skills

• 8+ years of hands-on SQL development experience
• Strong expertise in:
• SQL Queries
• Complex Joins
• Subqueries & CTEs
• Stored Procedures
• Functions, Triggers & Views
• Indexes
• Strong ability to read and understand complex SQL
• Strong data analysis and data mapping experience
• Database Design and Data Modeling
• Query Optimization and Performance Tuning
• Experience with one or more RDBMS:
• SQL Server
• Oracle
• PostgreSQL
• MySQL
• Experience with ETL and data integration
• Knowledge of SSMS, SSIS, and SSRS is an advantage
• Familiarity with Data Warehousing concepts
• Knowledge of Git or other version control tools

Client & Project Skills

• Strong communication and stakeholder management skills
• Proven experience in client management
• Ability to explain technical issues and solutions to non-technical stakeholders
• Experience handling client queries, clarifications, and escalations
• Ability to work independently and effectively support project teams
• Strong ownership of assigned tasks and deliverables

Good to Have

• Power BI / Tableau
• Azure SQL / AWS RDS / Cloud databases
• Azure Data Factory / Synapse Analytics
• Snowflake
• Python, Shell scripting, or PowerShell
• DevOps and CI/CD exposure
• Big Data technologies
• Agile/Scrum experience
• Enterprise-scale database environments