SQL Application Developer
FIRSTPRO INC
Paoli, PA, United States
3 months ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on indeed.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Compensation
$100,000.0 - $130,000.0
Working hours
Regular working hours
Job source
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
+10 more
SQL Stored Procedures
SQL Databases
Transact-SQL
Extensible Markup Language (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
This job is hosted externally. Click below to view the full posting and apply.
Apply on indeed.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
BB
Benedikt Bischof
about 4 years ago
AJ
Austin Joy
What Are The Top Skills Required For Azure Developers?
over 4 years ago
LM
Luis Minvielle
Fully Remote Software Engineer Jobs
over 2 years ago
LM
Luis Minvielle
What’s the Difference between a Junior, Mid, and Senior Developer?
over 3 years ago
LM
Luis Minvielle
Why Upskilling And Reskilling is Important For Developers
over 2 years ago
LM
Luis Minvielle
The 8 Best Code Testing Tools
over 2 years ago