Talent.com
This job offer is not available in your country.
Oracle Database Administrator - PL-SQL

Oracle Database Administrator - PL-SQL

Mastech DigitalIndia
24 days ago
Job description

Position : Oracle Database : : Full Time Period : Only Immediate Joiners / Currently Serving Notice / Notice is less than 30 Optimization & Tuning :

  • Analyze and resolve database bottlenecks affecting application / API performance.
  • Tune SQL queries, PL / SQL packages, stored procedures, and indexes for optimal response times.
  • Implement best practices for connection pooling, partitioning, and caching & Middleware Integration Support
  • Work with API Gateway and custom orchestration teams to optimize database interaction patterns.
  • Support GET / POST transaction flows from APIs into Oracle.
  • Ensure efficient database design for web applications with high concurrency and SLA & Cloud Integration
  • Manage data synchronization between on-prem Oracle and Fusion Cloud Oracle DB via OIC (Oracle Integration Cloud).
  • Implement and support Pub / Sub mechanisms for customer data exchange.
  • Monitor and troubleshoot replication / data transfer Excellence
  • Proactively monitor system health, query execution plans, and workload statistics (AWR, ASH, ADDM).
  • Provide root cause analysis and resolution for performance incidents.
  • Partner with infrastructure DBAs for patching, backups, disaster recovery, and capacity planning.
  • Develop and maintain documentation, standards, and runbooks for application database & Skills

68 years of hands-on experience as an Oracle DBA, with emphasis on Application DBA expertise in :

  • Oracle 12c / 19c performance tuning, indexing, partitioning, optimizer hints.
  • SQL and PL / SQL development and debugging.
  • 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 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).

    • (ref : hirist.tech)

    Create a job alert for this search

    Oracle Database Administrator • India