PLSQL Developer

Reward360 Global Services Pvt Ltd is India’s premier Customer Engagement Solutions Company. Headquartered in Bangalore with an office in Dubai and Singapore, our ‘Global’ loyalty solution has been built after years of deep understanding of consumers, the nuances of the loyalty diaspora, the onset of big data, and most important the simplicity that needs to be delivered across any loyalty program.

Our Technology, Marketing, Alliances, Business, Product, and Operations teams work in collaboration to create and deliver the most successful loyalty programs in India today. With over 2000+ retail alliances in India and access to over 10 million rewards globally, gives us the edge to be one of the most exciting and growing loyalty companies in Asia.

The only constant in today’s difficult and dynamic market is 'change' . Our team is dedicated to using behavioural patterns of customers combined with cutting edge technology to take complex problems that enterprises face today and simplify them. This helps make our programs more relevant and puts the customer on the path of true loyalty.

Over 100+ dedicated team members work in collaboration to create world-class loyalty products out of our Corporate Office, R&D Lab, and Operation Hubs.

What you’ll do:

1. Analyzing the Database and come up with an approach for archiving the data.
2. Manage Oracle and PLSQL databases across different environments and business accounts.
3. Provide support to the development and production support team in troubleshooting issues.
4. Write SQL scripts to automate processes and provide support in SQL query tuning.
5. Help the Development team to analyze any performance issues in the system.
6. Go through the AWS report for the DB and figure out any faults in the system which will help us to improve the performance.
7. Suggest the team on the Design of any new changes or any change in the Existing Design for better usage.
8. Automation of the reports needed by the bank.
9. Should be able to correct the data in the live data base which has millions of data.
10. Support the clients when there is any issues in the data base.

What we’ll need:

− Minimum 6-7 years of total experience with Oracle Database and PLSQL.
− Strong experience in Advanced PL/SQL development experience with Oracle 12c/19c database
− Well versed in database concepts as well as database design
− Should have excellent technical and analytical skills in Oracle PL/SQL ad building queries
− Well versed in writing complex SQL queries by using advanced PL/SQL functions
− Excellent in troubleshooting, diagnostic & analytical skills.
− Good communication & coordination skills are required.
− A strong sense of self-ownership along with team coordination skill is a must.