Skills from Primary Skill ClusterOracle PL/SQL(19c) Oracle Performance Tuning Unix DB Parameters tuning data pump or other DB native ETL tools table reorg partition setup maintenance swap RDBMS Oracle SQL Server MSSQL ANSI SQL AutoSys ControlM OEM toolsSkills outside Primary Skill ClusterShell scripting Autosys ETLJob Description: Responsibilities:Good experience in requirement gathering/ analysis DB design coding Unit testing SIT SupportEngineers would need to be hands on and are capable of conversing with Architecture implement and maintain database system to meet business the Business need in to Technical complex queries/ to write complex sql queries/PL SQl Code for reporting Database performance and troubleshoot issuesSupport all day to day activities related to database like data consolidation data migration scripting performance Skills:Having 10 Years of strong expertise in PL/SQL programming Oracle Database Management DB Design/Architecture & NormalizationStrong experience with Oracle 18c/19c and knowledge of Oracle database featuresProficient in DB performance tuning & optimization TechniquesExperience with Datawarehouse & ETL process is preferred Expertise in Data Modelling Expertise in Unix Shell ScriptingSolid Experience of creating PL/SQL Packages Procedures Functions Triggers Views and Exception handling for retrieving manipulating checking and migrating complex data sets in in data migration/conversation using SQL* in Data migration using import and in creating the indexes on tables and partitioning the table for SQL tuning in writing procedures functions views materialized views as for performance tuning activities in the good experience on Client Interaction and Presentation Skills. Nice to have skills:Autosys ETL Knowledge of Big Data is plusCiti or Banking experience in the Compliance domain in the Agile Scrum Methodology