Oracle Database Administrator

3 days ago

Shimoga, Karnataka, India Mastech Digital Full time

Position: Oracle Database Administrator

Location: Remote

Duration: Full Time and Full Time Contractors

Notice Period: Only Immediate Joiners/ Currently Serving Notice/ Notice is less than 30 days

Budget: 10-16 LPA for Full Time and 15-25 LPA for Contract (For Contract- No PF, No Gratuity, No leaves, No benefits)

Year of experience: 6-12 years

Key Responsibilities


• Performance Optimization & Tuning

o Analyze and resolve database bottlenecks affecting application/API performance.

o Tune SQL queries, PL/SQL packages, stored procedures, and indexes for optimal response times.

o Implement best practices for connection pooling, partitioning, and caching strategies.


• Application & Middleware Integration Support

o Work with API Gateway and custom orchestration teams to optimize database interaction patterns.

o Support GET/POST transaction flows from APIs into Oracle.

o Ensure efficient database design for web applications with high concurrency and SLA targets.


• On-Premise & Cloud Integration

o Manage data synchronization between on-prem Oracle and Fusion Cloud Oracle DB via OIC (Oracle Integration Cloud).

o Implement and support Pub/Sub mechanisms for customer data exchange.

o Monitor and troubleshoot replication/data transfer issues.


• Operational Excellence

o Proactively monitor system health, query execution plans, and workload statistics (AWR, ASH, ADDM).

o Provide root cause analysis and resolution for performance incidents.

o Partner with infrastructure DBAs for patching, backups, disaster recovery, and capacity planning.

o Develop and maintain documentation, standards, and runbooks for application database operations.

________________________________________

Qualifications & Skills


• 6–8 years of hands-on experience as an Oracle DBA, with emphasis on Application DBA responsibilities.


• Strong expertise in:

o Oracle 12c/19c performance tuning, indexing, partitioning, optimizer hints.

o SQL and PL/SQL development and debugging.

o AWR, ASH, ADDM, TKPROF, and other Oracle diagnostic/tuning tools.


• Experience supporting web applications, API-driven architectures, or middleware platforms.


• Familiarity with Oracle Integration Cloud (OIC) and Fusion Cloud database integration (Pub/Sub methodology preferred).


• Knowledge of high availability, scalability, and SLA management for mission-critical applications.


• Solid understanding of database security, auditing, and user access controls.


• Strong analytical skills and ability to work in cross-functional agile teams.


• Excellent communication skills to interact with application developers, architects, and operations teams.

________________________________________

Preferred/Bonus Skills


• Exposure to Oracle GoldenGate or other replication tools.


• Experience with API Gateway products (Apigee, Kong, Oracle API Gateway, etc.).


• Knowledge of containerization (Docker, Kubernetes) and DevOps pipelines for DB changes.


• Familiarity with monitoring tools (Oracle Enterprise Manager, Grafana, Prometheus).

  • Oracle Database Administrator

    3 hours ago

    Shimoga, Karnataka, India beBeeDatabase Full time ₹ 15,00,000 - ₹ 25,00,000

    As an Oracle database administrator, you will be responsible for the installation, configuration, and upgrade of Oracle server software and related products. You will also be tasked with monitoring application-related products, such as OACore, OAFM, Apache, and others. Additionally, you will establish and maintain backup and recovery policies and...

  • Senior Oracle Database Administrator

    7 days ago

    Shimoga, Karnataka, India beBeeDatabase Full time US$ 1,80,000 - US$ 2,50,000

    About this roleLemongrass is a global leader in SAP consulting, focused on helping organizations transform their business processes through innovative solutions and technologies.Our team is what makes us exceptional. At Lemongrass, you will work with the smartest and most motivated people in the business. We take pride in our culture of innovation and...

  • Senior Oracle Database Specialist

    4 days ago

    Shimoga, Karnataka, India beBeeDatabase Full time ₹ 1,27,52,000 - ₹ 2,01,60,000

    Database Systems EngineerThe successful candidate will be responsible for the design, implementation, and maintenance of Oracle RDBMS systems, including Exadata and Oracle Cloud Infrastructure (OCI).This is a hands-on role requiring technical expertise, cloud migration experience, and strong communication skills.Engage with assigned clients to deliver...

  • Senior Oracle Database Migration Expert

    5 days ago

    Shimoga, Karnataka, India beBeeDatabase Full time ₹ 1,50,00,000 - ₹ 2,50,00,000

    Lead Database Migration SpecialistAbout the RoleWe are seeking a seasoned Oracle Database specialist to lead our database migration initiatives. As an Oracle DB Migration Lead, you will be responsible for ensuring seamless migrations across various platforms.Key ResponsibilitiesMigrate and modernize large-scale Oracle databases with zero/near-zero downtime,...

  • Oracle Database Specialist

    3 hours ago

    Shimoga, Karnataka, India beBeeDatabase Full time ₹ 7,50,000 - ₹ 10,00,000

    Database Engineer JobWe are seeking a skilled Database Engineer to join our team. As a Database Engineer, you will be responsible for performing standardized operations, health checks, and troubleshooting for Oracle databases on Exadata platforms with GoldenGate replication.The successful candidate will have hands-on experience with Oracle DBA tasks, schema...

  • Oracle E-Business Suite Senior Administrator

    5 days ago

    Shimoga, Karnataka, India beBeeOracledbadmin Full time ₹ 14,40,000 - ₹ 19,20,000

    Job Title:Senior Oracle E-Business Suite AdministratorWe are seeking a skilled Oracle Apps DBA to administer and manage Oracle E-Business Suite environments.Key Responsibilities:Administer Oracle EBS R12.2 databases, ensuring high availability, security, and scalability.Perform database administration tasks including backup & recovery, performance tuning,...

  • Oracle Database Specialist

    4 days ago

    Shimoga, Karnataka, India beBeeDatabase Full time ₹ 9,60,000 - ₹ 16,00,000

    Job Title: Oracle Database ExpertJob Description:We are seeking a skilled Oracle database professional to join our team. As an Oracle database expert, you will play a critical role in ensuring the performance and scalability of our databases. Your expertise in performance optimization and tuning will be essential in analyzing and resolving database...

  • Highly Skilled Database Administrator Wanted

    4 days ago

    Shimoga, Karnataka, India beBeeDatabase Full time ₹ 18,00,000 - ₹ 24,00,000

    Job Title: Oracle Database AdministratorWe are seeking a skilled professional to oversee the day-to-day tasks associated with ensuring the smooth functioning of our databases.

  • Oracle Database Specialist

    3 hours ago

    Shimoga, Karnataka, India beBeeDatabase Full time ₹ 15,00,000 - ₹ 20,10,000

    Job Opportunity: Oracle Database SpecialistWe're seeking a skilled professional with 4–6 years of expertise in Oracle database development. The ideal candidate will showcase their proficiency in writing and optimizing PL/SQL code.Key Responsibilities:- Design, develop, and maintain efficient PL/SQL procedures, packages, triggers, and functions.- Optimize...

  • Senior Oracle Database Specialist

    4 days ago

    Shimoga, Karnataka, India beBeeDatabase Full time ₹ 7,50,000 - ₹ 15,00,000

    Job Role OverviewWe seek a seasoned Oracle professional to implement and manage Oracle applications, provide technical consulting services, develop and maintain Oracle databases.The ideal candidate will possess expertise in Oracle HR, Oracle Applications, consulting, integration, and database management.Key Responsibilities:Implementing and managing Oracle...