Oracle - Production Support Engineer
omega solutionsSanta Clara (CA)
About the role
Oracle – Production Support Engineer Production Support engineer would need to have at least 4+ years of experience, preferably would have worked as a DB Admin (Oracle / other RDBMS) in the past. Proficient with Oracle PL/SQL, Oracle 10/11g/ experience, including designing tables, stored procedures, triggers, and user-defined functions, performance tuning. Oracle Streams experience highly preferred. Creating primary database storage structures, designing and creating primary objects, modifying database structure as necessary for enhancements or performance, creating documentation, designing interfaces, database objects, and creating plans. Build, maintain, and enhance all objects packages/functions in PL/SQL to support application process. Strong understanding in database Performance Troubleshooting/Tuning, be skillful in SQL execution plan, AWR, ADDM, ASH etc reports. Perform functions including SQL tuning, database application design, and developer support. Monitor and optimize performance of the database, plan for backup and recovery of the database, and allocate system storage, plan future needs. Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds. Create database-related scripts and programs to support development and production environments. Experience in Unix/Linux Shell and Python scripting mandatory. Will be working on Production support, Releases for applications on a day to day basis.
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.
More like this