- Please come if you are having less than 30days Notice Period.
- Having experience in Oracle SQL & PLSQL Development with minimum 3 to 10 years of experience.
- Experience in developing Procedures, Functions, Triggers, Cursors and Packages.
- Experience in using advanced features like BULKCOLLECT, FORALL and Ref cursors.
- Good exposure to SQL queries and handling Exceptions in PLSQL.
- Good exposure to writing dynamic functions, procedures and packages.
- Worked with Tools like SQL*Plus and SQL Developer.
- Expertise in Dynamic SQL, Collections, cursors, Exception handling.
- Experience in stored procedures, functions and packages as per the business Requirement. Loaded external files Data into Oracle Tables using SQL Loader.
- Positive knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes and optimize procedures and packages.
- Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
- Development experience of materialized views for data replication in distributed environments.
- Good to have: Knowledge Oracle database administration tasks include configuration management, backup/recovery, performance optimization, and space management.
Qualifications
- 3+ years of experience in production support or IT operations.
- College degree (Bachelor) in Computer Science, Information Technology, or related field.
- Strong troubleshooting and analytical skills for enterprise applications.
- ITIL framework knowledge and incident management experience.
- Experience with monitoring tools (Splunk, Dynatrace, AppDynamics).
- Proficiency with ticketing systems ( JIRA).
- Experience with AWS cloud services.
- SQL skills for database troubleshooting and data validation.
- Scripting experience (Unix, Shell) for automation.