Oracle PL-SQL Developer - Database Design & Schema

Job Title : Oracle PL/SQL Developer

Experience : 5-7 Years

Location : Hyderabad

Notice Period : Immediate Joiners Preferred

Job Description :

We are seeking a highly skilled and self-driven Oracle PL/SQL Developer with 5 to 7 years of hands-on experience in database development and performance tuning. The ideal candidate should be proficient in Oracle SQL and PL/SQL, and able to work independently in a fast-paced environment.

Key Responsibilities :

- Develop and maintain PL/SQL procedures, functions, packages, and triggers.

- Design and create database schemas including tables, views, indexes, and constraints.

- Write efficient and reliable SQL queries, including query optimization and tuning.

- Develop and manage ETL processes for data transformation and migration.

- Create and maintain SQL-Loader scripts for high-volume data loading tasks.

- Perform performance tuning and troubleshooting of existing database queries.

- Understand and handle basic XML parsing in PL/SQL.

- Collaborate with cross-functional teams to support application requirements and improvements.

Required Skills :

- Strong experience with Oracle SQL and PL/SQL development.

- Hands-on experience in designing and creating database schemas.

- Solid understanding of writing and optimizing complex SQL queries.

- Experience with writing and managing ETL processes.

- Proficiency in using SQL-Loader for bulk data loads.

- Basic knowledge of XML data handling in Oracle.

- Experience in database query performance tuning.

- Excellent communication skills and the ability to work independently.