Work with a Client to provide enterprise-wide, Oracle Database Administration support for production systems and provide DBA services to application development teams, including database design, database generation, coding, and database production support. Provide DBA support with a high degree of customer service, technical expertise, and timeliness. Provide accurate and creative solutions to user problems of moderate nature to ensure user productivity.
Provide Development and/or Production support. This includes creating primary database storage structures, designing, and creating primary objects, modifying database structure as necessary for enhancements or performance, creating documentation, designing interfaces, database objects, and creating plans. Monitor and optimize performance of the database, plan for backup and recovery of the database, and allocate system storage and plan future storage needs. Create database-related scripts and programs to support development and production environments. Research, evaluate, design, test, recommend, and plan implementation of new or improved RDBMS, ETL and database tools.
· Proficiency in using query languages such as SQL
· Proficiency in writing/debugging PL SQL
· Proficiency in Oracle DBA
· Hands on experience on database design
· Hands on Experience from 4 to 7 years