Pl/Sql Developer

Summary

Join MentorMate, a global leader in digital transformation, as an experienced PL/SQL Developer. Leverage your expertise in SQL, Oracle PL/SQL, and Unix Shell scripting to develop, optimize, and maintain complex database solutions. Collaborate with application developers, ensuring data integrity and security while contributing to performance tuning and troubleshooting. You will work in an Agile environment, utilizing your knowledge of modern RDBMS products and DevOps practices. This role requires extensive experience with Oracle PL/SQL and related technologies. MentorMate offers competitive pay and flexibility.

Requirements

• 4+ years of experience working with Oracle PL/SQL
• Excellent working knowledge and experience of SQL, Oracle PL/SQL, and Unix Shell (Perl or Python) programming languages
• Extensive proficiency in modern RDBMS products, particularly Oracle (latest version). PostgreSQL is a major plus
• Experience developing complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL
• Proficiency in using Standard Oracle Packages (e.g., UTL_FILE), Dynamic SQL, Records, Arrays, PL/SQL tables, and File handling
• Knowledge in SQL and PL/SQL Performance Tuning, query rewriting, and using Explain Plan and Hints
• Expertise in Collections, Exception Handling, Partitioning techniques, BULK features, Analytics functions, and External tables
• Solid experience and comfort with UNIX/Linux platforms and sufficient commands
• Agile working experience with Scrum and SDLC methodologies and best practices. Experience with Atlassian products such as JIRA, Confluence, and BitBucket
• Thorough working experience with DevOps, UC4, Maven, Jenkins, and CI/CD
• Proficiency utilizing object-oriented analysis and design principles
• In-depth knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications

Responsibilities

• Develop, test, and maintain PL/SQL code for database applications
• Optimize and tune PL/SQL code for performance improvements
• Collaborate with application developers to design and implement database solutions
• Create and maintain documentation for database processes and procedures
• Troubleshoot and resolve database-related issues
• Ensure data integrity and security
• Participate in code reviews and provide constructive feedback
• Work in an Agile environment, following Scrum and SDLC methodologies

Preferred Qualifications

• Experience with the Informatica Platform, along with a strong understanding of best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products
• ETL and data modeling knowledge and experience, proficient in creating mappings, workflows, and implementing ETL concepts
• Good knowledge of recent programming languages and frameworks (such as Java, Angular or React, XML, JSON)

Benefits

• Competitive pay
• Flexibility