Oracle DBA

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 Location : Mumbai (Near to Lower-parel Station/ Curry Road Station )