Description:

ProArch is seeking a skilled PL/SQL Developer to join their team.
The successful candidate will be responsible for developing and maintaining database objects and applications using PL/SQL in Oracle environments.
This role is critical for ensuring the efficiency and reliability of data processing systems.
The developer will collaborate with analysts and other developers to meet project requirements.
Key responsibilities include developing, testing, and maintaining PL/SQL code, including stored procedures, functions, and triggers.
The developer will work closely with data analysts to understand business requirements and translate them into technical specifications.
Performing data analysis and optimizing queries for better performance is essential.
The role involves assisting in database design, including schema creation and normalization.
Troubleshooting and resolving PL/SQL programming issues and database errors is a key task.
Participation in code reviews and contributing to the improvement of overall code quality is expected.
Documenting database designs, procedures, and other technical specifications is required.
Staying updated with the latest Oracle features and PL/SQL best practices is important.

Requirements:

A Bachelor's degree in Computer Science, Information Technology, or a related field is required.
The candidate must have 5+ years of experience in PL/SQL development and Oracle database management.
Proficiency in writing complex PL/SQL queries, procedures, and functions is necessary.
A strong knowledge of Oracle database concepts and design principles is required.
Experience with performance tuning and query optimization techniques is essential.
Familiarity with ETL processes and data integration tools is preferred.
Excellent analytical and problem-solving skills are required.
Good communication and teamwork skills are necessary for this role.
The ability to work independently and handle multiple tasks effectively is important.
Knowledge of version control systems (e.g., Git) is a plus.