0% found this document useful (0 votes)
6 views3 pages

PL/SQL Lead Job Description

Uploaded by

Simmass
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
6 views3 pages

PL/SQL Lead Job Description

Uploaded by

Simmass
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

PLSQL LEAD

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.
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.

Common questions

Powered by AI

BONbLOC's performance tuning and database optimization directly impact customer satisfaction by ensuring higher efficiency, speed, and reliability in their services. By rewriting optimized SQL queries and partitioning large tables, BONbLOC improves query performance and system response times, which leads to a smoother user experience. This efficiency allows clients to process and analyze data faster, directly contributing to better decision-making and operational outcomes, ultimately resulting in increased client satisfaction and long-term retention .

BONbLOC's collaboration with clients on modernization projects aligns with its mission to deliver scalable solutions using cutting-edge technologies and its vision to become an advanced technology company powered by capable people. By working closely with clients on projects related to IT modernization, BONbLOC not only improves client operations but also reinforces its standing as an innovative leader in technology solutions. This alignment ensures long-term business value by harnessing new technologies, thus enhancing client relationships and driving mutual success .

BONbLOC's commitment to core values such as Integrity, Collaboration, Innovation, and Excellence shapes a working environment centered on honest, transparent communication, teamwork, continuous innovation, and a strong emphasis on quality. Integrity ensures that all conducts are honest and transparent, fostering trust and ethical standards. Collaboration focuses on valuing teammates and prioritizing team success, leading to a strong, cohesive work environment. Innovation and excellence push employees to continuously improve, fostering a culture of growth and high performance, which attracts top talent and maintains employee satisfaction .

BONbLOC's policy on flexible working hours contributes to productivity and employee satisfaction by providing employees with the flexibility to balance work and personal life efficiently. This flexibility can lead to higher morale, reduced stress, and a better work-life balance, which are crucial factors for maintaining high levels of productivity and creativity. Additionally, it helps attract and retain top talent who value personal flexibility, thereby ensuring a motivated and effective workforce capable of delivering high-quality service outcomes for the company .

BONbLOC's technical expertise in PL/SQL and ETL processes enhances its competitive advantage by allowing the company to deliver highly efficient, customized database solutions and data processing capabilities. This expertise ensures that data from both internal and external systems are handled optimally, reducing processing time and increasing accuracy and reliability. This technical proficiency enables BONbLOC to execute complex data projects that meet varied client needs, thus distinguishing the company in a competitive software industry landscape .

A technical lead at BONbLOC is responsible for coordinating with the team to understand business requirements, designing and developing PL/SQL, ETL processes, and maintaining various database objects. They guide developers in code implementation and are involved in performance tuning of Oracle databases. These responsibilities contribute to BONbLOC's goals by ensuring that technical solutions align with business needs, optimize database performance, and improve system efficiency, thereby enhancing the overall quality and scalability of services offered to clients .

BONbLOC leverages emerging technologies like Blockchain, Data Science, IoT, and AI to build SaaS solutions that address complex supply chain data collection and analysis. This technological integration allows BONbLOC to help customers monitor and track supply chain flows efficiently. Through these innovations, the company not only provides modernized solutions but also adds significant value to clients' businesses, enhancing their capabilities in tracking and analysis, leading to better decision-making and competitive advantage .

BONbLOC's mission is to build simple, scalable solutions using Blockchain, IoT, and AI technologies to enable customers to realize unprecedented business value year after year. This mission informs the company's operations by guiding their focus on providing SaaS solutions aimed at solving large-scale supply chain data problems and modernizing IT systems. The emphasis on simplicity and scalability ensures that the company continually innovates and adapts their services to meet customer needs effectively .

BONbLOC's innovation core value is intrinsically linked to its focus on emerging technologies like Blockchain, IoT, and AI. This focus reflects the company's commitment to continuous advancement and superior execution through new solutions. By prioritizing innovation, BONbLOC encourages the development and integration of groundbreaking technologies into its service offerings, which helps maintain a competitive edge and deliver high-value outcomes for clients, driving the company's growth and success .

By integrating its Digital and Modern platform with both traditional and emerging technologies, BONbLOC achieves strategic advantages such as enhanced flexibility and broad service offerings. The integration allows BONbLOC to support a wide range of modernization projects, from standard ERP and WMS implementations to mainframe and AS400 system updates and cloud adoption. This dual approach maximizes their solution applicability, allowing them to cater to diverse client needs effectively and positioning themselves as a versatile partner in IT modernization .

You might also like