Sonicwall
Senior Oracle DBA
Pune, Maharashtra, 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 purposes.
- 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.