Oracle PLSQL Lead

Job Description:

Job Description:
We are looking for a technical lead with 8+ Yrs exp who should have Coordinated with team in
understanding the business requirements and delivering the deliverables to the business users.
Design, develop, and support PL/SQL, ETL processes for loading data from external as well as
internal systems using SQL Loader and External tables.
Roles and Responsibilities:
• Should have hands on experience and be able to guide the team of developers
• 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 objects including tables, indexes, views, sequences,
packages.
• Worked with Bulk Collections for 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 commands including all DDL (Data Definition Language), DML (data
manipulation language), and DCL (Data Control Language) .
• Interacted with Business Analysts and Users for gathering and analyzing the Business Report
requirements.
• Requirements gathering for the Interfaces and custom programs development through
meetings with functional team and business users.
• Analysis (Business and Technical) of existing system with objective of improving & optimizing
the system performance.
• Handled a project where it involved building a process for BEx Team.
Required Skills:
• Should have sound experience with calling API thru PLSQL procedures and able to debug API
code & test API utilizing Postman
• Should have good exposure to Linux/Unix, Shell Scripting & XML
• Good experience in using WinSCP & Putty
• Knowledge or experience with scheduling tools like Control-M
• Good understanding on Ansible script (YAML creation) & Monitoring jobs
• Flexible working hours (able to work in shifts, if needed)
• Must have hands on experience in coding and be able to guide the team of developers.
• Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and
collections to implement business logic using SQL developer.
• Generated SQL scripts for 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.

ABOUT BONbLOC
BONbLOC is a 4-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 solutions to 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 our software.
On the services side, we go to market with our 'Digital and Modern' platform where we use a
range of technologies from timeless traditional 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.
Our Core values:
· 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.