YASH Technologies
Location
Pune | India
Job description
Oracle SQL, PLSQL Developer
5 to max 8 years of experience in all phases of SDLC including requirement gathering, analysis, application design, development, testing, implementation and maintenance. • Must have strong team building skills and Strong ITIL process Implementation experience. • Extensive SQL and PL/SQL programming experience including packages, stored procedures, functions, triggers, indexes and exception handling. Create database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer, toad. • Strong working knowledge of Loading Data using SQL* Loader and PL/SQL using different file format. • Extensive experience in trouble shooting, Query Optimization and performance tuning use of explain plans. • Experience in using the features Ref-Cursors, PL/SQL Tables, Materialized Views, Dynamic SQL and Oracle RAC. • Experience to write scheduler jobs and Troubleshoot issue if any failures. • Analyze application requirements and provide recommended design. Support code migration from development to staging environment. • Write complex SQL queries and PL/SQL procedures to extract data from various source tables. • Ability to work independently and as part of a team, deliver under pressure and tight deadlines • Strong aptitude and troubleshooting skills • Preferably good skill MSSQL T-SQL. • Good to have exposure on public clouds (AZURE & GCP) • Strong knowledge on Linux (RHEL) system • Experience creating Shell scripts. • Ability to understand complex domain and identify business entity & data model • Ability to be flexible and work analytically in a problem-solving environment.Job tags
Salary