Database Developer – SQL Procedures and Query Optimization

The Elite Job; Verona (WI); Presencial; USD 90 000 - 120 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Competitive compensation

Flexible work options

Professional development

Certification support

Resumo da oferta

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.

Qualificações

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

Responsabilidades

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

Conhecimentos

SQL

Stored procedures

Query optimization

Performance tuning

Database design

Data integrity

Formação académica

Bachelors degree

Ferramentas

MS SQL Server

PostgreSQL

MySQL

Oracle DB

Descrição da oferta de emprego

1. Job Summary

The Elite Job is seeking a skilled and detail-oriented Database Developer – SQL Procedures and Query Optimization to design, develop, maintain, and optimize database solutions that support business applications and data-driven operations. The ideal candidate will have a strong understanding of relational database management systems, SQL programming, stored procedures, database performance tuning, and query optimization techniques.

2. Key Responsibilities

SQL Development and Stored Procedures

Design, develop, test, and maintain complex SQL queries, stored procedures, user-defined functions, views, and database triggers where appropriate.

Create reusable and maintainable database components that support business applications and reporting requirements.

Translate functional and technical specifications into efficient database logic.

Implement appropriate error handling, transaction management, and validation procedures within database code.

Review existing SQL scripts and procedures to identify opportunities for improvement.

Maintain clear documentation of database objects, business rules, dependencies, and processing logic.

Query Optimization and Performance Tuning

Analyze SQL queries and execution plans to identify inefficient operations, unnecessary table scans, expensive joins, and other performance bottlenecks.

Optimize queries through appropriate indexing strategies, query rewriting, join optimization, and execution‑plan analysis.

Improve the performance of stored procedures and database operations while maintaining accurate results.

Monitor query execution times, resource consumption, and database workload patterns.

Investigate slow-running queries and recommend corrective actions based on measurable performance improvements.

Collaborate with database administrators to evaluate indexing, statistics, partitioning, and other database performance considerations.

Conduct performance testing before and after changes to validate optimization results.

Database Design and Data Integrity

Develop and maintain relational database structures, including tables, relationships, constraints, indexes, and views.

Apply appropriate normalization and data modeling principles to support data consistency and efficient retrieval.

Implement primary keys, foreign keys, unique constraints, and validation rules to protect data quality.

Ensure database changes preserve data integrity and remain compatible with dependent applications.

Support database schema modifications, data migrations, and controlled releases.

Identify opportunities to simplify database structures and improve long‑term maintainability.

Testing, Troubleshooting, and Maintenance

Develop and execute unit tests, integration tests, and regression tests for database changes.

Troubleshoot database errors, incorrect query results, locking issues, deadlocks, and transaction‑related problems.

Investigate production issues and work with relevant teams to identify root causes and implement sustainable solutions.

Participate in code reviews and follow established database development standards.

Maintain version‑controlled SQL scripts and support structured deployment and rollback procedures.

Assist with data validation, reconciliation, and troubleshooting during application upgrades and system integrations.

Security and Governance

Follow database security policies and least‑privilege access principles.

Work with database administrators to ensure appropriate permissions and secure access to sensitive information.

Apply secure coding practices to reduce risks such as SQL injection and unauthorized data access.

Support audit requirements, change management procedures, and database documentation standards.

Follow organizational policies relating to confidentiality, data retention, privacy, and regulatory compliance.

Collaboration and Continuous Improvement

Work with software engineering, data engineering, quality assurance, and business teams to understand database requirements.

Participate in technical discussions, sprint planning, design reviews, and project meetings as required.

Provide technical recommendations for database architecture, query design, and performance improvement.

Share knowledge with team members and contribute to coding standards and development guidelines.

Stay informed about emerging database technologies, SQL optimization techniques, and industry best practices.

3. Required Skills and Qualifications

Educational Qualifications

Bachelors degree in Computer Science, Information Technology, Software Engineering, Computer Engineering, or a related discipline is preferred.

Equivalent professional experience and relevant technical certifications may be considered.

Additional training in database development, data management, or database performance optimization is an advantage.

Technical Skills

Strong proficiency in SQL programming, including complex queries, joins, subqueries, common table expressions, and aggregate functions.

Practical knowledge of stored procedures, user‑defined functions, views, and transaction management.

Experience with at least one relational database platform, such as Microsoft SQL Server, PostgreSQL, MySQL, or Oracle Database.

Understanding of query execution plans, indexing strategies, database statistics, and performance profiling.

Knowledge of relational database design, normalization, referential integrity, and schema management.

Familiarity with database transactions, isolation levels, locking, concurrency, and deadlock troubleshooting.

Experience with SQL development tools and database management environments.

Understanding of database backup, recovery, and deployment concepts.

Familiarity with Git or another version control system for managing database scripts.

Knowledge of data migration, ETL processes, reporting systems, or application integration is beneficial.

Basic scripting knowledge in Python, PowerShell, or another suitable language is an advantage.

Professional Skills

Strong analytical and logical reasoning abilities.

Excellent troubleshooting and root‑cause analysis skills.

Attention to detail when handling complex database logic and sensitive information.

Ability to manage multiple development tasks and meet agreed deadlines.

Clear written and verbal communication skills.

Ability to explain technical issues and optimization recommendations to non‑technical stakeholders.

A collaborative approach to working with cross‑functional teams.

Commitment to code quality, documentation, data accuracy, and continuous improvement.

4. Experience

Entry‑level candidates: Applicants with foundational SQL knowledge, relevant academic projects, internships, or database certifications may be considered for junior‑level opportunities where available.

Junior Database Developers: Typically have 1–2 years of experience writing SQL queries, developing database objects, and supporting database‑related applications.

Experienced Database Developers: Typically have 3–5 years of professional experience in SQL development, stored procedures, query optimization, and relational database management.

Senior‑level candidates: Additional experience with complex database workloads, advanced performance tuning, production troubleshooting, and database design is desirable.

Candidates should be able to demonstrate practical knowledge of SQL development and a structured approach to diagnosing database performance issues. Experience with large datasets, high‑transaction systems, cloud databases, or enterprise applications will be an advantage.

Experience requirements may vary according to the level of the position and the needs of the hiring team.

5. Working Hours

Employment Type: Full‑time, subject to the agreed employment arrangement.

Typical Schedule: Approximately 40 hours per week, depending on location and company policy.

Working Days: Generally Monday to Friday, subject to project requirements.

Work Arrangement: Remote, hybrid, or on‑site, depending on the specific vacancy.

Flexibility: Flexible working arrangements may be available for eligible positions and teams.

Meetings: Participation in team meetings, technical reviews, and project planning sessions may be required.

Additional Support: Occasional support outside standard working hours may be necessary for scheduled database deployments, critical incidents, or production maintenance, with arrangements determined by company policy.

The selected candidate will be expected to manage time effectively, communicate availability, meet delivery commitments, and coordinate with relevant teams across time zones when required.

6. Knowledge, Skills, and Abilities

Database Knowledge

Strong understanding of relational database concepts and SQL query processing.

Ability to develop efficient stored procedures and reusable database components.

Knowledge of database indexing, execution plans, query statistics, and optimization techniques.

Understanding of transactions, concurrency control, locking, and data consistency.

Familiarity with database scalability, availability, and maintainability considerations.

Analytical Abilities

Ability to examine complex queries and identify inefficiencies.

Capability to compare execution plans and determine the likely causes of performance degradation.

Ability to evaluate optimization alternatives and assess its impact on performance and correctness.

Confidence to investigate data discrepancies and resolve database-related defects.

Development and Operational Skills

Ability to write readable, maintainable, and well‑documented SQL code.

Knowledge of structured testing, code reviews, and change management.

Ability to use database monitoring and diagnostic tools effectively.

Understanding of deployment procedures and the risks associated with changes to production databases.

Ability to follow security standards and protect confidential business data.

Personal Attributes

A proactive and solution‑oriented mindset.

Strong organizational and time‑management skills.

Willingness to learn new tools, technologies, and development practices.

Professional integrity and accountability.

Ability to work independently while contributing effectively to a team.

Commitment to delivering accurate, reliable, and high‑quality database solutions.

7. Benefits

The Elite Job aims to provide a supportive and professional working environment. Depending on the specific role, employment terms, location, and applicable company policies, benefits may include:

Competitive Compensation: Salary aligned with experience, technical expertise, role responsibilities, and the applicable market.

Flexible Work Options: Potential access to remote or hybrid working arrangements where available.

Professional Development: Opportunities to improve SQL programming, database architecture, and performance optimization skills.

Technical Learning: Exposure to database development tools, enterprise applications, and modern data management practices.

Career Advancement: Opportunities to progress into senior database development, database architecture, data engineering, or related technical positions.

Collaborative Environment: Opportunities to work with developers, data professionals, and technology specialists.

Performance Recognition: Recognition for quality work, effective problem‑solving, and contributions to project success, subject to company policy.

Work‑Life Balance: Clear work priorities and appropriate scheduling practices, subject to operational requirements.

Certification Support: Access to relevant training or certification assistance where offered by the organization.

Specific benefits, allowances, paid leave, insurance, bonuses, and other employment provisions will be confirmed during the recruitment process and documented in the applicable offer.

8. Why Join The Elite Job?

Joining The Elite Job offers an opportunity to contribute to technology‑focused projects where database reliability, data accuracy, and system performance are important to business success.

As a Database Developer – SQL Procedures and Query Optimization, you will have the opportunity to apply your technical expertise to practical challenges, improve application responsiveness, and help build maintainable database solutions.

Reasons to consider this opportunity include:

Meaningful Technical Challenges: Work on SQL procedures, complex queries, performance bottlenecks, and database reliability improvements.

Professional Growth: Strengthen your expertise in database programming, execution‑plan analysis, indexing, and performance tuning.

Collaborative Work: Coordinate with professionals across software development, data engineering, testing, and business operations.

Continuous Learning: Build knowledge of evolving database technologies and development practices.

Career Development: Develop a foundation for future opportunities in database architecture, data engineering, technical leadership, and enterprise data management.

Quality‑Focused Culture: Contribute to solutions that emphasize maintainability, security, accuracy, and efficient execution.

Opportunity to Make an Impact: Help improve the reliability and performance of the data systems that support business operations.

We welcome candidates who are passionate about database development, enjoy solving technical problems, and are motivated to deliver measurable improvements in database performance and reliability.