PL/SQL Developer-Madurai

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

#HiringAlert

We are looking " Oracle APEX " for Reputed Client @ Permanent Role.

Must Have Skills:

1.Experience in Oracle APEX, SQL / PLSQL concepts, collections, function, procedure, package and types - Mandatory

2. Experience in JASPER / OBIEE reports

Good To Have Skills:

1.Knowledge in Oracle Forms and Reports, JavaScript, HTML, CSS or any other web-based programming language is added advantage (Optional)

2.Key Responsibilities: Design develop test and implement features and code using Oracle Application Express APEX

3. Perform requirements analysis development design test and deployment of custom Oracle applications.

4. Writing SQL queries Views Materialized views PLSQL procedures functions packages triggers cursors collections Ref cursor cursor variables System reference cursor Dynamic SQL

5. Debug code and maintain PL SQL procedures and functions.

6.Optimize existing applications and scripts for both usability and performance.

7. Adherence to policies processes and procedures within your areas of responsibility

8.Evaluate new features and technologies overseeing their implementation into the environment as appropriate.

9.Ability to prioritize, manage, deliver and report on multiple projects simultaneously highly motivated and able to work against aggressive deadlines schedules.

Professional Attributes:

1. Ability to work with minimal supervision.

2. Exhibits strong ethics, positive attitude, and calm demeanor under pressure.

3. Flexible, organized and possesses the ability to work in a fast-paced environment.

Location : Chennai

Please get to know about us by visiting http://www.peoplefirst.co.in/" target="_blank">www.peoplefirst.co.in 

We have a job opportunity for the role of "Outsystems Developer" in one of the fast-growing Japanese-based Start-Up Companies.

Job Location: Chennai / Coimbatore / Bhubaneswar

Job Description:

Key Responsibilities & Job Duties

● To provide functional support for our ERP

Finance applications (Oracle eBusiness Suite)

○ Assist users in case of question

○ Manage functional requests

● Train users to keep the right level of skill

○ To organize audits of the use of systems

○ Detect and collect issues

○ Implement action plan and coordinate actions

● To manage enhancements in accordance with the procedures which apply in the department

○ Collect enhancements from users

○ Challenge the user requirements

● Define priorities

○ Write functional specifications and coordinate developments with the technical team

● Test and train the users

○ Regularly communicate to the users the status of the enhancement

○ Report activity to the management

○ Collaborate with functional support in other zones to share information

○ Optionally, may manage some projects

Key Technical & Functional Competencies
● Functional competencies

○ Strong Business processes: Finance

● Technical competencies

○ Good Knowledge of Oracle SQL

○ Strong Oracle eBusiness Suite

Modules: AP, AR, GL, FA (At least at a professional for two Modules)

○ Basic knowledge of Oracle eBusiness Suite Modules: INV, PO, OE, WSH is preferable

• 4-15 year experience in Application Support
• Must have good knowledge in Java/J2EE, Microservices, PL/SQL, Unix
• Good to have knowledge in Agile, JIRA, Splunk, Service Now
• Good understanding and hands-on experience in Incident, Problem and Change Management
• Provide technical leadership to the team & contribute in the skill development within team
  Interact with internal teams and client stakeholders to trouble shoot the tickets/incident and manage other support activities
• Good communications skills are necessary, must be team player and inquisitive.
• Strong customer service and support focus with a desire to deliver a high-quality service
• Ability to multi-task, work under pressure and to tight deadlines
• Flexible in working outside of office business hours at short notice (as required)
• Should be able to examine the system and identify the areas for Service Improvements & Value adds.

smartShift Technologies is looking for a seasoned Database Administrator - Oracle to join our Bangalore team.

 Responsibilities

• Perform regular Database administration tasks.
• Perform HA and DR setup maintenance tasks
• Analyze the performance metrics and provide tuning recommendations
• Analyze the repetitive support requests and provide the automation feasibility
• Handle incidents and problems
• Perform trend analysis of the incidents/events and help in finding the resolution

 Skills & Experience

• Strong experience in Database Administration  in Oracle database 
• Have strong knowledge on Oracle SQL and PL/SQL 
• Expertise in writing and analysing Stored procedure , packages and triggers. 
• Exposure to AWS Cloud RDS is required
• Experience in Database Patching/Upgrade/Migrations
• Experience in managing the HA and DR setups ( Standby, DataGuard)
• Experience in performance tuning ,query optimisation
• Experience with client interaction is preferred
• Exposure to other MySQL database is preferred
• Excellent written and verbal communication skills. 
• Real time experience in DB administration (Installation/Tablespace Management/Object Management
• Expertise in RMAN and other backup(Expdp/Impdp) methodology implementations
• Experience in Database Patching/Upgrade/Migrations
• Knowledge on GoldenGate is desirable
• Knowledge on Oracle 12C/19C new features
• Experience with client interaction is preferred
• Knowledge on RAC & ASM is desirable
• Exposure to AWS Cloud is desirable
• Excellent written and verbal communication skills

Excellent knowledge with proven implementation experience of:  Axiom Controller View V9 / V10 (2+ years’ experience).  Building and configuring Axiom workflows to solve complex business problems and mapping to Axiom data dictionaries.   XBRL and template disclosure submission including taxonomy, data point model and validations experience.   Knowledge of EU regulatory reporting requirements (COREP/Statistical) with strong Capital knowledge.  Packaging, deploying, branching Axiom solution including upgrades as part of the software development lifecycle.   Oracle PL/SQL.