PL/SQL Developer

ProArch is seeking a skilled PL/SQL Developer to join our team. The successful candidate will be responsible for developing and maintaining database objects and applications using PL/SQL in Oracle environments. You will play a critical role in ensuring the efficiency and reliability of our data processing systems while collaborating with analysts and other developers to meet project requirements.

Key Responsibilities:

• Develop, test, and maintain PL/SQL code, including stored procedures, functions, and triggers.
• Work closely with data analysts to understand business requirements and translate them into technical specifications.
• Perform data analysis and optimize queries for better performance.
• Assist in database design, including schema creation and normalization.
• Troubleshoot and resolve PL/SQL programming issues and database errors.
• Participate in code reviews and contribute to the improvement of overall code quality.
• Document database designs, procedures, and other technical specifications.
• Stay updated with the latest Oracle features and PLSQL best practices.

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience in PL/SQL development and Oracle database management.
• Proficient in writing complex PL/SQL queries, procedures, and functions.
• Strong knowledge of Oracle database concepts and design principles.
• Experience with performance tuning and query optimization techniques.
• Familiarity with ETL processes and data integration tools.
• Excellent analytical and problem-solving skills.
• Good communication and teamwork skills.
• Ability to work independently and handle multiple tasks effectively.
• Knowledge of version control systems (e.g., Git) is a plus.

Contract

Remote