Oracle Plsql Developer

Job Description:

PLSQL Developer

Job Description:
We are looking for a PLSQL Developer with 7 to 10 Yrs of relevant experience in Oracle Plsql.
Roles and Responsibilities:
• Design, develop and maintain tables, standard views, materialized views,
synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences,
implicit cursors, explicit cursors, cursor for loops, reference cursors and other
database objects.
• Extensively worked on creating database objectsincluding tables, indexes, views,
sequences, packages.
• Worked with Bulk Collectionsfor bulk load processing. Involved in code walk through
and review sessions with the development team.
• Extensively done performance tuning of oracle databases by rewriting optimized SQL
queries.
• Worked on Partitioning large tables using rollback tablespace, range partitioning and
created indexes on various tables to improve query performance.
• Extensively worked on SQL commandsincluding all DDL (Data Definition Language), DML
(data manipulation language), and DCL (Data Control Language).
Required Skills:
• Should have more than 4 years ofstrong experience in Performance Tuning
• good exposure to Linux/Unix, Shell Scripting & XML
• Good experience in using WinSCP & Putty
• Flexible working hours (able to work in shifts, if needed)
• Must have hands on experience in coding.
• Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and
collections to implement business logic using SQL developer.
• Generated SQL scriptsfor data validation, data conversion and manipulation and
materialized the views for remote instances.
• Wrote conversion scripts using SQL, PL/SQL procedures, functions and packages to
migrate data from one database (SQL Server) to Oracle platform.
Shift timings- 1.30 Pm to 10.30pm (Ist) 0r 2Pm to 11pm (Ist)
Location – Chennai or Hyderabad

Company Profile:
BONbLOC is a 5-year-old, fast growing, “Great Place to work” certified, Software and Services company
with a growing team of 200+ professionals working across various cities in India and US. Our software
product group builds SaaS solutionsto solve large scale supply chain data collection and analysis problems
using Blockchain, Data Science and IOT technologies. Our services group provides dedicated
offshore/onsite support to select large customers in their IT modernization efforts working on
technologies such as Mainframe, AS400, Cognos, Oracle, .NET, Angular, Java, Tableau, Xamarin, Android,
etc.
On the software side, we go to market with our SaaS products built on blockchain, IOT and AI. We help
customers monitor and track their supply chain flow with oursoftware.
On the services side, we go to market with our 'Digital and Modern' platform where we use a range of
technologies from timelesstraditional to JOOG (just out of git) to help customers with their modernization
initiatives. We implement and support standard ERP and WMS packages, build custom web and mobile
applications, help customers modernize their mainframe and as400 systems, build large scale data
warehousing and generative AI based applications, cyber-security, cloud adoption and similar projects.
Our mission: We will build simple,scalable solutions using Blockchain, IoT and AI Technologies that enable
our customers to realize unprecedented business value year after year.
Our Vision: We will become an advanced information technology company powered by happy,
intellectual and extraordinarily capable people.
Integrity: We will be honest and transparent in our conduct as professional individuals, groups and teams.
Collaboration: We will respect and value our teammates and will always place team success over
individual success.
Innovation: We will act in the knowledge that only our continuous innovation can drive superior execution
Excellence: We believe that our delivery quality drives customer success which in turn drives our Company
Success.