Sonicwall

Senior Oracle DBA

Bengaluru, Karnataka, India. Posted a month ago

The role

The candidate will manage and optimize Oracle E-Business Suite 12.1.3 environments. This includes leading upgrades to 12.2 or migrations to Oracle Cloud Infrastructure.

What you will do

  • Administer and maintain Oracle EBS R12.1.3 environments including patching, cloning, backups, and upgrades
  • Lead and support the upgrade path to Oracle EBS 12.2 or migration to Oracle Cloud Infrastructure (OCI)
  • Support month-end, quarter-end, and year-end financial closure activities
  • Perform database cloning for development, testing, and troubleshooting
  • Troubleshoot and optimize SQL queries and PL/SQL code
  • Monitor and optimize database performance, availability, and scalability
  • Manage concurrent managers, workflow services, and EBS application components
  • Implement and maintain database security, backup/recovery strategies, and disaster recovery plans
  • Collaborate with application teams to support schema changes and deployments
  • Automate routine DBA tasks using shell scripting or other tools

Required qualifications

  • Bachelor’s degree in Computer Science, Information Technology, or related field
  • 8–10 years of experience as an Oracle DBA
  • At least 5 years supporting Oracle EBS R12
  • Strong knowledge of Oracle 12c/19c database architecture and administration
  • Experience with Oracle EBS modules such as Financials, SCM, and HRMS
  • Proficiency in RMAN, Data Guard, and Oracle Enterprise Manager (OEM)
  • Expertise in Unix/Linux environments and shell scripting
  • Familiarity with Oracle WebLogic Server and Oracle Applications Framework
  • Strong analytical and problem-solving skills
  • Excellent communication and documentation abilities

Nice to have

  • Experience with SharePlex for replication and high availability
  • Exposure to Hyperion for financial planning and analysis
  • Basic skills in OBIEE (Oracle Business Intelligence Enterprise Edition) for reporting and data analysis
  • Oracle Certified Professional (OCP) certification
  • Experience with Oracle RAC and ASM
  • Familiarity with cloud platforms (OCI, AWS, Azure) and migration strategies
  • Knowledge of SOA Suite or other Oracle middleware technologies

About the company

SonicWall has delivered a partner-first unified cybersecurity portfolio for more than 30 years. The company helps organizations simplify security operations and achieve better security outcomes.

Senior Oracle DBA at Sonicwall | JobZoey