Database Engineer

Innover Systems; Pune District; On-site; INR 600,000 - 900,000; Full time

Job summary

Innover Systems in Pune is seeking a Database Developer with 3+ years of hands-on experience to design, develop, optimize, and maintain database solutions. You will work on SQL-rich environments and support business-critical applications with strong data management and security practices.

The role requires deep knowledge of Microsoft SQL Server, MySQL, PostgreSQL, or Oracle, plus expertise in stored procedures, functions, triggers, and indexing.

Qualifications

• 3+ years of database development experience.
• Strong SQL knowledge and relational database concepts.
• Experience with SQL Server, MySQL, PostgreSQL or Oracle.
• Expertise in stored procedures, functions, triggers, views and indexing.
• Experience in query optimization and performance tuning.
• Knowledge of backup/recovery and ETL processes.
• Familiarity with data modeling and normalization.
• Basic Git version control knowledge.

Responsibilities

• Design, develop, and maintain relational databases.
• Write and optimize complex SQL queries, procedures, functions, triggers, and views.
• Perform database performance tuning and query optimization.
• Develop ETL processes for data integration.
• Monitor health, security, backup, and recovery of databases.
• Collaborate with developers and business teams on database requirements.
• Ensure data integrity and security across environments.
• Troubleshoot database issues and provide timely resolutions.
• Create and maintain database documentation and specs.
• Support migrations, upgrades, and deployments.

Skills

SQL

RDBMS concepts

Stored procedures

Functions

Triggers

Indexing

Query optimization

Performance tuning

ETL processes

Data migration

Git

Cloud basics

Education

Bachelor's degree in CS/IT

Tools

Microsoft SQL Server

MySQL

PostgreSQL

Oracle Database

Job description

Location: Pune
Experience: 3+ Years
Work Mode: Work from Office (5 Days a Week)

About the Role

We are looking for a skilled Database Developer with 3+ years of experience in designing, developing, optimizing, and maintaining database solutions. The ideal candidate should have strong expertise in SQL, database performance tuning, and data management to support business-critical applications.

Key Responsibilities

• Design, develop, and maintain relational databases.
• Write, optimize, and troubleshoot complex SQL queries, stored procedures, functions, triggers, and views.
• Perform database performance tuning and query optimization.
• Develop and maintain ETL processes for data integration.
• Monitor database health, security, backup, and recovery processes.
• Collaborate with developers and business teams to understand database requirements.
• Ensure data integrity, consistency, and security across all database environments.
• Troubleshoot database-related issues and provide timely resolutions.
• Create and maintain database documentation and technical specifications.
• Support database migration, upgrades, and deployment activities.

Required Skills

• 3+ years of experience as a Database Developer.
• Strong knowledge of SQL and RDBMS concepts.
• Hands-on experience with Microsoft SQL Server, MySQL, PostgreSQL, or Oracle Database.
• Expertise in Stored Procedures, Functions, Triggers, Views, and Indexing.
• Experience in Query Optimization and Performance Tuning.
• Knowledge of Database Backup & Recovery.
• Familiarity with ETL processes and data migration.
• Understanding of database normalization and data modeling.
• Experience with version control tools like Git is an advantage.
• Basic knowledge of cloud databases (AWS RDS, Azure SQL, or Google Cloud SQL) is preferred.

Preferred Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Relevant database certifications are an added advantage.