Oracle PL/ SQL Developer

Location : Chennai/ Pune, Currently WFH

Exp : 5+ Yrs

Notice period : Immediate/ 15 days/ 1 month

• 5+ years of experience of Oracle SQL and Stored procedures and should have knowledge on how to debug an Oracle Package/Stored Procedure
• 1+ years of experience of core .NET framework, C# and ASP.Net.
• 2+ years of n-tier Production Support experience in solving critical production issues, RCA, Permanent Fixes, Batch monitoring, Problem Management.
• Extremely good communication skills, as person needs to work with multiple geographically located teams.
• Must have experience with design, code, test, debug, and document complex database programs to ensure that data processing in production systems meet user needs.
• Coordinate with various developers, project managers and analyst during applications development phase to understand applications support requirements, migration, data loads and prepare Runbook.
• Troubleshoot and resolve complex production and non-production issues.
• Review and upload large data sets into Database using tools, and write custom procedures to perform uploads when necessary, and also automate uploads when feasible.
• Provide data analysis and validation.
• Perform database code reviews and provide recommendations.
• Identification of performance issues on production and non-production systems.
• Knowledge in partitioning tables, review create and rebuild indexes, analyze query's execution plan and fine tune the performance of SQL and PL/SQL.
• PL/SQL and SQL Tuning and Optimization of newly developed and existing applications.

Perks and Benefits