Data System Expert

Job Title: Database Architect

Oracle Database Administrator Job Description

This is an exciting opportunity to work with a high-performance team in a dynamic environment. We are seeking a skilled Oracle Database Administrator to join our team and contribute to the optimal performance and security of our database infrastructure.

The ideal candidate will have strong 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.

The successful candidate will be responsible for ensuring the efficient operation of our database systems, providing root cause analysis and resolution for performance incidents, partnering with infrastructure DBAs for patching, backups, disaster recovery, and capacity planning, and developing and maintaining documentation, standards, and runbooks for application database operations.

Key Responsibilities:

• Performance Optimization & Tuning:
  • Optimize database performance by analyzing and resolving bottlenecks affecting application/API response times
  • 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:
  • Work with API Gateway 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 targets
• On-Premise & 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 issues
• Operational 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 operations

Qualifications & Skills:

• 6-8 years of hands-on experience as an Oracle DBA, with emphasis on Application DBA responsibilities
• Strong 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 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)