Oracle DBA - SBI Securities
- Sbicap Securities
- 5 - 10 years
- Mumbai
- 4 months ago
- Email to a friend
- Report this job
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 & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: Sbicap SecuritiesLocation(s): Mumbai+ View Contact
Keyskills: Oracle Database Upgradation Installation PSU Patching Configuration Database Backup Oracle 12c Database Migration Patching Devops Recovery Management Oracle 19c RAC Installation Oracle RAC
Fraud Alert to job seekers!
₹ 15-19 Lacs P.A
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in