We are Looking for - PL/SQL Developer

Mar 7

We Prioritize Growth

Join AiRo Digital Labs and build your career with a leader in emerging digital technologies such as robotic process automation, conversational AI, machine learning, the internet of things, voice-based technologies, and cloud enablement.
At AiRo, we offer you competitive benefits and compensation package along with the opportunity to learn on the job, develop knowledge of the process, and grow your career. What’s more, you will have fun as you solve some of the most complex business problems.

Your Job Profile as a PL/SQL Developer

A PL/SQL developer is responsible for managing and designing the network interface of PL/SQL packages according to business requirements and core specifications. PL/SQL developers must have excellent knowledge of technical solutions to create efficient databases and applications with optimal infrastructure and excellent navigation.

Duties and Tasks of Your Particular Role

Coordinate with the team of java developers to accomplish complex financial calculations.

Develop complex PL/SQL packages, procedures, functions for the application, according to business requirements in UNIX and windows environments.
Develop PL/SQL store procedures, packages, and functions for data extraction, transformation, and data loading (ETL).
Implement procedures to install and deploy large numbers of Linux / Unix servers.
Modify and develop new scripts in LINUX to provide the same functionality as that are provided in UNIX.
Work with the advanced features of PL/SQL like collections, nest table, ref cursors, materialize views and dynamic SQL.
Develop load processes and data warehouse integration ETL procedures.
Develop PL/SQL procedures to create database objects dynamically base on user inputs.
Migrate legacy Java code for computing satellite pointing angles into PL/SQL to improve satellite installer efficiency.

Education

Bachelor’s degree in computer science, software development, engineering, or a related technical field

Location

Remote

You must have

Qualifications in a computing or computer/engineering related discipline.
Strong PC, Unix and database knowledge.
Proficient in SQL, PL/SQL and other database languages.
Experience in Performance Tunning
Good in SQL, PLSQL basic concepts of java and performance tunning Mandate
Performance tuning. Partitions, Indexes (how it works), Hits, Reading AWR report,
collections, pass by value/reference.
Web development skills including HTML, Javascript.
Knowledge of Java Programming language is desirable.
Knowledge on Webservers.
Ability to multi-task in a fast paced, team-oriented environment.
Ability to quickly master customer solutions.
Writing Complex SQL Queries for Reports.
Having good knowledge in implementing joins.
Having good knowledge in developing Anonymous and Sub programmed Blocks.
Proficient in PL/SQL and creation/modification of database objects like Tables, Packages, Procedures, Functions, views, sequences.
Experience in Creating SQL LOADER Control Programs and PL/SQL Validation Scripts for Validations and Import the data from Legacy system to Base tables.
Well equipped with tools like SQL Developer.

Years of Experience

4 - 8 Years

Cultural Fit

Self-governed: You don't just understand your responsibility - you understand how your work creates an impact and how important it is.
Driven: You are self-driven, hard-working and take pride in your work.
Collaborative: You see yourself as an essential part of a team and where your contribution is equally as important as the other team members.
Creative: You are creative and can think out of the box.