Software Developer

Responsibilities and Requirements:

1. Oracle Database

• Strong hands-on experience with Oracle 19c/12c/11g.
• Knowledge of tables, views, indexes, sequences, synonyms, constraints and database objects.

1. SQL & PL/SQL

• Advanced SQL queries, joins, subqueries, CTEs and analytical functions.
• Development of Procedures, Functions, Packages, Cursors and Triggers.
• Dynamic SQL and exception handling.

1. Performance Tuning

• SQL query optimization and execution-plan analysis.
• Index optimization and statistics management.
• Troubleshooting slow-running queries and database performance issues.

1. Database Design

• Database schema design and normalization.
• Primary/foreign keys, relationships and constraints.
• Understanding of ER diagrams and data modelling.

1. Data Management & Migration

• Data migration, bulk data processing and data validation.
• Experience with Oracle Data Pump (EXPDP/IMPDP) and SQL*Loader.
• Handling large-volume datasets.

1. Database Troubleshooting

• Identification and resolution of Oracle errors.
• Knowledge of locks, blocking sessions, deadlocks and transaction management.
• Debugging and maintenance of PL/SQL code.

1. Database Security

• User and role management.
• GRANT/REVOKE privileges and basic database security concepts.

Education

UG: B.Tech / B.E. in Computer Science and Engineering (CSE), Electronics and Communication Engineering (ECE), Electrical and Electronics Engineering (EEE)

Experience :

10+ years development experience with Oracle Database version 9i /10g / 11g /12c Manage all phases of the SDLC from analysis, design, development, testing, implementation and maintenance.