Senior Oracle DBA(Performance Tunning)

Job Description

Oracle DBA Performance Tunning About Oracle - CSS The Customer Success Services (CSS) is a unit within the Oracles Customer Service Organization that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and project based one-time services. CSS services team sells from a broad IT-services portfolio both in fixed price and T&M basis. CSS services are typically requested by large Oracle customers that require the utmost attention to real mission critical applications and processes. CSS covers the majority of large-scale Oracle customers. Oracle Customer Success Services provides unmatched, tailored support that ensures organization’s Oracle technology investments deliver the cutting-edge innovation and performance your business requires to compete, all while coexisting within your IT environment. CSS is industry-leading expertise with the highest customer satisfaction to support organization’s business every step of the way. Job Responsibilities: Provide post-sales technical support and solutions to Oracle customers. Act as the primary point of contact for customer inquiries, troubleshooting, and issue resolution. Install, configure, and administer Oracle Database/RAC 11g, 12c, and 19c. Perform database upgrades, patching, and performance tuning. Diagnose and resolve moderately complex technical issues related to Oracle products. Interface with customers’ IT teams regularly, either on-site or remotely. Manage escalations, develop action plans, and facilitate issue resolution with Development and Support teams. Ensure high customer satisfaction through proactive service recommendations and support. Utilize Oracle Enterprise Manager (OEM) for database monitoring and management. Work independently with minimal supervision while advising management on progress. May take on project lead responsibilities and provide guidance to team members. Mandatory Skills: Minimum 7 years of experience as an Oracle Database Administrator/Consultant/Support Engineer. Availability to work in a 24x7 support environment. Expertise in Oracle Database Architecture, RAC, and Performance Tuning. Strong troubleshooting skills for database performance and SQL tuning. Experience in database upgrades, patching, and maintenance. Good understanding of support processes and ability to manage escalations. Strong analytical skills with independent problem-solving capabilities. Excellent communication and customer management skills. BE/BTech/MS in Computer Science or equivalent preferred. Oracle Database / Exadata / OCI certification preferred. If you have the above skills, take up the below list of self-test questions to know if you qualify to apply. Self-Test Questions: Can I explain the use of TKPROF? What initialization parameter should be turned on to get full TKPROF output? Do I know the fastest query method for a table? Can I fix the contention for library caches? Do I know row chaining, how does it happen? How can I reduce it? How do I correct it?