PL SQL Developer

ASGN - Cleveland, OH

Full-time - Mid Level

Cleveland, OH

Administrative and Support Services

About the position

The PL/SQL Developer will be an integral part of an integrated product team consisting of system owners, developers, and testers. This role involves a comprehensive set of responsibilities including the analysis, design, coding, unit testing, and documentation/audit checks for assigned system change requests. The developer will engage in customized coding using PL/SQL to meet end-user specifications, ensuring that all system changes adhere to established developer guide requirements and standards. Participation in system requirements reviews, critical design reviews, test readiness reviews, and pre/post-implementation reviews is essential as part of the defined system development life cycle. In this position, the developer will utilize their expertise to design, develop, code, test, and debug software. They may work across various areas such as equipment or software design, engineering evaluation or testing, configuration management procedures, and statistical analysis and modeling. The role requires collaboration with users to define the scope and objectives of existing or new systems, providing analytical support and technical advice throughout the conceptualization, development, and implementation phases. The developer will also be responsible for planning and scheduling new application systems projects in conjunction with users, systems software, and computer center operations personnel. This includes identifying objectives, time frames, costs, and manpower requirements. Additionally, the role involves ensuring the identification and documentation of hazards within software systems using various analysis tools and techniques, as well as reviewing and evaluating systems and software for adherence to government or commercial directives, standards, guidelines, and criteria concerning software safety and systems safety. The developer will confirm that design mitigations are captured in the design documentation and verify their implementation, while also performing basic design, build, or maintenance of software using various authoring or scripting languages and management tools.

Responsibilities

• Design, develop, code, test, and debug software.
• Work with users to define existing or new system scope and objectives.
• Provide analytical support and technical advice during the conceptualization, development, and implementation phases.
• Plan and schedule new applications systems projects with users and systems software personnel.
• Perform tasks to ensure identification and documentation of hazards within software systems.
• Review and evaluate systems and software for adherence to directives and standards.
• Confirm design mitigations are captured in documentation and verify implementation.
• Identify problems uncovered by testing or customer feedback and correct them.
• Evaluate code to ensure it is valid and meets industry standards.

Requirements

• 8+ years of software development experience required.
• 3-5+ years of PL/SQL coding experience.
• Advanced Oracle PL/SQL skills.
• Oracle DBMS experience - 12c or higher.
• Experience with Agile System Development Life Cycle methodologies required.
• Knowledge of IT Service Management practices is beneficial.
• Excellent interpersonal and consultative skills.
• Excellent documentation and communication skills.
• Self-motivated with the ability to motivate others.
• Good problem-solving skills.
• Ability to follow complex instructions and work independently or in a team.
• Knowledge of commonly used concepts and practices for full product development life-cycle desired.
• Ability to prioritize, plan, organize, and manage multiple tasks efficiently.

Nice-to-haves

• Experience with APEX Office Print (AOP) is a plus.
• Highly adaptive and flexible to a changing environment.

Benefits

• Comprehensive benefits package including quality career resources, training, certifications, and development opportunities.