Job Description :
Role & Responsibilities :
- Database Design : Designing and creating the structure of Oracle databases, including defining tables, relationships, constraints, and data modeling
- SQL Development : Writing, optimizing, and maintaining SQL queries and scripts to retrieve, update, insert, and delete data from Oracle databases
- PL/SQL Development : Developing PL/SQL (Procedural Language/SQL) code, including stored procedures, functions, packages, and triggers, to implement business logic within the database
- Performance Tuning : Optimizing database performance by fine-tuning SQL queries, indexing, and query execution plans . Identifying and resolving performance bottlenecks
- Data Migration : Transferring data between different databases or Oracle versions, ensuring data integrity and consistency during the migration process
- Database Administration : Overseeing database administration tasks, including backup and recovery, security management, user access control, and database maintenance
- Security Implementation : Implementing security measures and access controls to protect the Oracle database from unauthorized access and data breaches
- ETL Processes : Designing and maintaining Extract, Transform, Load (ETL) processes to extract data from various sources, transform it, and load it into Oracle databases
What You Must Have :
- 1- 4 years of experience as an Oracle Developer or in a similar database-focused role.
- Strong proficiency in SQL Development, including writing complex queries and understanding query optimization.
- Experience with PL/SQL Development, including stored procedures, functions, packages, and triggers.
- Basic understanding of database design principles, including tables, relationships, and constraints.
- Familiarity with performance tuning concepts in Oracle databases.
- Knowledge of data migration techniques and considerations.
- An understanding of core database administration tasks.
- Exposure to ETL processes