Oracle DBA - SBI Securities

3 - 8 years

15 - 19 Lacs

Posted:1 week ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Role & responsibilities

  • Database Management:

    Lead, Manage, Migrate, Upgrade and optimize RDBMS oracle databases ensuring high availability, scalability, and performance.
  • Database Architecture & Design:

    Work with application development teams to design and implement database architectures, including schema design, indexing strategies, and partitioning.
  • Performance Tuning & Optimization:

    Proactively monitor and fine-tune database performance, identifying bottlenecks and applying optimizations to improve query execution times and system responsiveness.
  • Backup & Recovery:

    Develop/Design backup strategies and disaster recovery planning to ensure business continuity and data integrity.
  • Automation & Scripting:

    Develop and implement automation scripts for database maintenance, backups, and monitoring using shell script or tool.
  • Security & Compliance:

    Implement and enforce database security policies, including encryption, access control, and auditing, to meet compliance and regulatory standards.
  • Incident Management & Troubleshooting:

    Lead the response to production database issues, ensuring quick resolution and minimal downtime.
  • Collaboration:

    Work closely with engineering, DevOps, and other teams to ensure seamless integration between database systems and applications.
  • Research & Innovation:

    Stay up-to-date with the latest trends and technologies in RDBMS/ Oracle databases and recommend new tools or methodologies to improve system performance and capabilities.

Preferred candidate profile

  • Oracle Certified DB Professional (OCP) 3+ years of hands-on experience with Oracle databases in a Banking/financial mission critical production environment.
  • Should be able to work in 24*7 production database support environment.
  • Proactively monitor, manage and maintain to ensure DB availability for single as well as RAC database environment.
  • Managing tablespaces, user quota, rollback segments, user maintenance, database security imposition by user creation assignment of roles and privileges.
  • Hands on experience required on Database Upgradation/ Migration on Oracle 12c, 19c and single/RAC instance.
  • Should have sound experience in Oracle 12c, 19c with Installation, Configuration, Upgrades, Administration, Backup and Recovery, Disaster Recovery and Patching.
  • Experience should include capacity planning, performance tuning, space management, backup and recovery, managing schemas and DB clustering technologies.
  • Strong practical experience of ORACLE in a production RAC Installation, Administration, PSU Patching and ASM storage management.
  • Should have Operating system experience in Linux/Windows and UNIX Scripting.
  • Performed manual Drill Switchover and Switchback on multiple databases (Single Instance/RAC) as a part of DR-Drill activity.
  • Should be able to use Oracle management tools (Data Guard, RMAN, Data pump/ Export-import), experience in clone/refresh Schema, database from Production to Test and Development Environment.
  • Deep knowledge of database performance tuning, query optimization, and storage management.
  • Strong knowledge in analysing AWR/ TKPROF report for database performance issue and able to handle the severity-1 issues in production.
  • Experience with designing and implementing backup strategies and disaster recovery plans.
  • Should have worked on database security practices, including Encryption/Redaction/Oracle Vault, user access control, and compliance standards.
  • Strong analytical and troubleshooting skills in a high pressure environment.
  • Excellent communication skills and ability to work effectively across the teams.

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Sbicap Securities logo
Sbicap Securities

Investment Banking

Mumbai

RecommendedJobs for You

Bengaluru, Karnataka, India