This position is no longer open for applications

Senior SQL Data Engineer

Senior SQL Data Engineer (BBBH1664204) Madison, New Jersey

Salary: USD60 - USD80 per hour

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




 

;