SQL Application Developer

FIRSTPRO INC
Paoli, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 130K

Job location

Paoli, United States of America

Tech stack

Profiling
Data Integration
Data Integrity
Relational Databases
Database Design
Database Storage Structures
Monitoring of Systems
JSON
Microsoft SQL Server
Performance Tuning
Query Optimization
Software Engineering
SQL Stored Procedures
SQL Databases
T-SQL
XML
Transaction Processing (Computing)
Freeform SQL
Database Optimization
Database Performance
Semi-structured Data
Database Monitoring

Job description

  • Design, develop, maintain, and optimize database solutions in a high-volume transactional environment supporting business-critical applications.
  • Collaborate with software developers, project managers, and business stakeholders to create and enhance database structures, queries, and stored procedures.
  • Analyze business requirements and technical specifications to determine solution feasibility, provide effort estimates, and deliver scalable database solutions.
  • Participate in all phases of the software development lifecycle, including planning, documentation, development, testing, deployment, and ongoing support.
  • Create and maintain relational database objects such as tables, views, indexes, functions, and stored procedures.
  • Monitor, troubleshoot, and optimize SQL queries and database performance to support high-frequency transaction processing.
  • Apply database design and data modeling best practices to ensure data integrity, scalability, and maintainability.
  • Utilize database monitoring and profiling tools to identify performance bottlenecks and implement improvements.
  • Support data integration, reporting, and analytics initiatives using structured and semi-structured data formats.
  • Work closely with cross-functional teams to ensure reliable system performance and successful project delivery.

Requirements

Do you have experience in XML?, * Experience with Microsoft SQL Server (2016 or later) and T-SQL development.

  • Strong understanding of relational database design principles and data modeling techniques.
  • Experience developing and optimizing stored procedures, functions, indexes, and complex SQL queries.
  • Proven ability to troubleshoot and improve database performance in transactional environments.
  • Familiarity with SQL profiling, monitoring, and performance tuning tools.
  • Experience working with XML, JSON, and data reporting solutions.
  • Strong analytical, problem-solving, and communication skills.
  • Ability to collaborate effectively within cross-functional teams and manage multiple priorities.

Preferred Technical Skills

  • Microsoft SQL Server
  • T-SQL
  • Database Design & Data Modeling
  • Performance Tuning & Query Optimization
  • Indexing Strategies
  • SQL Profiling & Monitoring Tools
  • XML & JSON
  • Data Analysis & Reporting

Benefits & conditions

$100,000 - $130,000 a year - Permanent, Full-time, Pulled from the full job description

  • Health insurance
  • Paid time off
  • Vision insurance
  • Dental insurance, * Dental insurance
  • Health insurance
  • Paid time off
  • Vision insurance

Apply for this position