Role: Senior Oracle DBA with EDW
Location: Houston, TX ( ONSITE)
Duration: Long Term
• DW and Oracle performance tuning and developing query execution plans
• Creating objects/queries based on the cost
• JDE to EDW table pull and working with Informatica and Azure team for ETL/Pipeline design
• Creation and maintenance of MVs, Procedures, Indexes, tables, views etc. in Oracle DB/EDW
• Maintaining Data and structure of existing EDW, develop new objects, migration to higher environments
• Troubleshooting issues with various EDW objects, archiving of data and objects in EDW from time to time
• Testing of dependent objects that feed in and out to different applications
• Liaison with WFT IT folks, Business folks and get requirements and develop EDW objects
• Work in a time bound manner with limited supervision
• Attend various meetings with different application owners/leads, project owners, WFT IT folks and get requirements for development.
• Good communication skills and interpersonal skills