PL/SQL Developer

3 - 7 years

0 Lacs

Posted:3 days ago| Platform: Shine logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

As a PL/SQL Developer with 3+ years of experience in Oracle / Postgres, you will be responsible for designing, developing, and maintaining database applications using the PL/SQL programming language. Your key roles and responsibilities will include: - Designing and developing database schemas, stored procedures, functions, and triggers using PL/SQL to ensure efficient data storage and retrieval. - Optimizing database performance by tuning SQL queries and PL/SQL code to enhance overall system efficiency. - Developing and executing test plans to validate the quality and accuracy of PL/SQL code, ensuring the reliability of database applications. - Troubleshooting and resolving issues related to PL/SQL code to maintain the integrity and functionality of database systems. - Implementing database security policies and procedures to safeguard the confidentiality and integrity of data, ensuring data protection. - Collaborating with cross-functional teams to support their data needs and provide access to data for reporting and analytics purposes. - Deploying and supporting object shipment during any database deployment and integrated system upgrades. - Creating and maintaining database schemas, tables, indexes, and relationships based on project requirements and best practices. - Writing and optimizing SQL queries to extract, manipulate, and transform data for various business needs, ensuring query performance. - Integrating data from different sources into the SQL database, including APIs, flat files, and other databases, for comprehensive data storage. - Developing and maintaining data models, ER diagrams, and documentation to effectively represent database structures and relationships. - Monitoring and fine-tuning database performance to identify and resolve bottlenecks and inefficiencies for optimized system functionality. - Ensuring data accuracy and consistency through validation and cleansing processes, identifying and rectifying data quality issues. - Analyzing and optimizing complex SQL queries and procedures for enhanced performance and efficiency. - Maintaining comprehensive documentation of database structures, schemas, and processes for future reference and team collaboration. You should possess strong problem-solving and analytical skills, with attention to detail, excellent project management abilities to oversee multiple projects and meet deadlines, and strong collaboration skills to work both independently and in a team. Fluency in English with excellent written and verbal communication skills is essential for effective interaction with stakeholders.,

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Bahwan CyberTek logo
Bahwan CyberTek

Information Technology

Muscat

RecommendedJobs for You

Bengaluru, Karnataka, India

Gurugram, Haryana, India

Mumbai, Maharashtra, India

Hyderabad, Telangana, India