> Markdown version of [/jobs/ext/519607-sql-application-developer](https://www.wearedevelopers.com/jobs/ext/519607-sql-application-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # SQL Application Developer - **Company:** FIRSTPRO INC - **Location:** Paoli, PA, United States - **Salary:** $100,000.0 - $130,000.0 - **Contract:** Permanent contract - **Skills:** 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, Transact-SQL, Extensible Markup Language (XML), Transaction Processing (Computing), Freeform SQL, Database Optimization, Database Performance, Semi-structured Data, Database Monitoring - **Published:** June 11, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=ad0aa98a32de717a ## About the Role 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 ## 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. ## Related Videos - [Profiling Symfony & PHP apps with Blackfire](https://www.wearedevelopers.com/videos/265-profiling-symfony-php-apps-with-blackfire) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Database DevOps with Containers](https://www.wearedevelopers.com/videos/145-database-devops-with-containers) - [Enhancing Workload Security in Kubernetes](https://www.wearedevelopers.com/videos/356-enhancing-workload-security-in-kubernetes) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers) - [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)