Database Administrator at A listed organisation in Telecom & Broadband · Mumbai · 3 - 9 years · ₹12L - ₹15L / yr · Posted 4 Jan 2023
Database Administrator
at A listed organisation in Telecom & Broadband
- Design, develop, implement and maintain our core Oracle applications.
- Maintain our SQL / PLSQL processes.
- Ensure DB availability.
- Proactively manage and maintain security standards and controls by creating storage database structures with high-level security features.
- Actively seek to optimise and simplify our architecture.
- Take ownership of performance and capacity monitoring aspects of the DB.
- Execution of data migration jobs and scripts as required.
- Assist the infrastructure team in sizing hardware used for the DB.
- Support and collaborate with product developers.
- Contribute to the creation and maintenance of disaster recovery plans.
- Work closely with the application vendors, co-ordinate and manage the DBA activities.
- Own and follow up with Vendors/Stakeholders & their DBAs when required.
- Create a reliable backup strategy. Ensure database backups are appropriately
- executed and periodic restorations are exercised to ensure backup quality.
- Determine and document DB policies, procedures and standards.
- Performance testing and evaluation to ensure data security, privacy and integrity.
- Identification of bottle necks and deadlock issues.
- Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
- Install upgrades and security patches.
- Alter storage structures to meet the evolving needs of the company.
- Set up database user accounts.
- Train users on how to access the information in the database.
- Find and debug malfunctioning programs affecting the database integrity.
- Create autonomous database backups.
- Regularly update the database security protocols.
Desired Skills:
- Ideally Oracle Certified DB Professional (OCP) with more than 5 years’ experience with Oracle, preferably in a lead role.
- Technical degree preferable (B.E. / B. Tech).
- Must experience with an organisation that has 24x7 reliability on its database.
- Must have experience with Oracle Exadata.
- Must Operating system experience in Linux.
- Must hands on knowledge of Shell scripting on Linux Platform
- Must hands on knowledge of Oracle management tools (Data Guard, RMAN).
- Must hands on knowledge of SQL / PLSQL.
- Experience should include DB design (modelling and normalisation), capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies.
- Knowledge of Partitioning.
- Knowledge of architecture design principles.
- Good problem solver, focused and dedicated developer with ability to work on
- your own as well as with a team.
- Hands on experience with DB standards and end user applications-translating
- capacity requirements into infrastructure deployment technology.
- Strong practical experience of ORACLE in a production environment (Ver 19c).
- Must be a self-starter with a strong attention to detail.
Shubham Vishwakarma
Full Stack Developer - Averlon
Similar jobs (2)
Job Description — L2/L3 Oracle DBA and Oracle Apps DBA
Experience: 5–10 years of relevant experience
Support coverage: Dubai customer business hours and on-call support as required
Role Overview
We are seeking an experienced Oracle DBA and Oracle Apps DBA to support
customer Oracle Database and Oracle E-Business Suite (EBS) environments. The role
involves L2 incident resolution, L3 troubleshooting, performance tuning, patching,
upgrades, and maintaining database and application availability.
Key Responsibilities
Oracle Database Administration
∙Install, configure, administer, and maintain Oracle databases across
production and non-production environments.
∙Monitor database health, availability, performance, storage, and capacity.
∙Troubleshoot database incidents, connectivity failures, locking, blocking, and
resource issues.
∙Analyse AWR and ASH reports, SQL execution plans, and database wait
events to resolve performance problems.
∙Configure and manage RMAN backups; perform recovery and restore
validation.
∙Administer Oracle RAC, ASM, Grid Infrastructure, and Data Guard
environments.
∙Perform database patching, upgrades, migrations, and refreshes through
approved change procedures.
∙Manage database users, roles, privileges, auditing, and security controls.
∙Execute disaster recovery drills, Data Guard switchovers, and failovers.
∙Automate routine administration and monitoring using shell scripts and SQL.
Oracle Applications DBA
∙Administer Oracle E-Business Suite R12.2 application and database tiers.
∙Monitor and troubleshoot concurrent managers, concurrent requests,
Workflow Mailer, application services, and login issues.
∙Perform EBS online patching using ADOP and manage the associated
patching lifecycle.
∙Clone and refresh EBS environments using supported tools, including Rapid
Clone.
∙Maintain application configuration using AutoConfig and context files.
∙Administer EBS-related WebLogic Server, Oracle HTTP Server, and Forms
services.
∙Troubleshoot application-tier performance and coordinate with functional
and development teams.
∙Support EBS upgrades, technology-stack patches, certificate renewals, and
integration-related incidents.
∙Maintain operational procedures for application startup, shutdown, backup,
recovery, and maintenance.
L2/L3 Support and Customer Operations
∙Own incidents and service requests within agreed SLAs.
∙Provide L2 troubleshooting and escalate complex issues with complete
diagnostic evidence.
∙Lead L3 investigation, root-cause analysis, and permanent corrective actions.
∙Support major incidents, communicate progress, and document recovery
actions.
∙Raise and manage Oracle Support service requests.
∙Prepare change plans, risk assessments, validation steps, and rollback
procedures.
∙Maintain runbooks, knowledge articles, configuration records, and shift
handovers.
∙Coordinate with customer teams and internal infrastructure, storage,
network, and application teams.
∙Mentor junior DBAs and identify opportunities to reduce recurring incidents.
Required Skills and Experience
∙Hands-on production experience administering Oracle Database, including
Oracle 10g, 11g, 12c, 18c and 19c.
∙Strong experience supporting Oracle EBS R12.2 as an Apps DBA.
∙Practical knowledge of RAC, ASM, Data Guard, RMAN, Data Pump, and
The recruiter has not been active on this job recently. You may apply but please expect a delayed response.
Role: Oracle DBA – GoldenGate & Database Migration
Location: Bangalore / Hyderabad
Experience: 8–15 years
Key Responsibilities:
- Manage Oracle databases in production and non-production environments.
- Strong hands-on experience with Oracle GoldenGate for replication, CDC, and data synchronization.
- Lead/support database migration, upgrade, and transformation projects.
- Perform database performance tuning, backup/recovery, troubleshooting, and high availability activities.
- Work on migration planning, execution, validation, and post-migration support.
- Collaborate with application, infrastructure, and cloud teams for end-to-end migration activities.
Must-Have Skills:
- 8–15 years of strong Oracle DBA experience.
- Hands-on expertise in Oracle GoldenGate.
- Proven experience in DB migration projects.
- Strong knowledge of Oracle RAC, Data Guard, RMAN, performance tuning, and troubleshooting.
- Good understanding of Unix/Linux and SQL/PLSQL.
- Excellent communication and stakeholder-management skills.
Location: Bangalore / Hyderabad
CTC: Up to ₹24 LPA
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon