Complex queries, Advanced P/SQL Development (collections, mviews, partitioning etc.), Performance tuning (strong), Data Modeling (medium)
Stored Procedures, functions, packages, triggers, views, and Materialized views
Key skills:
- Understanding of Relational Database concepts
- Strong SQL analytical skills
- Good understanding of Data modelling concepts and Performance Optimization.
- Working knowledge on Database design
- Identify data quality issues and root causes.
- Experience in database objects like Stored Procedures, functions, packages, triggers, views, and Materialized views.
- Hands on with indexing and partition strategies that helps in query performance.
- Experience in Advanced PL/SQL, bulk Operations and SQL Loader
- Exposure to analysis of Oracle Database AWR/ADDM reports and troubleshooting of database performance issues.
- Assist in the execution/analysis of integration, user acceptance and performance testing.
- Review/Analyze test case results to ensure functionality meets the documented requirement.
- Working knowledge of Jira, Bitbucket, DevOps exposure for CI/CD pipelines and RLM process.
- Ability to work independently and as part of a team, and strong communication skills(verbal and written)
- Performance tuning
Education:
- Bachelor’s degree/University degree or equivalent experience
Applications Development
Time Type:
Full timeView the " " poster. View the .
View the .
View the