Oracle DBA

YOU Broadband India Ltd.; Surat; On-site; INR 600,000 - 900,000; Full time

Job summary

A leading broadband service provider in Gujarat is seeking an experienced Oracle DBA to administer large production database environments. The successful candidate will be responsible for database monitoring, security management, and performance tuning. Strong experience in Oracle 10g and 12c, along with good communication skills, is essential for this role.

Qualifications

• Hands on experience in Oracle 10g and 12c.
• Knowledge of Oracle Architecture and monitoring.
• Good knowledge of Linux operating systems.
• Understanding of Oracle administration and performance tuning.
• Experience in maintaining production environments and database patching.

Responsibilities

• Administer large production database environments.
• Ensure compliance with security standards and controls.
• Monitor database performance and capacity.
• Maintain best practices for backup and restore procedures.
• Provide technical recommendations based on problem analysis.

Skills

Oracle 10g

Oracle 12c

Linux

SQL

PL/SQL

RMAN

Data Guard

Shell scripting

MySQL

SQL Server

Job description

YOU Broadband is looking for experienced and professional Oracle DBA who is ready to work to administer large, production DB environment and troubleshoot and provide system level solutions. This includes Oracle databases for production, testing, and staging environments.

• Have good understanding of Oracle database and its architecture.
  
• Proactively manage and maintain security standards and controls including compliance related reporting and controls.
  
• Take ownership of performance and capacity monitoring aspects of the DB.
  
• Ensures that best practices are followed in all areas including RMAN backup/restore, EXPDP/IMPDP, tablespace management, Data Guard
  
• Deriving RCA for the problem tickets and providing technical recommendation.
  
• Have sound communication skills with management, development, teams, vendors, systems administrators and other related service providers.

Required Skills :

• L1 and L2 Hands on experience in Oracle 10g, 12c .
• Knowledge of Oracle Architecture and day to day monitoring.
• A good knowledge of the operating system(s) Linux is preferable.
• Understanding of the Oracle administration, performance tuning, SLA and availability.
• Experience in maintaining production environment, database patching , installation and up gradation.
• Determine, enforce and document database policies, procedures and standards.
• Performance testing and evaluation to ensure data security, privacy and integrity. Identification of bottle necks and deadlock issues.
• Experience with RMAN, Data Guard, ASH/AWR analysis,Table Partitioning.
• Command over SQL and PL/SQL.
• Knowledge of automation using shell scripts.
• Knowledge in other RDBMS like MySQL, SQL server etc.