Oracle Cloud Database Performance Engineer

As a member of support organization, the job focus is to deliver high quality customer service to the Oracle database cloud customer base while serving as an advocate for the customer needs. The job profile involves resolving technical issues mostly raised by customers through the customer portal. The job responsibility includes: 

• Taking ownership of customer issues reported and seeing problems through to resolution.
• Researching, diagnosing, troubleshooting and identifying solutions to resolve technical issues.
• Following standard operating procedures for proper engagement of internal and external stakeholders.

Autonomous Database

An autonomous database is a cloud database that uses machine learning to automate database tuning, security, backups, updates, and other routine management tasks traditionally performed by DBAs. Unlike a conventional database, an autonomous database performs all these tasks and more without human intervention.

Oracle Database-as-a-Service

Oracle Database-as-a-Service (DBaaS) brings the power and versatility of the Oracle Database to the cloud. As a service offering built on top of Oracle Cloud Infrastructure, it integrates award winning Oracle database technologies such as the Oracle Autonomous Database, Oracle Exadata and Oracle Real Application Clusters (RAC) making them available to customers of all stripes both for Online Transaction Processing (OLTP) as well as Data Warehousing workloads.

References

• https://www.oracle.com/database/what-is-a-cloud-database
• https://www.oracle.com/database/autonomous-database.html
• https://www.oracle.com/database/what-is-autonomous-database.html

Educational Qualification

• A degree in a relevant field from a recognized university
• B Tech / M Tech / BE / MCA / MSc or BSc Computer science

Required skills

 Technical

Working Experience in Oracle Cloud Technologies – Oracle Cloud Infrastructure (OCI)

Work experience and in-depth knowledge and working experience in Oracle Database Performance Tuning

 

• Strong Oracle DBA skills, SQL / PL/SQL knowledge
• Strong understanding of Oracle Database Performance Tuning methodologies including SQL Tuning - Serial and Parallel Queries, Data Compression, Partitioning, Materialized Views in RAC and Multitenant environments.
• Strong ability to understand, interpret and correlate AWR reports, TFA Logs, Exawatcher logs to troubleshoot complex performance issues, SQLT, SQLHC, EM Performance monitoring tools
• Ability to build testcases to reproduce customer issues
• Good understanding of the Oracle product features and options: Exadata, Clusterware, ASM, RAC, Dataguard, Golden Gate, Patching, etc.
• Operating system knowledge (Unix, Linux and/or Windows)
• Programming in C or Java
• Preferred certifications – OCI (Oracle Cloud Infrastructure), OCP
• Autonomous Database - Shared/Dedicated
• Backup Cloud Services
• Oracle Database Autonomous Recovery Service - ZDLRS/DBRS/RCV

Good working knowledge of other Oracle Database Areas

• Backup and Recovery
• Dataguard
• Real Application Clusters, ASM

Experience in the following

• Operating System (various Unix & Linux flavors).
• Networking & Hardware. 
• Virtualization

Customer Management

• Ability to understand customer problem and provide technical solution in timely manner.
• Ability to understand customer urgency and sensitivity of problem.
• Ability to speak confidently and communicate clearly with customer.
• Ability to work efficiently with a highly demanding customer.
• Ability to collaborate effectively with different stake holders – internal and external.
• Independent and self-motivated.

Work Experience

• 10+ years of experience in Performance Tuning, Administration/Troubleshooting/Maintenance of the Oracle Database.
• Working knowledge in Oracle cloud or any other leading cloud technologies.

Oracle Database Performance Tuning – Instance and SQL Tuning

Career Level - IC4

As a member of support organization, the job focus is to deliver high quality customer service to the Oracle database cloud customer base while serving as an advocate for the customer needs. The job profile involves resolving technical issues mostly raised by customers through the customer portal. The job responsibility includes: 

• Taking ownership of customer issues reported and seeing problems through to resolution.
• Researching, diagnosing, troubleshooting and identifying solutions to resolve technical issues.
• Following standard operating procedures for proper engagement of internal and external stakeholders.

Autonomous Database

An autonomous database is a cloud database that uses machine learning to automate database tuning, security, backups, updates, and other routine management tasks traditionally performed by DBAs. Unlike a conventional database, an autonomous database performs all these tasks and more without human intervention.

Oracle Database-as-a-Service

Oracle Database-as-a-Service (DBaaS) brings the power and versatility of the Oracle Database to the cloud. As a service offering built on top of Oracle Cloud Infrastructure, it integrates award winning Oracle database technologies such as the Oracle Autonomous Database, Oracle Exadata and Oracle Real Application Clusters (RAC) making them available to customers of all stripes both for Online Transaction Processing (OLTP) as well as Data Warehousing workloads.

References

• https://www.oracle.com/database/what-is-a-cloud-database
• https://www.oracle.com/database/autonomous-database.html
• https://www.oracle.com/database/what-is-autonomous-database.html

Educational Qualification

• A degree in a relevant field from a recognized university
• B Tech / M Tech / BE / MCA / MSc or BSc Computer science

Required skills

 Technical

Working Experience in Oracle Cloud Technologies – Oracle Cloud Infrastructure (OCI)

Work experience and in-depth knowledge and working experience in Oracle Database Performance Tuning

 

• Strong Oracle DBA skills, SQL / PL/SQL knowledge
• Strong understanding of Oracle Database Performance Tuning methodologies including SQL Tuning - Serial and Parallel Queries, Data Compression, Partitioning, Materialized Views in RAC and Multitenant environments.
• Strong ability to understand, interpret and correlate AWR reports, TFA Logs, Exawatcher logs to troubleshoot complex performance issues, SQLT, SQLHC, EM Performance monitoring tools
• Ability to build testcases to reproduce customer issues
• Good understanding of the Oracle product features and options: Exadata, Clusterware, ASM, RAC, Dataguard, Golden Gate, Patching, etc.
• Operating system knowledge (Unix, Linux and/or Windows)
• Programming in C or Java
• Preferred certifications – OCI (Oracle Cloud Infrastructure), OCP
• Autonomous Database - Shared/Dedicated
• Backup Cloud Services
• Oracle Database Autonomous Recovery Service - ZDLRS/DBRS/RCV

Good working knowledge of other Oracle Database Areas

• Backup and Recovery
• Dataguard
• Real Application Clusters, ASM

Experience in the following

• Operating System (various Unix & Linux flavors).
• Networking & Hardware. 
• Virtualization

Customer Management

• Ability to understand customer problem and provide technical solution in timely manner.
• Ability to understand customer urgency and sensitivity of problem.
• Ability to speak confidently and communicate clearly with customer.
• Ability to work efficiently with a highly demanding customer.
• Ability to collaborate effectively with different stake holders – internal and external.
• Independent and self-motivated.

Work Experience

• 10+ years of experience in Performance Tuning, Administration/Troubleshooting/Maintenance of the Oracle Database.
• Working knowledge in Oracle cloud or any other leading cloud technologies.

Oracle Database Performance Tuning – Instance and SQL Tuning

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s problems. True innovation starts with diverse perspectives and various abilities and backgrounds.

When everyone’s voice is heard, we’re inspired to go beyond what’s been done before. It’s why we’re committed to expanding our inclusive workforce that promotes diverse insights and perspectives.

We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer a highly competitive suite of employee benefits designed on the principles of parity and consistency. We put our people first with flexible medical, life insurance and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by calling +1 888 404 2494, option one.

Disclaimer:

Oracle is an Equal Employment Opportunity Employer*. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

* Which includes being a United States Affirmative Action Employer