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.