Responsibilities Proposed architectural solutions to best meet business needs. Assisted in implementing and optimizing Oracle solution architecture. Developed architectural strategies to meet current and future enterprise needs. Recommended new technologies to support Oracle architecture. Developed architecture requirements based on technical and functional specifications. Developed and enforced enterprise-wide architectural policies. Coordinated with… Show more Responsibilities Proposed architectural solutions to best meet business needs. Assisted in implementing and optimizing Oracle solution architecture. Developed architectural strategies to meet current and future enterprise needs. Recommended new technologies to support Oracle architecture. Developed architecture requirements based on technical and functional specifications. Developed and enforced enterprise-wide architectural policies. Coordinated with architect team to develop scalable, maintainable, and cost-effective applications. Design and implement scalable data models that support business needs. Design and manage ETL (Extract, Transform and Load) processes to integrate data from various sources. Implement measures to ensure data accuracy, consistency, and reliability. Establish and enforce data governance policies to ensure compliance with data protection regulations Show less

Responsibilities Participated in the development of new PL/SQL procedures, functions, and triggers and also updating the old ones based on the change requests Created various DML and DDL statements using Oracle PI/SQL and SQL Tuned some existing queries using Hints to improve execution time of the queries. Participated in creation of database objects like tables, views, Materialized views, cursors (Implicit, Explicit, REF), procedures, packages, cursors using Oracle tools… Show more Responsibilities Participated in the development of new PL/SQL procedures, functions, and triggers and also updating the old ones based on the change requests Created various DML and DDL statements using Oracle PI/SQL and SQL Tuned some existing queries using Hints to improve execution time of the queries. Participated in creation of database objects like tables, views, Materialized views, cursors (Implicit, Explicit, REF), procedures, packages, cursors using Oracle tools like TOAD, PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions Prepared the test scenarios and performed unit and regression tests on PL/SQL programs Assist Java development team for writing SQL Queries for the application Designed and developed transactional and analytical data structures Involved in the continuous enhancements and fixing of production problems. Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.  Developed PL/SQL triggers and master tables for automatic creation of primary keys. Created scripts to create new tables, views, queries for new enhancement in the application using TOAD. Created indexes on the tables for faster retrieval of the data to enhance database performance.  Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.  Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.  Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks. Coordinated with clients for requirement gathering, clarification and providing solutions for several problems Handled client's enquiries regarding the project requirements Show less

Working with replication environment.