Job Description

• 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.
• Co-ordinate 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
• Troubleshooting and monitoring of any Apps specific batch jobs , services etc..
• Experience with Linux/Unix/AIX operating systems
• Maintaining CI/CD pipelines (configuration of new pipelines, update existing pipelines)
• Knowledge on automated build process
• Extensively worked on Bamboo, BitBucket,Maven,Jenkins and GitHub repositories tools
• Implementing and maintaining version control systems, configuration management tools, and other DevOps-related technologies.
• Designing and implementing automation tools and frameworks for continuous integration, delivery, and deployment.

Thanks