Pri India It Services logo

Senior DBA cum PLSQL Developer

Pri India It Services

6 - 11 years

Kochi

Posted:6 days ago

Job Description

Summary:

Senior Oracle Database Administrator (DBA) and PLSQL Developer

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

Unix AWS Rds Oracle PLSQL Development Triggers Development AWS Linux Optimization

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