Unlock Premium Benefits Today!
🚀 Elevate your career with priority access.
Stand out to top recruiters with Jobgether Priority Access:
  • ✅ Top Match: We help you identify job offers where you're a perfect fit.
  • ✅ Exclusive Referral Service: Connect directly with recruiters as a Jobgether Certified Premium User.
  • ✅ Personalized Feedback: Receive feedback and expert guidance on applications, and have your profile manually reviewed.
Go Premium

SQL Server Developer_TCG_SHIVAM

Remote: 
Full Remote
Contract: 
Full time
Work from: 
India

Offer summary

Qualifications:

Bachelor's degree in Computer Science or related field., 3+ years of experience with SQL Server (2012-2019)., Strong skills in writing complex SQL queries and stored procedures., Proficient in troubleshooting and optimizing SQL queries..

Key responsibilities:

  • Develop and maintain SQL Server databases and related applications.
  • Create and manage tables, views, and stored procedures as per project requirements.
  • Troubleshoot production issues and perform root cause analysis.
  • Collaborate with cross-functional teams to identify business needs and provide solutions.

CodersBrain logo
CodersBrain SME https://www.codersbrain.com/
201 - 500 Employees
See all jobs

Job description

Job Position: SQL Server Developer
Relevant Experience :3+Years
Location :Kolkata/remote
Notice Period: immediate To 30 days
Client :TCG Digital

Job description :

 Working experience on SQL Server 2019/2016/2014/2012 versions.
 Extensive experience in Creating Tables, Views, Synonyms, Constraints, Temp Tables, Table
Variables and writing code in Dynamic SQL.
 Master in writing complex queries to retrieve data using Joins, Sub Queries, Aggregate
Functions, String Functions, Union, UnionAll, Pivot, UnPivot, Ranking and RowNumber
Functions.
 Experience in creating and using Recursive CTE’s in complex requirements.
 Extensive experience and expertise in scripting Stored Procedures, User Defined Functions.
 Good experience in creating and using Cursors.
 Experience in handling exceptions using Try…, Catch.
 Good experience in writing DML Triggers to log data changes in audit tables.
 Extensive Experience on troubleshooting production issues.
 Knowledge on Query Optimization by creating Indexes.
 Experience on writing and using While Loop and IF statements.
 Involved in all Database related discussions in the internal project.
 Knowledge on using SQL Profiler to debug the issues.
 Having good knowledge on creating and scheduling of T-SQL jobs.
 Always provideed first response to reported production incidents followed by resolution.
 Root Cause Analysis done for many production issues and implimented permanent fixes and
deployed in production.
 Worked with multiple teams across units to identify business needs and solution options.
 Experience in administration including adding database logins, granting permissions, profiler
tracing and taking backups.
 Experience in identifying potential problems and recommended alternative solutions.
 Quick learner, excellent problem solving and analytical skills and to address the business
problems with sound technical solution.
 Strong inclination for finishing tasks before deadline. Strong ability and experience in
seeking solutions effectively in challenging environment.
 Excellent understanding of project issues, Ability to work on critical requirements.

Required profile

Experience

Spoken language(s):
English
Check out the description to know which languages are mandatory.

Hard Skills

Query OptimizationStored ProcedureDynamic QueriesMicrosoft SQL Server Data Engine (MSDE)Aggregate FunctionsDatabase CursorNested LoopsSQL (Programming Language)Database TriggersBigTablePivot PointDatabase AdministrationUnion AvoidanceRoot Cause AnalysisDatabase Performance Analyzer

Other Skills

  • Analytical Skills
  • Time Management
  • Problem Solving
Are you interested?

Related jobs

See more jobs