Oracle PL SQL Developer(SJ-IQ)

SE Mentor Solutions; Ernakulam; On-site; INR 550,000 - 900,000; Full time

Job summary

SE Mentor Solutions is seeking a talented Software Developer with 2+ years of experience in database development and data processing. You will design, optimize, and maintain PL/SQL based database solutions to support business applications and reporting.

Exposure to Snowflake and Python will be an added advantage. Responsibilities include developing database objects, optimizing queries, ensuring data integrity, and collaborating with cross-functional teams to deliver data-driven solutions.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• Minimum 2 years of relevant experience in database development and software development.
• Excellent communication and interpersonal skills.

Responsibilities

• Design, develop, test, and maintain database objects using PL/SQL (procedures, functions, packages, triggers, views).
• Develop and optimize complex SQL queries for data extraction, transformation, and reporting.
• Analyze requirements and translate them into efficient database solutions.
• Monitor performance and implement tuning strategies for efficiency.
• Ensure data integrity, security, and compliance with standards.
• Collaborate with stakeholders and teams to deliver data-driven solutions.
• Support ETL processes and data integration across systems.
• Follow development best practices and participate in code reviews.
• Create and maintain technical documentation for developed solutions.

Skills

PL/SQL development

SQL & query optimization

Relational databases

Data modeling & design

Troubleshooting & problem-solving

Education

Bachelor's degree in CS/IT/Engineering

Tools

Snowflake

Python

Job description

Job Requirement

Job Summary

We are looking for a talented and motivated Software Developer with 2+ years of experience in database development and data processing. The ideal candidate should have strong expertise in PL/SQL and database technologies and be capable of developing, optimizing, and maintaining database solutions that support business applications and reporting needs. Exposure to Snowflake and Python will be an added advantage.

Key Responsibilities

• Design, develop, test, and maintain database objects such as stored procedures, functions, packages, triggers, and views using PL/SQL.
• Develop and optimize complex SQL queries for data extraction, transformation, and reporting.
• Analyze business requirements and translate them into efficient database solutions.
• Monitor database performance and implement tuning strategies to improve efficiency.
• Ensure data integrity, security, and compliance with organizational standards.
• Troubleshoot and resolve database-related issues and application data problems.
• Collaborate with business stakeholders, developers, and cross-functional teams to deliver data-driven solutions.
• Support ETL processes and data integration activities across multiple systems.
• Participate in code reviews and follow development best practices.
• Create and maintain technical documentation for developed solutions.

Required Skills

• Strong hands-on experience in PL/SQL development.
• Good knowledge of relational databases such as Oracle, SQL Server, MySQL, PostgreSQL, or any equivalent database platform.
• Proficiency in writing complex SQL queries, performance tuning, and database optimization.
• Understanding of database design principles, normalization, and data modeling.
• Experience in troubleshooting and resolving database performance issues.
• Strong analytical and problem-solving skills.

Good to Have Skills

• Experience with Snowflake Data Warehouse.
• Knowledge of Python for data processing, automation, or scripting.
• Exposure to ETL/ELT tools and data integration processes.
• Familiarity with cloud-based data platforms and data warehousing concepts.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• Minimum 2 years of relevant experience in database development and software development.
• Excellent communication and interpersonal skills.
• Ability to work independently and manage multiple priorities in a fast-paced environment.
• Prior experience in the Pharmaceutical domain will be an added advantage.

Required Skills

• Primary Skillset: PL/SQL (any database platform is acceptable)
• Secondary Skillset (Good to Have): Snowflake, Python