Senior Oracle Administrator - PostgreMS SQL, MYMS SQL

Job Summary

Adhering to SLAs Reporting to the Track Lead / Team Lead Helping team members in case of Issues/Technical Problems Handling tickets / requests Troubleshooting technical issues Ensuring that the processes are adhered to Responsible for successful completion of Installation, configuration and migration Ensure maximum uptime according to the SLA Responsible for building / maintaining a test environment Improves and maintains customer and employee satisfaction Implementing new technologies and design changes Implementing Backup/Restoration Strategy for 24x7 operation support Applying patches/upgrades to maintain security level Monitoring and maintaining SLA requirements by the team members Backup/Restoration Strategy for 24x7 operation support Installation of Oracle Software/Database Pre-requisites Oracle Database Basic Administration and Latest Features. Maintain instance parameters and system settings Migrating databases using various tools such Import/Export , Data pump, Backup Restore Applying and Testing security patches to the databases. Managing User Accounts. Experience in cloning using cold backup, hot-backup and RMAN backup. Capacity Planning in terms of Growth of Database. Automated File and Storage Management. Good knowledge of 19c and latest oracle AI version features along with Data Pump, ASM and Flash back recovery. Experience in basic Performance Tuning and Monitoring using AWR,ADDM and ASH Working Knowledge high availability solutions like DataGuard, RAC basic to medium level administration of such environments Database Resource Management and Task Scheduling. Scheduling Database Backups, taking Logical Backups & Physical Backups. Implementing Database Security Policy. Adhering to SLAs Reporting to the Track Lead / Team Lead Helping team members in case of Issues/Technical Problems Handling tickets / requests Troubleshooting technical issues Ensuring that the processes are adhered to Responsible for successful completion of Installation, configuration and migration Ensure maximum uptime according to the SLA Responsible for building / maintaining a test environment Improves and maintains customer and employee satisfaction Implementing new technologies and design changes Implementing Backup/Restoration Strategy for 24x7 operation support Applying patches/upgrades to maintain security level Monitoring and maintaining SLA requirements by the team members Backup/Restoration Strategy for 24x7 operation support Installation of Oracle Software/Database Pre-requisites Oracle Database Basic Administration and Latest Features. Maintain instance parameters and system settings Migrating databases using various tools such Import/Export , Data pump, Backup Restore Applying and Testing security patches to the databases. Managing User Accounts. Experience in cloning using cold backup, hot-backup and RMAN backup. Capacity Planning in terms of Growth of Database. Automated File and Storage Management. Good knowledge of 19c and latest oracle AI version features along with Data Pump, ASM and Flash back recovery. Experience in basic Performance Tuning and Monitoring using AWR,ADDM and ASH Working Knowledge high availability solutions like DataGuard, RAC basic to medium level administration of such environments Database Resource Management and Task Scheduling. Scheduling Database Backups, taking Logical Backups & Physical Backups. Implementing Database Security Policy. 

Key Responsibilities

Skill Requirements

Other Requirements