Summary
✨ AI‑Generated
Join a long-term onsite contract as an Oracle database specialist responsible for designing high-performance relational database solutions. You will develop complex PL/SQL logic, tune demanding queries, analyze database performance reports, and implement business rules for financial transaction workflows.
Highlights
Long-term contract focused on high-performance Oracle database development, advanced query tuning, database programming, financial transaction systems, and performance analysis.
Description
Role: PL/SQL Developer
Location: Alpharetta, GA (Onsite)_Local Preferred
Duration: Long Term Contract
Must have : AWR Reporting / ASH, Financial Domain
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 toolsData 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.Migration & Maintenance: Author deployment scripts, execute data migration runs, and maintain comprehensive schema version control.
Technical Skills & Qualifications:
Experience:
8 to 12 yearsCore 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: Rakesh.pathak@envisiontechsol.com
Office Cell#: 609-606-7003 Ext-167
Direct Number+1 609-609-3646
