Description :

Job Title: Oracle Database Developer

Experience : 3-10 Years

Location - New Delhi

Job Overview: As an Oracle Database Developer, you will be responsible for the design, development, and maintenance of Oracle databases. You will work closely with software developers, system analysts, and other IT professionals to ensure the effective management and optimization of Oracle database systems.

Responsibilities:

Database Design and Modeling:

• Design and implement Oracle database architectures based on business requirements.
• Develop entity-relationship diagrams and data models to illustrate database design.

SQL Coding and Optimization:

• Write and optimize complex SQL queries and stored procedures.
• Tune and troubleshoot SQL queries for performance and efficiency.
• Implement best practices for Oracle database development and optimization.

PL/SQL Development:

• Develop and maintain PL/SQL procedures, functions, triggers, and packages.
• Implement business logic within the Oracle database using PL/SQL.

Database Implementation and Maintenance:

• Install, configure, and upgrade Oracle database systems.
• Ensure data security, integrity, and availability in Oracle environments.
• Perform regular Oracle database maintenance tasks, including backups, restores, and patching.

Collaboration:

• Collaborate with application developers to integrate databases with applications.
• Work closely with system analysts to understand and implement data requirements.

Data Migration and Transformation:

• Design and execute data migration and transformation processes within the Oracle environment.
• Ensure smooth data transitions between Oracle databases and other systems.

Documentation:

• Create and maintain documentation for Oracle databases, including schemas, procedures, and guidelines.
• Document changes and updates to the Oracle database structure.

Security:

• Implement and maintain Oracle database security measures to protect sensitive data.
• Monitor and audit Oracle database access and usage.

Requirements:

Education:

• Bachelor's degree in Computer Science, Information Technology, or a related field.

Experience:

• Proven experience as an Oracle Database Developer or in a similar role.
• Solid understanding of Oracle database architecture and features.

Skills:

• Proficient in Oracle SQL and PL/SQL development.
• Experience with Oracle database administration tasks.
• Strong analytical and problem-solving skills.