Blue Yonder - Senior Oracle Database Administrator - Cloud & Automation

Description : What Youll Do :

• Install, patch, and maintain all Oracle software.
• Tune all Oracle instance components including SQL and PL / SQL
• Review and approve all production schema changes.
• Design and implement a backup & recovery system.
• Automate repetitive tasks by writing shell scripts / leveraging existing automation frameworks.
• Ensure DB availability.
• Proactively manage and maintain security standards and controls.
• Owning and resolving problems and managing customer expectations
• Actively seek to learn, optimize, and investigate all issues related to database.
• Help in the creation and maintenance of disaster recovery plans.
• Help create a reliable backup strategy.
• Assist the infrastructure and Application team in sizing hardware used for the databases.
• Ensure database backups are appropriately executed and periodic restorations are exercised to ensure backup quality.
• Support and collaborate with support analyst, product developer and professional services.
• Proactively Identification of bottle necks and blocking and deadlock issues
• Ensure SLA's & operational KPIs are met, working as necessary with internal and external support functions when major incidents occur.
• Troubleshoot and resolve, in conjunction with Operational / Customer DBAs, database application issues across production, test and development environments.
• Broad experience in the art of performance tuning, utilizing OEM or third-party tools to finely tune objects and partitions in Oracle 19c, and applications.
• Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing shell scripting or other scripting tools.
• Mentor fellow DBAs

What We Are Looking For :

(ref : hirist.tech)