Oracle PL/SQL developer

at Mobile Programming LLC

Oracle PL/SQL developer

Mobile Programming LLC

Oracle PL/SQL developer at Mobile Programming LLC · Bengaluru (Bangalore) · 3 - 8 years · ₹10L - ₹14L / yr · Profitable · Posted 23 Sep 2022

Oracle PL/SQL developer

at Mobile Programming LLC

Posted by keerthi varman

3 - 8 yrs

₹10L - ₹14L / yr

Bengaluru (Bangalore)

Skills

Oracle SQL Developer

PL/SQL

ETL

Informatica

Data Warehouse (DWH)

Oracle

dbms

SQL

Data migration

The role and responsibilities of Oracle or PL/SQL Developer and Database Administrator:
• Working Knowledge of XML, JSON, Shell and other DBMS scripts
• Hands on Experience on Oracle 11G,12c. Working knowledge of Oracle 18 and 19c
• Analysis, design, coding, testing, debugging and documentation. Complete knowledge of
Software Development Life Cycle (SDLC).
• Writing Complex Queries, stored procedures, functions and packages
• Knowledge of REST Services, UTL functions, DBMS functions and data integration is required
• Good knowledge on table level partitions, row locks and experience in OLTP.
• Should be aware about ETL tools, Data Migration, Data Mapping functionalities
• Understand the business requirement, transform/design the same into business solutions.
Perform data modelling and implement the business rules using Oracle database objects.
• Define source to target data mapping and data transformation logic as per the business
need.
• Should have worked on Materialised views creation and maintenance. Experience in
Performance tuning, impact analysis required
• Monitoring and optimizing the performance of the database. Planning for backup and
recovery of database information. Maintaining archived data. Backing up and restoring
databases.
• Hands on Experience on SQL Developer

The role and responsibilities of Oracle or PL/SQL Developer and Database Administrator:
• Working Knowledge of XML, JSON, Shell and other DBMS scripts
• Hands on Experience on Oracle 11G,12c. Working knowledge of Oracle 18 and 19c
• Analysis, design, coding, testing, debugging and documentation. Complete knowledge of
Software Development Life Cycle (SDLC).
• Writing Complex Queries, stored procedures, functions and packages
• Knowledge of REST Services, UTL functions, DBMS functions and data integration is required
• Good knowledge on table level partitions, row locks and experience in OLTP.
• Should be aware about ETL tools, Data Migration, Data Mapping functionalities
• Understand the business requirement, transform/design the same into business solutions.
Perform data modelling and implement the business rules using Oracle database objects.
• Define source to target data mapping and data transformation logic as per the business
need.
• Should have worked on Materialised views creation and maintenance. Experience in
Performance tuning, impact analysis required
• Monitoring and optimizing the performance of the database. Planning for backup and
recovery of database information. Maintaining archived data. Backing up and restoring
databases.
• Hands on Experience on SQL Developer

Read more

Users love Cutshort

Read about what our users have to say about finding their next opportunity on Cutshort.

Shubham Vishwakarma

Full Stack Developer - Averlon

I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.

Companies hiring on Cutshort

companies logos

About Mobile Programming LLC

Founded :

2010

Type :

Services

Size :

1000-5000

Stage :

Profitable

About

Mobile programming LLC is a US based MNC company. Our services are focused on Mobility Solutions, Custom App Development, Cloud Solutions, IoT, AR/VR, Blockchain, Artificial Intelligence & Machine Learning, Predictive Analytics & Big Data Solutions, and several other trending as well as emerging technologies.

You can find more details on - https://www.mobileprogramming.com/

Mobile programming LLC is a US based MNC company. Our services are focused on Mobility Solutions, Custom App Development, Cloud Solutions, IoT, AR/VR, Blockchain, Artificial Intelligence & Machine Learning, Predictive Analytics & Big Data Solutions, and several other trending as well as emerging technologies.

You can find more details on - https://www.mobileprogramming.com/

Read more

Company video

Mobile Programming LLC's video section

Mobile Programming LLC's video section

Connect with the team

Chandni oli

Piyush Singla

Vandana Dhiman

Abha Sharma

Krishna sravani

Neha Rana

Abhinav Dang

Preeti Gupta

Garima Walia

Surya Prabha

Preeti Bedi

Navrose Kaur

Nivedita Kumari

Anurodh Dhanwik

nitika nitika

Pankaj Bhardwaj

Tripti Jaiswal

Apurva kalsotra

Shweta Verma

Priyanka Anbarasu

Sindhuja Pasupathi

Surabhi Parihar

Simran Saini

Jagdeep Kaur

Sheetal Sharma

Divya Joshi

Nishanth Lingaraj

Prateek Kaushik

sudiksha arora

Zareen Kareem

Ragu Badri

vandana chauhan

Abha Sharma

Vinay Sattu

Company social profiles

Similar jobs (3)

Gravity Engineering Services Pvt Ltd

PL/SQL Developer

at Gravity Engineering Services Pvt Ltd

Akash Bhatt

Posted by Akash Bhatt

Delhi, Gurugram, Noida, Ghaziabad, Faridabad, Kolkata, Hyderabad, Chennai

2 - 12 yrs

₹5L - ₹25L / yr

PL/SQL

Oracle SQL Developer

Stored Procedures

Performance Testing

Shell Scripting

We are hiring a PL/SQL Developer to build and optimise database logic on Oracle.

Responsibilities

Write stored procedures, functions, packages and triggers in PL/SQL
Tune complex SQL queries for performance
Build data loads and batch jobs
Support production databases and fix issues

Requirements

2+ years of PL/SQL development on Oracle
Strong SQL and query-tuning skills
Unix shell scripting is a plus

We are hiring a PL/SQL Developer to build and optimise database logic on Oracle.

Responsibilities

Write stored procedures, functions, packages and triggers in PL/SQL
Tune complex SQL queries for performance
Build data loads and batch jobs
Support production databases and fix issues

Requirements

2+ years of PL/SQL development on Oracle
Strong SQL and query-tuning skills
Unix shell scripting is a plus

Read more

Sapical Consulting Services Private Limited

Oracle Database Administration

at Sapical Consulting Services Private Limited

Sapical Consulting

Posted by Sapical Consulting

Indore

5 - 10 yrs

₹5L - ₹7L / yr (ESOP available)

Oracle DBA

oracle ebs 12

Oracle RAC

Oracle ASM

Oracle Data Guard

+6 more

Job Description — L2/L3 Oracle DBA and Oracle Apps DBA

Experience: 5–10 years of relevant experience

Support coverage: Dubai customer business hours and on-call support as required

Role Overview

We are seeking an experienced Oracle DBA and Oracle Apps DBA to support

customer Oracle Database and Oracle E-Business Suite (EBS) environments. The role

involves L2 incident resolution, L3 troubleshooting, performance tuning, patching,

upgrades, and maintaining database and application availability.

Key Responsibilities

Oracle Database Administration

∙Install, configure, administer, and maintain Oracle databases across

production and non-production environments.

∙Monitor database health, availability, performance, storage, and capacity.

∙Troubleshoot database incidents, connectivity failures, locking, blocking, and

resource issues.

∙Analyse AWR and ASH reports, SQL execution plans, and database wait

events to resolve performance problems.

∙Configure and manage RMAN backups; perform recovery and restore

validation.

∙Administer Oracle RAC, ASM, Grid Infrastructure, and Data Guard

environments.

∙Perform database patching, upgrades, migrations, and refreshes through

approved change procedures.

∙Manage database users, roles, privileges, auditing, and security controls.

∙Execute disaster recovery drills, Data Guard switchovers, and failovers.

∙Automate routine administration and monitoring using shell scripts and SQL.

Oracle Applications DBA

∙Administer Oracle E-Business Suite R12.2 application and database tiers.

∙Monitor and troubleshoot concurrent managers, concurrent requests,

Workflow Mailer, application services, and login issues.

∙Perform EBS online patching using ADOP and manage the associated

patching lifecycle.

∙Clone and refresh EBS environments using supported tools, including Rapid

Clone.

∙Maintain application configuration using AutoConfig and context files.

∙Administer EBS-related WebLogic Server, Oracle HTTP Server, and Forms

services.

∙Troubleshoot application-tier performance and coordinate with functional

and development teams.

∙Support EBS upgrades, technology-stack patches, certificate renewals, and

integration-related incidents.

∙Maintain operational procedures for application startup, shutdown, backup,

recovery, and maintenance.

L2/L3 Support and Customer Operations

∙Own incidents and service requests within agreed SLAs.

∙Provide L2 troubleshooting and escalate complex issues with complete

diagnostic evidence.

∙Lead L3 investigation, root-cause analysis, and permanent corrective actions.

∙Support major incidents, communicate progress, and document recovery

actions.

∙Raise and manage Oracle Support service requests.

∙Prepare change plans, risk assessments, validation steps, and rollback

procedures.

∙Maintain runbooks, knowledge articles, configuration records, and shift

handovers.

∙Coordinate with customer teams and internal infrastructure, storage,

network, and application teams.

∙Mentor junior DBAs and identify opportunities to reduce recurring incidents.

Required Skills and Experience

∙Hands-on production experience administering Oracle Database, including

Oracle 10g, 11g, 12c, 18c and 19c.

∙Strong experience supporting Oracle EBS R12.2 as an Apps DBA.

∙Practical knowledge of RAC, ASM, Data Guard, RMAN, Data Pump, and

Job Description — L2/L3 Oracle DBA and Oracle Apps DBA

Experience: 5–10 years of relevant experience

Support coverage: Dubai customer business hours and on-call support as required

Role Overview

We are seeking an experienced Oracle DBA and Oracle Apps DBA to support

customer Oracle Database and Oracle E-Business Suite (EBS) environments. The role

involves L2 incident resolution, L3 troubleshooting, performance tuning, patching,

upgrades, and maintaining database and application availability.

Key Responsibilities

Oracle Database Administration

∙Install, configure, administer, and maintain Oracle databases across

production and non-production environments.

∙Monitor database health, availability, performance, storage, and capacity.

∙Troubleshoot database incidents, connectivity failures, locking, blocking, and

resource issues.

∙Analyse AWR and ASH reports, SQL execution plans, and database wait

events to resolve performance problems.

∙Configure and manage RMAN backups; perform recovery and restore

validation.

∙Administer Oracle RAC, ASM, Grid Infrastructure, and Data Guard

environments.

∙Perform database patching, upgrades, migrations, and refreshes through

approved change procedures.

∙Manage database users, roles, privileges, auditing, and security controls.

∙Execute disaster recovery drills, Data Guard switchovers, and failovers.

∙Automate routine administration and monitoring using shell scripts and SQL.

Oracle Applications DBA

∙Administer Oracle E-Business Suite R12.2 application and database tiers.

∙Monitor and troubleshoot concurrent managers, concurrent requests,

Workflow Mailer, application services, and login issues.

∙Perform EBS online patching using ADOP and manage the associated

patching lifecycle.

∙Clone and refresh EBS environments using supported tools, including Rapid

Clone.

∙Maintain application configuration using AutoConfig and context files.

∙Administer EBS-related WebLogic Server, Oracle HTTP Server, and Forms

services.

∙Troubleshoot application-tier performance and coordinate with functional

and development teams.

∙Support EBS upgrades, technology-stack patches, certificate renewals, and

integration-related incidents.

∙Maintain operational procedures for application startup, shutdown, backup,

recovery, and maintenance.

L2/L3 Support and Customer Operations

∙Own incidents and service requests within agreed SLAs.

∙Provide L2 troubleshooting and escalate complex issues with complete

diagnostic evidence.

∙Lead L3 investigation, root-cause analysis, and permanent corrective actions.

∙Support major incidents, communicate progress, and document recovery

actions.

∙Raise and manage Oracle Support service requests.

∙Prepare change plans, risk assessments, validation steps, and rollback

procedures.

∙Maintain runbooks, knowledge articles, configuration records, and shift

handovers.

∙Coordinate with customer teams and internal infrastructure, storage,

network, and application teams.

∙Mentor junior DBAs and identify opportunities to reduce recurring incidents.

Required Skills and Experience

∙Hands-on production experience administering Oracle Database, including

Oracle 10g, 11g, 12c, 18c and 19c.

∙Strong experience supporting Oracle EBS R12.2 as an Apps DBA.

∙Practical knowledge of RAC, ASM, Data Guard, RMAN, Data Pump, and

Read more

Gravity Engineering Services Pvt Ltd

Database Administrator

at Gravity Engineering Services Pvt Ltd

Akash Bhatt

Posted by Akash Bhatt

Delhi, Gurugram, Noida, Ghaziabad, Faridabad, Kolkata, Pune, Hyderabad, Bengaluru (Bangalore)

2 - 14 yrs

₹5L - ₹28L / yr

Oracle

Oracle SQL Developer

Oracle DBA

Relational Database (RDBMS)

We are looking for a Database Administrator to keep our databases fast, secure and highly available.

Responsibilities

Install, configure and maintain Oracle, PostgreSQL and SQL Server databases
Tune queries and database performance
Manage backup, recovery and disaster-recovery plans
Handle replication, high availability and security

Requirements

2+ years as a DBA on Oracle, PostgreSQL or SQL Server
Strong backup, recovery and tuning experience
Oracle or Microsoft DBA certification is a plus

We are looking for a Database Administrator to keep our databases fast, secure and highly available.

Responsibilities

Install, configure and maintain Oracle, PostgreSQL and SQL Server databases
Tune queries and database performance
Manage backup, recovery and disaster-recovery plans
Handle replication, high availability and security

Requirements

2+ years as a DBA on Oracle, PostgreSQL or SQL Server
Strong backup, recovery and tuning experience
Oracle or Microsoft DBA certification is a plus

Read more

Why apply to jobs via Cutshort

people_solving_puzzle

Personalized job matches

Stop wasting time. Get matched with jobs that meet your skills, aspirations and preferences.

people_verifying_people

Verified hiring teams

See actual hiring teams, find common social connections or connect with them directly.

ai_chip

Move faster with AI

We use AI to get you faster responses, recommendations and unmatched user experience.

Did not find a job you were looking for?

Search for relevant jobs from 10000+ companies such as Google, Amazon & Uber actively hiring on Cutshort.

Get to hear about interesting companies hiring right now

Follow Cutshort

Users love Cutshort

Read about what our users have to say about finding their next opportunity on Cutshort.

Shubham Vishwakarma

Full Stack Developer - Averlon

I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.

Companies hiring on Cutshort

companies logos