SQL Developer

Training Basket; Dadri; Sur place; INR 600 000 - 900 000; Plein temps

Résumé du poste

Training Basket is seeking a database engineer to design, develop, and maintain SQL databases, tables, views, and stored procedures across demanding data projects. You will optimize complex queries and support reporting needs, ensuring accuracy and reliability of data assets.

The role requires strong knowledge of SQL and RDBMS concepts, hands-on experience with MySQL, SQL Server, PostgreSQL or Oracle, and good data modeling, indexing, and ETL awareness.

Qualifications

• Strong knowledge of SQL and relational database concepts.
• Hands-on experience with MySQL, SQL Server, PostgreSQL or Oracle.
• Good understanding of SQL queries, joins, subqueries, and aggregates.
• Knowledge of stored procedures, functions, triggers, and views.
• Understanding of indexing and data modeling.

Responsabilités

• Design, develop, and maintain SQL databases, tables, views, and stored procedures.
• Write and optimize complex SQL queries for data retrieval and reporting.
• Perform ETL preparation and data cleansing.
• Collaborate with developers and analysts to support BI requirements.
• Assist in database backup, recovery, and maintenance.

Connaissances

SQL

RDBMS concepts

Data querying

Stored procedures

Problem solving

Outils

MySQL

SQL Server

PostgreSQL

Oracle

Description du poste

Design, develop, and maintain SQL databases, tables, views, and stored procedures.

Write and optimize complex SQL queries for data retrieval and reporting.

Develop stored procedures, functions, triggers, and database scripts.

Perform database performance tuning and query optimization.

Ensure data accuracy, integrity, consistency, and security.

Troubleshoot database-related issues and resolve errors.

Work with large datasets and perform data extraction, transformation, and loading (ETL).

Create database reports and support business intelligence requirements.

Collaborate with developers, data analysts, and other technical teams.

Assist in database backup, recovery, and maintenance activities.

Maintain proper documentation of database structures and SQL scripts.

Requirements

Strong knowledge of SQL and RDBMS concepts .

Hands-on experience with MySQL, Microsoft SQL Server, PostgreSQL, or Oracle.

Good understanding of SQL queries, joins, subqueries, and aggregate functions.

Knowledge of stored procedures, functions, triggers, and views.

Understanding of database normalization and indexing.

Familiarity with database design and data modeling.

Knowledge of query optimization and performance tuning.

Understanding of primary keys, foreign keys, and database constraints.

Basic knowledge of ETL processes and data warehousing.

Strong analytical and problem-solving skills.