Database Developer with more than several years of experience in designing, developing, and testing software applications using Oracle SQL, PL/SQL, PostgreSql and Snowflake.Data Migration.ETL/ ELT Process.Also have experience in Different Clinical Studies using Medidata, Rave and Datalabs to design the Databse Layer for the Reporting solution using Spotfire.Responsibilities :* Creating and Modifying Oracle SQL Queries, Views, Tables, Procedures, Functions, Packages, Triggers,Collections (Associative Array, Nested Table), Cursors, Pipelined Functions, Analytical Functions, Dynamic SQL, Bug Fixing, Debugging etc. with Oracle SQL, PLSQL and some extent in PostgreSQL.* Oracle to Excel Data Export.* Creating and Modifying Oracle Forms and Reports (D2K).* Creating Technical Solution Design Document (TSD).* Creation and Review of Migration Sheets.* Develop and Unit/Integration Test the applications according to technical design specifications* QA Support during UAT as well as Postproduction Support.* Code review.* Mentor junior members of the team with the goal of improving their design and development skills.* Manage the project tasks to ensure on-time delivery of quality product features and enhancements.* Participate in review sessions to analyze business requirements and write design specifications.* Provide enhancements for existing applications according to written specifications.* Train the trainees to improve their technical skills in SQL, PLSQL etc.* Being part of Interview Technical Panel.
Listed skills include Requirements Analysis, Oracle Reports, Software Development, Vss, and 4 others.