T-SQL(SQL) Database Engineer

Please call me at 408-675-8983 OR Email me : harika@cognateinc.com
 to discuss If you are qualified for this position & submit your resume in Word doc along with a brief cover letter and full contact info.
 

Role: T-SQL(SQL) Database Engineer
Location: Milpitas, CA
Duration: Fulltime/Permanent/Direct Hire.
 
Job Description – 
  • This job requires extensive knowledge in writing complex SQL queries, stored procedures, views. SQL Developers design, develop, test, implement and maintain new and existing SQL code in the application. 
  • They will review requirements, suggest schema design, optimize SQL. They should review and guide the team members to ensure quality deliverables.
 
Following are the primary tasks of the Database Engineer: 
  • Develop and optimize views, stored procedures, SQL code, & ad-hoc queries
  • Help write and optimize in-application T-SQL statements.
  • Own/review DB task related deliverables for accuracy, quality, performance & reliability.
  • Gather business requirements and convert it into SQL queries for DB specific projects
  • Creation of implementation plans, design based on specifications
  • Ensure performance, security, and availability of databases
  • Prepare documentations and specifications
  • Introduce initiatives to increase the productivity of the team by using tools, processes.
  • Analyse data for issues, patterns, and suggest potential fixes
  • Work on ETL and reporting tools such as SSRS, Pentaho, etc.,
  • Ability to analyse explain plans, slow query logs, deadlock logs, and suggest options to improve the system
 
Experience
  • 3-7 years using T-SQL.
  • Strong in SQL Coding, data analysis, performance tuning, schema design.
  • Experienced at optimizing large complicated SQL statements using explain plans
  • Understanding application workflow of data
  • Experience working with different teams (Application, QA, DB, etc.,) smoothly and effectively
  • Being detail oriented and having analytical thinking abilities is a must.
  • Experience with MySQL, Toad, and SVN is highly desirable
  • Experience with ETL and reporting tools is desirable
  • Experience working with Performance Monitoring tools is desirable
  • Knowledge in insurance domain is a plus.
 
Soft Skills
  • Being proactive & self-motivated. 
  • Being a good communicator, both written and spoken.
  • Communicating key project data to team members and building cohesion among teams.
  • Ability to work effectively in a fast paced and high-pressure environment
 
How to Apply:
If you are qualified for this position, please submit your resume in Word format along with a brief cover letter to APPLY NOW through this site.
 
 
About Us:
Headquartered in the heart of Silicon Valley, Cognate Inc. was established in 2005 and is a leading IT staffing and IT Consulting Company. Our focus areas includes Staffing and Consulting for Cloud Computing, Data Analytics, Big Data, Enterprise Security & Risk Management, Mobile Applications Development, IT Infrastructure Support, Enterprise Applications Support, E-Commerce, and Software & Platform as Service etc.

Want to apply later?

Type your email address below to receive a reminder

Apply to Job

ErrorRequired field
ErrorRequired field
ErrorRequired field
Error
Error
insert_drive_file
insert_drive_file