PL/SQL Architecture

Role & responsibilities

Work mode: Remote

Shift : UST (Night shift)

About the Role

We are looking for an experienced PL/SQL Architect to design, develop, optimize, and modernize large-scale Oracle database solutions. The ideal candidate will have deep expertise in Oracle PL/SQL, database architecture, performance tuning, data modeling, and enterprise application integration.

The role will involve working closely with application, infrastructure, data, and business teams to define scalable database architectures and ensure high performance, availability, security, and maintainability.

Key Responsibilities

• Design and implement enterprise-grade Oracle database architectures.
• Develop complex PL/SQL procedures, functions, packages, triggers, cursors, and stored procedures.
• Define database design standards, coding standards, and development best practices.
• Perform SQL and PL/SQL performance tuning, query optimization, indexing, partitioning, and execution-plan analysis.
• Design highly scalable and reliable database solutions for high-volume transactional systems.
• Lead database modernization and migration initiatives where required.
• Design data models, schemas, relationships, constraints, and database objects.
• Analyze and optimize AWR/ASH reports, execution plans, wait events, and database performance metrics.
• Work with DBAs on database availability, backup/recovery, replication, and disaster-recovery requirements.
• Identify database bottlenecks and provide architecture-level recommendations.
• Integrate Oracle databases with enterprise applications, APIs, middleware, and third-party systems.
• Ensure database solutions comply with security, governance, and regulatory requirements.
• Review technical designs and PL/SQL code developed by engineering teams.
• Establish reusable frameworks, libraries, and database components.
• Mentor senior developers and provide technical leadership to the database development team.
• Participate in architecture reviews, solution design, estimation, and technical documentation.
• Support production issues and provide root-cause analysis for critical database problems.

Required Skills

• 1015+ years of experience in Oracle database development and architecture.
• Strong hands-on expertise in Oracle PL/SQL.
• Excellent knowledge of:
• Stored Procedures
• Functions
• Packages
• Triggers
• Cursors
• Collections
• Dynamic SQL
• Bulk processing
• Exception handling
• Strong expertise in SQL performance tuning and optimization.
• Deep understanding of Oracle database architecture and internals.
• Experience with execution plans, indexing, partitioning, materialized views, and query optimization.
• Strong database design and data modeling skills.
• Experience with large-volume transactional databases.
• Experience with Oracle RAC, Data Guard, GoldenGate, or similar technologies is desirable.
• Knowledge of database security, access control, encryption, and auditing.
• Experience working with REST APIs, Java/.NET applications, middleware, or enterprise integration platforms.
• Strong troubleshooting and analytical skills.
• Experience with Agile/Scrum development environments.

Performance & Optimization Expertise

The candidate should be capable of independently handling:

• Complex SQL optimization
• PL/SQL performance tuning
• Explain Plan / execution-plan analysis
• AWR and ASH analysis
• Index strategy
• Table and index partitioning
• Bulk collect / FORALL optimization
• High-volume data processing
• Deadlock and locking issues
• Memory and resource optimization
• Database concurrency and transaction management

Preferred Skills

• Oracle 19c / 21c / 23ai experience
• Oracle RAC / Data Guard
• GoldenGate / replication technologies
• Oracle Exadata
• Oracle Cloud Infrastructure (OCI)
• AWS/Azure database services
• Database migration and modernization
• Microservices and enterprise application architecture
• ETL/data integration technologies
• Python or Shell scripting
• CI/CD for database deployments
• Liquibase, Flyway, or similar database deployment tools

Education

• Bachelor's or master’s degree in computer science, Information Technology, Engineering, or a related discipline.
• Equivalent professional experience may be considered.