Remote SQL Developer - Optimize & Scale Databases

allps; United States; Hybrid; USD 80,000 - 110,000; Full time

Job summary

A technology solutions provider is seeking a skilled SQL Developer to design, optimize, and maintain database solutions from a remote location. The ideal candidate will have 2–8 years of experience and must excel in writing complex SQL queries, optimizing database performance, and collaborating with development teams to ensure data accuracy. This is a full-time position that offers the opportunity for remote work and requires strong analytical skills and good communication abilities.

Qualifications

• 2–8 years of experience as a SQL Developer with a strong understanding of database management.
• Ability to write complex SQL queries and optimize database performance.
• Good analytical skills with the ability to resolve database-related issues.

Responsibilities

• Design and develop efficient SQL queries and functions.
• Optimize database performance and implement best practices.
• Work closely with developers and analysts to ensure data integrity.

Skills

SQL (MySQL / PostgreSQL / MS SQL Server / Oracle)

Complex joins, subqueries, CTEs, window functions

Query optimization and performance tuning

Database design, normalization, and indexing

Working with large datasets

ETL processes and data validation

Analytical and problem-solving skills

Good communication and documentation skills

Tools

NoSQL databases (MongoDB, DynamoDB)

Python, PL/SQL, T-SQL

BI tools (Power BI, Tableau, Looker)

Cloud databases (AWS RDS, Azure SQL, Google BigQuery)

Version control systems (Git)

Job description

Job Title: SQL Developer

Experience: 2–8 Years
Location: Remote
Employment Type: Full-time

Job Description

We are looking for a skilled SQL Developer to design, develop, optimize, and maintain database solutions that support business applications and analytics. The ideal candidate should have strong experience in writing complex SQL queries, improving database performance, and collaborating closely with development and analytics teams to ensure data accuracy, reliability, and scalability.

Key Responsibilities

• Design, develop, and maintain efficient SQL queries, views, stored procedures, and functions
• Optimize database performance through indexing, query tuning, and best practices
• Analyze and resolve database-related issues and performance bottlenecks
• Work closely with application developers, data analysts, and business stakeholders
• Ensure data integrity, consistency, and security across databases
• Support data migration, backups, and recovery processes
• Document database designs, processes, and technical solutions
• Assist in reporting and data extraction requirements when needed

Must-Have Skills

• Strong hands-on experience with SQL (MySQL / PostgreSQL / MS SQL Server / Oracle)
• Expertise in writing complex joins, subqueries, CTEs, and window functions
• Experience in query optimization and performance tuning
• Solid understanding of database design, normalization, and indexing
• Experience working with large datasets
• Familiarity with ETL processes and data validation
• Strong analytical and problem-solving skills
• Good communication and documentation skills

Good-to-Have Skills

• Experience with NoSQL databases (MongoDB, DynamoDB, etc.)
• Knowledge of Python, PL/SQL, or T-SQL
• Exposure to data warehousing concepts
• Experience with BI tools (Power BI, Tableau, Looker, etc.)
• Familiarity with cloud databases (AWS RDS, Azure SQL, Google BigQuery)
• Understanding of version control systems (Git)
• Basic knowledge of data security and compliance standards