PL/SQL Developer

Integration Innovation, Inc.

Washington, DC, United States

3 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Java (Programming Language) Amazon Web Services Data Analysis Application Performance Management CA Workload Automation Ae Microsoft Azure Batch Processing Big Data Code Review Databases Data Validation Data Conversion

+42 more

Data Integration Data Integrity Extract Transform Load (ETL) Data Migration Relational Databases Cursor (Graphical User Interface Elements) Database Design Database Development Database Schema Linux Job Scheduling Python (Programming Language) Oracle Databases Oracle (Applications) Oracle SQL Developer Performance Tuning Scrum Methodology Query Optimization Release Management Shell Script Software Engineering SQL Stored Procedures PL-SQL SQL*Plus SQL Databases Freeform SQL Data Server Interface Enterprise Software Applications Cloud Platform System Sql Optimization Database Optimization Database Performance Indexer Backend Git Information Technology Deployment Automation Toad (Software) Restful APIs Oracle Cloud Infrastructure Software Version Control Control M

Job description

We are seeking an experienced PL/SQL Developer to design, develop, enhance, and support Oracle database applications and backend systems. The ideal candidate will have strong expertise in Oracle SQL and PL/SQL, database performance tuning, stored procedures, packages, functions, triggers, and data integration. This role will work closely with application developers, business analysts, database administrators, and other technical teams to deliver reliable, scalable, and high-performing database solutions., * Design, develop, test, and maintain complex Oracle SQL and PL/SQL code.

Develop and maintain stored procedures, functions, packages, triggers, views, cursors, and database objects.
Analyze business and technical requirements and translate them into database solutions.
Develop complex SQL queries for application processing, reporting, data validation, and reconciliation.
Perform query optimization and database performance tuning, including execution plan analysis, indexing, and SQL optimization.
Troubleshoot production issues, identify root causes, and implement appropriate fixes.
Develop and maintain batch processing jobs, data interfaces, and ETL-related database processes.
Perform data analysis, data conversions, migrations, and data validation activities.
Work with large datasets while maintaining application performance, data integrity, and accuracy.
Participate in code reviews and ensure development follows established coding standards and best practices.
Create technical documentation, including database designs, data mappings, process flows, and implementation procedures.
Support application releases, deployments, testing, and production implementations.
Collaborate with DBAs, application developers, QA teams, business analysts, and infrastructure teams.
Provide ongoing production support and resolve database-related incidents and defects.
Participate in Agile/Scrum ceremonies and contribute to sprint planning, estimation, and technical design discussions.

Requirements

Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent professional experience.
5+ years of experience developing applications using Oracle SQL and PL/SQL.
Strong hands-on experience with:
Oracle Database
SQL and PL/SQL
Stored procedures and functions
Packages and triggers
Views and materialized views
Cursors and exception handling
Dynamic SQL
Bulk processing using BULK COLLECT and FORALL
Strong understanding of relational database concepts, data modeling, normalization, and database design.
Experience troubleshooting and optimizing complex SQL queries.
Experience analyzing Oracle execution plans and identifying database performance issues.
Knowledge of indexes, partitions, constraints, sequences, and other Oracle database objects.
Experience working with high-volume transactional or enterprise database systems.
Experience with source control and software development lifecycle processes.
Strong analytical, troubleshooting, and problem-solving skills.
Strong written and verbal communication skills.

Preferred Qualifications

Experience with Oracle 12c, 19c, or newer versions.
Experience using tools such as Oracle SQL Developer, TOAD, or SQL*Plus.
Experience with ETL, data migration, and data conversion projects.
Experience with Unix/Linux environments and shell scripting.
Experience with job scheduling tools such as Control-M, Autosys, or Oracle DBMS Scheduler.
Familiarity with REST APIs, Java, Python, or other application development technologies.
Experience working in Agile/Scrum development environments.
Experience with CI/CD pipelines and automated deployment processes.
Knowledge of cloud environments such as AWS, Azure, or Oracle Cloud Infrastructure (OCI).
Experience supporting mission-critical or high-availability enterprise applications.

Technical Skills

Primary: Oracle, SQL, PL/SQL, Stored Procedures, Packages, Functions, Triggers, Views, Cursors, Query Optimization, Performance Tuning

Secondary: Linux/Unix, Shell Scripting, Git, ETL, Data Migration, DBMS Scheduler, SQL Developer, TOAD, Agile/Scrum