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.

Required Experience:

IC