Senior Solutions/SQL Architect

19 hours ago


Plantation FL United States Gravity IT Resources Full time
To Apply for this Job Click Here

Job: Senior Solutions/SQL Architect
Location: Remote (EST)
Job Type: Contract
Referral Bonus: $2,000

Must be US Citizen / Green Card Holder
**No 3rd Parties**

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 bottlenecks.
  • System 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 performance.
  • Collaborative Planning: Work closely with SQL Architects, DBAs, and subject matter experts to gain insights into the system and gather relevant performance data.
  • Optimization 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# applications.
  • Implementation: Lead the execution of the performance optimization plan, collaborating with the internal team to make the system scalable and performant under high loads.
  • Knowledge Transfer: Provide clear documentation of the changes and mentor the internal team to ensure sustainable improvements going forward.

Skills & Qualifications:

  • Proven experience as an MS SQL Solutions Architect with a focus on performance tuning and optimization.
  • Deep understanding of brokerage trading platforms and the specific challenges posed by legacy systems.
  • Expertise in SQL Server performance tuning, resolving deadlocks, optimizing slow queries, and addressing excessive locking and blocking.
  • Proficient in analyzing and optimizing C++ and C# applications interacting with SQL databases.
  • Strong ability to work with minimal documentation and make sense of complex, undocumented systems.
  • Experience collaborating with cross-functional teams including SQL Architects, DBAs, and SMEs to diagnose and resolve performance issues.
  • Excellent problem-solving skills with the ability to diagnose performance gaps and devise targeted solutions.
  • Hands-on experience with database design, query optimization, indexing strategies, and partitioning.
  • Strong communication skills, with the ability to explain complex technical issues and work effectively with both technical and non-technical stakeholders.
  • Ability to lead and mentor teams, ensuring successful knowledge transfer.

Minimum Qualifications:

  • Bachelor’s degree or equivalent work experience.
  • Minimum 7 years of relevant experience.

Desired Qualifications:

  • Mastery in MS SQL Server performance tuning, optimizing SQL code.
  • Development experience (C++/C#/.Net Core).
  • Cross-platform development experience (Ubuntu/Linux, Windows, etc.).
  • Skilled at managing many async streams of communication, remotely directing work (Slack).
To Apply for this Job Click Here #J-18808-Ljbffr
  • Solutions Architect

    4 weeks ago


    Charlotte, NC, United States Strategic Staffing Solutions Full time

    Solutions Architect (SQL Server) Remember to check your CV before applying Also, ensure you read through all the requirements related to this role. Location: Charlotte, NC Rate: $70-80/hr (W2 ONLY) Duration: 12+ Months Description: Digital Solution Architecture within the IT organization, you will drive the strategic direction for Digital application...

  • Solutions Architect

    1 month ago


    Charlotte, NC, United States Strategic Staffing Solutions Full time

    Solutions Architect (SQL Server)Location: Charlotte, NCRate: $70-85/hr (W2 ONLY)Duration: 12+ MonthsDescription:Digital Solution Architecture within the IT organization, you will drive the strategic direction for Digital application development and delivery to the Cloud. This includes working with a small team of Solution architects, designing technology...

  • Solution Architect

    3 weeks ago


    Hollywood, FL, United States INSPYR Solutions Full time

    Title: Solution Architect Ready to apply Before you do, make sure to read all the details pertaining to this job in the description below. Location: Miramar, FL Duration: 6+ months Compensation: $85.00 - 95.00/hr Work Requirements: US Citizen, GC Holders or Authorized to Work in the U.S. Solution Architect Overview: Core focus is a sustainable technical...


  • Minneapolis, MN, United States Clifton Larson Allen LLP Full time

    CLA is a top 10 national professional services firm where our purpose is to create opportunities every day, for our clients, our people, and our communities through industry-focused wealth advisory, digital, audit, tax, consulting, and outsourcing services. Even with more than 8,500 people, 130 U.S. locations, and a global reach, we promise to know you and...


  • Miami, FL, United States Anaplan Full time

    At Anaplan, we are a team of innovators focused on optimizing business decision-making through our leading scenario planning and analysis platform so our customers can outpace their competition and the market. What unites Anaplanners across teams and geographies is our collective commitment to our customers’ success and to our Winning Culture. Our...


  • Miami, FL, United States Anaplan Inc Full time

    At Anaplan, we are a team of innovators who are focused on optimizing business decision-making through our leading scenario planning and analysis platform so our customers can outpace their competition and the market. What unites Anaplanners across teams and geographies is our collective commitment to our customers’ success and to our Winning Culture. Our...


  • Fort Meade, FL, United States Leidos Full time

    The Digital Modernization Sector has a career opportunity for a Senior Solution Architect for Innovations supporting the Global Solutions Management – Operations II (GSM-O II) contract with the Defense Information Systems Agency (DISA). This contract includes the Operations, Sustainment, Maintenance, Repair, and Defense of the Defense Information System...


  • Miami, FL, United States Anaplan Full time

    At Anaplan, we are a team of innovators who are focused on optimizing business decision-making through our leading scenario planning and analysis platform so our customers can outpace their competition and the market. What unites Anaplanners across teams and geographies is our collective commitment to our customers' success and to our Winning Culture. Our...


  • Concord, NH, United States Acxiom Full time

    Acxiom Solution Architect, Senior Director Concord, New Hampshire Apply Now You will accelerate Acxiom’s transformation to deliver marketing solutions on industry-leading cloud platforms such as AWS, Google, Snowflake, and Databricks. You will drive innovation, design advanced frameworks, and lead the development of cloud solutions for global clients. In...


  • Seattle, WA, United States Acxiom Full time

    Acxiom Solution Architect, Senior Director Seattle, Washington Apply Now You will accelerate Acxiom’s transformation to deliver marketing solutions on industry-leading cloud platforms such as AWS, Google, Snowflake, and Databricks. You will drive innovation, design advanced frameworks, and lead the development of cloud solutions for global clients. In this...

  • Data Architect

    1 month ago


    Miami, FL, United States InterEx Group Full time

    Senior Data Architect, Contract (US Remote)Our client, a leading Fortune 500 company in the Consumer Packaged Goods (CPG) industry, is seeking a highly skilled Senior Azure Data Architect to lead their cloud data strategy and architecture initiatives. In this remote contract role, you will be responsible for designing scalable data solutions, overseeing data...

  • Solutions Architect

    16 hours ago


    Naugatuck, CT, United States Nesco Resource Full time

    Nesco Resource is currently looking for a Solutions Architect / Power BI Developer. The right candidate will lead the application development architecture design; write, execute, and debug Power BI queries; lead the integration of MS Dynamics 365 with custom SQL databases and perform other technology-related tasks as assigned. The Solutions Architect / Power...


  • Albuquerque, NM, United States Acxiom Full time

    You will accelerate Acxiom’s transformation to deliver marketing solutions on industry-leading cloud platforms such as AWS, Google, Snowflake, and Databricks. You will drive innovation, design advanced frameworks, and lead the development of cloud solutions for global clients. In this strategic role, you will implement transformative solutions using...


  • Arlington, VA, United States Merito Group Full time

    Solutions Architect, Arlington, VA - up to $175k Is this the role you are looking for If so read on for more details, and make sure to apply today. Multibillion dollar government contractor is seeking in an immediate Solutions Architect to support a Department of Homeland Security customer located in Arlington, VA. This is a hybrid...


  • Arlington, VA, United States Merito Group Full time

    Solutions Architect, Arlington, VA - up to $175kIs this the role you are looking for If so read on for more details, and make sure to apply today.Multibillion dollar government contractor is seeking in an immediate Solutions Architect to support a Department of Homeland Security customer located in Arlington, VA. This is a hybrid roleResponsibilities:This...


  • Washington, DC, United States Winslow Technology Group Full time

    Job Description As an integral member of Winslow Technology Group, LLC (WTG), the Senior Solutions Architect will play an essential role on our pre-sales team working in collaboration with our Account Executives to provide leading solutions to WTG customers. Working with a team of highly motivated professionals, you will have the opportunity to navigate the...

  • Solutions Architect

    3 weeks ago


    Englewood, CO, United States US Main Full time

    Hi, Please read the information in this job post thoroughly to understand exactly what is expected of potential candidates. Hope you are doing well? I am looking for a candidate with experience as Solution Architect. Role: Solution Architect Location: Englewood CO- Hybrid Duration: 6 months contract to hire. We can only use USC and GC because of C2H...


  • San Francisco, CA, United States High-Tech Professionals Full time

    Enterprise Solutions Architect Job ID: 1778Location: San Francisco, CAType: PermanentStatus: ClosedKey Skills: Enterprise Solutions architect, fusion applications, Cloud, SaaS, Oracle, Cloning, Java, XML, SQL, PL/SQL, Lead, multi-threadDescription: Seeking architectural leader for designing and creating frameworks and tools supporting applications,...

  • Solutions Architect

    2 weeks ago


    United, United States Snowflake Computing Full time

    Build the future of the AI Data Cloud. Join the Snowflake team. Snowflake Professional Services is the implementation and strategy experts for the Snowflake platform. We engage with customers at all phases of the customer journey to optimize, accelerate, and achieve business outcomes. Our teams of Solutions Architects demonstrate technical leadership...


  • Los Angeles, CA, United States Prosum2 Full time

    .NET/SQL Application Developer/Architect Summary We are seeking a highly motivated senior developer / architect to join our software development and application support team. The well-rounded individual will help design and program web-based business and reporting applications. Candidates must be able to translate business requirements into technical...