• Designed, developed, and maintained database objects such as tables, views, indexes, and Sequences, creating and optimizing complex SQL queries to extract and manipulate data efficiently.• Developed PL/SQL packages, procedures, functions, and triggers to automate business processes and enhance application functionality.• Analyzed and optimized SQL queries to improve performance and reduce execution time, utilizing Oracle performance tuning tools and techniques, including Explain Plan, SQL Trace, and TKPROF.• Implemented indexing strategies and optimized database schema design to enhance performance.• Designed and developed ETL processes to extract, transform, and load data from various sources into the Oracle database.• Worked with business analysts and data architects to ensure data integrity and consistency across systems, creating and maintaining data migration scripts for system upgrades and data consolidation projects.• Collaborated with application developers to integrate PL/SQL code into applications and troubleshoot issues, providing production support by diagnosing and resolving database-related issues and errors.• Developed and maintained documentation for database processes, procedures, and applications.Implemented and enforced database security policies to protect sensitive data, conducting regular audits and reviews to ensure compliance with organizational and industry standards.

• Developed and maintain SQL and PL/SQL code for various applications.• Written and optimized complex SQL queries and PL/SQL procedures.• Designed and implemented database structures, including tables, views, indexes, and constraints.• Ensuring data integrity and consistency by implementing validation and error-handling mechanisms.• Collaborated with developers, analysts, and stakeholders to understand business requirements and translate them into technical solutions.• Participated in code reviews and provide feedback to improve code quality.• Troubleshooting and resolved database-related issues, improving overall system reliability.• Maintaining technical documentation for database development and processes.

• Performing data cleaning, data validation, data manipulation, and data transformation on top of raw data. • On top of the cleansed data generating reports as per the client’s requirements. • Solving issues while doing import and export independently and High attention to detail and ensure zero defects in process. • Handle the day-to-day volumes of the assigned task and ensure the given “Service Level Agreement” are met. • Interacting and coordinating with the client to accurately reflect the catalog for price, product, and other related information.