Oracle PL SQL Developer(SJ-IQ)

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

Job summary

SE Mentor Solutions in India is seeking a Software Developer with 2+ years of experience in database development and data processing, focusing on PL/SQL and relational databases. Exposure to Snowflake and Python is a plus.

You will design, develop, test, and maintain database objects, optimize SQL queries, ensure data integrity, and collaborate with stakeholders to deliver data-driven solutions. Candidates should have a Bachelor's degree and strong communication skills; pharma domain experience

Qualifications

• Bachelor's degree in Computer Science, IT, Engineering, or related field.
• 2+ years of relevant experience in database development and software development.
• Strong PL/SQL with relational databases.
• Experience in data processing, ETL/ELT is a plus.
• Exposure to Snowflake and Python is preferred.
• Excellent communication and ability to work independently.
• Pharma domain experience is a bonus.

Responsibilities

• Design, develop, test, and maintain database objects (procedures, functions, packages, triggers, 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 standards.
• Troubleshoot and resolve database-related issues and data problems.
• Collaborate with stakeholders, developers, and cross-functional teams to deliver data-driven solutions.
• Support ETL processes and data integration across systems.
• Participate in code reviews and follow development best practices.
• Create and maintain technical documentation.

Skills

PL/SQL

Snowflake

Python

SQL Queries

Data Modeling

Performance Tuning

Education

Bachelor's degree

Tools

Oracle

SQL Server

MySQL

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