Oracle Apps DBA

Description

Application DBA SupportCode Review ParticipationSQL Tuning exercises with Development staffSQL Reviews with Development staffDatabase design tasks during application design User managementStandards Adherence Maintain property security models within the database Maintain proper naming methods within the application designs Performance Tuning Regular performance checking of instancesRecommend changes to environment/objects for performance considerationsInvestigate any performance issue in relation to the database with the ability to investigate external influences on the databaseReview current database design for potential improvements Production SupportParticipate in any Triage calls as necessaryParticipate in capacity planning effortsParticipate in the monitoring of system resources in determining future capacity needs Basic SkillsKnowledgeable in database design principlesAbility to analyze a current situation for problem determinationSolid communication skills that provide the ability to Communicate current status of critical situations in a concise meaningful mannerCoordinate efforts of multiple teams and team members to complete specific work items5 years experience working with common Oracle Database Administrative tools for example but not limited toERWinLatest Oracle Database versionToad (development and DBA use)ADDM/AWR (producing and interpreting)Generate a trace file and use TKPROF to analyze