App Dev & Support Engineer III

6 - 11 years

4 - 8 Lacs

Posted:3 hours ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Must Have Skills:

Minimum 6+ years of e xperience in support and operation process with below skills-

DB PL/SQL

: Oracle SQL and PL/SQL (performance tuning of SQL queries)

Servers : Linux (must)-

Understanding and through knowledge of Linux server environment (bash)

Script

: Bash/Python/PL/SQL

Application Server

: Apache Tomcat

Production Support :

Troubleshoot application problems, analyse logs and provide details

Good to Have Skills

Report

: PowerBI /Webfocus report

ETL tools

: ODI/OWB
Good knowledge of system security, update OS process, analyse vulnerability, apply patches

Communication:

Should have good analytical and communication skills. Create any necessary

Documentation:

Create necessary documentation as part of the support activity, RCA and process.

Job Roles / Responsibilities: \u202F

Support running production application, validate data, validate data replication between multiple databases and data processing with client.
Analyse application logs to validate if application is running as expected.
Support QA Platform: validate deployment package provided by dev team, deploy application to QA platform, validate application is running as expected in QA environment.
Identified potential issues in QA and report to dev team.
Develop required script which will help in day-to-day support activity LSQL - Procedures/Functions, bash/python scripts and Windows bat script.
Deploy application to staging and production environment. Validate deployment, test application, debug application.
Coordinate support activity across support team and getting job done.

PL/SQL Development:

Design, develop, and maintain PL/SQL packages, procedures, functions, triggers, and scripts.
Write efficient and optimized PL/SQL code for business logic and data manipulation.

Database Design and Management:

Create and manage database objects such as tables, views, indexes, sequences, and synonyms.
Normalize database schema and enforce data integrity using constraints.
Understanding on OLTP and OLAP

Performance Tuning:

Analyze and optimize existing PL/SQL code and queries for performance.
Use tools like SQL Trace, TKPROF, and Explain Plan to identify bottlenecks.

Data Integration:

Develop ETL (Extract, Transform, Load) processes using PL/SQL to migrate and transform data.
Work with external systems for data import/export.

Debugging and Troubleshooting

Debug PL/SQL code and resolve run-time errors.
Conduct unit testing and participate in integration testing.

Collaboration with Other Teams

Work with front-end and middleware developers to integrate PL/SQL logic with applications.
Collaborate with data analysts, DBAs, and business analysts to understand data requirements.

Support:

Support production environments and handle on-call support for PL/SQL-based issues.
Ability to check and simulate the production tickets and provide the fix in a timeline

Shell Scripting:

Monitoring the crontab jobs to validate the smooth process of daily loads
Ability to write and understand the shell script

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Conduent logo
Conduent

IT Services and IT Consulting

Florham Park New Jersey

RecommendedJobs for You