What are the responsibilities and job description for the Oracle PL/SQL Developer position at VeriiPro?
Job Summary
- 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).
- Oracle Advanced PLSQL Developer Certified Professionals.