Main Responsibilities
Knowledge of online patching of EBS application patches
Experience working with WebLogic administration
Working knowledge on setting up environment on RAC
Troubleshooting and resolve issues related to oracle workflows/ integrations /ODI
Design and build database, schemas, and database objects
Working knowledge of version oracle database 11g/12c/19c
Set up routine database backup procedures and disaster recovery procedures.
Setup of disaster recovery site for production environment and monitor of the same
Design and implement database security schemas
Assist developers and end-users with database usage, query development, and tuning
Perform cloning of application and database instances utilizing Oracles Rapid Clone methodology
Good exposure on RMAN, ASM, Dataguard, Datapump Utilities.
Develop, construct, test and maintain architectures
Align architecture with business requirements
Data acquisition
Develop data set processes
Use programming language and tools
Identify ways to improve data reliability, efficiency and quality
Conduct research for industry and business questions
Use large data sets to address business issues
Deploy sophisticated analytics programs, machine learning and statistical methods
Prepare data for predictive and prescriptive modeling
Find hidden patterns using data
Use data to discover tasks that can be automated
Deliver updates to stakeholders based on analytics
Integrate new data feeds into a cloud-based data warehouse
Design a high performing data schema to support a dashboard report
Design and build a marketing database to support a client’s business needs
Develop data automation and monitoring scripts
Develop ETL scripts to perform data transformations
Integrate with a legacy database system to support data analysis
Create documentation and data dictionaries to support end-users of data systems
Perform business analysis and requirements gathering to support a variety of data projects
Define and implement web analytics
Key Competencies
Exceptional mathematical skills, in order to perform computations and work with algorithms
Excellent written and verbal communication skills
The ability to explain complex process to people who aren’t programming experts
Strong analytical skills
High attention to detail
Innovation and creativity
The ability to work with large, complex datasets.
Qualifications
Bachelor ‘s degree in Computer Science, Mathematics, Information Management Technology or any other related field.
Oracle Certified Professional (OCP)
Oracle EBS R12 (1ZO 238) Certified
Database systems like SQL and NoSQL
Data warehousing solutions
ETL tools
Machine learning
Data APIs
Python, Java, and Scala programming languages
Understanding the basics of distributed systems
Knowledge of algorithms and data structures
Relevant Experience
Minimum of 5-6 years’ experience in a similar role.
Experience in Oracle EBS R12.X, installation, patching, backup/recovery, and cloning.
Completed minimum 5 end to end installation on R12.
Experience on working with EBS on cloud environment.
Experience in recovering application & database in case of any eventuality.
3-5 years’ experience in technology/data roles
Experience with relational database systems (MSSQL, Oracle, Sybase, MySQL, Postgres, SAP HANA)
Advanced skills in data scripting and database development technologies (SQL, C#, Python, PowerShell, Ruby, Java, Batch Scripting)
Experience with Cloud platforms (AWS, Azure, Google Cloud)
Experience with Big Data Technologies (Hadoop, Spark, RedShift, Big Query, Apache) and basic understanding of NoSQL technologies (Splunk, ELK, AWS DynamoDB)
go to method of application »
Apply via :
recruitment.jubileeinsurance.com
