6 to 8 years experience in Develop, design, test and implement complex database programs using Oracle PL SQL
Strong knowledge in DDL and DML
Expertise in finding own solution and implementing it with minimal guidance on the requirements
Ability to work with DBA team to implement SQL tuning recommendation and optimize Oracle parameters.
Good experience in merge join bulk number of tables in app accounting system
Strong knowledge in complex Views Optimize and Materialize views
Understanding in limitations of materialize views
Creating schema objects and implementing rules for data integrity
Analyze to explain plan and AWR reports, monitor long running queries using OEM tools
Ability to tune or re-write logic to achieve optimal performance.
Strong knowledge in Common Table Expressions CTE
Good experience in migrating data between applications from BOW to BMO
Export, purge, migration data migration experience is mandatory
Good to have knowledge in Extract and migrate tables
Ability to perform the role Oracle SQL Developer specialist packages tables jobs views PL SQL code
Ability to handle the views giving performance issue
Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 30,000+ people globally that cares about your growth - one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.
Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.
Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.
: Full Time
: Individual Contributor
: 05/08/2022, 7:20:18 AM