Oracle DB Developer - Database Design & Maintenance (5-10 yrs)

Job Description :

Role : Oracle Developer

You will be responsible for designing, developing, and maintaining database applications that support business operations. You will work closely with Team Lead, Java application developers to understand the business requirements and deliver efficient, scalable solutions.

Key Responsibilities :

Database Design :

- Design and implement database structures, ensuring they are optimized for. performance, reliability, and scalability.

Stored Procedures and Functions :

- Develop, test, and maintain stored procedures, functions, and triggers to support business logic and data manipulation.

SQL Development :

- Write complex PL/SQL procedures and SQL queries for data extraction, transformation, and reporting.

- Optimize queries for performance and efficiency.

Data Migration :

- Assist in data migration efforts, including data cleansing, validation, and transformation to ensure data integrity during transitions.

Performance Tuning :

- Monitor database performance and implement tuning techniques to optimize system performance and response times.

Troubleshooting and Support :

- Provide technical support to application developers and end-users, diagnosing issues related to the database and resolving them promptly.

Requirements :

- BE/B. Tech/MCA with 5+ years of experience.

- SCJP/OCJP certification is required.

- Proven experience as an Oracle Developer or similar role, with a strong understanding of Oracle.

- Database concepts.

- Proficiency in PL/SQL, SQL, and database design principles.

- Experience with Oracle tools and technologies, such as Oracle SQL Developer, Oracle Data.

- Integrator, or Oracle Forms.

- Familiarity with performance tuning and optimization techniques for Oracle databases.

- Strong analytical and problem-solving skills, with attention to detail.

- Good communication and teamwork abilities.