PL/SQL Developer

Role: PL/SQL Developer
Location: Columbus, OH
Duration: 3+ Months
Top Three Skills:
1) PL/SQL
2) Knowledge of retail
3) SQL - pulling queries, inner/outer joins
4) Shell scripting
5) Pro*C(combo of C and SQL)
6) Oracle forms
Job Description:
REQUIREMENTS:
The Application Engineer role is an integral part of the Application Technologies team, ensuring stability and efficient operation of RMS (Retail Merchandising System) application on Oracle WebLogic. The Application Engineer is responsible for managing and maintaining all environments of Oracle RMS application. The Application Engineer will play a key role in the implementation, integration, rollout and management of RMS application technology stack. The main tasks will include installing, configuring, maintaining, cloning, monitoring, documenting, and supporting the RMS application and other WebLogic/Tomcat based applications. The role requires working independently with business and IT teams, providing outstanding user support for application technologies and related business processes.
BACKGROUND:
- Lead RMS environment build and deliver activities
- Collaborate with project manager and project teams for RMS code migration
- Install, patch, administer, monitor and clone Oracle RMS, RPM, and RIB application environments
- Coordinate and guide support team in supporting RMS, RPM, and RIB application set up and configurations
- Provide engineering assistance for RMS, RPM, and RIB application environments
- Participate in Unit, System and Integration testing related to application
- Coordinate with business and solution delivery team on maintenance and configuration of RMS, RPM and RIB applications
- Managing Service Requests with Oracle Technical Support for RMS, RPM and RIB application
- Monitoring, tuning, and improving performance of RMS, RPM and RIB application
- Assist with installation and administration of other WebLogic/Tomcat based applications
CORE SKILL SETS:
- 5 years of technical support and technology implementation experience in RMS, RPM and RIB application with heavy emphasis on install, patching and tuning
- Experience with app-tier clustering and cloning
- Technical, functional and analytical abilities sufficient for the support and configuration of RMS, RPM and RIB application version (10,12 and 13.x)
- Technical knowledge in Java/J2EE technologies preferably in retail domain
- Working knowledge of PL/SQL and Oracle database 12c
- Experience in a retail apparel environment with mid to large size organization
- Technical experience with Oracle WebLogic 10.3.6 or higher. Experience with 12c is a plus
- Must be solutions-oriented and have exceptional written, verbal and interpersonal communication skills
Strong analytical thinking, troubleshooting and problem solving skills within complex enterprise systems
- Experience with IBM WebSphere 6 or higher, WebMethods and other middleware technologies is a plus
- Experience in integrating Retail modules with Single Sign On (SSO)
- Experience working in a shared services environment is a plus
- Ability to be on call 24x7 and have a flexible work schedule
Additional Information:
- PL/SQL, ability to write robust queries on a database, knowledge of pro*c and shell scripting, oracle forms is outdated but they use them still, need to be able to make modifications to the forms
- No maintaining of the database or anything with modifying how it behaves and what it does, more on the application side, if a business user asks to come up with a list of data points for them to be able to go in and analyze (ex. transactions for the last year with specific qualifiers) the individual should be able to go into the RMS table and understand the structures to write a SQL query
- Have a baseline understanding of what data is stored in what table and how they join
- Java understanding would be a plus