Sr. Oracle DBA
Role details
Job location
Tech stack
Job description
-
Responsible for installation of Amazon Web Services (AWS) RDS, Oracle database, RAC, dataguard and Golden Gate on different platforms.
-
Responsible for the installation and maintenance of databases on the cloud environments.
-
Responsible for security and safety of the data and the database.
-
Responsible for patching and upgrades of the Database.
-
Responsible for DC/DR, Backup/Restore of the Database.
-
Responsible for health and uptime of database
-
Support the product team for application schema setup.
-
Support the application team for connecting with the database, load balancing and failover.
-
Support the development teams to troubleshoot and resolve the database related issues.
Requirements
Certified candidate with 7 years of experience to manage all aspects of Amazon RDS, Oracle Database administration, 1. Understanding on Amazon Web Services(AWS) RDS, Oracle Architecture and end to end administration.
-
Understanding of network concepts, storage systems, ASM disk groups.
-
Hands on experience in installation of Oracle Databases in Standalone, RAC, DataGuard and Golden Gate environments.
-
Hands on experience on the installation and maintenance of databases on the cloud environments.
-
Hands on experience in Database patching, Version Upgrade.
-
Familiar with various backup and recovery methods.
-
Experience with DC/DR configuration for high availability.
-
Experience with SQL tuning, configuration or Resource Manager.
-
Working knowledge in Unix environments such as AIX/Solaris/Linux/HP-UX and Unix shell scripts.
-
Hands on experience in analysing Oracle Trace files, Alert log, Listener log.
-
Good knowledge on document and run book preparation.
-
Good communication skill is necessary.
-
Willingness to travel to client sites if required.
-
Data Extraction, transformation, masking, subsetting and loading Additional skills - Nice to have
Working knowledge of other RDBMSs like PostgreSQL, MS/SQL, MySQL