Sr. Database Developer / Database Developer ()

PsiberTech Solutions Pte Ltd; Chennai District; On-site; INR 600,000 - 1,200,000; Full time

Job summary

PsiberTech Solutions Pte Ltd is looking for candidates with 2 to 7 years of MS SQL experience to join their team in Chennai, Tamil Nadu. The role requires hands-on expertise with MS SQL Server and the full Microsoft BI Stack including SSIS, SSAS, SSRS, and Power BI.

The ideal candidate will work on creating and maintaining ETL processes, optimizing queries, and dealing with performance issues. Strong communication skills and experience in data analysis will be crucial for success in this role.

Qualifications

• Minimum of 2 to 7 years of MS SQL experience required.
• Hands-on expertise with MS SQL Server and the full Microsoft BI Stack.
• Experience in writing stored procedures, functions, and performance tuning.

Responsibilities

• Develop and maintain ETL processes and scripts to move data between systems.
• Handle performance-related issues and conduct analysis.
• Report development and communication with stakeholders.

Skills

MS SQL experience

Database design

Query optimization

ETL processes

Performance tuning

Tools

Microsoft BI Stack - SSIS

SSAS

SSRS

Power BI

Job description

Posted On

28-May-2024 06:05

Experience

to 2 years

Shift

Day

Location

Job Type

Full Time

A minimum of 2 to 7 years of MS SQL experience is required.

Experience in Database design, Query optimization, Writing stored procedures, Functions, etc. (MS SQL Server)

Candidate should have hands‑on Expertise with MS SQL Server and the full Microsoft BI Stack - SSIS, SSAS, SSRS, and Power BI.

Have a sound working knowledge of stored procedures, functions, cursors, and triggers.

Good knowledge of SQL queries. Exposure to handling large objects.

Have exposure to handling performance‑related issues and quick analysis skills.

Strong communication abilities and Report Development.

Data analysis experience with enterprise data mapping/updating queries/validation rules etc.

Develop and maintain ETL processes and scripts to move data between systems and databases.

Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.

Experience with backups, restores, and recovery models.