SQL Developer

Optimum Financial Solutions

1 - 3 Years
5 Openings
2.0 - 4.0 Lac/Yr
Mumbai
Face-to-Face interview

Key Skills

Apply

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 server’s 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