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 :

- Bachelors degree (STEM preferred) and minimum of 5-8 years of relevant work experience as an Sr.

- Oracle DBA

- Strong understanding of cloud computing technologies; preferable hands-on experience in working with Azure

- Experience in handling customer escalations

- Experience in writing automation scripts, building application dashboards for proactive monitoring using PowerShell, Python, Bash scripting or similar technologies, ability to debug and optimize code and automate routine tasks.

- The right candidate should have knowledge of PowerShell, Ansible, Git Actions etc.

- Experience with DevOps methodologies and tools (Git, Jenkins, Docker, Kubernetes)

- Excellent problem-solving and analytical skills

- Strong communication and collaboration skills

- Ability to work independently and as part of a team.

- Strong attention to detail and ability to prioritize tasks effectively.

- Experience with monitoring and logging tools (OEM, Zabbix, Splunk, Solarwind).

- Solid understanding of cloud Infrastructure environments, specifically Linux and Windows based deployments.

- Excellent SQL skills and ability to write complex queries to pull and analyze data from multiple sources.

- Good understanding of different file formats such as YML, JSON, Parquet.

- Excellent organizational skills, able to take a systematic approach in resolving issues.

- Proven ability to work creatively and analytically in a problem-solving environment.

- This role involves rotational shifts, including night shifts, to provide 24/7 application support.

- Flexibility to work weekends and public holidays as per shift schedule.

- Ability to handle responsibilities independently during off-hours.

- Team player, fast learner, work in a fasted paced environment and share knowledge.