Oracle Database Specialist

Job Title: Oracle Database Specialist<\/span><\/span><\/span> <\/span>
<\/span><\/span>Experience:<\/span><\/span><\/span> <\/span><\/span>10+ Years<\/span><\/span><\/span> <\/span><\/span>
<\/span><\/span>Location:<\/span><\/span><\/span> <\/span><\/span>Mumbai (Onsite)<\/span><\/span><\/span> <\/span><\/span>
<\/span><\/span>Notice Period:<\/span><\/span><\/span> <\/span><\/span>Immediate Joiners Only<\/span><\/span><\/span> <\/span><\/span>
<\/span><\/span><\/div><\/div>

Job Summary<\/span><\/span><\/span> <\/span><\/span>
<\/span><\/p>

We are seeking an experienced Oracle Database Specialist with 10+ years of hands\-on<\/span> <\/span><\/span>expertise<\/span> <\/span><\/span>in managing,<\/span> <\/span><\/span>optimizing, and supporting enterprise\-scale Oracle database environments. The ideal candidate will<\/span> <\/span><\/span>possess<\/span> <\/span><\/span>strong database administration, performance tuning, backup and recovery, and troubleshooting skills, ensuring high availability, security, and reliability of critical business applications.<\/span><\/span><\/span> <\/span><\/span>
<\/span><\/p><\/div>

Key Responsibilities<\/span><\/span><\/span> <\/span><\/span>
<\/span><\/p><\/div>

  • Manage,<\/span> <\/span><\/span>monitor, and<\/span> <\/span><\/span>maintain<\/span> <\/span><\/span>Oracle databases across production, testing, and development environments.<\/span><\/span><\/span> <\/span><\/span>
    <\/span><\/span><\/li><\/ul><\/div>
    • Diagnose and resolve database performance issues, bottlenecks, and system failures.<\/span><\/span><\/span> <\/span><\/span>
      <\/span><\/span><\/li><\/ul><\/div>
      • Perform database tuning, optimization, and SQL query performance improvements.<\/span><\/span><\/span> <\/span><\/span>
        <\/span><\/span><\/li><\/ul><\/div>
        • Execute database upgrades, patching, migrations, backup, and recovery activities.<\/span><\/span><\/span> <\/span><\/span>
          <\/span><\/span><\/li><\/ul><\/div>
          • Develop and<\/span> <\/span><\/span>maintain<\/span> <\/span><\/span>database objects including stored procedures, packages, functions, and triggers.<\/span><\/span><\/span> <\/span><\/span>
            <\/span><\/span><\/li><\/ul><\/div>
            • Support application teams with database\-related enhancements, troubleshooting, and deployments.<\/span><\/span><\/span> <\/span><\/span>
              <\/span><\/span><\/li><\/ul><\/div>
              • Ensure database security, user access management, and compliance with organizational standards.<\/span><\/span><\/span> <\/span><\/span>
                <\/span><\/span><\/li><\/ul><\/div>
                • Implement and<\/span> <\/span><\/span>maintain<\/span> <\/span><\/span>backup and disaster recovery strategies using RMAN and Data Guard.<\/span><\/span><\/span> <\/span><\/span>
                  <\/span><\/span><\/li><\/ul><\/div>
                  • Conduct capacity planning and scalability assessments to support business growth.<\/span><\/span><\/span> <\/span><\/span>
                    <\/span><\/span><\/li><\/ul><\/div>
                    • Perform incident management, root cause analysis (RCA), and preventive maintenance.<\/span><\/span><\/span> <\/span><\/span>
                      <\/span><\/span><\/li><\/ul><\/div>
                      • Collaborate with infrastructure, development, and application support teams for seamless integrations and releases.<\/span><\/span><\/span> <\/span><\/span>
                        <\/span><\/span><\/li><\/ul><\/div>
                        • Maintain database documentation, operational procedures, and best practices.<\/span><\/span><\/span> <\/span><\/span>
                          <\/span><\/span><\/li><\/ul><\/div>

                          Required Skills &<\/span> <\/span><\/span>Expertise<\/span><\/span><\/span> <\/span><\/span>
                          <\/span><\/p><\/div>

                          • Strong<\/span> <\/span><\/span>expertise<\/span> <\/span><\/span>in Oracle Database Administration (10g/11g/12c/19c and above).<\/span><\/span><\/span> <\/span><\/span>
                            <\/span><\/span><\/li><\/ul><\/div>
                            • Extensive experience in SQL and PL/SQL development.<\/span><\/span><\/span> <\/span><\/span>
                              <\/span><\/span><\/li><\/ul><\/div>
                              • Proven experience in database performance tuning and query optimization.<\/span><\/span><\/span> <\/span><\/span>
                                <\/span><\/span><\/li><\/ul><\/div>
                                • Hands\-on<\/span> <\/span><\/span>expertise<\/span> <\/span><\/span>with RMAN backup and recovery, Data Guard, and replication technologies.<\/span><\/span><\/span> <\/span><\/span>
                                  <\/span><\/span><\/li><\/ul><\/div>
                                  • Strong understanding of database security, user management, and access controls.<\/span><\/span><\/span> <\/span><\/span>
                                    <\/span><\/span><\/li><\/ul><\/div>
                                    • Experience troubleshooting and resolving critical database issues in high\-volume production environments.<\/span><\/span><\/span> <\/span><\/span>
                                      <\/span><\/span><\/li><\/ul><\/div>
                                      • Good knowledge of Unix/Linux operating systems and database administration utilities.<\/span><\/span><\/span> <\/span><\/span>
                                        <\/span><\/span><\/li><\/ul><\/div>
                                        • Experience managing large\-scale enterprise database environments.<\/span><\/span><\/span> <\/span><\/span>
                                          <\/span><\/span><\/li><\/ul><\/div>
                                          • Strong analytical, problem\-solving, and communication skills.<\/span><\/span><\/span> <\/span><\/span>
                                            <\/span><\/span><\/li><\/ul><\/div>

                                            Preferred Skills<\/span><\/span><\/span> <\/span><\/span>
                                            <\/span><\/p><\/div>

                                            • Experience with Oracle RAC, ASM, and high\-availability architectures.<\/span><\/span><\/span> <\/span><\/span>
                                              <\/span><\/span><\/li><\/ul><\/div>
                                              • Exposure to<\/span><\/span> <\/span><\/span>cloud\-based database platforms such as AWS RDS, Oracle Cloud Infrastructure (OCI), or Microsoft Azure.<\/span><\/span><\/span> <\/span><\/span>
                                                <\/span><\/span><\/li><\/ul><\/div>
                                                • Knowledge of scripting languages such as Shell Scripting or Python for automation.<\/span><\/span><\/span> <\/span><\/span>
                                                  <\/span><\/span><\/li><\/ul><\/div>
                                                  • Familiarity with DevOps practices and CI/CD environments.<\/span><\/span><\/span> <\/span><\/span>
                                                    <\/span><\/span><\/li><\/ul><\/div>
                                                    • Experience working in Agile/Scrum project delivery models.<\/span><\/span><\/span> <\/span><\/span>
                                                      <\/span><\/span><\/li><\/ul><\/div>

                                                      Desired Candidate Profile<\/span><\/span><\/span> <\/span><\/span>
                                                      <\/span><\/p><\/div>

                                                      • Ability to work independently in a fast\-paced production environment.<\/span><\/span><\/span> <\/span><\/span>
                                                        <\/span><\/span><\/li><\/ul><\/div>
                                                        • Strong troubleshooting and incident management capabilities.<\/span><\/span><\/span> <\/span><\/span>
                                                          <\/span><\/span><\/li><\/ul><\/div>
                                                          • Excellent stakeholder management and cross\-functional collaboration skills.<\/span><\/span><\/span> <\/span><\/span>
                                                            <\/span><\/span><\/li><\/ul><\/div>
                                                            • Immediate availability or ability to join at short notice is highly preferred.<\/span><\/span><\/span> <\/span><\/span>
                                                              <\/span><\/span><\/li><\/ul><\/div>

                                                              <\/span><\/span>
                                                              <\/span><\/p><\/div>


                                                              <\/div><\/span>