Database Developer

3i Infotech; Mumbai; On-site; INR 600,000 - 900,000; Full time

Job summary

3i Infotech in Mumbai (BKC) is seeking a Database Developer with 2–3 years of hands-on Oracle Database experience to design, develop and maintain database objects. You will optimize SQL/PLSQL queries and work with Java/.NET teams for integration in a full-time on-site role.

The candidate should be proficient in data migration, validation, and performance tuning, contributing to scalable database solutions and production support.

Qualifications

• 2+ years hands-on Oracle Database development.
• Strong knowledge of SQL and PL/SQL.
• Experience with stored procedures, functions, packages, and triggers.
• Ability to optimize queries and performance.
• Experience in data migration and validation.
• Exposure to Java/.NET integration is a plus.

Responsibilities

• Design, develop, and maintain database objects.
• Develop and optimize SQL/PLSQL for performance.
• Analyze and resolve production and non-production DB issues.
• Perform data validation, migration, and reconciliation.
• Collaborate with Java/.NET and frontend teams for integration.
• Ensure scripts run correctly across environments and follow standards.

Skills

SQL

PL/SQL

Stored Procedures

Triggers

Cursors

Views

Indexes

Data Modelling

Data Migration

Performance Tuning

Java/NET Integration

Tools

Oracle Database

Job description

Job Description Database Developer

Experience: 2 TO 3 Years
Role: Database Developer
Location: [BKC]
Employment Type: Full-time

Key Responsibilities

• Design, develop, and maintain database objects including tables, views, indexes, stored procedures, functions, and packages.
• Develop and optimize SQL and PL/SQL queries for performance and scalability.
• Analyze and resolve database-related issues in production and non-production environments.
• Perform data validation, reconciliation, migration, and data-fix activities.
• Work closely with Java/.NET and frontend teams for database integration and application requirements.
• Identify and resolve performance bottlenecks, including query optimization and indexing.
• Participate in database design, impact analysis, and technical discussions.
• Support deployment activities and ensure proper execution of database scripts across environments.
• Follow coding standards, version control, documentation, and change-management processes.
• Support production issues and provide timely root-cause analysis and fixes.

Required Technical Skills

• 2+ years of hands-on experience in Oracle Database development.
• Strong knowledge of SQL and PL/SQL.
• Good understanding of:
• Stored Procedures & Functions
• Packages
• Triggers
• Cursors
• Views & Materialized Views
• Indexes
• Constraints
• Transactions and Exception Handling
• Experience in SQL query tuning and performance optimization.
• Good understanding of database normalization and data modelling.
• Experience in data migration, data validation, and reconciliation.
• Basic knowledge of Oracle performance monitoring and troubleshooting.
• Exposure to application integration with Java/.NET is an advantage.

Good to Have

• Experience with Oracle 12c+
• Knowledge of large-volume transactional databases.
• Experience with JDBC/REST/API-based application integration.
• Exposure to banking, financial services, government, or other transaction-intensive applications.
• Knowledge of Git/version control and deployment processes.

Candidate Profile

• Strong analytical and problem-solving skills.
• Ability to understand business requirements and translate them into database solutions.
• Good communication and coordination skills.
• Ability to work independently as well as with cross-functional teams.
• Willingness to support critical production issues when required.