Posted:11 hours ago|
Platform:
Remote
Contractual
• 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.
________________________________________
• 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.
________________________________________
• 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).
Mastech Digital
Upload Resume
Drag or click to upload
Your data is secure with us, protected by advanced encryption.
Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.
We have sent an OTP to your contact. Please enter it below to verify.
Instantly access job listings, apply easily, and track applications.
navi mumbai
0.5 - 0.5 Lacs P.A.
bengaluru
14.0 - 24.0 Lacs P.A.
pune, maharashtra, india
Experience: Not specified
Salary: Not disclosed
Salary: Not disclosed
0.5 - 0.9 Lacs P.A.
6.0 - 10.0 Lacs P.A.
chennai, tamil nadu
Salary: Not disclosed
greater noida
14.0 - 22.5 Lacs P.A.
2.5 - 3.0 Lacs P.A.
3.0 - 8.0 Lacs P.A.
