Oracle PLSQL developer with XML and JSON

• *Role description**

Role : Oracle PLSQL developer with XML and JSON

Experience: 5\-10Yrs

Location : Bangalore

Notice period: 0\-15days

Primary SKills: Oracle PLSQL, functions, triggers, Advanced features of PLSQL, XML, JSON, storedprocedures.

Detailed Job description

\-Bachelors’ Degree with 4\-5 years of relevant experience as Oracle PLSQL developer \-Primary Skills DataBase Developer with strong SQL programming, SQL queries, PL/SQL functions, Scripting \-Hands on experience as analyze, Design and Code development for medium to larger requirements using Oracle SQL, PL/ SQL, 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 Independently. \-Daily status exchange internally with team and email communications to counterparts / Bank. \-Conducting/Participating the scrum call and Retrospection meetings. \-Performing the code reviews for team. \-Participating into innovative initiatives. Roles \& Responsibilities: Closely working with the team, ensuring the team concerns/issues are resolved and motivated them to provide the effective deliverables. Forecast the project resourcing requirement and ensuring the effective end\-2\-end hiring and onboarding / offboarding. Conduct feedback review sessions, recognitions and appraisals for the team. Timely highlighting the team pulse to leadership and taking the required actions. Lead and Manage a team of developers, Business Analyst and QA. Responsible for Leading multiple delivery streams to deliver successful product outcomes. Planning and scheduling the delivery process, including defining project scope, milestones, and timelines. Identify and manage the risks to the delivery, including developing contingency plans to mitigate potential issues. Communicate with stakeholders, including team members, clients, and other stakeholders, to ensure that everyone is informed about the progress of the delivery. Track the progress and making adjustments as needed to keep the delivery on track. Provide guidance and mentorship to team members to ensure that they have the skills and support they need to complete their tasks. Provide the technical leadership and guidance to team Working with clients or other stakeholders to meet their needs and expectations. Work with L2 Support and Client Service Management team to ensure NPS. Participate into Production Incident Bridge calls and providing suggestions/solutions. Ensuring the Jira Hygiene and ensure team is following the best practices. Conducting sprint retrospection meetings and actions on outcome of it. Participating in scrum of scrums and cross squad meetings to discuss, highlight dependencies across systems

• *Skills**

Databases, PL/SQL, SQL, Oracle

• *About UST**

UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future\-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.