PROGRAMMER 9853- PLSQL Developer-Oracle DB- Toad- Packages & Procedures
Bangalore, India
IT – IT /
Fulltime /
Hybrid
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.
