Solid knowledge of data warehouse architecture, dimension modeling, and metadata management.
Strong knowledge of ASM, RAC and basic knowledge of golden gate replication.
Basics of AIX/Linux Administration, LDAP, Shell Scripting, SQL.
Strong knowledge in database backups and recovery techniques.
Strong group leadership, communication and presentation skills.
Strong Experience With
Implementation and support of large Oracle environments
Enterprise Manager Grid Control
Backup and recovery concepts and RMAN
Data warehousing and OLTP environments
Oracle RAC
Performance problem identification and remediation
AIX and Linux
Strong verbal, written, organizational and documentation skills
Ability to provide accurate and realistic effort estimates, commit and deliver accordingly
Proven analytical and problem solving skills; creative thinking
Ability to work in a fast paced environment with occasional non-business hours (evenings and weekends) flexibility and able to prioritize and juggle multiple projects
Ability to work productively in a team environment and participate as a positive and cooperative team member
Weekly database maintenance like generating stats, index reorg, space optimization
Experience in technical transitions.
Recommended Knowledge, Skills, and Abilities
Oracle Data Guard
Golden gate
SQL tuning and database performance troubleshooting.