Posted:1 month ago|
Platform:
Work from Office
Full Time
Oracle PLSQL Developer Job Description: Roles and Responsibilities: 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). Required Skills: Should have more than 6 years of strong experience in Performance Tuning Good exposure to Linux/Unix, Shell Scripting & XML Good experience in using WinSCP & Putty Flexible working hours (able to work in shifts, if needed) Must have hands on experience in coding. 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.
Digital Mapout Solutions
Upload Resume
Drag or click to upload
Your data is secure with us, protected by advanced encryption.
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.
We have sent an OTP to your contact. Please enter it below to verify.
Instantly access job listings, apply easily, and track applications.
Bengaluru
6.0 - 11.0 Lacs P.A.
Bengaluru
2.25 - 4.0 Lacs P.A.
Hyderabad
5.0 - 15.0 Lacs P.A.
Bengaluru
18.0 - 22.5 Lacs P.A.
Pune
4.0 - 9.0 Lacs P.A.
Bengaluru
4.0 - 9.0 Lacs P.A.
Hyderabad
7.0 - 17.0 Lacs P.A.
Chennai
30.0 - 35.0 Lacs P.A.
Pune, Chennai, Bengaluru
15.0 - 20.0 Lacs P.A.
15.0 - 25.0 Lacs P.A.
