??’?? ??????: ??/??? ?????????

???? ????: ??????

?????: ??? ????? / ????? ?????

??????????: ??–?? ?????

?????????? ????: ???????? / ????-???? ??????????

We are looking for an experienced PL/SQL Architect to design, develop, optimize, and modernize enterprise-scale Oracle database solutions.

The ideal candidate will bring strong hands-on expertise in Oracle PL/SQL, database architecture, performance optimization, data modeling, high-volume transaction processing, and enterprise application integration.

Key Responsibilities

- Design scalable and enterprise-grade Oracle database architectures.
- Develop complex PL/SQL procedures, functions, packages, triggers, cursors, and stored procedures.
- Define database design standards, development standards, and PL/SQL coding best practices.• Perform advanced SQL and PL/SQL performance tuning and query optimization.
- Analyze execution plans, AWR/ASH reports, wait events, locking issues, and database performance metrics.
- Design indexing and partitioning strategies for large-volume transactional systems.
- Build and optimize schemas, relationships, constraints, materialized views, and database objects.
- Lead database modernization and migration initiatives.
- Identify database bottlenecks and provide architecture-level recommendations.
- Work closely with DBAs on high availability, backup/recovery, replication, and disaster recovery.
- Integrate Oracle databases with APIs, middleware, Java/.NET applications, and third-party enterprise systems.
- Review database architecture, technical designs, SQL, and PL/SQL code developed by engineering teams.
- Establish reusable frameworks, libraries, and database components.
- Mentor senior developers and provide technical leadership to database engineering teams.
- Support critical production issues and perform root-cause analysis.
- Participate in architecture reviews, solution design, estimation, and technical documentation.

???????? ??????

10–15+ years of Oracle database development and architecture experience

Advanced hands-on expertise in Oracle PL/SQ





?????? ????????? ??:

- Stored Procedures
- Functions
- Packages
- Triggers
- Cursors
- Collections
- Dynamic SQL
- Bulk Processing
- Exception Handling
- Solid SQL and PL/SQL performance tuning expertise
- Deep understanding of Oracle database architecture and internals
- Execution Plan / Explain Plan analysis
- Indexing and partitioning strategies
- Materialized Views and query optimization
- Strong database design and data modeling skills
- Experience with high-volume transactional databases
- Database concurrency and transaction management
- Deadlock and locking troubleshooting
- Database security, access control, encryption, and auditing
- REST APIs and enterprise application integration
- Strong troubleshooting and analytical capabilities
- Experience working in Agile/Scrum environments
- Performance & Optimization Expertise The candidate should be capable of independently handling
- Complex SQL optimization
- PL/SQL performance tuning
- AWR and ASH analysis
- Execution-plan 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
- Oracle RAC / Data Guard
- Oracle GoldenGate
- Oracle Exadata
- Oracle Cloud Infrastructure (OCI)
- AWS / Azure database services
- Database migration and modernization
- Microservices architecture
- ETL / Data Integration technologies
- Python / Shell scripting
- CI/CD for database deployments
- Liquibase / Flyway or similar deployment tools

Education

Bachelor’s or Master’s degree in Computer Science, Information Technology, Engineering, or a related discipline.

Equivalent relevant professional experience may also be considered.

? Interested candidates can apply or share their updated resume via DM / email.

- #Hiring #PLSQLArchitect #OracleJobs #OraclePLSQL #DatabaseArchitect #OracleDatabase #PLSQLDeveloper #SQLDeveloper #OracleRAC #DataGuard #GoldenGate #DatabaseJobs #RemoteJobs #ITJobs #TechHiring #NightShiftJobs

📌 PL/SQL Architect | 10-15 YOE | Immediate Joiner (India)
🏢 Codians.ai
📍 India