(MY) Database Administrator IF0000

Key Responsibilities
Providing Physical Database Administration consists of:

• Plan and install existing database management software.
• Upgrade allowable patches for existing database management software.
• Create physical database shell.
• Plan and allocate database file - level storage at the operating system level.
• Create physical database storage structures (e.g., table spaces for Oracle, MSSQL, and My SQL).
• Maintain database security roles/views.
• Manage application interface IDs within the database management system.
• Solely manage DBMS system admin IDs/roles/privileges.
• Provide maintenance scripts for physical database aspects.
• Monitor and optimize DBMS performance and capacity.
• Plan and implement performance and capacity improvements.
• Perform database verification and consistency checks.
• Assist in setting up backup and recovery procedures and schedules.
• Define log archiving strategy and assist in its setup.
• Execute database recovery procedures in case of hardware failure.

Providing Database Administration consists of:

• Investigate and fix database management system problems.
• Execute and monitor batch job scripts, including data loads and archiving.
• Perform database synchronizations/replication configuration and setup.
• Provide performance monitoring and analytical tools.
• Optimize and tune performance.

Providing Logical Database Administration consists of:

• Size and plan databases.
• Provide scripts to create tables/indexes/triggers/functions/views.
• Create tables and indexes.
• Normalize tables. 

Requirement

• Bachelor Degree in Computer Science
• Well verse skills in Oracle, SQL Server 2016 and above, MSSQL 2016 and above