Position Title: Oracle SQL / Oracle E-Business Developer
Employment Type: Direct Hire, Full Time, Permanent
Work Schedule: Night Shift
Work Arrangement: Hybrid (2 days onsite in a week)
Work Location: Makati
Max Salary Offer: 160,000
Job Description:
· Design, develop, and implement Oracle database applications.
· Write optimized SQL and PL/SQL queries for database operations.
· Manage and maintain stored procedures (SP), packages, and synonyms.
· Grant and manage user permissions to ensure security and compliance.
· Perform database tuning, including optimization of joins, hints, and query execution plans.
· Troubleshoot and resolve database-related issues.
· Collaborate with project managers, business analysts, and other developers to deliver effective database solutions.
· Ensure data integrity and implement best practices for database architecture.
Skills
Non-negotiable/Required
§ Orport § Explain Plan and Query cost analysis
§ SQL Hints and Partitioning § Oracle Performance monitoring, Spikes, active sessions
§ Toad oracle Auto optimizer tool or any other similar tools which recommends
§ Tuning of complex PL/SQL with Dynamic SQL
§ Knowledge of Oracle - 12c and above
§ Proficient in SQL and PL/SQL
§ Deep Oracle tuning experience. o Understands how the Oracle Optimizer works at a deep level o Understands Oracle Explain plans at a deep level
o Has clear method for measuring and improving query performance (method-r, etc.)
o Understands tools to improve and manage performance such as SQL Profiles, SQL Plan baselines
§ Familiar with Data Modeling at a level to make recommendations of how model can be improved to support optimal query execution
§ Worked with large data volumes -our prod db is 100TB plus….tuning in smaller databases is completely different than tuning for large databases
MINIMUM QUALIFICATION REQUIREMENT
· At least 5 years of experience in the implementation or support of Oracle E-Business Suite, particularly in HRMS (HR, Payroll and Benefits modules)
· Experience in the custom application design and development and its integration into the main Oracle E-Business Suite;
· Must have good knowledge on:
o Understanding of entity-relationship diagrams, and can read and understand the Technical Reference Manuals
o Understanding of the Oracle E-Business Suite database schema, for a range of application modules.
o Understanding of basic database concepts: e.g., instance, table space, data files, database structure, indexes to fine tune programs and solve program failures. o Understanding of basic Unix Operation system concepts, programs, directory structure and basic commands (e.g., vi, sh)
o Familiarity with the technical aspects of Unix, the Oracle RDBMS, and tools
o Knowledgeable in Oracle E-Business Suite’s system administration tasks, e.g., define users, application responsibility, register functions, menus and procedures.
o Knowledgeable in Oracle's object deployment process using FNDLOAD (e.g. concurrent programs, reports, menus, functions, templates, request groups, responsibility, etc.)
· At least 5 years of experience in Oracle PL/SQL;
· Solid years of experience in Oracle Workflow.
· Solid years of experience in Oracle Reporting Tools (e.g. XML Publisher, Oracle Reports Builder, html Reporting)
· Solid years of experience in data analysis, data integration, data conversion / migration
· Advanced experience in using interface files such as generating and/or loading data from spreadsheets, text files, etc.
· Intermediate knowledge in data warehousing process and any reporting tools (e.g., Cognos, Business Objects);
· Considerable years of experience in Documentation (e.g. MD050, MD070)
· Considerable years of experience in the analysis of financial data
· Familiar with the use of version control (e.g. SVN, CVS)
· Experience in integrating Oracle EBS with other cloud applications like Taleo, Oracle Fusion and Oracle RightNow an advantage