Senior DBA cum PLSQL Developer (Kochi)

Senior DBA cum PLSQL Developer (Kochi)

19 Nov
|
PRI India IT Services
|
Kochi

19 Nov

PRI India IT Services

Kochi

Greetings from PRI Global.!

Job Description:

Job Title: Senior DBA cum PLSQL Developer
Experience: 812 years
Location: Kochi
Work Mode: Hybrid
Project Duration: 6 Months (Strong performers will be considered for full time conversion after 6 Months or Project will be extended)

Notice Period: Immediate to 30 Days

Job Summary

We are looking for an experienced Senior Oracle DBA cum PL/SQL Developer with 8–12 years of hands-on experience in Oracle Database Administration and SQL/PLSQL Development.

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: If you or someone in your network is looking for a great career opportunity please share your updated CV at [email protected] .

📌 Senior DBA cum PLSQL Developer (Kochi)
🏢 PRI India IT Services
📍 Kochi

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior dba cum plsql developer (kochi) / kochi

Subscribe to this job alert:

Get the latest job offers by email for: senior dba cum plsql developer (kochi) / kochi