Oracle DB Admin

Oracle DB Admin

Oracle DB Admin

Location: Delhi

Experience: 8 years to 10years

Interview Mode: Online Drive

Interview Date: 26th June 2025 (Thursday)

Interview Time: 3: 00 PM to 5: 00 PM

Must Have:

• Oracle installation and Configuration on Linux/Windows OS platform, configuring HA, DR databases, Database upgrades and applying PSU packs, Hands on experience in writing/troubleshooting shell scripts/Perl/python

Good to Have:

• Knowledge of Cloud computing technologies, Real Application Cluster

Roles & Responsibilities:

• Strong working knowledge of Oracle 12C, 18C and 19C. Knowledge of 21C will be added advantage.
• Perform day-to-day administration of Oracle databases, including backup/recovery, Capacity planning and performance tuning.
• Very good knowledge about Oracle Architecture, RAC, High Availability and DR solution and OEM
• Configuring High Availability and DR solution with DGMGRL
• Upgrading oracle databases to latest versions
• Applying latest Fix-Packs as per requirements
• Monitor database performance and recommend improvements for operational efficiency
• Database performance tuning by configuring database parameters.
• Monitor the Oracle Alert logs files, transaction logs, archive logs and backup log
• Day to day activities like TS, backup, cronjob, OEM alert
• Experience with Data-Guard, Cloning, RMAN backups, Golden Gate and point in time recovery, ASM
• Monitor system's health and performance
• Perform Database maintenance like, Reindexing, Update Statistics and review and optimize query tuning.
• Perform scheduled maintenance and support release deployment activities after hours
• Review Hardware and configuration and suggest the improvement areas.
• Hands on setting up DR environment and experience in DR testing.
• Manage database security and make sure it’s complied policies, regular audit of security processes
• Familiarity with monitoring tools like Confio, Solarwind and splunk etc.
• Good knowledge in Linux operating system and hands on experience in writing shell scripts/Perl/python, with this scripting knowledge, should explore automating the repetitive tasks
• Refine and automate regular processes, track issues and document changes
• Independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution
• Capacity planning, space management and data maintenance activities for database system. Perform database enhancement and modification as per the requirements.
• Global On-call Support including weekend
• Regular Connect with Client
• Operational Shift support as per Roster
• Willing to learn and work on other Opensource/ DB technologies like DB2, PostgreSQL, MySQL
• Knowledge of ITSM process and ticketing tool like ServiceNow /REMEDY etc.

15 years of Full time Education