Oracle Database Administrator - PL-SQL

Position : Oracle Database Administrator

Location : Remote

Duration : Full Time Contractors

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

Performance Optimization & Tuning :

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

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

Application & Middleware Integration Support

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

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

On-Premise & Cloud Integration

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

- Monitor and troubleshoot replication/data transfer issues.

Operational Excellence

- 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 operations.

Qualifications & Skills

Strong expertise in:

- 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 teams.

Preferred/Bonus Skills :

- 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).