Database Developer

Indiglobe IT Solutions

3 - 7 years

0 Lacs

pune maharashtra

Posted:1 day ago| Platform: Shine logo

Apply

Skills Required

stored procedures database design oracle mysql views ssis joins triggers unit testing database ssrs keys maintenance ssas sql ctes database normalization complex queries indexes sql optimization windows functions database denormalization data modelling row number types of union functions constraints database transactions udts temporary tables partitioning backup restore metalized views

Work Mode

On-site

Job Type

Full Time

Job Description

You will be responsible for designing and implementing databases, as well as data modeling. This includes creating indexes, views, complex triggers, stored procedures, efficient functions, and appropriate store procedures to facilitate effective data manipulation and data consistency. You should have a good understanding of keys, constraints, indexes, joins, CTEs, partitioning, Row Number() and Windows functions, temporary tables, UDTs, types of union, and materialized views. Utilizing strong analytical and problem-solving skills, you will be required to work on database normalization and de-normalization, and have expertise in writing complex logic. Troubleshooting, optimizing, and tuning SQL processes and queries will be part of your responsibilities, as well as writing unit test cases. Understanding database transactions and states, and designing, implementing, and monitoring queries and stored procedures for performance optimization are key tasks. Additionally, you should be able to debug programs, integrate applications with third-party web services, and identify opportunities for improved performance in SQL operations. Knowledge of database backup, restore, and maintenance procedures, along with experience in working with development, testing, UAT, and production environments and their databases is essential. Skills in working with SSRS and SSIS are required, and experience in SSAS will be considered a plus. Good communication skills are also important for this role.,

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Indiglobe IT Solutions

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Database Developer