Oracle Database Administrator

Oracle database administrator L2

Job description-

Roles and Responsibilities - L2

In depth Knoweldge on oracle database Architecture & concepts

Implementation, Upgrade & Administration

Replication & DR activities

Profile server resource usage optimize and tweak as necessary

Primary on day to day schema changes and database maintenance

Help developers to optimize queries, stored procedure and database design

Hands on experience in Root cause analysis for business impacting issues

Design, install, monitor, maintain and performance tune production, test/development, and QA database environments. Ensure high levels of data availability.

Responsible for developing, implementing and overseeing database policies and procedures to ensure the integrity and availability of all databases and their accompanying software.

Design and implement redundant systems, policies and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets and will remain current with the latest technologies and industry/business trends.

Develop, implement and maintain scripts for database backup and restore for all databases and test the procedures periodically.

Regularly monitor and tune databases for optimal performance, Troubleshoot, resolve, and communicate problems and failures with databases and related server applications.

Willing to work in 24x7 support environment

Ensure performance, security, and availability of databases

Prepare documentations and specifications

Proficiency in Database monitoring tool and Recovery tools

Handle common database procedures, such as upgrade, migration, backup, recovery etc.

Assists in developing and implementing best practices for DR and Backups

Collaborate with other team members and stakeholders

Primary on day to day schema changes and database maintenance

Please share the profile on Pratiksha.Waghole@lntinfotech.com .