PLSQL Architect

PLSQL Architect - CREQ Description Hands-on with Oracle PLSQL Development UNIX AutoSys

Hands-on experience knowledge in Presto Tool (This is a tool that is used to Query across multiple Databases)

Analyze explain plan and AWR reports monitor long running queries using OEM tools and able to tune or re-write logic to achieve optimal performance

Work with DBA team to implement SQL tuning recommendation and optimize Oracle parameters

Evaluating existing data systems and reverse engineer and optimize the data model

Working with the application development team to create conceptual data models and data flows

Developing best practices for data design data types naming standards to ensure consistency within the system

Implementing data strategies data retention historical Primary Location Chennai, Tamil Nadu, India Job Type Experienced Primary Skills MS SQL Server, Oracle PL / SQL Years of Experience 9 Qualification

Hands-on with Oracle PLSQL Development UNIX AutoSys

Hands-on experience knowledge in Presto Tool (This is a tool that is used to Query across multiple Databases)

Analyze explain plan and AWR reports monitor long running queries using OEM tools and able to tune or re-write logic to achieve optimal performance

Work with DBA team to implement SQL tuning recommendation and optimize Oracle parameters

Evaluating existing data systems and reverse engineer and optimize the data model

Working with the application development team to create conceptual data models and data flows

Developing best practices for data design data types naming standards to ensure consistency within the system

Implementing data strategies data retention historical

Travel No