Sanjay J.

Sanjay J.

Database architecture

Noida , India

Experience: 16 Years

Sanjay

Noida , India

Database architecture

42336 USD / Year

  • Immediate: Available

16 Years

Now you can Instantly Chat with Sanjay!

About Me

Oracle Certified Associate, has been involve in large scale and complex IT projects in leading role with 18+ years of professional experience in design, development, and production support. Expert and highly familiar with a wide variety of developmen...

Show More

Portfolio Projects

Description

  • Writing PL/SQL stored packages, procedures, functions, triggers views, indexes etc.
  • Creating common Library functions and templates that can be used by various projects.
  • Solution mapping, designing and effort estimation.
  • Code Review, System Testing/UAT/Production Implementation as on incremental basis.
  • Migration of scripts from 11g to 12c and 18c.

Show More Show Less

Description

  • Successfully worked on Performance Tuning, Monitoring and Optimization of PL-SQL blocks in both Development and Production environment.
  • Successfully implemented the indexes such as Clustered index, Non-clustered index appropriately on data structure to achieve faster data retrieval.
  • Implemented code changes.
  • Worked on Jenkins Implementation
  • Successfully implemented DBFit test cases.

Show More Show Less

Description

Successfully collaborate Product Development and Sourcing Departments, early in the process. It helps in reducing the overall cycle time, as well as improve the overall efficiency of organizations. Sourcing impacts the product development process from line planning all the way through to final delivery of the product. Product Lifecycle Management deals with Apparel industry. It helps to maintain styles, colors, raw material, vendors, mills, suppliers.

Show More Show Less

Description

    • Identified high-impact SQL, optimized with the help of execution plan, AWR reports and Code Expert.
    • Data conversion and transferred data feed to different third-party applications.
    • Gathered requirements for the application, draw out a plan for releases of the enhancements.
    • Worked on design and implemented IT system solutions for clients.
    • Authored Functional Specifications for client and generated business rules.
    • Technical Suggestion and Discussions with Client and Third-Party Vendors to propose new technologies.
    • Evaluated customer’s needs, defined and established new standards, implemented changes, planned different transitions and tested functionality in order to fulfill organizations’ needs.
    • Documented test cases, managed changes and addressed cost concerns to organizations.
    • Data modelling – logical as well physical.
    • Worked on Jenkins Implementation

Show More Show Less