Job : Senior Solutions / SQL Architect
Location : Remote (EST)
Job Type : Contract
Referral Bonus : $2,000
Must be US Citizen / Green Card Holder
What We Are Looking For :
We are seeking an experienced MS SQL Solutions Architect Consultant to lead the resolution of long-standing performance issues in a 20-year-old brokerage trading platform which supports low latency and high throughput trades. The system has minimal documentation and testing, making it crucial for the ideal candidate to understand the intricacies of such legacy platforms and diagnose the root causes of deadlocks and low performance under specific loads. The candidate will collaborate closely with internal SQL Architects, DBAs, and SMEs to understand the system and devise a plan to improve its performance. This engagement requires deep technical expertise, problem-solving abilities, and hands-on leadership to enhance the platform’s efficiency. This role requires a highly skilled, self-driven consultant who can quickly diagnose issues, devise a performance optimization strategy, and execute it with precision to improve our clients brokerage trading platform’s efficiency.
What You’ll Be Doing :
Performance Troubleshooting : Lead efforts to diagnose and resolve long-standing SQL Server performance issues such as deadlocks, excessive locking, slow queries, and bottlenecksSystem Analysis : Conduct a thorough analysis of the legacy brokerage trading platform with minimal existing documentation to identify gaps in code and database structures that impact performanceCollaborative Planning : Work closely with SQL Architects, DBAs, and subject matter experts to gain insights into the system and gather relevant performance dataOptimization Strategy : Develop a clear and actionable plan for optimizing the platform, focusing on SQL Server tuning, query optimization, and addressing code inefficiencies in C++ / C# applicationsImplementation : Lead the execution of the performance optimization plan, collaborating with the internal team to make the system scalable and performant under high loadsKnowledge Transfer : Provide clear documentation of the changes and mentor the internal team to ensure sustainable improvements going forwardSkills & Qualifications :
Proven experience as an MS SQL Solutions Architect with a focus on performance tuning and optimizationDeep understanding of brokerage trading platforms and the specific challenges posed by legacy systemsExpertise in SQL Server performance tuning, resolving deadlocks, optimizing slow queries, and addressing excessive locking and blockingProficient in analyzing and optimizing C++ and C# applications interacting with SQL databasesStrong ability to work with minimal documentation and make sense of complex, undocumented systemsExperience collaborating with cross-functional teams including SQL Architects, DBAs, and SMEs to diagnose and resolve performance issuesExcellent problem-solving skills with the ability to diagnose performance gaps and devise targeted solutionsHands-on experience with database design, query optimization, indexing strategies, and partitioningStrong communication skills, with the ability to explain complex technical issues and work effectively with both technical and non-technical stakeholdersAbility to lead and mentor teams, ensuring successful knowledge transferMinimum Qualifications :
Bachelor’s degree or equivalent work experienceMinimum 7 years of relevant experienceDesired Qualifications :
Mastery in MS SQL Server performance tuning, optimizing SQL codeDevelopment experience (C++ / C# / .NetCross-platform development experience (Ubuntu / Linux, Windows,Skilled at managing many async streams of communication, remotely directing work (Slack)