Oracle PL/SQL Developer

Basic Function

The Oracle PL/SQL Developer is a database development position with our product development organization and is responsible for development, maintenance and optimization of SQL code targeting Oracle and SQL Server databases based on use cases, user stories, software requirements specifications, and functional specifications with their Agile team. 

Essential Duties and responsibilities

• Work with peers and Senior Engineers to ensure that software products deliver business value, are completed on time, have high quality, and minimize technical debt.
• Participate in development efforts within a project team.  Clearly communicate actionable information to the project team.
• Ensure that software products deliver business value, are completed on time, have high quality, and minimize technical debt.
• Participate in advanced debugging efforts within the project team when production and development issues arise.
• Participate in R&D initiatives that are focused on new product design, usage and/or applicability of new technologies, and architectural direction.
• Successfully interact across various functional roles and departments to ensure effective communication and collaboration.
• Establish and uphold firm expectations and ensure that deliverables are self-certified prior to transitioning to the downstream consumers of the deliverable (QA and customers).
• Work effectively with minimal supervision. The expectation is that the employee in this position will be able to receive a statement of objectives and detailed direction and be able to effectively execute to those directions and clearly communicate the project impediments to his/her peers with minimal feedback or assistance from Senior Engineers and peers.
• Proactively Manage Technical Debt – i.e technical debt is raised, managed, and prioritized for fix.
• Drive application security best practices within the development organization and align to the security policies in place.
• Provide database Support and Maintenance (as needed)
• Participate in the evaluation/implementation of third-party software solutions.
• Participate in process improvement initiatives and stay well updated with technology changes.
• Stays abreast of corporate and division strategy and mission.
• Engineering Operations Responsibilities to include participating in application development efforts to meet and or exceed client expectations, Practice Agile principle on project execution, participate in effective requirement planning sessions and application design sessions with cross functional groups.
• Encourages collaborative efforts and camaraderie with on-shore and off-shore team members.
• Demonstrates a working understanding of software development processes and methodologies, with the ability to share knowledge with peers, and project team members.
• Working understanding of industry best standards in database development

TECHNICAL SKILLS EXPERIENCE

• Strong experience with Oracle database architecture and design principles.
• Proficiency in writing complex SQL queries and optimizing database performance.
• Experience with Oracle tools like SQL*Plus, SQL Developer, or other integrated development environments (IDEs) for writing and testing PL/SQL code.
• Experience with version control systems (e.g., Git) for managing PL/SQL code and collaboration.
• Advanced knowledge of PL/SQL programming, including procedures, functions, packages, and triggers.
• Expertise in identifying slow running queries and optimize them. Understanding of indexing strategies to improve query performance.
• Knowledge of database normalization principles to design efficient and scalable databases.
• Experience with Oracle SQL loader in loading large data files and basic ETL processes.
• Familiarity with dynamic SQL and bulk processing techniques.
• Ability to document code, database schemas, and business logic clearly for maintainability and knowledge sharing.

Job Qualifications

Education:  Bachelor of Engineering/Technology in Computer Science/Information Technology required OR equivalent experience

Experience:

The successful candidate must have a minimum of 4 years of experience in Oracle PL/SQL development.

The ideal candidate must have a proven track record developing software to meet business and project needs.  As such, the candidate must have the ability to understand project requirements and be able to deliver database solutions that meets those requirements.  The candidate is part of the */dxg CS Lien Solutions Technology team and is expected to be a team player.

Other Knowledge, Skills, Abilities or Certifications:

• Knowledge of database replication techniques.
• Knowledge of data warehousing concepts.
• Experience with other databases, programming languages or technologies (e.g., MS SQL, SSRS, MySQL, C#, Java, Python) is a plus.

• Proven experience in documenting technical project artifacts.
• Strong analytical, detailed, problem solving, and troubleshooting skills.
• Solid verbal and written communication skills (Internal & External)
• Adaptive, forward-thinking, and team oriented.
• Ability to work in a fast-paced and demanding environment.
• Continuous attention to technical excellence (self-development)
• A passion about your work with a strong desire to learn, grow and make a difference.
• Familiar with CI / CD platforms.
• Knowledge of database design and object/relational database technology.
• Highly organized and productive, requiring little supervision.
• Demonstrated experience with a formal Software Development Life Cycle, SCRUM, Agile development experience a must.
• Customer-Focused with demonstrated ability to deliver results, on time, high quality and on budget working with geographically distributed teams.