Work Model: Remote
Job Role:
We are looking for a Senior Oracle PL/SQL Developer to join our Software Development team and contribute to the development and maintenance of the company’s mature business applications. These applications rely on extensive database-driven business logic and complex workflows implemented at the Oracle database level. In this role, you will be responsible for developing new features, maintaining existing solutions, analyzing complex business processes, and optimizing database performance to ensure scalability, reliability, and high-quality software delivery.
Requirements:
- Minimum 7 years of hands-on experience developing solutions with Oracle SQL and PL/SQL, or an equivalent demonstrable level of expertise
- Strong knowledge of Oracle SQL and PL/SQL
- Proven experience developing and maintaining applications with complex PL/SQL business logic distributed across packages, procedures, functions, triggers, and scheduled jobs
- Experience designing relational database models
- Experience working with Oracle database objects such as views, sequences, synonyms, database jobs, and database links
- Experience handling CLOB and BLOB data types
- Experience using dynamic SQL and implementing SQL injection prevention techniques
- Solid understanding of Oracle transaction management, concurrency control, and locking mechanisms
- Experience analyzing and optimizing SQL queries, including execution plan analysis and efficient index usage
- Experience working with user-defined types and PL/SQL collections
- Experience processing XML and JSON data
- Experience using Git for version control.
Nice to Have:
- Experience designing and optimizing batch processing for large data volumes, including tables containing CLOB/BLOB columns
- Knowledge of Oracle security concepts, including users, roles, and privileges
- Experience with hashing functions, encryption mechanisms, and Oracle data protection features
- Experience integrating REST and SOAP web services from PL/SQL
- Experience with Java stored procedures
- Experience using Jira and Bitbucket
- Linux knowledge and experience using shell commands for data processing
- Bachelor’s degree in Computer Science, Software Engineering,
- Information Technology, or a related technical field, or equivalent professional experience.
Responsibilities:
- Develop, test, and maintain SQL and PL/SQL components for the company’s business applications
- Design and implement new features while enhancing existing functionality
- Design data processing, integration, and reporting mechanisms
- Integrate external services and process XML/JSON messages within the Oracle database
- Analyze and optimize SQL and PL/SQL code for performance, scalability, and maintainability
- Assess existing application workflows and evaluate the impact of changes on dependent components and processes
- Investigate application behavior, identify root causes of issues, and implement effective solutions
- Participate in code reviews, effort estimation, and technical documentation
- Collaborate closely with team members to analyze business requirements and deliver high-quality technical solutions.
For this position, the company reserves the right to request professional references and/or letters of recommendation.
