Job Summary
We are seeking an experienced Infra. Technology Specialist with 5 to 8 years of experience to join our team. The ideal candidate will have expertise in NoSQL/MongoDB Admin MySQL and Oracle. This hybrid role offers the opportunity to work both remotely and on-site during day shifts. The candidate will play a crucial role in managing and optimizing our database infrastructure.
Responsibilities
Mandatory Technical Requirements
Monitoring database which include basic health checks growth of objects performance of the database and giving recommendations.
Installation and configurations of Oracle Database servers 19c onwards
Regular monitoring & Trouble shooting of all DB environments (RAC data guard & single instance).
Logical Backup of Databases using Datapump
Cloning the Oracle database for test & development environment setups
Patching the Database home and Grid home with the latest PSU patches
Troubleshooting root cause analysis and resolution of any database errors and issues
Database refresh using RMAN duplicate and in 19C/21C backup based duplication method
Backup and restore using RMAN utility
Monitoring the Database health in Oracle 12c grid control Oracle Enterprise Manager OEM.
Configuring and Managing the OEM 12 c OEM
Configure and Manage of Data guard/HA
Checking the Archive log shipping between the Primary and the standby (DR) databases and troubleshooting it by rebuilding the Standby databases.
Checking the partitions of Oracle Data files and Archive log according to our policy.
Database/ASM/Tablespace capacity management
Scheduling and configuring backup jobs using OEM and Cron
Conducting DR drills and performing switch over and switch back operations.
SQL and Database Tuning
Managing and Configuring Multitenant Architecture/Databases
Managing Database Vaults TDE Data protection Redaction Masking and Security aspects of Data and Database
User/Privilege Management.
Certifications Required
Certified MongoDB Administrator Oracle Certified Professional MySQL Database Administrator