System Engineer Database

Qualification minimum Bachelor s degree Or master s degree in computer science information technology or related discipline Experience minimum 10 years Experience in Oracle database at least 5 years with databases on multiple platforms Experience implementing and managing support maintenance of Oracle SQL DB Responsibilities Perform all aspects of SQL and Oracle database administration including installation configuration upgrades and maintenance Ensure the availability performance and security of Oracle databases within the Oracle WebLogic and Java environment Data modelling and database design Maintains production and development test environments including database refresh upgrade and migration activities Implements all access control to the database considering security efficiency integrity ownership and redundancy concerns May develop stored procedures and or triggers Administers a variety of database systems such as Microsoft SQL Server and other Database Management Systems DBMS Develops and enforces database administration and user standards and procedures audits modifies and amends data in systems using SQL commands Reviews technical designs reports documentation and other materials produced by staff creates and maintains highlevel reporting statesmanlike and optimize database performance through tuning activities such as query optimization index creation and system monitoring Identify and resolve performance bottlenecks to ensure optimal database response times and efficient resource utilization Develop and implement robust backup and recovery strategies to protect critical data and ensure high availability Conduct regular database backups perform recovery procedures and test backup integrity to minimize data loss and downtime Design develop and implement Oracle technical solutions based on requirements Provide expertise and guidance in the configuration and customization of Oracle EBS applications Collaborate with functional Associates and business stakeholders to gather requirements and translate them into technical specifications Develop and enhance integrations between Oracle EBS applications using Oracle Integration Cloud OIC as well as other integration platforms Create custom reports and perform data analysis Utilize Oracle Analytics Cloud to build interactive dashboards and derive meaningful insights from data Leverage strong knowledge of standard Web Services to integrate and extend for Oracle Fusion applications Troubleshoot and resolve technical issues related to Oracle EBS applications and integrations Stay up to date with the latest Oracle technologies tools and best practices and share knowledge with the team Assist in system integrations with other applications as required Provide technical support to endusers and assist with issue resolution Skills Oracle 12c 19c 21c Patching Upgrading MAN Backup Recovery Replication strategies using Data Guard Shell Scripting Monitoring Alerting using Oracle Enterprise Manager SQL Performance Tuning SQL Advanced Security options Auditing VPD TDE Exadata RAC Appliance Table Partitioning Indepth knowledge of Oracle Fusion ERP modules Depth Knowledge of Oracle EBS Function Gap Analysis Good understanding Oracle Business process workflows Strong programming skills in languages such as Java Python or JavaScript Oracle certifications in relevant areas would be a plus Good understanding of standard Web Services and their integration capabilities Solid understanding of Oracle applications and their underlying data models Need to be able to do configuration Testing lead data migration and integration activities from legacy systems to Oracle Depth Knowledge of System Configuration Depth Knowledge of EBS Implementation Key area of experience Experience performing all aspects of Oracle database administration installation configuration upgrades and maintenance ensuring availability performance and security within the Oracle WebLogic and Java environment Experience in installation maintenance and troubleshooting of Oracle database 12c 19c 21c Experience on Oracle 12c 19c RMAN Data Guard ASM Standby Database setup and Management Expertise in Oracle RAC Oracle Data Guard and Oracle standalone administration Knowledge experience on Different Backup methods and backup tools is needed Experience analysing tuning monitoring and optimizing performance for Oracle databases Experience collaborating with development and infrastructure teams on databaserelated support including troubleshoot problems and provide technical guidance on database design schema changes and performance optimizations Excellent communication skills both written and verbal Strong aptitude to learn and adapt to technology Effective project management time management and organizational skills Ability to communicate clearly and effectively with all levels in an organization Strong team interaction and collaboration skills Detail oriented with strong analytical and organizational skills Server Utilization Performance Report Periodically OVM Oracle Virtual Machine Management support and Administration Oracle Linux OS Support Storage Clustered Support Company Profile TYCHE HR Consultancy is a leading human resource consultancy specializing in recruitment sourcing headhunting for permanent placements outsourcing local and overseas hiring Our team of experienced professionals works tirelessly to match the right talent with the right opportunities helping businesses thrive and individuals succeed With a strong network and an innovative approach to talent acquisition we provide topnotch HR solutions tailored to our clients unique needs Whether you are looking to build your dream team or take the next step in your career TYCHE HR Consultancy is here to support you every step of the way