What are the responsibilities and job description for the Oracle Ops DBA position at Conch Technologies Inc?
Greetings
Position : Sr Oracle Ops DBA
Location : New York city , NY
Duration : 12 Months Contract
Technical Skills :
Seven or more years of experience in database Operational experience using Oracle 12c R1 and 19c versions.
Strong experience in oracle DB related consultancy & procedure
Expert / well versed with Oracle DB architecture.
Strong performance tuning skills in a very large database environment.
Proactively monitoring the database's health and taking preventive or corrective action as required
Experience in Manage / co-ordinate in User Role and Privileges and provide report for Database Audit
Real time exposure on High availability in Oracle Environment RAC, Data guard, Clustering, Golden Gate, ASM, Replication
Should have worked on Disaster Recovery Plan, Shell Scripting knowledge, Database Migration / Upgrades
Troubleshooting knowledge on SQL, PL / SQL programs, Packages, Stored procedures, Functions and Triggers to automate the interface processes for daily / incremental loads.
Ability to use SQL Trace and AWR reports to analyze results, then to recommend options for problem resolution.
Expert level knowledge in writing / troubleshooting PL / SQL queries, shell scripting.
Strong experience with Oracle RMAN backup / recovery methodologies.
Must be able to organize work efficiently and work well under stress, changing priorities, and time constraints.
Familiarity with Splunk and Fog light tools / OEM tools
Should be able to guide / recommend DB developers as needed.
Coordinate with I&O DB team for any DR activity, patching, performance issues etc..
Lead and co-ordinate with various Infra and Apps teams during Techlines or any major releases.
Should act as point of contact for any DB related information from an Apps perspective. ( go to guy for any DB related info for developers)
Recommend database tuning and performance monitoring as needed.
Perform general technical trouble shooting and give consultation to development teams
Assist developers with database activities.
Troubleshooting and monitoring of any Apps specific batch jobs , services etc..
Experience with Linux / Unix / AIX operating systems
Behavioral Skills :
Must have superior problem-solving skills with extremely high levels of initiative and assertiveness.
Effective interpersonal, team building and communication skills
Qualification :
Bachelor's degree preferably in Computer Science or Information Systems and / or equivalent formal training or work experience.
7-10 years of relevant experience in relational database management systems..
Thank you &
Regards
V S Durga Prasad | Sr.
T Recruiter
E : vprasad@conchtech.com |
T : 901-466-4708
Conch Technologies Inc |
www.conchtech.com
