End-client: Sherwin Williams’s || Working with a Prime Vendor
The Oracle Developer position is responsible for the requirement gathering, documentation, design, development, implementation and maintenance of financial web application for the Credit / Customer centric project, with a focus on Oracle database development, batch process development and reporting. Maintain and troubleshoot existing applications following Industry standard coding and best practices. Develop and maintain solutions for new requests and enhancements for existing applications focusing on impact analysis and best code performance. Document requirements, develop design documentation, test cases and maintain in Confluence. Track issues and manage tasks with JIRA, Maintain version control with GIT. The position requires participation in the complete system development life cycle including post implementation support. The developer provides technical consulting to management, business users, and works closely with other developers as a supervisor and mentor.
Essential Functions
Strategy & Planning
Work with the business units to identify business requirements for requested projects.
Identify the technical requirements of projects.
Analyze all aspects of the projects.
Perform feasibility and cost/benefit analyses for proposed projects.
Plan and organize tasks, report on project progress, coordinate with additional development teams.
Development & Deployment
Perform complex programming assignments requiring an advanced aptitude of established programming standards, methods, and best practices.
Design application and database components for development projects.
Perform analysis of business models, logical specifications, and/or customer requirements to design and build Internet solutions utilizing multiple technologies.
Mitigate significant risks associated with projects, which have a high technical complexity and/or involve significant challenges to the business.
Operational Management
Maintain and modify Accounts Receivable, Credit Collection, and Email Management applications, make approved changes by amending application documentation, developing detailed programming logic, and coding changes.
Provide support for these critical application problems and issues.
Act as a Subject Matter Expert in the discovery and investigation of critical production problems as required.
Willingness and ability to coordinate/supervise efforts of other developers.
Incidental Functions
Conduct research into new technologies, including tools, components, and frameworks.
Train and knowledge share with development teams.
Mentor and coach developers and/or Professional Apprentices.
Project and task management and reporting as necessary.
Make presentations to management, clients, and peer groups as requested.
Schedule and lead project and communication meetings.
Provide tier 2, on-call support for critical application problems and issues.
Analyze performance of programs and take action to correct deficiencies based on consultation with users and approval of manager.
Assist with projects as may be required to contribute to efficiency and effectiveness of the work.
Attend management meetings on behalf of team.
Participate in hiring activities and fulfilling affirmative action obligations and ensuring compliance with the equal employment opportunity policy.
Application server maintenance tasks such as: software/hardware upgrades, patching, security configuration, batch process maintenance and migration to new platforms.
Address internal audit concerns to address Sarbanes-Oxley compliance.
Working outside the standard office 7.5 hours workday may be required; on-call availability
Position Requirements
Formal Education & Certification
Bachelor degree or foreign equivalent in a related field or equivalent experience.
Knowledge & Experience
3+ years of IT experience.
3+ years of experience developing OLTP database applications in Oracle 11g and UNIX/LINUX/Solaris environment within a multi-tier environment; building and formulating business requirements.
Hands of experience in JIRA, GitHub, ControlM, Micro Services / Bhoomi Services
3+ years of experience in development and performance tuning using Oracle Exadata.
Work with PL/SQL Types, PL/SQL Collections, SQL Loader, PL/SQL Functions and Procedures, XML, Packages, and Materialized view, Triggers, Complex SQL\'s and SQL Reports;
Work with PL/SQL techniques in LOBs, Multilingual character conversion; Optimize the applications using Exadata Oracle Performance Tuning Techniques; develop Unit Testing Methods for PL/SQL; develop UNIX scripts for batch processing and work with Oracle RAC clusters and Exadata systems; and Knowledge of Account Receivable system
Strong experience in handling large volume data movement and maintenance.