Roles and Responsibilities :
Database Design and Development : -
Design and implement database structures, including tables, views, and indexes.
Develop PL / SQL procedures, functions, and packages to encapsulate business logic.
Performance Tuning : -
Optimize SQL queries and PL / SQL code for performance.
Analyze and resolve performance issues using tools like Oracle Explain Plan and SQL Trace.
Data Manipulation :
Write complex SQL queries to retrieve, insert, update, and delete data.
Use PL / SQL to automate data processing tasks.
Testing and Debugging :
Conduct unit testing of PL / SQL code to ensure functionality and reliability.
Debug and troubleshoot PL / SQL programs, identifying and fixing issues.
Documentation :
Maintain comprehensive documentation of database designs, PL / SQL code, and procedures.
Create user manuals and technical documentation for future reference.
Collaboration :
Work closely with database administrators, application developers, and business analysts to gather requirements.
Participate in code reviews and provide constructive feedback to peers.
Maintenance and Support :
Monitor database performance and make recommendations for improvements.
Provide support for production issues and assist in system upgrades.
Security Management :
Implement security measures to protect sensitive data and ensure compliance with regulations.
Manage user roles and permissions within the database.
Integration :
Integrate with other systems and applications, ensuring smooth data flow and communication.
Use tools and technologies such as Oracle Forms, Oracle Reports, or APEX for front-end development.
Continuous Learning :
Stay updated with the latest Oracle technologies and PL / SQL features.Participate in training sessions and workshops to enhance skills.
PL/SQL Developer with AWS, Informatica exp
Optimize SQL queries and PL/SQL code for performance. Analyze and resolve performance issues using tools like Oracle Explain Plan and SQL Trace. Work closely with database administrators, application developers, and business analysts to gather requirements. Implement security measures to protect sen...
Senior Oracle PL SQL Developer
A company is looking for a Senior Oracle PL/SQL Developer. ...
10627 – Heroku Postgres / PL-SQL Developer III
The Heroku Postgres/ PLS-SQL Developer III is responsible for analyzing, designing, developing, and implementing software projects and operational maintenance Data hub tasks using Heroku platform. Working with testers and DevOps engineers for testing and deploying Java based web applications on the ...
Pega Developer with JAVA & SQL
EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal...
SQL and Mainframe Data Specialist with Guidewire and Informatica Knowledge
Kore1 provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Kore1 complies with applicable state and local laws governing nondis...
Java Backend Developer with AWS
Technical Skills</u></b></p> <p>Tech stack:</p> <ul> <li>Strong experience in AWS</li> <li>Backend dev</li> <li>Java/Kotlin (JDK)</li> <li>Spring / Springboot</li> <li>Distributed systems, Service and CLI devel...
Python Developer- ONLY 3 SLOTS- WE NEED EXP WITH investment systems
Must haves:</u></b><br /> * <b>Investment systems knowledge (trading, securities, etc)</b><br /> * Ability to effectively communicate with portfolio managers, work closely with them to rapidly build solutions<br /> * Python strongly preferred<br /> * K...
Oracle PL/SQL Developer
Must have over 15 years of experience in software development<br /> - Requires at least 12 years of strong development experience using Oracle PL/SQL<br /> - Must have used features like Analytical functions, merge statements, WITH clause, Oracle partitioning, job logging, exception hand...
Java Developer with AWS
Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. The company places a strong emphasis on employee training and development. Experience on writing Data Base SQLs. Design, implement and maintain Java-based applications that can be high-vo...
Python Developer- WE NEED EXP WITH Investment Systems
Must haves:</u></b><br /> * Investment systems knowledge (trading, securities, etc)<br /> * Ability to effectively communicate with portfolio managers, work closely with them to rapidly build solutions<br /> * Python strongly preferred<br /> * Knowledge of AWS ser...