Remote SQL Pro: Stored Procedures & Query Tuning

The Elite Job; Verona (WI); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive compensation

Flexible work options

Professional development

Certification support

Job summary

The Elite Job seeks a Database Developer – SQL Procedures and Query Optimization to design, develop, and maintain robust database solutions that support our business applications in Wisconsin. You will work on SQL development, stored procedures, and performance tuning to ensure reliable data processing.

Responsibilities include designing relational schemas, optimizing queries, implementing error handling, and documenting objects.

Qualifications

• Strong proficiency in SQL programming, including complex queries, joins, subqueries, CTEs, and aggregates.
• Experience with stored procedures, UDFs, views, and transaction management.
• Experience with at least one major RDBMS (MS SQL Server, PostgreSQL, MySQL, Oracle).

Responsibilities

• Design, develop, test, and maintain complex SQL queries, stored procedures, user-defined functions, views, and triggers.
• Analyze queries and execution plans to identify bottlenecks and optimize performance.
• Maintain documentation of database objects, relationships, and processing logic.
• Ensure data integrity and security while supporting scalable data access across systems.

Skills

SQL

Stored procedures

Query optimization

Performance tuning

Database design

Data integrity

Education

Bachelors degree

Tools

MS SQL Server

PostgreSQL

MySQL

Oracle DB

Job description

The Elite Job seeks a Database Developer – SQL Procedures and Query Optimization to design, develop, and maintain robust database solutions that support our business applications in Wisconsin. You will work on SQL development, stored procedures, and performance tuning to ensure reliable data processing.

Responsibilities include designing relational schemas, optimizing queries, implementing error handling, and documenting objects.