As senior member of database engineering group, within NetSuite business unit, you will work in a role to diagnose and resolve performance issues with overall database instance or individual queries. In addition you will collaborate with development teams to ensure they deliver solutions designed for optimal performance.You will encounter a variety of interesting problems and find ways to solve them rapidly and effectively.
To be successful in this role you should be familiar with SQL constructs, understand principles of schema modelling, know main concepts of Oracle database internals like architecture (multitenancy, memory components, etc), waits events, logs, etc. A positive desire to learn, listen, think, test, and fix problems daily is essential to success.
Operational experience of managing backups, applying patches, etc will be supplementary and desirable but not core skills required for the role.In addition, this role requires someone to work either Sunday to Thursday or Tuesday to Saturday as their regular working week in EU time shift (1pm – 10pm). Flexible working arrangement where working from home 2-3 days a week is acceptable.
Career Level – IC3
NetSuite Database Cloud Engineering is responsible for performance of (38k+ Production DBs and 80k+ QA/Demo/Dev Dbs). Challanges faced by the team can be broken down into the few categories:
– Diagnose and resolve individual SQL performance issues (you would need to apply hints, define new indexes, investigate optimiser/environment issues ).
– Diagnose and resolve performance issues with overall database instance (DB configuration, Oracle bugs, Issues injected by Development teams and etc).
– Explore and adopt new technologies, eg Oracle 23ai, Autonomous Transaction Processing, Auto indexing, Frequent statistics and etc.
– Collaborate with Development teams to ensure they designing solution for optimal performance.
To be successful in the role you should be passioned about database performance and have some skills from the list below:
– SQL Tuning
– PL/SQL experience
– understand DB schema design principles
– Solid understanding of Oracle architecture and internals (RAC, Memory Components, processes)
– Experience with AWR and/or ASH data
Following skills are not mandatory but will give an advantage to candidate:
– RAC performance diagnostics (Shared disk system, Clusterware, Interconnects, Kernel)
– Oracle Tracing (intermediate)
– Hands on experience with Shell, python, perl or Java
– Building synthetic test cases
– Experinece Used tools like Oracle Real Application Testing, SwingBench or HammerDB
– NoSQL DB experience
– Experience with source control systems: Gitlab, BitBucket and etc
Related education & industry experience:
A Bachelors degree in a technical area or equivalent experience in a relevant field is required.
Candidate should have at least 3 years of experience in performance tuning, database development, software engineering, or database engineering; or directly related SQL tuning experience in other roles such as QA, SRE or DBA.
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
