PL/SQL Developer

Envision Technology Solutions; Alpharetta (GA); On-site; USD 110,000 - 170,000; Full time

Job summary

Envision Technology Solutions in Alpharetta, GA seeks an experienced Oracle SQL/PL-SQL Developer to design and manage high-performance database solutions. You will craft robust data models, write server-side logic, and aggressively tune complex queries for throughput and stability.

Responsibilities include building stored procedures, ETL workflows, and integrating business rules in the database layer, with collaboration across Java teams.

Qualifications

• 8–12 years of database development experience.
• Proficient with Oracle 19c/21c and PL/SQL.
• Experience in performance tuning and data modeling.

Responsibilities

• Design, write, and maintain high-performance Oracle database objects.
• Develop AML, ACH, and banking transaction processing logic in PL/SQL.
• Tune queries, analyze AWR reports, and optimize data workflows.
• Collaborate with Java teams to align APIs with data layer.

Skills

Oracle Database Expertise

Advanced PL/SQL Mastery

Tuning Methodologies

IDE Tools

Scripting UNIX

Tools

Oracle SQL Developer

Toad

PL/SQL Developer

Job description

Duration: Long Term Contract

Job Description:

We are seeking a highly skilled Oracle SQL/PL-SQL Developer to design, develop and manage high-performance relational database solutions. You will be responsible for creating robust data models, writing advanced server-side programmatic logic, and aggressively tuning complex queries to ensure maximum data throughput and application stability

Key Responsibilities

• Database Programming: Design, write, and maintain robust, high-performance database objects like stored procedures, packages, functions, and database triggers.
• Experience in generating and analyzing AWR reports.
• Knowledge of AML processes and transaction monitoring.
• Knowledge of ACH/payment processing and reconciliation.
• Understanding of banking and financial transaction life cycles.
• Business Logic Integration: Code complex business rules directly into the Oracle database layer using PL/SQL for security and processing speed.
• Performance Tuning: Diagnose, troubleshoot, and optimize sluggish SQL statements using available tools
• Data Modeling: Design efficient relational database architectures including schemas, tables, primary/foreign key relationships, and indexes.
• ETL Pipeline Development: Build, manage, and scale Extract, Transform, Load (ETL) data integration workflows to ingest external application data
• Collaboration & Integration: Interface with backend application developers (e.g., Java engineering teams) to align front-end APIs with data tier structures.

Technical Skills & Qualifications:

Experience:

• 8 to 12 years

Core Technical Requirements

• Oracle Database Expertise: Proficient experience with recent versions (e.g., Oracle 19c or 21c).
• Advanced PL/SQL Mastery: Proven capability utilizing collections, bulk operations, analytical functions, and ref cursors.
• Tuning Methodologies: Hands-on experience partitioning tables, managing optimizer statistics, and modifying query execution paths.
• IDE Tools: High familiarity with database interfaces, specifically Oracle SQL Developer, Toad, or PL/SQL Developer.
• Scripting Language : High familiarity and experience with UNIX scripting.

Preferred / "Nice-to-Have" Skills

• Cloud Environments: Experience managing or mapping databases on cloud infrastructures like AWS (Amazon RDS/S3) or Oracle Cloud Infrastructure (OCI).
• Complementary Languages: Basic competency with Python, or core Java.

CI/CD Paradigms

Understanding of DevOps data practices such as database version

Thanks,

Email: [e-mail]