Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Smart Energy Water Team. If you also belong to the team, you can get access from here

Smart Energy Water

Compare button icon Compare button icon Compare

Filter interviews by

Smart Energy Water Database Developer Interview Questions and Answers

Updated 7 Jun 2024

Smart Energy Water Database Developer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via campus placement at Malviya National Institute of Technology (NIT), Jaipur and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Apti + Basic Coding and SQL questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. What are DBMS? how do you manage them?
  • Ans. 

    DBMS stands for Database Management System. It is a software that allows users to interact with databases.

    • DBMS is used to create, update, and manage databases.

    • It provides tools for data storage, retrieval, and manipulation.

    • Examples of DBMS include MySQL, Oracle Database, and Microsoft SQL Server.

  • Answered by AI
  • Q2. What are indexes? How are they built
  • Ans. 

    Indexes are data structures that improve the speed of data retrieval in databases.

    • Indexes are built on columns in database tables to quickly locate rows based on the indexed column values.

    • They are typically implemented using B-tree or hash data structures.

    • Examples of indexes include primary keys, unique keys, and non-unique indexes.

    • Creating an index involves sorting the values of the indexed column and storing pointers

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Its easy just keep calm

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

1hrs, reasoning, math

Round 3 - One-on-one 

(4 Questions)

  • Q1. 1hrs, technical question, DBMS, Architecture.
  • Q2. Postgres architecture.
  • Q3. Most troubled issue you faced?
  • Q4. Roles responsibility
Round 4 - HR 

(1 Question)

  • Q1. Company benefits

Interview Questionnaire 

4 Questions

  • Q1. Need more concentrate on performance tuning, golden gate, restores
  • Q2. Strong in core dba
  • Ans. 

    Being strong in core DBA means having a deep understanding of database architecture, performance tuning, backup and recovery, and security.

    • Proficient in SQL and PL/SQL

    • Expertise in database installation, configuration, and maintenance

    • Skilled in performance tuning and optimization

    • Experience in backup and recovery procedures

    • Knowledge of database security and access control

    • Familiarity with database monitoring and troublesh...

  • Answered by AI
  • Q3. Strong in OEM
  • Ans. 

    OEM is Oracle Enterprise Manager, a tool for managing Oracle databases.

    • Strong knowledge of OEM is essential for effective database administration

    • Ability to configure and customize OEM for specific needs

    • Experience with using OEM for performance tuning and monitoring

    • Familiarity with OEM's various features, such as backup and recovery, security, and patching

    • Knowledge of how to troubleshoot issues with OEM

  • Answered by AI
  • Q4. Core dba tasks

Interview Preparation Tips

Interview preparation tips for other job seekers - be strong in core dba and other topics also
Interview experience
1
Bad
Difficulty level
Hard
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jan 2022. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Nothing related to project. no rac in project but asked all questions on rac.
  • Ans. You need to have 15 years in 6 years.
  • Answered Anonymously
  • Q2. You applied for junior position ? hahahaha
  • Q3. You understand right

Interview Preparation Tips

Interview preparation tips for other job seekers - you should be over talented to crack the interview.

I applied via Recruitment Consultant and was interviewed in Sep 2020. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Good technical discussion on Oracle database technology like RMAN, Dataguard, Performance tuning, Upgrades, Patching.
  • Q2. Delivery Lead Role responsibilities
  • Q3. Resource Manager Role responsibilities

Interview Preparation Tips

Interview preparation tips for other job seekers - I was contacted by Suseela Budda from Solugenix HR Team for senior oracle dba role on 28th Aug 2020 via email. we had discussion on job position and my profile details on 2nd Sep 2020. Later my interview was scheduled thru Microsoft Teams video for the 1st round of technical discussion on 4th Sep 2020 about 45 mins and cleared the same.
2nd round of technical discussion scheduled on 8th Sep 2020 and rescheduled to 9th Sep 2020 due to Panel unavailability. Had cleared the interview (35 Mins) on next day 9th Sep 2020. 3rd round of interview with Director Madhu scheduled on 11th Sep 2020 for 1 hr. HR called me on 16th Sep 2020 and greeted that i have cleared all rounds of interviews. Need all education and experiences documents and i have shared all docs by next day. HR called me again on 18th Sep 2020 to inform me that Director round feedback is shared and am selected for Lead DBA role due to my Resource Management skills and Delivery Skills. Also informed that offer discussion will be happening next week with HR manager.
I waited for 10 days for HR Manager/HR Recruiter to come back and i did not get any response and i tried reaching them several times.
upon calling 2-3 times Suseela HR picked my call and informed that offer is pending due to Director Madhu has fallen sick due to COVID-19 and had to wait for next week to get approval to release offer letter.
Also she suggested me to look into other opportunities.
This is my pathetic experience with Solugenix India.

My question is -
1) if project sow is not signed and trying to recruit upfront and wasting my time and their time.
else
2) Are they misusing my education/experience/ID proofs (Original Photo Copy) for other purpose.

Am just concerned about this and i strongly do not recommend this company for interviews.

Regards,
Naresh Thummeti

Smart Energy Water Interview FAQs

How many rounds are there in Smart Energy Water Database Developer interview?
Smart Energy Water interview process usually has 2 rounds. The most common rounds in the Smart Energy Water interview process are Coding Test and One-on-one Round.
What are the top questions asked in Smart Energy Water Database Developer interview?

Some of the top questions asked at the Smart Energy Water Database Developer interview -

  1. What are indexes? How are they bu...read more
  2. What are DBMS? how do you manage th...read more

Tell us how to improve this page.

Smart Energy Water Database Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Siemens Interview Questions
4.1
 • 429 Interviews
Thermax Limited Interview Questions
4.2
 • 244 Interviews
ABB Interview Questions
4.1
 • 229 Interviews
Tata Power Interview Questions
3.9
 • 161 Interviews
Suzlon Group Interview Questions
4.1
 • 128 Interviews
BHEL Interview Questions
4.1
 • 109 Interviews
View all
Smart Energy Water Database Developer Salary
based on 18 salaries
₹5.5 L/yr - ₹11.2 L/yr
41% more than the average Database Developer Salary in India
View more details
Product Engineer
155 salaries
unlock blur

₹6 L/yr - ₹15 L/yr

Senior Product Engineer
69 salaries
unlock blur

₹7.5 L/yr - ₹27 L/yr

Senior Software Engineer
64 salaries
unlock blur

₹6.6 L/yr - ₹21.2 L/yr

Production Analyst
54 salaries
unlock blur

₹7 L/yr - ₹9.8 L/yr

Technical Lead
35 salaries
unlock blur

₹9.8 L/yr - ₹27.5 L/yr

Explore more salaries
Compare Smart Energy Water with

Tata Power

3.9
Compare

Adani Green Energy

4.1
Compare

Suzlon Group

4.1
Compare

Thermax Limited

4.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview