What are the responsibilities and job description for the Senior SQL Server Developer (US-Remote) position at Third Eye Software?
NO AGENGIES, NO Employers, NO 3rd PARTY RECRUITERS
Location: Remote - U.S. Based
Employment Type: Contract (W2, C2C)
Citizenship Requirement: U.S. Citizens or Green Card Holders only
Rate: Negotiable
Work Hours: Standard Eastern Time (ET) business hours
We're hiring 2-3 Senior SQL Server Developers to support a critical initiative with a large-scale enterprise technology organization in the financial services space. For full consideration, please complete the application questions.
This is a hands-on role focused on analyzing and rewriting SQL for performance. It's ideal for experienced developers who understand how to write highly efficient SQL and are familiar with the internals of SQL Server, particularly around query optimization, execution plans, and performance bottlenecks. You'll collaborate with a SQL Server performance SME who spent over a decade at Microsoft, so strong fundamentals and real-world experience are key.
Key Responsibilities:
- SQL Performance Optimization: Analyze and optimize SQL queries for performance, ensuring high efficiency and scalability. Identify slow-running queries and suggest appropriate optimizations.
- Rewriting Complex SQL Queries: Refactor and rewrite poorly performing SQL queries into efficient, scalable, and optimized code. Expert-level knowledge of SQL optimizer with proven performance rewrites.
- Knowledge of Database Architecture Design: Detailed understanding of the design and implementation of robust and scalable database architectures for high-performance systems.
- Identify and Fix Inefficient Code: Act as a Subject Matter Expert to find suboptimal queries and rewrite them for performance without affecting business logic.
Required Experience:
- 7 years of SQL Server development and administration
- 5 years focused on SQL Server performance tuning and internals
- Strong experience with SQL Server Optimizer, execution plans, indexing strategies, and diagnosing latching/blocking issues
- Proven ability to work in high-parallel query execution environments
- Knowledge of the SQL SOS (operating systems), thread scheduler and of how the statistics based optimizer works
- Strong problem-solving abilities, attention to detail, and the communication skills to collaborate effectively with technical leads
Required Tools & Technologies:
- Microsoft SQL Server, SSMS
- Query execution plan analysis
- SQL Profiler, Extended Events
- Dynamic Management Views (DMVs)
- Performance monitoring tools (PerfMon, Redgate, etc.)
Benefits:
- Fully remote
- Employer-provided equipment
Third Eye Software is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation, gender identity, or any other characteristic protected by law.
