Senior Oracle Database Administrator

Tech Mahindra; Mumbai City; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading company in IT Services is seeking a Mid-Senior level Database Administrator to manage user-related queries, optimize database performance, and conduct training. The role involves proactive interaction with infrastructure teams and adherence to organizational policies.

Qualifications

• Experience in user management and database configuration.
• Proficient in SQL tuning and performance enhancement.

Responsibilities

• Resolving user-related queries and managing database users.
• Monitoring performance and conducting training for users.

Skills

User Management

Database Performance Monitoring

SQL Tuning

Tools

OEM 12C

RMAN

Job description

Resolving user-related queries in production and test databases.

Creating new users and assigning profiles in production databases as per client requests.

User management and maintenance of all database users, including granting privileges according to client policies.

Performing logical backups using Export-Import and Data Pump utilities upon user requests.

Applying database bug patches as required. Creating SQL tuning sets and advisory reports using OEM 12C to improve database performance. Executing weekly database analysis for performance enhancement.

Conducting monthly purging activities to free up space and archival activities to improve performance.

Monitoring performance, installing and configuring databases, scheduling RMAN backups, and monitoring RMAN status for all production databases.

Proactively interfacing with other infrastructure support teams such as UNIX, Windows, Network, Storage, and Monitoring.

Documenting issues and resolutions, preparing progress reports for customers.

Conducting training for users, customers, and team members. Guiding and mentoring team members on technical problems beyond their level.

Ensuring adherence to organizational policies, processes, and practices.

Actively participating in organizational and unit-level initiatives.

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Administrative

Industries

IT Services and IT Consulting