SQL DB Developer

⦁ Worked on multiple PaaS application development with integration with Oracle Fusion ERP cloud (Financial modules)

⦁ Knowledge of Oracle EBS forms, OAF, Workflow, PLSQL is must as they have to understand existing application in premise and accordingly develop/migrate in cloud

⦁ Good understanding about Oracle ERP financial modules

Responsibilities 

• Should be able to understand functional & technical requirements from business and come up with solutions.

• Development, Support, Debugging and troubleshooting of the existing developed applications (Forms, Reports, Interfaces etc.).

• Should be able to configure Oracle EBS/Cloud including the configuration of Business Processes and security.

• Integrations of customized applications with Oracle standard applications modules.

• Should be very strong in SQL and strong in PLSQL (especially Packages, Procedures and Functions).

• Database structure design for Tables, views, sequences, synonyms, and database triggers etc.

• Training users/BSAs when required & preparing technical documentation.

• Ensure customer satisfaction, Self-drive and perform duties with minimal supervision.

• Ensure tickets are resolved within SLA’s and assignments are completed within the agreed deadlines

• Good enough to understand the existing PLSQL packages/procedures/functions and modified / create new ones as needed.

• Ability and willingness to stay updated with the latest developments and updates in Oracle Fusion technologies and best practices.

Requirement: 

• 4+ years of Technical or Techno-Functional experience in Oracle EBS R12/Cloud Applications on Oracle HR/HCM (Any Modules in HR), SQL/PLSQL. 

• Good experience with HR/HCM (Any Modules in HR) is a must and should understand the functionality.

• Should be able to understand (Any Modules in HR) data model and should be quick enough to switch from one product to another product easily.

• Ability to develop custom solutions, extensions, and integrations to meet specific business requirements.

• Proficiency in creating custom reports, dashboards, and analytics using Oracle BI Publisher, Oracle OTBI (Oracle Transactional Business Intelligence), and other reporting tools.

• Knowledge of security models, user roles, and access controls within Oracle Fusion applications to ensure data integrity and compliance.

• Strong analytical and problem-solving skills to identify and address technical issues, system errors, and integration challenges.

• Good to have experience in Performance tuning techniques.

• Effective communication skills at all organizational levels, including written, oral, and presentation skills.

• Should be a good team with can do attitude.

• Capability to switch and willingness to work in any of the technologies as per the need basis.

• Should have a good understanding in working with onsite-offshore model.

We are looking "Fusion Technical Consultant (OIC)" for Reputed client @ Chennai Permanent Role.

Experience: 7+ Yrs

• Proven experience as a Fusion Technical Consultant with strong expertise in Oracle Integration Cloud (OIC),

• Strong hand on experience generating BI reports (strictly Mandatory)

• Proficiency in Java, PL/SQL, Web Services, and other relevant programming languages.

• Strong problem-solving skills and the ability to troubleshoot complex technical issues independently.

• Prior experience in a customer-facing technical support role is a plus resolving P1/P2 tickets in a close deadline.

• Hands-on experience with Oracle Fusion Middleware technologies, including Oracle SOA Suite, Oracle Service Bus, and ADF. 

• Excellent communication skills, both written and verbal, to effectively interact with clients and team members.

• Oracle certifications in Fusion Middleware and OIC are highly desirable.

Good To Have Skills:

• Good to have functional knowledge of AR, AP, GL,CM, Expense, FA, Procurement side.

Key Responsibilities: 

• Collaborate with clients to understand their technical requirements and challenges related to Oracle Fusion applications and Oracle Integration Cloud (OIC).

• Provide expert-level support and troubleshooting for technical issues, system outages, and integration bottlenecks in a timely and efficient manner.

• Diagnose and resolve complex technical problems related to Fusion applications, OIC integrations, interfaces, and extensions.

• Perform root cause analysis and implement preventive measures to avoid future technical glitches.

• Collaborate with cross-functional teams, including developers, functional consultants, and business analysts, to ensure seamless integration and functionality.

• Develop and maintain technical documentation, including troubleshooting guides, best practices, and solution implementation details.

• Participate in regular status meetings with clients to address support requests, provide updates, and offer recommendations for process improvement.

• Stay updated with the latest releases, patches, and updates related to Oracle Fusion applications and OIC.

Professional Attributes: 

• Flexibility

• Willing to work in shifts

• Willing to learn attitude

Educational Qualification: ANY

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).

Essential Duties:

• Work directly with clients to provide rapid and accurate analysis of production issues (including solution tracking).
• Answer customer questions, file bugs, and reproduce, troubleshoot, resolve, and escalate issues as necessary.
• Own and drive customer issues from start to finish.
• Become an expert on a given product domain from both a business and technical standpoint.
• Handle urgent escalation issues, ensuring we accurately prioritize based on severity and customer impact.

Minimum Requirements:

• BS or MS in Computer Science, Engineering, or related. We will also consider other significant technical experience.
• Minimum of 7 years of application support experience. 
• Strong Oracle SQL, PL/SQL skills required.
• Order-To-Cash (O2C) or Procure-To-Pay (P2P) cycle experience in Oracle EBS (Financials). Other ERPs can also be considered. 
• Excellent spoken and written English. All customer communications are in English.
• Strong communication skills, including the ability to adjust to the technical level of the audience and explain complex ideas clearly and concisely.
• Ability to work with a global teams and build strong cross-functional relationships.
• Positive attitude and the ability to overcome adversity; ability to stay calm under pressure.
• Strong desire and ability to continually learn new skills, processes, technologies, and product knowledge. You will learn something new every day!
• Problem-solving capabilities as well as excellent customer service skills.
• Ability to take ownership and follow through on client issues until resolution.
• Ability to effectively communicate and coordinate with peers and senior management as required.
• Strong organizational skills, attention to detail and technical judgment.