Greetings from PRI Global.!
Job Title:
Notice Period:
Job Summary
Senior Oracle DBA cum PL/SQL Developer
The ideal candidate must have strong expertise in managing end-to-end Oracle database environments, including installation, configuration, upgrades, performance tuning, backup and recovery, high availability, disaster recovery, and production support.
Additionally, the candidate should be proficient in developing and optimizing complex SQL queries, PL/SQL packages, procedures, functions, and triggers, along with experience in data modeling, ETL, database migration, and application integration.
Candidates must have strong hands-on experience in BOTH Oracle DBA and PL/SQL Development.
Key Responsibilities:
1. Oracle Database Administration
- Manage end-to-end Oracle database administration, including installation, configuration, patching, upgrades, and maintenance.
- Administer Oracle 12c, 19c, and 21c databases across Production, UAT, Development, and DR environments.
- Perform database cloning, refresh, migration, and deployment activities.
- Ensure database availability, reliability, and stability.
2. PL/SQL Development & Database Engineering
- Design, develop, and optimize complex SQL queries and PL/SQL objects.
- Develop and maintain Packages, Procedures, Functions, Triggers, and database-driven application components.
- Perform data modeling, schema design, ETL, and data migration activities.
- Collaborate with application development teams to improve database performance and code quality.
3. High Availability, Backup & Recovery
- Manage Oracle RAC, ASM, and Data Guard environments.
- Implement and maintain RMAN backup and recovery strategies.
- Perform point-in-time recovery, database restoration, failover, and switchover activities.
- Maintain disaster recovery procedures and ensure business continuity.
4. Performance Tuning & Optimization
- Monitor database performance using OEM, AWR, ASH, and ADDM.
- Perform SQL tuning, query optimization, indexing, and execution plan analysis.
- Optimize database memory, storage, and configuration parameters.
- Identify and resolve database performance bottlenecks.
5. Security, Automation & Monitoring
- Implement database security, user access controls, auditing, and vulnerability management.
- Develop Shell scripting and PL/SQL automation scripts.
- Manage database monitoring, alerting, capacity planning, and maintenance activities.
6. Production Support & Technical Leadership
- Provide L2/L3 production support and resolve critical database issues.
- Perform incident management, root cause analysis (RCA), and troubleshooting.
- Support database upgrades and cloud migration initiatives involving AWS/Azure.
- Maintain technical documentation, SOPs, and database governance standards.
- Coordinate with application, infrastructure, and support teams.
Mandatory Technical Skills
- Oracle DBA Administration – Oracle 12c/19c/21c
- SQL & PL/SQL Development
- Oracle RAC, ASM, Data Guard
- RMAN Backup & Recovery
- Oracle Enterprise Manager (OEM)
- AWR, ASH, ADDM
- SQL Performance Tuning and Query Optimization
- Database Installation, Configuration, Patching & Upgrades
- Database Migration, Cloning & Refresh
- Linux/Unix and Shell Scripting
- Production Support and Troubleshooting
Good to Have Skills
- AWS RDS / AWS Database Services
- Azure Oracle Workloads
- ETL and Data Modeling
- SQL Developer / TOAD
- Jira / ServiceNow
Note: