Pri India It Services logo

Senior DBA cum PLSQL Developer

Pri India It Services

7 - 10 years

12 - 17 Lacs

Kochi

Posted:6 days ago

Job Description


Senior

The candidate must have experience in both DBA and PLSQL.

  • Location : Kochi
  • Work Type - Hybrid / General Shift
  • Interview Type - 2 Virtual Round
  • Contract Period - 6 Months

Job Summary:

Senior Oracle Database Administrator (DBA) and PLSQL

Oracle Database Administration

  • Manage end-to-end Oracle database operations including installation, configuration, patching, upgrades, and maintenance.
  • Administer Oracle 12c/19c/21c databases across Production, UAT, Development, and DR environments.
  • Execute database cloning, refresh, migration, and deployment activities ensuring high availability and reliability. 

Database Development & Engineering

  • Design, develop, and optimise complex SQL, PL/SQL packages, procedures, functions, triggers, and database-driven application components.
  • Support data modelling, schema design, ETL processes, data migration activities, and application database integration.
  • Collaborate with development teams to improve scalability, maintainability, code quality, and database development standards. 

High Availability, Backup & Recovery

  • Manage Oracle RAC, ASM, and Data Guard environments to ensure business continuity and disaster recovery readiness.
  • Design, implement, and validate RMAN backup and recovery strategies, including point-in-time recovery.
  • Develop, test, and maintain failover, switchover, and disaster recovery procedures to meet availability SLAs. 

Performance Tuning & Database Optimization

  • Monitor database health and proactively identify performance bottlenecks using OEM, AWR, ASH, and ADDM reports.
  • Perform SQL tuning, query optimization, indexing improvements, and execution plan analysis.
  • Optimize database storage, memory, and configuration parameters to maximize system performance and scalability.

Security, Automation & Monitoring

  • Implement database security standards, user access controls, auditing, and vulnerability remediation activities.
  • Develop Shell, PL/SQL, and automation scripts to streamline routine DBA operations and maintenance tasks.
  • Establish monitoring, alerting, capacity planning, and forecasting processes to ensure proactive database management 

Production Support & Technical Leadership

  • Provide L2/L3 production support, incident management, RCA, and resolution for critical business applications.
  • Lead database upgrades, cloud migration initiatives (AWS/Azure), and infrastructure modernization projects.
  • Collaborate with application, infrastructure, and support teams while maintaining documentation, SOPs, and governance standards. 

Key Technical Skills

  • Oracle Technologies: Oracle 12c/19c/21c, RAC, Data Guard, ASM, RMAN, OEM/Grid Control.
  • Performance & Automation: SQL, PL/SQL, AWR, ASH, ADDM, Shell Scripting, Query Optimization.
  • Platforms & Tools: Linux/Unix, AWS RDS, Azure Oracle Workloads, SQL Developer, TOAD, Jira, ServiceNow.

Skills Required

Amazon Rds Cloud Unix PLSQL Development Data warehousing Oracle Azure Cloud Data

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