Pri India It Services logo

Senior DBA cum PLSQL Developer

Pri India It Services

8 - 12 years

Kochi

Posted:4 hours ago

Job Description

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:

Skills Required

PLSQL Development SQL Senior Query Optimization RMAN Administration Oracle DBA Recovery

Learn the skills this job asks for

See your skill gap for Database Administrator →

Free courses, interview questions and practice for each skill.

Work Mode

Hybrid

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Pri India It Services logo
Pri India It Services

RecommendedJobs for You

Pri India It Services logo

Senior DBA cum PLSQL Developer

Pri India It Services

Kochi

Pri India It Services logo

Senior DBA cum PLSQL Developer

Pri India It Services

Kochi

Pri India It Services logo

Senior DBA cum PLSQL Developer

Pri India It Services

Kochi

Pri India It Services logo

Senior DBA cum PLSQL Developer

Pri India It Services

Kochi

Pri India It Services logo

Senior DBA cum PLSQL Developer

Pri India It Services

Kochi

Pri India It Services logo

Senior DBA cum PLSQL Developer

Pri India It Services

Kochi