Manage and optimize Oracle databases, perform backups and recovery, tune performance, handle Data Guard and RAC configurations, support GoldenGate setups and troubleshooting, coordinate with sysDBA and product teams, and raise/follow Oracle support requests.
Job Title: Oracle DBA
Location: Bangalore
Job Summary:
We are looking for an experienced Application DBA to be a key member of our App DBA team. The ideal candidate will have a strong foundation in Core Oracle DBA, a solid understanding of Data Guard, proficiency in RAC, and at least average knowledge of GoldenGate. The successful candidate will be responsible for maintaining and optimizing our Oracle databases, troubleshooting issues, coordinating with Sys DBA teams, and collaborating with the Product Development team.
Key Responsibilities:
Core Oracle DBA:
- Create and manage user roles.
- Perform data refreshes from higher environments.
- Optimize database performance through tuning.
- Manage backup and recovery operations.
- Troubleshoot and resolve Oracle database issues.
- Raise Service Requests (SR) with Oracle and follow up until resolution.
Data Guard:
- Implement and manage Oracle Data Guard configurations.
- Ensure high availability and disaster recovery for Oracle databases.
RAC (Real Application Clusters):
- Troubleshoot server and database issues (excluding shutdown and startup).
- Provide support and resolution for RAC-related issues.
Coordination and Communication
- Act as the primary point of contact (POC) for the Business Unit and collaborate with the Sys DBA team for change management and coordinate weekend activities.
- Work with assigned applications to manage data in the supporting databases.
- Liaise with the Product Development team to address and fulfill database-related requests.
GoldenGate:
- Add new tables to GoldenGate configurations (uni-directional and bi-directional).
- Troubleshoot and restart GoldenGate processes, including log and pump issues.
- Identify and resolve lag issues within the GoldenGate environment.
Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
Skills:
- Strong knowledge of Core Oracle DBA fundamentals, including user roles, data refreshes, performance tuning, and backup/recovery.
- Proficiency in managing and troubleshooting Oracle Data Guard and RAC environments.
- Experience with GoldenGate configuration and troubleshooting.
- Ability to effectively coordinate with multiple teams and communicate complex technical issues clearly.
- Experience with raising and managing Service Requests with Oracle Support.
Photon Chennai, Tamil Nadu, IND Office
DLF IT Park 1/124 Mount Poonamallee Road Sivaji Gardens Manapakkam , Chennai, India, 600089
Similar Jobs
Cloud • Information Technology • Security • Software
The Staff Quality Engineer will lead quality initiatives, engage in SDLC processes, architect testing strategies, and mentor teams in quality standards and automation.
Top Skills:
AWSCypressGherkinPytestPython
Cloud • Information Technology • Security • Software • Cybersecurity
Design and produce high-fidelity creative assets across print, digital, web, social, video, and events. Prepare production-ready artwork, perform photo retouching, build and maintain graphic files, and collaborate with creative, production, and stakeholder teams to ensure brand-aligned, high-quality deliverables.
Top Skills:
Adobe Creative SuiteAdobe IllustratorAdobe IndesignAdobe PhotoshopFigmaGoogle SlidesMS OfficeMicrosoft Powerpoint
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Senior SAS developer responsible for designing, developing, and optimizing SAS programs and ETL workflows. Work includes Base SAS, macros, PROC SQL, SAS DI Studio and EG, scheduling (LSF), Unix/shell scripting, performance tuning of SAS servers, and transforming banking data for enterprise data warehouses. Collaborate with clients, QA, DBAs and support teams.
Top Skills:
Base SasETLHadoopLsf Platform SuiteProc SqlSASSas Data Integration StudioSas EgSas MacroSas ServersShell ScriptingSQLUnix
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
