Senior DBA Developer

Indiglobe IT Solutions

8 - 12 years

0 Lacs

pune maharashtra

Posted:1 week ago| Platform: Shine logo

Apply

Skills Required

performance tuning ssrs oracle triggers ssas views database stored procedures database design data modeling unit testing mysql ssis sql database transactions sql query optimization denormalization backup restore indexes functions database normalization

Work Mode

On-site

Job Type

Full Time

Job Description

You should have 8-10+ years of experience in MySQL, SQL, and ORACLE. Your responsibilities will include designing and implementing databases and data modeling, creating indexes, views, complex triggers, stored procedures, functions, and store procedures for efficient data manipulation and consistency. You will be designing databases, writing sequences, jobs, complex queries in SQL, MySQL, and ORACLE. It is essential to have a strong understanding of Keys, Constraints, Indexes, Joins, CTEs, Partitioning, Row Number() and Windows function, Temporary Tables, UDTs, Types of Union, Materialized views, etc. Your role will involve troubleshooting, optimizing, and tuning SQL processes and complex queries, writing unit test cases, and understanding database transactions and states. You will also design, implement, and monitor queries and stored procedures for performance, debug programs, and integrate applications with third-party web services. Identifying opportunities for improved performance in SQL operations and implementations is crucial. You should have knowledge of database Backup, Restore & Maintenance, as well as working in development, testing, UAT, and production environments and their databases. Experience in SSRS and SSIS is required, and experience in SSAS will be a plus. Good communication skills are essential for this role. Key Skills: Performance tuning, database transactions, SSRS, SQL query optimization, ORACLE, de-normalization, triggers, backup and restore, SSAS, views, database, indexes, functions, stored procedures, database design, data modeling, unit testing, MySQL, database normalization, SSIS, SQL,

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

RecommendedJobs for You

Senior DBA Developer

Indiglobe IT Solutions

pune, maharashtra

Senior DBA Developer

Indiglobe IT Solutions

pune, maharashtra

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Senior DBA Developer