SQL Performance Engineer in New York, NY at ConsultNet

Date Posted: 10/17/2019

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    New York, NY
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
    10/17/2019
  • Job ID:
    19-00803

Job Description

Title:  SQL Performance Engineer
Location: NYC or Metro Park, NJ
Duration: Direct Hire w/Client (Fulltime)

JOB DESCRIPTION:

Financial client is looking for a seasoned Performance Engineer with solid experience in SQL Server.  Will be working closely with DBAs and Developers to indentify performance issues.

Must have strong understanding of SQL Server when it come to performance.
Good understanding of Index.

Summary:

As a SQL Performance Engineer it will be your primary responsibility to assist the development teams in performance issues related to SQL Queries, Database Design and SQL Server Integration Services (SSIS).
 
Major Responsibilities:
 
  • Work with Team Leads, DBA's and Architects to help assist in troubleshooting SQL related performance issues.
  • Strong technical understanding of SQL Server performance troubleshooting techniques
  • Advise developers on T-SQL coding best practices
  • Advise DBA Team on Database configurations that may assist environmental health
  • Support production processes on daily basis
  • Strong understanding of Database SDLC and CI/CD fundamentals
 
Secondary Responsibilities:
  • Develop ETL processes
  • Assist Technical Leads in POC projects
Requirements:

3 to 5 years working with relational databases - modeling, stored procedures, functions and triggers. Preferable SQL Server 2016
  • 3 to 5 years of building batch processing via ETL processes. SQL Server Integration Services (SSIS).
  • Ability to build ETL batches to manipulate data into and out of a variety of trading and back office systems.
  • Experience working with enterprise schedulers. Tidal preferred.
  • Ability to multitask several ongoing issues. This involves the ability to assess priority and make appropriate decisions quickly and effectively.
  • Successful candidates will feel comfortable in a team oriented environment and possess skills to "win over” the trust of a broad user base.
  • Excellent written and verbal communication skills
  • Effective presentation skills
     
Be a part of the ConsultNet difference. As a leading national provider of IT staffing and solutions, ConsultNet delivers exceptional services to startup, midmarket and Fortune 1000 companies across North America. Since 1996, we've partnered with clients to create rewarding opportunities for our consultants, successfully building teams that have surefire results.
In the past two years alone, we have placed more than 1,500 consultants in contract, contract-to-hire, or direct placement opportunities. We understand communication is key to finding the right job that matches your skills and career goals. For us, it's not just the work that we do; it's how we do the work. Our breadth of offerings extends to multiple IT positions in major markets throughout the country, see more at www.consultnet.com