Talent.com
Senior Solutions/SQL ArchitectGravity IT Resources
Senior Solutions/SQL ArchitectGravity IT ResourcesGravity IT Resources • Plantation, Florida
Senior Solutions / SQL ArchitectGravity IT Resources

Senior Solutions / SQL ArchitectGravity IT Resources

Gravity IT Resources • Plantation, Florida
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

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
  • Cross-platform development experience (Ubuntu / Linux, Windows,
  • Skilled at managing many async streams of communication, remotely directing work (Slack)
    • [job_alerts.create_a_job]

    Senior Resource • Plantation, Florida

    [internal_linking.similar_jobs]
    HRIS Senior Analyst - Workday

    HRIS Senior Analyst - Workday

    Hays • Miramar, FL, United States
    [job_card.full_time]
    This role supports HR, Payroll, Talent, and Recruiting teams by administering and optimizing Workday Human Capital Management (HCM) modules. The ideal candidate will have deep Workday expertise, str...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Application Administrator - OnBase - FT - Days - DIO

    Application Administrator - OnBase - FT - Days - DIO

    Memorial Healthcare System • Miramar, FL, US
    [job_card.full_time]
    At Memorial, we are dedicated to improving the health, well-being and, most of all, quality of life for the people entrusted to our care. An unwavering commitment to our service vision is what makes...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Senior BI Developer

    Senior BI Developer

    VentureTech Solutions • Plantation, FL, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Senior BI Developer This position is in-office.The office is located in Plantation, FL.We are seeking a Senior BI Developer who thrives in a collaborative, fast-paced environment and is passionate ...[show_more]
    [last_updated.last_updated_30]
    Remote Application Specialist

    Remote Application Specialist

    U.S. Navy • Opa Locka, FL, US
    [filters.remote]
    [job_card.full_time]
    ABOUT Culinary Specialists (CSs) operate and manage Navy messes and living quarters to provide meals and accommodations for Navy personnel. They prepare menus, manage food inventories, maintain fina...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Collections Specialist

    Senior Collections Specialist

    ICBD • Lauderdale Lakes, FL, US
    [job_card.full_time]
    Collections Specialist—Behavioral Health – Exact Billing Solutions (EBS).Exact Billing Solutions is a unique team of revenue cycle management professionals specializing in the substance...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Engineer

    Data Engineer

    NationsBenefits • Plantation, FL, US
    [job_card.full_time]
    NationsBenefits is recognized as one of the fastest growing companies in America and a Healthcare Fintech provider of supplemental benefits, flex cards, and member engagement solutions.We partner w...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    SYSTEM EXECUTIVE CHEF

    SYSTEM EXECUTIVE CHEF

    Morrison Healthcare • Weston, FL, US
    [job_card.full_time]
    Morrison's hospital kitchens, restaurants, and cafés feature socially responsible practices and exceptional guest experiences. The company's comprehensive Mindful Choices® wellnes...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Entry Product Support - No Experience

    Data Entry Product Support - No Experience

    GLOCPA • Hialeah, Florida
    [job_card.full_time]
    We’re looking for Customer Support Product Testers across the US to work from home and help top brands improve their products before they hit the market.[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior AI Digital Operations Specialist

    Senior AI Digital Operations Specialist

    Generali Global Assistance | Travel Insurance • Pembroke Pines, FL, United States
    [job_card.full_time]
    Embark on a Journey That Makes a Difference.At Generali Global Assistance (GGA), every day is an opportunity to help people explore the world with confidence. We’re not just in the business of prote...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Remote BCBA Needed - Apply Today

    Remote BCBA Needed - Apply Today

    BK Behavior • Miami Gardens, FL, US
    [filters.remote]
    [job_card.full_time] +1
    Board Certified Behavior Analysts (BCBAs).Applicants must already hold active BCBA certification.Our training program is designed to support certified BCBAs in excelling within our company.Transiti...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Software Development Engineer

    Software Development Engineer

    Amazon • Hialeah, FL, USA
    [job_card.full_time]
    Join Amazon's engineering team and help us build innovative solutions to complex problems.As a Software Development Engineer, you will design, develop, and test software applications and services.W...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Software Engineer, Core Experiences - Pembroke Pines, USA

    Senior Software Engineer, Core Experiences - Pembroke Pines, USA

    Speechify • Pembroke Pines, FL, US
    [job_card.full_time]
    Speechify is the easiest way to listen to the world's information.Articles on the web, documents in the cloud, books on your phone. We absorb it all and let you listen to it at your desk, on the...[show_more]
    [last_updated.last_updated_30] • [promoted]
    CAT Risk Analyst

    CAT Risk Analyst

    Munich RE • Miami Gardens, FL, United States
    [job_card.full_time]
    Amelia, United States; Atlanta, United States; Austin, United States; Charlotte, United States; Chicago, United States; Dallas, United States. Hartford, United States; Houston, United States; Miami...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Board Certified Assistant Behavior Analyst (BCaBA)

    Board Certified Assistant Behavior Analyst (BCaBA)

    Physical 4 U Inc • Hialeah, FL, US
    [job_card.full_time]
    We are seeking a compassionate BCaBA to join our team.The BCaBA will work under the supervision of a BCBA to implement behavior intervention plans, collect and analyze data, and support individuals...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Diver

    Diver

    US Navy • Hialeah, Florida, United States
    [job_card.part_time]
    Navy Divers go where few can-into the depths of the sea to execute critical underwater operations that keep the Navy moving and missions on track. From salvaging sunken wreckage and repairing ships ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Team Lead-109010

    Team Lead-109010

    Extended Stay America • Davie, FL, United States
    [job_card.full_time]
    The Team Lead ("TL") position assists the General Manager ("GM") in managing the hotel operations on a day-to-day basis to ensure optimum performance and continual improvement in the Key Performanc...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Claims Investigator - Part-Time

    Claims Investigator - Part-Time

    Allied Universal® Compliance and Investigations • Opa-locka, FL, US
    [job_card.full_time] +1
    Advance Your Career in Insurance Claims with Allied Universal® Compliance and Investigation Services.Allied Universal® Compliance and Investigation Services is the premier destination for a...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Senior Software Engineer, Core Experiences - Miami Gardens, USA

    Senior Software Engineer, Core Experiences - Miami Gardens, USA

    Speechify • Miami Gardens, FL, US
    [job_card.full_time]
    Speechify is the easiest way to listen to the world's information.Articles on the web, documents in the cloud, books on your phone. We absorb it all and let you listen to it at your desk, on the...[show_more]
    [last_updated.last_updated_30] • [promoted]