Job Description
Well versed with optimized and complex SQL queries for updating/fetching data.
Well versed with Stored procedures, cursors, loops, user defined functions, triggers, indexes, partitioning, normalization, table design, database diagrams, complex queries, views, cte, temporary tables etc
Well versed with Microsoft SQL Server 2012 + environments
Monitoring and troubleshooting SQL servers issues using system
Implementation and maintenance of database backup and restoration
Security and grants, managing permissions for user/logins and assigning server/database roles.
Fetching required data from the database for the team
Backing up, restoring the database manually and also by scheduling the jobs and maintenance Plans.
Configuring, developing and troubleshooting in MS SQL and SSRS
Rebuilding the indexes at regular intervals for better performance
Understand and implement execution plans..
Monitoring SQL server performance using profiler to find performance.
Good communication and problem solving skills
Employement Category:
Employement Type: Full time
Industry: IT/Computers - Software
Functional Area: IT
Role Category: Software Engineer/Programmer
Role/Responsibilies: SQL Server 2012+ Developer
Contact Details:
Company: Achieve
Location(s): Pune
Keyskills:
SQL queries for updating/fetching data. Well versed with Stored procedures
loops
ser defined functions
partitioning
Normalization
able design
database diagrams
complex queries
cte
emporary tables etc