Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Oracle DBA - SBI Securities @ Sbicap Securities

Home > DBA / Data warehousing

 Oracle DBA - SBI Securities

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.

Job Classification

Industry: Financial Services (Broking)
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Administrator
Employement Type: Full time

Contact Details:

Company: Sbicap Securities
Location(s): Mumbai

+ View Contactajax loader


Keyskills:   Oracle Database Upgradation Installation PSU Patching Configuration Database Backup Oracle 12c Database Migration Patching Devops Recovery Management Oracle 19c RAC Installation Oracle RAC

 Job seems aged, it may have been expired!
 Fraud Alert to job seekers!

₹ 15-19 Lacs P.A

Similar positions

Application Database Administrator-NoSQL Cloud Databases

  • IBM
  • 3 - 7 years
  • Mumbai
  • 22 hours ago
₹ Not Disclosed

Technical Specialist-BI

  • Birlasoft
  • 6 - 8 years
  • Bengaluru
  • 2 days ago
₹ Not Disclosed

Oracle Integration Cloud - Senior Technical Consultant

  • Fujitsu
  • 7 - 12 years
  • Noida, Gurugram
  • 3 days ago
₹ Not Disclosed

Lead Admin-sap Basis

  • Birlasoft
  • 2 - 4 years
  • Pune
  • 3 days ago
₹ Not Disclosed

Sbicap Securities

SBIcap securities Ltd