Oracle Database Administrator

We require an immediate joiner for an Oracle PL/SQL Developer with approximately 5+ years of experience typically outlines responsibilities centered on designing, developing, and optimizing complex database solutions and a strong understanding of the full Software Development Life Cycle (SDLC).

Job Description: Oracle PL/SQL Developer (Mid-to-Senior Level)

Key Responsibilities

• Develop and maintain complex PL/SQL packages, stored procedures, functions, triggers, and views to implement business logic.
• Write and optimize advanced SQL queries for data manipulation, retrieval, and analysis, focusing on performance and efficiency.
• Perform performance tuning of SQL and PL/SQL code.
• Designing databases and ensuring their stability, reliability, and performance
• Write complex queries and scripts with advance SQL queries.
• Develop, Implement and optimize Procedures, Functions, Triggers, Views, Joins, database objects
• Analyse existing SQL queries/ procedures for performance optimization and troubleshooting issues.

Required Skills:-

• Hands on Experience in developing, implementing and optimizing Procedures, Functions, Triggers, Views, Joins, database objects.
• Excellent skills in troubleshooting, debugging and developing procedures in database issues.
• Knowledge of best practices when dealing with relational databases.
• Critical thinker and problem-solving skills.
• Good time-management skills and a team player
• Design and implement database schemes, tables, indexes, and constraints, applying knowledge of data modeling and normalization techniques.
• Manage data migration and transformation processes using tools such as SQL*Loader and develop ETL components as needed.
• Create and maintain technical documentation, including design documents, test plans, and operation instructions.
• Implement security measures and ensure compliance with data integrity and security policies.

Qualifications

• Education: Bachelor's or Master's degree in Computer .
• Experience: Minimum of 5 years of proven experience in Oracle PL/SQL development.
• Technical Proficiency:
• Strong command of advanced SQL and PL/SQL programming, including performance tuning techniques.
• Hands-on experience with database development tools.