[Hiring] Oracle Database Developer @Robbins-Gioia LLC

Role Description

Currently, RG is looking to hire an Oracle Database Developer to support the Programmed Depot Maintenance Scheduling System (PDMSS). As part of RG’s modernization of this sophisticated application, we are looking for an Oracle Database Developer to join our development team to provide expertise and support to optimize performance of the core database.

The Oracle Database Developer will work remotely as part of the development team to design and write efficient PL/SQL queries, procedures, and views in support of the team’s development objectives. They will document their code, update the status of their work using Agile management tools (Jira/Confluence/GitHub) and provide input and expertise during design meetings, Team stand ups, and retrospectives.

A Day In the Life:

• Writing efficient and optimized PL/SQL queries, views, procedures, and triggers
• Following coding standards and source control procedures for project
• Adhering to customer provided security guidelines
• Recommend data table modifications and assist with maintaining the data dictionary
• Participating in Team Scrum meetings
• Evaluating requested changes to determine direct and indirect impacts
• Evaluating code performance for requirements adherence
• Performing troubleshooting and root cause analysis tasks
• Attending business analysis reviews to support new data requests or looking for efficiency opportunities
• Maintaining Oracle 19c+ databases and making the structures more efficient
• Performing data imports, exports, and backups across multiple Oracle database schemas

Qualifications

• BA/BS Degree (additional experience may be substituted in lieu of degree)
• 3+ years’ experience as an Oracle PL/SQL developer
• Experience with Oracle SQL Developer (or PL SQL Developer or VS Code with SQL Developer Plug-In)
• Current NACI or ability to obtain one

Requirements

• Understand network and application performance and security considerations when writing queries and procedures
• Exhibit troubleshooting and root cause analysis thought processes
• Work within a team environment and demonstrate excellent oral and written communication skills
• Prioritize and work within Agile sprint time limits

Benefits

• Oracle Certifications
• Ability to travel for technical meetings as required (anticipated <10%)
• Working knowledge of Oracle query optimization techniques
• Expertise in data modeling techniques
• Experience in RESTful web services, endpoints, APIs, and the JSON format
• Familiarity with Object/Relational Mapping (ORM) (Hibernate)
• Modeling and executing historical data analytics
• Current Security Clearance (Secret or higher)

Physical Requirements & Disclaimer

Sedentary work: Exerting up to 10 lbs. of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required, only occasionally and all other sedentary criteria are met. EOE, including disability/vets.