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]
    Data Entry Product Support - No Experience

    Data Entry Product Support - No Experience

    GLOCPA • Weston, 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]
    Tech - IR Tech

    Tech - IR Tech

    HCA Westside Regional Medical Center • Plantation, FL, United States
    [job_card.full_time]
    HCA Westside Regional Medical Center.Magnet Medical is committed to providing accurate and transparent information regarding advertised pay for job positions. However, it's important to note the fol...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Architect

    Architect

    Gpac • Pembroke Pines, Florida, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Join a highly respected Design-Build General Contractor with a strong backlog of commercial projects and a reputation for excellence. This growing organization is committed to delivering exceptional...[show_more]
    [last_updated.last_updated_variable_days]
    System Administrator

    System Administrator

    GA Telesis, LLC • Medley, FL, US
    [job_card.permanent]
    [filters_job_card.quick_apply]
    GA Telesis is a global leader providing integrated solutions to the aviation and aerospace industries.We serve over 3,000 customers, including airlines, original equipment manufacturers, maintenanc...[show_more]
    [last_updated.last_updated_variable_days]
    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_variable_days]
    VP, Financial Consultant - Plantation, FL

    VP, Financial Consultant - Plantation, FL

    Charles Schwab • PLANTATION, FL, US
    [job_card.full_time]
    Click the link below to review our Investment Professionals’ incentive structure.Investment Professionals' Compensation | Charles Schwab. Here, innovative thought meets creative problem solving, hel...[show_more]
    [last_updated.last_updated_30] • [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]
    PT Saleslead

    PT Saleslead

    KnitWell Group • Miramar, FL, United States
    [job_card.full_time] +1
    Ann Taylor embodies and celebrates the spirit, heritage, and confidence of American women leading the lives they love.Since its beginnings, Ann Taylor has been committed to providing women with eve...[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]
    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]
    •Healthcare Consultant I - Hialeah

    •Healthcare Consultant I - Hialeah

    Conflux Systems • Hialeah, FL, United States
    [job_card.temporary]
    Here are the job details for your review : .Job Title : Healthcare Consultant I / Travel Case Manager / Social Worker.Duration : 3+ Months Contract (Potential for extension). Location : Miami Dade County, ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Pre- billing Specialist

    Pre- billing Specialist

    AMR • Weston, Florida, US
    [job_card.full_time]
    Job Description : Prebilling Specialist On Site : 2500 NW 29th Manor, Pompano Beach, FL 33069 Hourly Compensation : $18 / hr Why Choose GMR? Global Medical Response (GMR) and its family of solutions are...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    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]
    Sales Consultant

    Sales Consultant

    Victra - Verizon Wireless Premium Retailer • Miami Shores, FL, US
    [job_card.full_time]
    Victra is Verizon's largest premium retailer in the United States.We are seeking Sales Consultants who deliver world-class service to Every Guest. From executing Victra's sales process to sharing yo...[show_more]
    [last_updated.last_updated_30]
    Senior Java Software Engineer + (Payments Experience)

    Senior Java Software Engineer + (Payments Experience)

    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_30] • [promoted]
    Healthcare Sales Growth Consultant

    Healthcare Sales Growth Consultant

    ChenMed • Pembroke Pines, FL, US
    [job_card.full_time]
    Membership Growth Consultant (MGC).We're changing lives every day.For both our patients and our team members.Are you innovative and entrepreneurial minded? Is your work ethic and ambition off the c...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Remote Application Specialist

    Remote Application Specialist

    U.S. Navy • Pembroke Pines, 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_hours] • [promoted] • [new]