Database Developer

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.