PROGRAMMER 9853- PLSQL Developer-Oracle DB- Toad- Packages & Procedures

Extreme Networks; United States; Remote; USD 80,000 - 110,000; Full time

Job summary

A leading company seeks a highly skilled PLSQL Developer with extensive experience in enhancing Point of Sale systems. The role involves optimizing database performance, collaborating with IT teams, and ensuring efficient data transaction processes. Ideal candidates should possess a Bachelor's degree in Computer Science or a related field and demonstrate strong PL/SQL skills, problem-solving abilities, and collaborative spirit.

Qualifications

• 3-5 years of experience in IT required.
• Strong proficiency in PL/SQL and database development.
• Excellent problem-solving and analytical skills.

Responsibilities

• Develop and enhance Point of Sale (POS) system processes.
• Optimize database performance and ensure seamless data flow.
• Execute regular database maintenance and support users.

Skills

PL/SQL programming

Database design principles

SQL Developer

Data modeling

Problem-solving

Collaboration

SDLC knowledge

E2open CDM

Snowflake Datawarehouse

Education

Bachelor’s degree in Computer Science

Bachelor’s degree in Information Technology

Bachelor’s degree in related technical field

Job description

Job Description

We are seeking a highly skilled PLSQL Developer with a minimum of 3-5 years track record of relevant work experience.

Qualifications

Bachelor’s degree in Computer Science, Information Technology, or a related technical field.

Experience: 3-5 Years

Roles & Responsibilities

• Development and enhancements related to Point of Sale (POS)

• Understand and own the POS Processes and its Development and Optimise database performance and efficiency by evaluating and recommending new database technologies.

• Understand the impact of the POS Process in the downstream systems and work effectively with other IT teams for seamless flow of accurate data.

• Makes sure the DB jobs run seamlessly and keep a close watch on alerts including on time refreshes, scheduled jobs etc.

• Keep e2open and POS DB in sync with all related feed ins and feed outs. Work with and within e2open during planned maintenances and make sure ‘feedout’ and ‘feedins’ are processed.

• Execute regular database maintenance tasks, including database defragmentation, backups, and database replication.

• Support activities include Sales Rep assignment when Orders are unallocated, duplicate commission positions etc.

• Support users and developers by resolving data-related technical issues and troubleshooting queries by guiding them with best practices.

Skills Required:

• 3+ years of experience in IT

• Strong proficiency in PL/SQL programming.

• Developing stored procedures, packages, and functions in PL/SQL.

• Creating efficient database queries for high data retrieval speed.

• Designing and developing database schemas, stored procedures, functions, and triggers using PL/SQL.

• Developing and executing test plans to ensure the quality and accuracy of PL/SQL code.

• Familiarity with database design principles and data modeling.

• Experience with database development tools like SQL Developer, Toad, or similar.

• Excellent problem-solving and analytical skills.

• Strong communication and collaboration skills.

• Knowledge of SDLC (Software Development Life Cycle).

• Experience with e2open CDM is a plus.

• Experience in SNOWFLAKE Datawarehouse is a plus.