Back to Job Search Results

Senior SQL Data Engineer

Date Posted: 10/24/2023

Job #1630894
Contract
Madison, New Jersey

We have partnered with our client in their search for a Senior SQL Data Engineer. 

Responsibilities

  • Analyze and evaluate the performance of SQL queries and stored procedures.
  • Identify and address performance bottlenecks to enhance query execution efficiency.
  • Develop and implement optimization strategies to improve SQL Server database performance.
  • Recommend usage for Column Store index where it is an appropriate use case.
  • SQL Server transactional Replication
    • Apply best practices in setting up Transaction Replication for SQL Server.
    • Generate deployable scripts for replication.
    • Generate scripts for monitoring replication lags.
  • Database Optimization
    • Suggest and implement database schema changes to enhance performance.
    • Collaborate with developers to optimize database design and indexing.
  • Query Analysis and Profiling
    • Utilize query analysis tools and profiling techniques to identify problematic queries.
    • Propose and implement index strategies for query optimization.
  • Performance Testing
    • Design and execute performance testing scenarios to validate query improvements.
    • Create and maintain benchmarking procedures for ongoing performance evaluation.
  • Documentation and Training
    • Document performance tuning procedures, best practices, and recommendations.
    • Provide training and guidance to developers and database administrators on query optimization techniques.
  • Collaboration
    • Work closely with cross-functional teams, including developers and DBAs, to optimize overall system performance.
    • Participate in code reviews and provide input on query optimization.
    • Sybase Support 
    • Collaborate with Sybase experts as needed to troubleshoot issues.

Skills Required

  • Bachelor’s degree in computer science, Software Engineering, or a related field.
  • Proven experience as a SQL Server Performance Tuning Expert.
  • Some knowledge of Sybase database systems.
  • Proficiency in query analysis and optimization tools.
  • Familiarity with database performance monitoring and profiling.
  • Strong problem-solving skills and attention to detail.
  • Excellent communication and teamwork skills.

 

Title 

  • Senior SQL Data Engineer

Location 

  • Newark, NJ

Client Industry

  • Financial Services

Pay

  • $75-$80/hour


Reference ID: $Job_id$

 

Apply Now

Accepted file types are DOC, DOCX, PDF, HTML, and TXT.

Mandatory questions are indicated. All other questions are optional. I agree that any sensitive personal information I voluntarily provide in response to optional questions will be handled in accordance with the Global Privacy Policy. I acknowledge and agree to receive communications from Korn Ferry via phone, SMS and email (message frequency varies, SMS message and data rates may apply). I am not a citizen of, ordinarily resident, or physically located in Cuba, Iran, North Korea, Syria, or the Crimea, Donetsk, or Luhansk regions of Ukraine nor ordinarily resident or physically located in the Russian Federation. I understand that I can withdraw this consent at any time by contacting privacy@kornferry.com.