Oracle PLSQL developer with XML and JSON

Job Summary

Primary Skills DataBase Developer with strong SQL programming, SQL queries PLSQL functions, Scripting -Hands on experience as analyze, Design and Code development for medium to larger requirements using Oracle SQL, PLSQL, XML DB, JSON, Performance Tuning, etc Writing effective and tuned SQL queries, PL/SQL functions, stored procedures, triggers, cursors, materialized views ,Trouble shooting the production issues in lower environment with strong debugging skills Knowledge of database performance improvement techniques to make decisions or suggest designs based on the requirements and challenges Participate into Production Issue triage Bridge Calls and providing the solutions. Understanding of Agile methodologies and maintain the Jira Hygiene. Able to trouble shoot issues in production environment / strong debugging skills Thorough Unit Tests along with evidence and automating the Unit Tests using Ruby Cucumber. -Database environment setup - generating scripts for creating and amending tables and other objects in data dictionary. -Interacting with business users / counterparts to assist them with problem investigation Interacting with front end developers as part of the development process -Collaborating with Production L2 Support and ensuring the defect backlogs are within threshold Generating scripts for creating and amending tables and other objects in data dictionary. -Interacting with business users / counterparts to assist them with problem investigation Interacting with Front End Developers, Business Analysts and QA as part of the development process. -Assigned Tasks executed IndependentlyDaily status exchange internally with team and email communications to counterparts. Conducting Participating the scrum call and Retrospection meetings Performing the code reviews for team. Participating into innovative initiatives

Responsibilities

• Hands on experience as analyze, Design and Code development for medium to larger requirements using Oracle SQL, PLSQL, XML DB, JSON, Performance Tuning, etc
• Writing effective and tuned SQL queries, PL/SQL functions, stored procedures, triggers, cursors, materialized views
• Troubleshooting the production issues in lower environment with strong debugging skills
• Knowledge of database performance improvement techniques to make decisions or suggest designs based on the requirements and challenges
• Participate in Production Issue triage Bridge Calls and providing the solutions
• Understanding of Agile methodologies and maintain the Jira Hygiene
• Thorough Unit Tests along with evidence and automating the Unit Tests using Ruby Cucumber
• Database environment setup - generating scripts for creating and amending tables and other objects in data dictionary
• Interacting with business users / counterparts to assist them with problem investigation
• Interacting with front end developers as part of the development process
• Collaborating with Production L2 Support and ensuring the defect backlogs are within threshold
• Interacting with Front End Developers, Business Analysts and QA as part of the development process
• Assigned Tasks executed Independently
• Participating in scrum calls and Retrospection meetings
• Performing the code reviews for the team
• Participating in innovative initiatives

Skills

• SQL
• PL/SQL
• Oracle SQL
• XML DB
• JSON
• Performance Tuning
• Ruby
• Cucumber
• Jira

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.