Axiom Developer

About the client:

In 2019 the Frontrol team did an extensive review of the current landscape of project management tools and found that any given tool enabled anywhere from 1-4 functions of project management to the exclusion of the rest. We then envisioned the need for a single platform that combines all project functions and actors as opposed to currently available solutions that focused on one or two aspects of project management. The founders sold their vision to one of the biggest and most admired Engineering firms in the world (Fortune 500 company). This organization has tasked Frontrol to develop and deploy this platform for its 80K employees/partners/customers across 80+ countries. Frontrol then envisions taking this offering to other engineering firms globally before moving on to other industries including Utilities, Energy, State & Local Governments, Mining, Aerospace & Defense, Engineer to Order/Assemble to Order, Bio-Medical, etc. 

About the project:

The project is to develop Frontrols product PACE. PACE is envisioned to be a cloud based SAAS platform that provides project delivery organizations to enable all project functions across the entire project lifecycle from initiation to planning, execution and closeout and brings together all project participants involved from project managers, planners, team members (employees and partners), finance, operations management, regulators, sales and customers. 

Responsibilities:

• Write extracts for Data from Oracle EBS Projects. 
• Debug issues in data in source and target applications.
• Write technical design documents for extracts based on the business requirements given by users.
• Participate in test case prep for data validation 

Requirements:

• At least 4 years of experience in Building extracts, data conversion scripts, and reporting on EBS Oracle projects module.
• Strong experience in addressing performance issues in SQL queries. 
• Should have experience in at least one end to end data conversion cycle for Oracle EBS ( Or fusion PPM) projects module. 

Will be a plus:

• Scripting Skills (Bash, Powershell, Python, etc.)
• Strong understanding of data structures & algorithms

Job Title: Mulesoft Lead/Architect                   

Location: Hyderabad/ Pune

Prolifics, a pioneering technology solutions provider, is seeking a talented and inventive Mulesoft developer to join our dynamic team. At Prolifics, we believe in empowering our employees to push the boundaries of innovation, think outside the box, and deliver game-changing solutions to our clients.

To excel in this role, you should have:

• 5+ years of hands-on experience with MuleSoft and API Management with Excellent knowledge of SOA, ESB concepts.
• Configure APIs, proxy endpoints, API portals and API analytics based on technical specifications with MuleSoft API manager.
• Deep understanding of VPC and DLB’s.
• Deep understanding of REST, HTTP, MQ, JSON, XML and SOA Design and develop enterprise services using RAML in Mule, REST based APIs, SOAP Web Services and use of different mule connectors.
• Strong understanding and experience with security implementations (e.g. SSL/mutual SSL,mTLS SAML, Auth, OAuth).
• Strong understanding and experience with Mule 4 & Dataweave Language
• Ability to interface with clients, technology partners, testing, architecture, and analysis groups.
• Implement Policies in API Manager
• Deep experience with Any point Platform, Flow Design, API Design. Data weave, Cloud Hub, Runtime Fabric, API Management
• Knowledge of Jenkins / CICD Process, AZURE/AWS CICD Process.
• Prior Experience in integration with different applications like SOAP, REST WS, SAP, Salesforce, DB, etc. through Mule soft connectors.
• Creation of Mapping document by working with source and target systems
• Deploy APIs to Cloud hub, Runtime Fabric, On-prem workers, etc.
• MuleSoft RTF Deployment experience a plus
• Prior Experience in Munit, Automation Testing using JMeter.
• SonarQube experience is a plus.
• Anypoint MQ experience is must.
• Understand / apply reusable code design, leverage application architecture / patterns, framework capabilities and functionality, and design / develop solutions that are highly reliable, scalable, and perform to meet business-defined service levels.
• Experiences with Splunk/ELK is a plus.
• Experience in working in Micro services development preferably in API implementation in MuleSoft.
• Excellent communication skills
• Excellent interpersonal and analytical skills 
• Excellent attention to detail ability
• Must be a quick learner to gear up in the MuleSoft technology and architectural standards.

• You would be responsible for Developing SQL Databases, automation of business reports and Developing Business Dashboard using BI Tools.
• Development of high quality database solutions 
• Create complex functions, scripts, stored procedures and triggers to support application development.  
• Develop, implement and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Build appropriate and useful reporting deliverables
• Analyze existing SQL queries for performance improvements
• Fix any issues related to database performance and provide corrective measures.  
• MIS Automation
• Provide timely scheduled management reporting
• Create Business dashboard using Tableau BI Tool

Requirement / Desired Skills:

• 5+ years of business Analyst / SQL developer experience in Fintech,internet,consulting etc industry
• Excellent understanding of T-SQL programming
• Excellent understanding of Microsoft SQL Server 
• Good knowledge of HTML and JavaScript 
• SQL Server Reporting Services and SQL Server Analysis Services
• Knowledge of any of the BI Tool (Tableau, PowerBI or Qlikview)

About this role

We are seeking a seasoned DBA to join our team. You will have extensive experience in a mission-critical environment as a database administrator over a successful career.  You will primarily work on the Supporting our Databases, AWS RDS (MySQL), and  MongoDB/ Cassandra.

What You’ll Do

• Provide leadership in database scaling & monitoring. Maintain runbooks for our 24x7 SRE team. 
• Assist in troubleshooting and resolution of database issues. Perform database upgrades and patches.
• Define and develop data pipelines between platforms in a mission-critical environment using DMS, Fivetran, Kafka, etc.
• Work with our developers to optimize and tune their SQL queries.
• Assist in application development, debugging, and optimization with respect to data concerns.
• Provide input in the design and implementation of backup, recovery, and DR strategy
• Review application and database design for compliance.

What You’ll Need

• Ability to script in a high-level language like Python, Ruby, etc for Automation. 
• 8+ years of experience in AWS database services like RDS (Mysql), MongoDB/ Cassandra.
• 4+ years of experience in database design and DevOps on AWS.
• Must demonstrate a clear understanding of logical and physical database design and standards. 
• Experience in columnar data warehouse solutions like Redshift or Snowflake. 
• Must have extensive hands-on experience with MySQL in a large scale 24x7 production environment with millions of records.
• Bachelor of Science in Computer Science, Mathematics, or Engineering; or equivalent work experience

Bonus Points If You Have

• Experience with NoSQL solutions such as Cassandra/MongoDB etc.
• Experience with software development life cycle (SDLC) in an agile environment
• Hands-on production experience with Big Data applications such as Spark.
• Knowledge of development best practices (source control with Git, continuous integration, automated testing).

REQUIRED CITIZENSHIP / WORK PERMIT / VISA STATUS:
Should be currently based in Japan with Valid work visa

MUST HAVES:

• * Mandatory Skills - Mainframe, Cobol, JCL ,DB2
• * Should have working knowledge on at least one database – MS SQL server, Oracle, DB2, PostgreSQL, MongoDB, Firebird SQL diagnose
• * Language Skills - JLTP N3 would be fine if the

Requirements:

• · Graduate with 6+ years of experience in Mainframe based applications development, maintenance & run mode operations.
• · Ability to collaborate with a diversity of customer's teams to address important issues and to resolve them.
• · Experienced in collaborating with internal and external stakeholders, adaption and learning of the business processes.
• · Should have experience working with Mainframe, Cobol, JCL ,DB2.
• · Working knowledge on at least one database – MS SQL server, Oracle, DB2, PostgreSQL, MongoDB, Firebird SQL diagnose, troubleshoot and fix complex issues.

Only Japan based candidates with relevant experience can apply.

Roles and Responsibilities:

• Installation, configuration and upgrading of Oracle server software and related products.
• Establish and maintain sound backup and recovery policies and procedures.
• Take care of the Database design and implementation, including Patch Management and Version Control. Implement and maintain database security (create and maintain users and roles, assign privileges).
• Perform database/application tuning and performance monitoring.
• Setup and maintain documentation and standards.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 24x7 support when required.
• Perform general technical troubleshooting and give consultation to development teams.
• Interface with Oracle Corporation for technical support.
• Analyse potential impact of problem resolution and take corrective measures when needed.
• Root Cause Analysis.

Education, Skills and Experience required:

• Engineering or Technical Degrees (BE/ B.Tech/ ME/ M.Tech/ M.Sc / MCA)
• Minimum 4 years of relevant industry experience.
• Must have experience on multiple Hardware and Software Environments and be comfortable with complex heterogeneous systems environments.
• Must be an Oracle Certified Professional DBA (11g or above) with hands-on experience of RAC, RMAN.
• Good understanding of the Oracle database, related utilities and tools and underlying operating system.
• Excellent knowledge of the physical database design and all Oracle backup and recovery scenarios.
• Developing, managing and testing back-up and recovery plans. Data archival and space management.
• Ability to perform both Oracle and operating system performance tuning and monitoring.
• Good knowledge of Oracle security management and Oracle data integrity.
• Experience in code/data migration, database change management and data management through the various stages of the development life cycle.
• Sound knowledge of both database and system performance tuning and implemented application systems.
• Should have the ability to handle multiple projects and deadlines.
• Male candidates preferred as the role requires working in shifts.

Onsite Opportunity for Oracle Fusion HCM Functional (TalentManagement/ CoreHR) Consultant’s – UAE. Exp.- 8+Years, Very strong in Fusion TalentManagement/ CoreHR. Atleast 2 e2e Implementation in Fusion TalentManagement/ CoreHR. Excellent Communication. Joining time: Max. 10 Days. Kindly contact Ramesh- 782, 938, 2777, rbguddanur AT appstec-me DOT com